coppermine-gallery.com/forum

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: kenshiro on March 12, 2004, 04:31:29 PM

Title: Batch add Picture
Post by: kenshiro on March 12, 2004, 04:31:29 PM
Hi, There are a way when i make batch add picture, add a title of image equal to filename ?
Title: Batch add Picture
Post by: Joachim Müller on March 13, 2004, 12:10:01 PM
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
Title: Batch add Picture
Post by: sharks on March 15, 2004, 01:58:49 AM
lol, I was looking for this the day before you posted... I didn't expect it under 'Resize Pictures!'  :D

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.

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:

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