Massive Bulk Operation
This is an open discussion with 3 replies, filed under General.
Search
I lied. INSERT INTO sym_entries_data_28 (entry_id, handle, value) SELECT school.entry_id, "public", "Public" FROM sym_entries_data_5 AS school
did the trick.
I'd be interested to hear if there's a better way, though.
Nope, the direct SQL query is by far the fastest way to do this. There is the Resave Entries extension too that can be helpful if there are multiple/complex fields.
You must have read my mind. I was just about to write some nasty SQL to update the handles of a few thousand text inputs. That extension'll do the job nicely.
Thanks, brendo!
Edit: Actually, considering "Public" was the new default for the select box, resaving the entries via that extension would probably have worked too :)
Create an account or sign in to comment.
Apologies if this has already been asked; I must be searching for the wrong term.
I have a section of about 20k US public schools. I (stupidly) forgot to add a "type" select box (public or private) before I imported the public schools. Is there any way to do a one-shot massive bulk operation ("With selected..." > Set Type > Public) on all existing entries?
I'll happily dive into the SQL; I'm just not comfortable enough with the schema to risk constructing a query on my own.
Thanks!