CSV Import Appears to Work but Doesn't

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 16 total)
1 2
  • Author
    Posts
  • 01/25/2017 at 12:23 pm #408326
    KIMBERLY LUDWIKOSKI
    Participant

    I have been trying all morning to get a CSV file, created in Google Sheets, to import using the CSV import plugin. It appears to work, with no errors, but when I go to manage my entries, there are none there. I think I’ve read everything, and am not sure what I’m doing wrong.

    I’ve tried with the categories in no quotes, and single quotes. Didn’t make a difference.

    I’m attaching the file, as a text file and a csv file. I’d appreciate any insight you may have.

    Attachments:
    You must be logged in to view attached files.
    01/25/2017 at 12:28 pm #408329
    Steven Zahm
    Keymaster

    @ KIMBERLY

    Sounds like you added an Entry ID column and are mapping it on import. This is only for updating existing entries. Please try importing the CSV file without mapping the Entry ID column.

    Hope this helps, let me know.

    01/25/2017 at 5:01 pm #408391
    KIMBERLY LUDWIKOSKI
    Participant

    Thank you for looking at this, Steven. That is not the case, though. There is an ID column, but I left this as ‘Do Not Import’. Any idea what else I could be doing wrong?

    01/25/2017 at 5:29 pm #408421
    Steven Zahm
    Keymaster

    @ KIMBERLY

    Do you have both a first and last name column and mapping those if importing individuals? OR mapping organization if importing organizations? Like outlined in the CSV file requirements? If they are not, that would cause nothing to be imported.

    01/25/2017 at 5:35 pm #408422
    KIMBERLY LUDWIKOSKI
    Participant

    All are organizations (businesses) and I am mapping a business name to Organization.

    01/25/2017 at 5:43 pm #408424
    Steven Zahm
    Keymaster

    @ KIMBERLY

    Can you give me a temp WP admin login and I’ll take a look? Details can be posted here as a private reply.

    Is the file you attached originally still current? Can you also attach a screenshot showing the mapping you are using?

    01/25/2017 at 6:22 pm #408437
    KIMBERLY LUDWIKOSKI
    Participant

    I am working on the site locally, using WAMP, so I don’t think this is possible. Attached are documents showing the mapping of the fields, and a new copy of the CSV file.

    01/25/2017 at 6:29 pm #408438
    KIMBERLY LUDWIKOSKI
    Participant

    Trying again!

    Attachments:
    You must be logged in to view attached files.
    01/26/2017 at 1:41 pm #408502
    KIMBERLY LUDWIKOSKI
    Participant

    Hi Steve,

    Are you able to tell, from the mapping information & my listing file, what I am doing wrong?

    Kim

    01/26/2017 at 2:13 pm #408528
    Steven Zahm
    Keymaster

    @ KIMBERLY

    Yes, I have been working on this most the day in fact. And was typing my reply as I received your latest query.

    I was able to replicate this on my test site. I was not able to find the exact cause but it was either related the file not being able to be parsed properly due to some of the serialized field data. Maybe all the extra quotes was making it an invalid CSV file. There was also two Title fields. This could have been breaking the mapping.

    I was able to import just fine once the extraneous fields were removed from the file. So that is my suggestion.

    Now, that said, I did find a bug with the import of categories. The categories with & in the name were not being imported. It took me a while to track down why and correct. I’m not sure when this bug was introduced as I know it was not an issue before.

    I’m working on pushing an update to CSV Import in the next couple hours. Look for it in your WP and update. (Note: you’ll have to activate your license on the site to update with thin the admin. Alternatively, you can manually apply the update. Since you are working in WAMP, I assume you know how to do that.)

    Apologies for the troubles, let me know how it goes.

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

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