Multiple Customers or Products Import Problem

Hi I have this line in my cvs file

3,TEST03,Published,Coupon,Product,Percent,Overall,10,,Total,2,,,20100810,Customer,77,78,Include,7,1,No,No

I'm sure that the ids of customers and products exists, but the error say invalid customer id. If I replace 77,78 by 77 and 7,1 by 7... all works fine

Pls help!, I have the last PRO version

Regards

PS: Sorry but my ugly english

Hi Fernando, i think the commas might be causing the problem as it is being used as a seperator. Try this:

3,TEST03,Published,Coupon,Product,Percent,Overall,10,,Total,2,,,20100810,Customer,"77,78",Include,"7,1",No,No

Where the quote is used to indicate a string within a column.

Thanks,

With these details the import was successfull, but Its a good idea to upgrade the documentation (CSV spreedsheet format), another key is generate the CSV file in ASCII format because the "quote" is diferent in UTF-8 format.


Thanks a lot and have a nice day