Edit multiple titles at once

[hoss]

Is there any way I can edit the title of multiple images at once? It seems to default to the filename when they are uploaded but I'd like to change them to all be the same...more of a general description than a filename. I have a lot of pictures, so I really hope this is possible! Thanks.

[imperialWicket]

It would probably be easiest to upload as normal, allowing the titles to default as they normally do, then make this change manually in the database.

Something like:

Code: Select all

UPDATE joomla1518.jos_phocagallery SET title='My generic title' WHERE catid=5 ; 

A couple of notes - that will change the title for every image assigned to that category, not just the most recent uploads. If you wanted something that just affected the latest group

For the most recent group an update like:

Code: Select all

UPDATE joomla1518.jos_phocagallery SET title='testing' WHERE id < 150;

Where 150 is the id immediately prior to the group that you just uploaded.

If you aren't comfortable with SQL: I recommend that you backup your database first, then ask more questions (if anything is unclear), and then use this technique.