CSV Import: Upating Data

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
  • 01/05/2014 at 1:18 pm #276461
    Mike Nolan
    Participant

    Is it possible to update data entries via an CSV Import?
    I saw a post from 2010 where you stated that CSV Imports would not update data but, would create duplicate entries.
    Is this still the case or has this been updated?
    If this has not been updated or addressed, feature request:
    >> Allow for updating via CSV Import.

    01/06/2014 at 10:58 am #276486
    Steven Zahm
    Keymaster

    @ Mike

    With versions 1.0 and greater … off the top of my head I think this could be added with only a few lines of code and if the entry ID were supplied in the CSV file. There would be one big caveat. All the addresses, phone, email and such would actually be wiped and then reimported. This is because those fields support n-number of items. So, to answer your question, no, this has not been implemented because of that, sorry.

    01/06/2014 at 2:32 pm #276500
    Mike Nolan
    Participant

    @Steve

    Performing a complete wipe and re-import would not be unacceptable.
    It would actually be much, much more preferable than creating duplicates.

    Is there a limited to the number of entries that could or should be imported at one time?

    Ultimately we will have tens of thousands of entries but, we could break the uploads in to sub-sets if necessary.

    01/06/2014 at 3:12 pm #276512
    Steven Zahm
    Keymaster

    @ Mike

    The upper limit per import is still server resource bound. I’ve only tested up 20,000 in a CSV import. The current CSV Import will import the import in lots of 100. If you have a beefier server, you could alter this value quite easily to import 1000 at a time. Imports are more efficient in larger chunks. I have to keep the value low so it doesn’t run into problems on the lower priced shared hosts.

    NOTE: Even though the imports happen in chunks the CSV library I use still parses the entire file, so that’s where the script will be server resource bound.

    Hope that helps.

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

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