Import to store manager using CSV problem

Import to store manager using CSV problem

Avatar image
Dec 22, 2012
Ron wrote
Hi

We have just installed Store Manager as a test

We have a database of products (Access)
From that database I am defining the Quantity field as an Integer (no decimal places)e.g 49
I then export to CSV
If i load the csv file intto Excel, the Quantity field shows as an Integer e.g. 49
When I try to import to store manager (Standard not the extra module) the quantity field is shown as decimalised e.g 49.00 and on import it is not picke dup resulting in the quantity field as ""
Reply
3 Answers
Avatar image
Dec 24, 2012
Andrii Yanosh agent wrote
Hello Ron,

Thank you for your post.

It looks like you have selected different separators while exporting and importing your products.

Please make sure that the separators are the same, and pay your attention and "Quote string values with" option.

If the issue remains, you may submit a ticket here: http://support.emagicone.com/submit_ticket and attach your .csv file so we could check it for you.
Let us know how it goes anyway.
Avatar image
Dec 26, 2012
Ron wrote
Hi, thanks for the reply

No, it is not to do with the separator. If it was, all the fields would not be correct

Anyway, I have solved the problem. It seems that in Microsoft access even when you tell the field to be an Interger, it does not always force it. Then, because of the quirk, some csv viewers will show the integer and some will not

In order to force the issue, in the Access query I had to use

Format$(Int([Quantity]),"0")

And now all is well
Avatar image
Dec 26, 2012
Andrii Yanosh agent wrote
Hello Ron,

Thank you for keeping us informed and thank you for cooperation.