Alasitis Posted September 3, 2008 Share Posted September 3, 2008 When attempting to import my .csv file I get the following message: Invalid CSV file or delimiter.Originally, I downloaded an Excel CSV file from my supplier, edited it to make sure I had only acceptable PrestaShop headings and then saved it as a .csv file. I got the Invalid CSV file or delimiter. so I opened the file in Notepad and the commas were there and everything looked okay but further attempts got the same results. I then saved the text file as .csv and tried that without success.So now I am out of ideas and I will greatly appreciate any help.ThanksP.S. I also created a new, simple, file in Excel and saved it as a .csv file but it still did not work. Link to comment Share on other sites More sharing options...
jhnstcks Posted September 3, 2008 Share Posted September 3, 2008 Did you change the delimiter option to comma instead of semi-colon just before you upload? The option is just under the import button Link to comment Share on other sites More sharing options...
Alasitis Posted September 3, 2008 Author Share Posted September 3, 2008 When attempting to import my .csv file I get the following message: Invalid CSV file or delimiter.Originally, I downloaded an Excel CSV file from my supplier, edited it to make sure I had only acceptable PrestaShop headings and then saved it as a .csv file. I got the Invalid CSV file or delimiter. so I opened the file in Notepad and the commas were there and everything looked okay but further attempts got the same results. I then saved the text file as .csv and tried that without success.So now I am out of ideas and I will greatly appreciate any help.ThanksP.S. I also created a new, simple, file in Excel and saved it as a .csv file but it still did not work. I just tried a test file from another member and it worked. So I'm pretty sure there is something wrong with my .csv file. Thanks for the help ... Link to comment Share on other sites More sharing options...
Jean-Bruno Posted September 3, 2008 Share Posted September 3, 2008 Try to import without accentuation data. There is a mess with UTF8 and other ISO… Be carefull to your numbers data ( 5.05 is good, 5,05 not)Someone tell to me than you can export a CSV file from your PhpMyAdmin interface. Link to comment Share on other sites More sharing options...
Recommended Posts