So, this may not be news to most of you but I found a way to quickly prepare new descriptions for my mages offline and then have a spreadsheet concatenate SQL queries that you can run on your server (f.i. in phpMyAdmin) to bulk update your image titles in a hurry.
So what happened is that I migrated from Flickr and all of my images had ridiculous titles which didn't make any sense. Clicking every image in a Chevereto album, then clicking [Edit], changing the description and then saving the edit becomes tedious after a minute or two.
I downloaded the images table from my chevereto database and chopped off everything except for the image_id and image_title column (columns A and B in the sheet). I then added a column where I typed in a sensible description (column C) and a fourth column (D) containing the formula:
Copying the formula down for forty, 60 or more rows followed by simply typing in descriptions which matched my images resulted in something like this (I'm only showing a few rows out of more than 80).
Finally, I copied column D in its entirety into the query window in phpMyAdmin so it read:
And I ran the query (after simulating it first to ensure I had no SQL syntax errors). Instantly, my whole album view updated with the new titles on every single image after a page refresh and the new titles also show up when sharing via social networks or BBCode.
Probably trivial to most here but I thought it would be useful.
Disclaimer: PLEASE, PLEASE, PLEASE backup your database (or at least this table) before trying this out and ALWAYS run a query simulation before the "real thing"! I do not take responsibility for anyone messing up their whole site because of this!
So what happened is that I migrated from Flickr and all of my images had ridiculous titles which didn't make any sense. Clicking every image in a Chevereto album, then clicking [Edit], changing the description and then saving the edit becomes tedious after a minute or two.
I downloaded the images table from my chevereto database and chopped off everything except for the image_id and image_title column (columns A and B in the sheet). I then added a column where I typed in a sensible description (column C) and a fourth column (D) containing the formula:
Code:
="UPDATE chlv_images SET image_title = '" & C3 & "' WHERE image_id = " & A3 & ";"
Copying the formula down for forty, 60 or more rows followed by simply typing in descriptions which matched my images resulted in something like this (I'm only showing a few rows out of more than 80).
Finally, I copied column D in its entirety into the query window in phpMyAdmin so it read:
And I ran the query (after simulating it first to ensure I had no SQL syntax errors). Instantly, my whole album view updated with the new titles on every single image after a page refresh and the new titles also show up when sharing via social networks or BBCode.
Probably trivial to most here but I thought it would be useful.
Disclaimer: PLEASE, PLEASE, PLEASE backup your database (or at least this table) before trying this out and ALWAYS run a query simulation before the "real thing"! I do not take responsibility for anyone messing up their whole site because of this!