CSV Import > Record Updating without 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.

Tagged: , ,

Viewing 10 posts - 1 through 10 (of 10 total)
  • Author
    Posts
  • 01/06/2014 at 2:35 pm #276501
    Mike Nolan
    Participant

    @Steve

    Please allow for record updating without duplicates via CSV Import

    01/28/2015 at 8:29 am #317347
    Steven Zahm
    Keymaster

    @ Mike

    The latest version of CSV Import does support a pseudo update. If you add an Entry ID column to your CSV file and populate it with the Entry ID in Connections the data will be updated rather than duplicated.

    I say pseudo update because data such as addresses, phone, email and such are deleted and re-imported. Info like the name, bio, notes and visibility are updated. Additionally the category associations and images retain their links to the entry.

    So, from what you said, it does sound like the current updating support will meet your needs.

    I do not mention it as a feature because it has only limited testing but those that are using it seem fine with it and not have reported any bugs.

    I hope that helps!

    03/04/2015 at 5:15 pm #321611
    B
    Participant

    Using CSV Import I’ve tried to upload my list including an Entry ID field, however no data will import. If I exclude the Entry ID field on the csv file, the list imports correctly. Might you have any idea as to what would cause this?

    03/05/2015 at 10:47 am #321727
    Steven Zahm
    Keymaster

    @ Brannon

    Do the entry ID/s match those exactly that are already in Connections? If they do not match exactly, they will not be updated.

    03/05/2015 at 1:00 pm #321773
    B
    Participant

    Thank you for the reply and I apologize if I should have posted this as a new topic. I’m actually trying to upload new records into an empty connections db. I was trying to give the records my own ID number in the upload, but no records are added.

    03/05/2015 at 1:39 pm #321776
    Steven Zahm
    Keymaster

    @ Brannon

    Sorry, but you can not create your own ID/s those are auto create by the database table when an entry row is inserted. The entry ID for importing is only update an existing ID. Read more in my previously reply here:
    http://connections-pro.com/support/topic/csv-import-record-updating-without-duplicates/#post-317347

    03/05/2015 at 6:01 pm #321786
    B
    Participant

    So does that mean I have to import the entries first, and then go into MySQL to do the export so that I have the Entry IDs for my many records…since there is not an export function in the extension? Also, I’m not seeing in MySQL the table for images or image links. Since one cannot CSV import images (obviously) or links to images already within WP Media, I’m trying to find a work around, rather than uploading hundreds of pics that are already there. I see in MySQL connections_link>columns>images, but I have an image uploaded for one record but it’s not showing up there. Are they somewhere in the db? I saw another post about this but it did not seem to be what I’m referring to here.

    • This reply was modified 11 years, 5 months ago by B.
    03/06/2015 at 9:33 am #321841
    Steven Zahm
    Keymaster

    @ Brannon

    re: So does that mean I have to import the entries first, and then go into MySQL to do the export so that I have the Entry IDs for my many records…since there is not an export function in the extension?
    It’s the only way I can think of doing it. You can try using this script to do the export. This is not a plugin, it is a separate PHP script. It has a rather complicated setup, instruction in the txt file, but should work very well. It is going to be the base of the export that will be built into Connections.

    re: Also, I’m not seeing in MySQL the table for images or image links.
    There is none. The image name and meta data for the logo and photo are save in the the options column in the main {db-prefix}_connections table.

    re: I see in MySQL connections_link>columns>images,
    There is an image and logo column. They are binary values 0 or 1. It used used to determine if the image/logo is link to a “Link” url.

    re: I’m trying to find a work around, rather than uploading hundreds
    Change I’ve made to the image processing in version 8.1 will make this possible in future version of Connections… I’m just not quite there yet. If you can get the image name in the options column of the entry and you can get the image in the uploads folder, Connections will pick it up and use it. The folder path has to be precise though. Example:

    ../wp-content/uploads/connections-images/{entry-slug}

    The entry slug will only be known after it is imported, much like the entry ID it is unique and created when inserted into the db.

    Hope that helps.

    10/07/2015 at 8:15 pm #349734
    Jarred
    Guest

    <blockquote cite=”If you can get the image name in the options column of the entry and you can get the image in the uploads folder, Connections will pick it up and use it. The folder path has to be precise though.”

    I’m unable to find a mapping field for the options column you have mentioned above. Are you able to point me in the right direction?

    10/08/2015 at 10:31 am #349797
    Steven Zahm
    Keymaster

    @ Jarred

    re: I’m unable to find a mapping field for the options column you have mentioned above.

    There is no “mapping” field. I was referencing the entry options table item in the database.

    re: Are you able to point me in the right direction?

    This is beyond what I can provide support for as it requires advanced knowledge of mysql during database inserts directly, sorry.

  • Author
    Posts
Viewing 10 posts - 1 through 10 (of 10 total)
  • You must be logged in to reply to this topic.