Community
Showing results for 
Search instead for 
Do you mean 
Reply

Could not import list of products from CSV

Vad
Copper Contributor
Posts: 67
Country: Russia

Could not import list of products from CSV

Hi All, I'm trying to import the products list into ACT! 2008 (10.01) from CSV file. And I get the following error message: Could not find any valid products in C:\Temp\pricelist.csv. The pricelist.csv was created by Excel and it's contains 4 columns (name, item number, cost, price). What's the problem?
Regards,
Vad
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Could not import list of products from CSV

Vad
Copper Contributor
Posts: 67
Country: Russia

Re: Could not import list of products from CSV

[ Edited ]
Mike, Thanks for the answer.

But I found the source of trouble.

Russian version of Excel 2003 is not saving the csv file correctly. When I view the result of saving (csv file) with notepad I see the following:
Name;Item number;cost;price
First;1234;456,00;545,00

And ACT! doesn't understand such csv format. ACT! needs the following csv file:
Name,Item number,cost,price
First,1234,456.00,545.00

ACT's import was running fine when I made correction to the Excel-csv file under notepad (replace all characters from ";" to ","; and replace all numbers from "xxx,xx" to "xxx.xx".

Message Edited by Vad on 03-03-2008 02:21 PM
Regards,
Vad
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Could not import list of products from CSV

It's not just the Russion version. My English Excel 2007 has 3 CSV file formats.
 
It's why I suggested doing an export... easier than explaining the difference and means you know how to check if you forget next time :-)