CSV Error Message "Every record must include a first and last name…

Support has been upgraded!



The Support Forum is closed. Not to worry!  Providing the top quality support you expect and we're known for will continue! We're not ending support, just changing where you submit requests. This will provide you with the best experience possible.

Premium Support

Have you purchased an addon for Connections such as one of our premium templates or extensions with a valid license and you need help?

Please open a Support Ticket in your user account.

Click here to open a support ticket.

Free Support

Are you using the free Connections plugin? Don't worry, you are still very important to us! We are still providing you with the same high quality support that we're known for.

Please open a new support topic in the WordPress support forums for Connections.

Click here to open a support topic.

This topic is: resolved

Tagged: ,

Viewing 9 posts - 1 through 9 (of 9 total)
  • Author
    Posts
  • 03/13/2013 at 12:49 am #253920
    Lincoln
    Guest

    Version 0.7.3.1

    When trying to import a 300 record set I get the following:

    “Every record must include a first and last name or an organization name.”

    The file is an ANSI text file using “Field1″;”Field2”; … format

    The file uploads and takes me to the mapping screen.

    I make the necessary mappings for the 13 fields and then get that error.

    A screen cap of the mappings can be seen here: http://i.imgur.com/h5M04bF.jpg

    I had 100% Compliance for FName and LName. There were those where the organization was blank.

    To be safe I created entries for those blank fields

    Got the same result.

     

    Thanks for any guidance.

    03/13/2013 at 12:52 pm #253954
    Steven Zahm
    Keymaster

    @ Lincoln

    Open you CSV file in a text editor. Are the fields double quoted?
    Like so: “”field_name””

    That’s what it looks like from the screen capture. The field names can not be double quoted. Just do a find/replace all double quotes to a single quotes and the import should work fine.

    03/13/2013 at 10:52 pm #254025
    Lincoln
    Guest

    Thanks for the quick response. There were no double quotes. (There are some fields that are blank and they would show as ;””; The header and a single record are included here.

    “MEMBER ID”;”Prefix”;”First Name”;”Middle”;”Last Name”;”Company”;”Address1″;”Address2″;”City”;”State”;”Phone”;”Email”;”URL”

    “00003”;”Mr.”;”IRSHAD”;”A”;”AADIL”;””;”1221 E. 700 S.”;””;”Salt Lake City”;”UT”;”(801) 322-2868″;”Not Public”;””

    In this record the person has no company and no URL so they both show as “”

    Thank you again for the excellent support.

    03/14/2013 at 8:38 am #254046
    Steven Zahm
    Keymaster

    @ Lincoln

    Can I get a copy of the CSV?

    03/19/2013 at 4:50 pm #254600
    Ali
    Guest

    Hallo Steven!
    Is there already a solution? I have the same problem. I look forward to supporting! Thank you ;)

    03/19/2013 at 5:58 pm #254617
    Steven Zahm
    Keymaster

    @ Ali

    I really only see this issue with malformed CSV files, usually the fields are double quoted which messes up the parsing of the CSV file. Can you verify the proper quoting of the file and if it is correct, can I get a copy?

    03/21/2013 at 2:55 pm #254723
    Ali
    Guest

    Thanks for the quick reply. Now it works – but some areas are still not covered.

    Got a Tip?

    03/22/2013 at 8:53 am #254799
    Steven Zahm
    Keymaster

    @ Ali

    Not sure I understand, ” but some areas are still not covered.”

    Could you please provide more detail?

    03/22/2013 at 9:32 am #254804
    ali
    Guest

    I have found the answer on http://connections-pro.com/support/topic/csv-import-end-of-import-after-34-lines/

    ;)

    Thanks for your quick response!

  • Author
    Posts
Viewing 9 posts - 1 through 9 (of 9 total)

You cannot reply to this support topic. Please open your own support topic.