CSV Import Assigning Wrong Fields

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 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • 02/14/2016 at 7:19 am #365259
    Shawn Ryan
    Participant

    When I import the attached file (only one record, so I can easily clean up if things go wrong), it puts everything in the wrong fields. Everything auto-maps correctly during setup, but after import nothing is where it belongs. For example, it puts State and Zip Code in First and Last name (respectively).

    What am I missing? Thanks!

    Attachments:
    You must be logged in to view attached files.
    02/14/2016 at 7:35 am #365262
    Steven Zahm
    Keymaster

    @ Shawn

    I downloaded your CSV test file and replicated the issue. I do not know the cause yet… I’ve never seen this before so it’ll take me a little time to figure out why and how to correct. I’ll get back to your asap.

    02/14/2016 at 8:01 am #365263
    Shawn Ryan
    Participant

    Thanks Steven – glad it’s not just me! My best guess is I confused it by listing multiple fields as home phone? I know you can do that through the GUI when you add them manually, so I assumed it would be OK in the CSV, but maybe that’s what did it?

    Thanks for the quick reply, and the really great plugin!

    02/14/2016 at 1:12 pm #365269
    Steven Zahm
    Keymaster

    @ Shawn

    The issue as it turns out is the duplicate columns… The CSV Import does not support mapping multiple columns to the same field. Honestly, never tested that or even considered it. It is interesting that the duplicate columns shifts the data rather than overwriting a duplicate. Not supporting multiple columns of the same type is a limitation of the CSV file format… I suppose I could add a way by appending; 1 ,2, 3 and so on to the various field types but that would really further clutter up the drop down of mappable fields and probably not make the auto mapping work correctly.

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

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