Fields all mixed up

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 10 posts - 1 through 10 (of 27 total)
1 2 3
  • Author
    Posts
  • 12/21/2017 at 2:09 pm #444953
    Dan
    Participant

    I’m trying to import a csv and have mapped all the fields correctly (tried multiple times) but every time the address line one is in state, city is in zip code, phone #’s and email addresses are left out, etc. Is there any way I can send you the csv privately to troubleshoot?

    12/21/2017 at 3:38 pm #444959
    Steven Zahm
    Keymaster

    @ Dan

    What version of the CSV Import? Is it current? The current version is 1.4.7.

    Generally errors like this is due to malformed CSV files. I suggest opening the file in Google Sheets or LibreOffice Calc. Remove all empty columns, save out a copy ensuring the file is UTF8 encoded.

    If CSV Import is current and following the above linked advice does not help, you can attach the file as a private reply. You might have to rename it from .csv to .txt in order to attach it.

    Hope this helps, let me know.

    12/27/2017 at 3:12 pm #445384
    Dan
    Participant
    This reply has been marked as private.
    12/29/2017 at 10:01 am #445449
    Steven Zahm
    Keymaster

    @ Dan

    I see nothing obviously wrong with the file. Can I get a WP admin login and a screenshot of the mapping you are using when importing the file? Details can be posted here as a private reply.

    12/29/2017 at 11:48 am #445498
    Dan
    Participant
    This reply has been marked as private.
    12/29/2017 at 12:47 pm #445502
    Steven Zahm
    Keymaster

    @ Dan

    Thanks for the info, but, I still need the login URL. ;)

    12/29/2017 at 2:01 pm #445509
    Dan
    Participant
    This reply has been marked as private.
    12/29/2017 at 4:35 pm #445535
    Steven Zahm
    Keymaster

    @ Dan

    Hmmm… the password seems to be invalid. Could you double check it?

    12/29/2017 at 5:01 pm #445538
    Dan
    Participant

    I’m sorry. Try the same one again. It should work now.

    12/30/2017 at 10:32 am #445586
    Steven Zahm
    Keymaster

    @ Dan

    Ok, I was able to duplicate and determine the issues. Two items I do not think I considered… duplicate column names in the CSV file mapping to duplicate data types. Eg., multiple columns named phone, mapped to the “Home Phone” type. Each in themselves presents an issue and combined make it worse.

    The easy quick fix… make sure each column header name is unique and map each column to a unique field type. Eg., “phone, phone 1, phone 3” mapped to “Home Phone”, “Work Phone” and “Cell Phone”. OR Navigate to the Connections : Settings admin page, click the Field Configuration tab and scroll to the Phone Types section. Here you can add additional “home” phone types, such as “Home Phone 1”. You will then be able to map to it when importing. While this will work for the phone numbers, it will not work for the email as I have not yet added the email field types options yet. This will be added in the next Connections update.

    I don’t think I’ve ever considered that one would import multiple home phones and such to a single entry.

    If your timeline permits, I can work out this issue and update the CSV Import to work correctly in this scenario and then import the file for you. Let me know.

  • Author
    Posts
Viewing 10 posts - 1 through 10 (of 27 total)
1 2 3

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