Community
Showing results for 
Search instead for 
Do you mean 
Reply

Importing contact information from CSV not replacing currency field

New Member
Posts: 4
Country: United States

Importing contact information from CSV not replacing currency field

All other fields get imported but a user-defined field setup as a currency field. Using ACT! 2010. Excel 2007 workbook saved as CSV file. I did not have this problem with ACT! 2009.
Copper Contributor
Posts: 42
Country: United_Kingdom

Re: Importing contact information from CSV not replacing currency field

This is a known issue.

If you remove the currency symbols from the .csv file you should be able to import without issue. 

Simon Hales
Sr. Commercial Marketing Manager
Swiftpage
Highlighted
New Member
Posts: 4
Country: United States

Re: Importing contact information from CSV not replacing currency field

Currency signs were removed from source CSV file so that would not have been the problem. 
Copper Contributor
Posts: 42
Country: United_Kingdom

Re: Importing contact information from CSV not replacing currency field

Try formatting the currency cells as number, then re-importing.

The issue is documented here

Simon Hales
Sr. Commercial Marketing Manager
Swiftpage
New Member
Posts: 4
Country: United States

Re: Importing contact information from CSV not replacing currency field

Issue solved, operator error. Merge did not replace an existing field, using selective add did. Thanks,