Batch add Picture

[kenshiro]

Hi, There are a way when i make batch add picture, add a title of image equal to filename ?

[Joachim Müller]

not with the batch-add function, but you can use the "resize pictures" link in the admin menu to batch-rename pics in a folder.

GauGau

[sharks]

lol, I was looking for this the day before you posted... I didn't expect it under 'Resize Pictures!'  

I may as well post the way I came up with in case anyone wants a quick way if they are adding pictures frequently to lots of albums.

It's an SQL query - you need to have phpmyadmin or some other access to run SQL queries on MySQL.

Code Select Expand

update cpg11d_pictures set cpg11d_pictures.title =
SUBSTRING_INDEX(cpg11d_pictures.filename, '.', 1);

It simply sets the title to the filename without the extension. It works for filenames with only one '.' in them

If you want to keep existing titles, this should work:

Code Select Expand

update cpg11d_pictures set cpg11d_pictures.title =
SUBSTRING_INDEX(cpg11d_pictures.filename, '.', 1)
where cpg11d_pictures.title = ''