User Support Forum

Using PCP v14.4
When attempting to load contributions from a csv created in excel, the import keeps erroring on the date.
I have tried different formats for the date and reviewing/changing in notepad and the import continues to fail.
The process also takes the first two date numbers (the month) as the amount.
Would appreciate suggestions.

It sounds like your CSV file has commas (thousands separators) in the numbers, which for comma-separated-values purposes, is not a good idea.

Otherwise, if it's not extra commas confusing the file structure, then it's just the file structure that is not aligned to what the software is expecting.

Zorak
Thank you for the suggestion... I did not have any extra commas, however after reading your response and
reviewing my data I discovered I did not have the data in the proper field sequence as you suggested ...
corrected the sequence ... problem solved !
Thanks again.
Mike