CSV Import – Duplicates?

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 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • 06/07/2018 at 1:32 pm #464844
    Tony Nuismer
    Participant

    I’m tweaking my directory and import file as I see the results. Multiple imports don’t appear to be updating users, but duplicating them. Is there a way to update/modify the record on import instead?

    Deleting hundreds of staff members through “bulk” still isn’t fun.

    06/07/2018 at 2:16 pm #464856
    Steven Zahm
    Keymaster

    @ Tony

    Add an Entry ID column to you CSV file. Then add the ID assigned to each entry by WP to after you import to your CSV file. Then when you import again, Connections will be able to update that entry. Without that ID is is not possible to know if an entry is a duplicate or a new record. For example a last name change, there is no way to know that is not a new entry vs. an entry to be updated.

    Alternatively, instead of manually adding that Entry ID, after you import, you can export a CSV file which will already include it. This is found on the Connections : Tools admin page under the Export tab. You would want to use the “all” tool at the bottom of the page.

    Hope this helps!

    06/11/2018 at 1:57 pm #465243
    Tony Nuismer
    Participant

    I’ve added the EntryID column to my .csv import and ran the import. Where do I see the EntryID value in Connections? I’ve looked for it under “Manage”, but I don’t see it.

    Thoughts?

    06/11/2018 at 1:59 pm #465244
    Tony Nuismer
    Participant

    Nevermind…

    Just saw this: “If you are importing an exported file into a “clean” or “empty” database, do not map the Entry ID when importing. Mapping the Entry ID column tells the CSV Import to update the existing entries. If those entries do not exist, there are skipped, they are not imported as new entries.”

    06/11/2018 at 2:04 pm #465246
    Steven Zahm
    Keymaster

    @ Tony

    Just to confirm… you are good to go?

    06/11/2018 at 2:49 pm #465262
    Tony Nuismer
    Participant

    Yep… I’m good now with the EntryID. Still working on getting the Photo URL to work though.

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

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