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 ""
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
Dec 24, 2012
Dmytro Grycelyak
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.
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.
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
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
Dec 26, 2012
Dmytro Grycelyak
agent
wrote
Hello Ron,
Thank you for keeping us informed and thank you for cooperation.
Thank you for keeping us informed and thank you for cooperation.