Updating a subset of rows

  • Resolved markwill

    (@markwill)


    2 years ago

    I am hoping I am missing a feature here since this one seems kinda common.

    I have a table of around 1,000 rows but regularly want to edit a subset of these. I know I can filter and then export but I can’t see how to import for UPDATE of those rows. The first column in my exported file is a key and unique.

    I know I can import with truncate if I export the entire table but obviously that’s overkill when I might only want to edit, say, 20 rows.

    How can I import my edited csv file, to update rows?

    I think I saw a “coming soon” comment from Peter on this a year or two back, but can’t see that feature. Does it exist?

    Thank you.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    Hi @markwill,

    The feature you’re looking for would be the remote connection to a CSV file which is outlined here: CSV files | WP Data Access.

    When you update your CSV file, you can manage synchronization which is detailed here: Synchronization | WP Data Access

    Hope this helps! Let us know if you have more questions. ??

    Thread Starter markwill

    (@markwill)

    Thank you for the reply, @kimmyx. I wasn’t aware of this feature so appreciate the pointer. However, I am still somewhat confused about a couple of aspects of this.

    1. As I understand, I cannot host the .csv file on my own server? I need to create an account on the wpdafree.youniquedata.com and then upload my .csv file to that. Is that accurate?
    2. It looks like the process of linking to a remote data service creates a new database on my server. My intent is to remotely edit an existing table in an existing database (a custom table in my WordPress database). Is there any way to associate an existing table with a remote .csv file?

    Thank you.

    • This reply was modified 2 years ago by markwill.
    Thread Starter markwill

    (@markwill)

    Any further thoughts on this? At this point I am assuming the remote option isn’t going to work for me in the way I’d like (described above), but would love to be proved wrong on this.

    Plugin Contributor Kim L

    (@kimmyx)

    Hi @markwill,

    Apologies for the delay in response. ??

    1. There’s no ‘hosting’ happening when you connect through our premium data services. It only allows premium users to make heterogeneous external data sources available to their WordPress back-end and front-end. You can read more about our Premium Data Services here. This service is free for all premium users.
    2. That’s correct. All tables from your CSV files will live in a remote database.

    Hope this helps! Let us know if you have more questions.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Updating a subset of rows’ is closed to new replies.