Forum Discussion
csv exports unicode errors
Hi wonder if someone can help please. Im trying to upload product onto my website using a csv file but I keep getting the following errors:- I have setup products in the main software as suggeste...
Hi
When uploading csv the complete syntax needs to be spot on, if not it does not work on a lot of websites. What I try to do is:
1. download data in csv from the website and open teh file so you can see the exact structure.
2. Make sure you have the same separators (; or, or...) in your file as in the download. Check if you need to use the " " signs around values.
3. If you need to change the separator: open the csv in wordpad (right click, open with) and use the replace function to replace all "," with ";" in one go. save it and upload
4. if you need to add " " to your values you can use a VB code that yo u can find on the internet
Being precise is key in uploading csv data.
hope this helps