CnP Importer File Format Error Issue

[Neely]

I am using 8.1008

[CnP.Support]

Neely,

Are you using version 8 or 7?

[Neely]

Yes! I need you all to fix it!

I emailed the original file from the direct export from our CnP portal account. I really am curious to know what the issue is.

Thanks!
Neely

[CnP.Support]

Neely,

So what you are saying is that you "broke" it and we now we have to fix it?

The file you are having issues with is the file that you changed or is it the standard file that you downloaded?

If you have changed it please go ahead & send us the file so we can review it. The format is extremely strict to ensure we can map the data correctly in Salesforce. Please forward it to support and we will review it. It will be Monday before I can find an answer.

[Neely]

Hi,

I am doing a data import into our new SF instance and it seems that 'file1.csv' always gets this error:
Warning:Please select correct format file

However, 'file2.csv' and 'file3.csv' worked just fine. I unzipped the initial 'SalesforceReport' file and all files were imported except 'file1.csv'. I can't figure out how something is wrong with that file and nothing was wrong with 'file2.csv' and 'file3.csv'.

Here are some steps I tried to remedy the problem:

1. Thinking it might be a size issue, I broke down the export from the account portal by year, and then again by 6 month intervals, instead of doing one big export and still all files titled 'file1.csv' got the same error as listed above.

2. I tried renaming the file. I still got the same error listed above.

3. I also tried saving the file as a MS-DOS csv file.....and still got the same error.

Please help. It's going to be a long weekend weeding through all the temporary contacts that have been made, but it is 'forcing' me to clean up our dupes, so I can't be mad at that. (smile) It's worth it to have a cleaned out instance that will only have NPSP and CnP....maybe a few other apps after I get all of this working correctly.

Thank you,
-Neely