Importing contributions from a csv file

[mpereksta]

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.

[Zorak]

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.

[mpereksta]

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