cvs import not importing data into correct 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 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • 01/15/2014 at 9:08 pm #277217
    Dennis Kelly
    Participant

    Don’t know what I’m doing wrong, but when I import my cvs file, it is not putting the mapped fields in the correct place. For example, my data file field titled “email” I map to the import field “work email” but it is showing in the display under “website”. There are several errors similar to this I am getting. I’ve triple checked that I am matching the fields correctly, but it doesn’t seem to be working right?

    01/15/2014 at 9:59 pm #277225
    Steven Zahm
    Keymaster

    @ Dennis

    I just literately uploaded an update, version 1.0.4, which you can download from your purchase history. I do not believe the update will resolve the problem because it only contains some very minor tweaks and it actually sounds like a bad CSV file. But can you please update and give it a try. Also, can you attach a copy so I can take a look?

    01/15/2014 at 10:09 pm #277227
    Dennis kelly
    Guest

    Thanks for the quick reply. I will try the update.
    I don’t see anyplace here to upload a file?

    01/15/2014 at 11:51 pm #277229
    Dennis Kelly
    Participant

    Ok.. see the file attachment link way below.
    Here is the cvs file I’m working with.

    Attachments:
    You must be logged in to view attached files.
    01/16/2014 at 12:08 am #277231
    Dennis Kelly
    Participant

    Steve… I attached a screen shot of my map settings… then a screen shot of one of the imported records. Notice that the phone number is showing in the city field, the email is in the work phone field, the website in in the work email field, and the notes field is showing in the website field?

    Attachments:
    You must be logged in to view attached files.
    01/16/2014 at 10:37 am #277245
    Steven Zahm
    Keymaster

    @ Dennis

    The issue was the CSV file. The header columns were quoted, I don’t think that would have caused the issue. But, there was no header for a column, which I think might have confused the CSV parser. I’ve attached a corrected CVS file which I confirmed imported correctly … I did change the column headers to the names so they would auto map.

    Attachments:
    You must be logged in to view attached files.
    01/16/2014 at 10:52 am #277248
    Dennis Kelly
    Participant

    Thanks so much Steve. Appreciate the extra effort!

    01/16/2014 at 11:37 am #277253
    Steven Zahm
    Keymaster

    @ Dennis

    If you have a moment, I would truly appreciate a review as they really do make a difference. Many thanks in advance!
    http://wordpress.org/support/view/plugin-reviews/connections

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

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