Please help us to make AbanteCart Ideal Open Source Ecommerce Solution for everyone.

Support AbanteCart eCommerce

Author Topic: Import / Export Design  (Read 19063 times)

Offline Nimitz1061

  • Full Member
  • ***
  • Posts: 190
  • Karma: +22/-0
  • No matter where you go, there you are...
    • View Profile
Import / Export Design
« on: September 04, 2012, 07:54:12 PM »
One problem I have with import / export on Abantecart is that the product export seems to be so wide when exported to CSV or Tab Delimited forms.   Had a bit of trouble understanding why this might not seem a problem to developers until I had a chat with an associate today who had installed a version of the osCommerce import / export contribution which did the same thing.

Now I recall that we generated a version which chunked product imports and exports so that attributes were NOT in the same file and languages were on separate lines in order to keep them down to a dull roar and make the files more manageable....

David



Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 4363
  • Karma: +301/-10
    • View Profile
    • Ideal Open Source Ecommerce Solution
Re: Import / Export Design
« Reply #1 on: September 05, 2012, 04:29:41 PM »
There is a way to make CSV smaller. You can reduce number of related tables in your export request. In case on import, you can also do this in sets per table.

Number of fields also depends how many options use have for products and other attributes.
Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

Offline Nimitz1061

  • Full Member
  • ***
  • Posts: 190
  • Karma: +22/-0
  • No matter where you go, there you are...
    • View Profile
Re: Import / Export Design
« Reply #2 on: September 10, 2012, 10:29:20 AM »
That last makes sense - but, as I said, we dealt with that issue by splitting the options and attributes out.

I'm still running into issues attempting to import data that just doesn't get written to the database.  In particular, I always have to manually assign new products to the default store, and attempts to assign categories don't work.

David

Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 4363
  • Karma: +301/-10
    • View Profile
    • Ideal Open Source Ecommerce Solution
Re: Import / Export Design
« Reply #3 on: September 10, 2012, 10:32:29 AM »
Can you please, post or PM your import file. I will check this for you.

There was also a small bug in import part that I fixed for v1.1
We should have this version out later this week. We are working on final QA fixes.
Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

Offline Nimitz1061

  • Full Member
  • ***
  • Posts: 190
  • Karma: +22/-0
  • No matter where you go, there you are...
    • View Profile
Re: Import / Export Design
« Reply #4 on: September 10, 2012, 11:12:41 AM »
I'll try to find time to get to that soon.  May be best to just check it on 1.1 first, time wise..

David

Offline heavenlyscents4

  • Newbie
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: Import / Export Design
« Reply #5 on: September 23, 2012, 12:03:57 PM »
Hi, I too am having trouble importing csv files. It keeps coming up with an error message. Or it says file not found. So annoying.

Offline ksanjay

  • Newbie
  • *
  • Posts: 3
  • Karma: +0/-1
    • View Profile
Re: Import / Export Design
« Reply #6 on: March 20, 2013, 06:22:54 PM »
thanks for the information....................

 

Powered by SMFPacks Social Login Mod