Announcement

Collapse

Information Needed

See more
See less

CnP Importer File Format Error Issue

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • CnP Importer File Format Error Issue

    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
    Last edited by Neely; 12-21-2013, 10:19 AM.

  • #2
    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.
    Regards,
    Click & Pledge Support Department

    On Salesforce? Help us by rating our app: Click & Pledge Donor Management on AppExchange

    Join us @ the educational webinars: https://clickandpledge.com/webinars/
    Live Support available Join between 3:00 - 3:30 p.m. ET Monday - Thursday: https://clickandpledge.com/webinars/
    Are you on Salesforce? Join us at the Power of Us Hub: https://powerofus.force.com/0F980000000CjpC

    Comment


    • #3
      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

      Comment


      • #4
        Neely,

        Are you using version 8 or 7?
        Regards,
        Click & Pledge Support Department

        On Salesforce? Help us by rating our app: Click & Pledge Donor Management on AppExchange

        Join us @ the educational webinars: https://clickandpledge.com/webinars/
        Live Support available Join between 3:00 - 3:30 p.m. ET Monday - Thursday: https://clickandpledge.com/webinars/
        Are you on Salesforce? Join us at the Power of Us Hub: https://powerofus.force.com/0F980000000CjpC

        Comment


        • #5
          I am using 8.1008

          Comment

          Working...
          X