Page 1 of 1

Data Exchange Import

Posted: Thu Apr 25, 2013 3:00 pm
by janice
I am new to Able Commerce - our site is still getting set up.
I'm wanting to import our product database. I tried to import the csv file. I have about 400 products.
I chose the file and submitted it. After 4-5 hours and over 225,000 records I canceled it.
Can anyone tell me if they have had this experience or how it should work? There is no documentation on it that I could find.

Thank you,
Janice

Re: Data Exchange Import

Posted: Thu Apr 25, 2013 8:32 pm
by Naveed
Hello Janice,

This is a bug with data exchange import, if you try import .csv text file with over 200 records. However you can avoid that bug by zipping that .csv file into a .zip file and then import it. ( This issue is fixed for next release).

Re: Data Exchange Import

Posted: Fri Apr 26, 2013 8:57 am
by janice
I just tried it. It did not work.

here is the error below

Compressed CSV data file is not valid, it must only contain one csv file.

Re: Data Exchange Import

Posted: Mon Jun 10, 2013 2:48 am
by ForumsAdmin
Please make sure that your zip file contains only the csv file and nothing else. Btw if you use R5 you will not face any of these issues. They are already fixed in R5 and R5 is already released.

Re: Data Exchange Import

Posted: Thu Nov 07, 2013 8:54 am
by kastnerd
Using AbleCommerce Gold (build 5731) Is it possible to import variants directly to the SQL database? any problems with doing that? When importing 48,000 lines of updated variants takes for ever and gives errors so i have to do it in small batches.

Re: Data Exchange Import

Posted: Wed Nov 20, 2013 1:25 am
by Naveed
Please report any other issues you are facing while importing. The above mentioned is already reported and fixed for Gold R5 and latest releases.

Re: Data Exchange Import

Posted: Wed Jun 01, 2016 8:40 am
by kastnerd
I am using GoldR6 build 6169 and it takes for ever to import. like 1 record per min

Re: Data Exchange Import

Posted: Wed Jun 01, 2016 10:57 am
by Katie
We've released 6 new versions since R6 was released. You might consider upgrading.

Thanks
Katie