put a name into images without a name with filename

[daniell]

i want to know if theres a way to put the filename ( eg. jessicaalba.jpg )  as the name of that image on cpg!?!?!

maybe with phpmyadmin.. this is possible?!

thankz

[Abbas Ali]

Go to "Edit Files" of the album and copy the filenames to the "Title" field. This should solve your purpose i guess.

[daniell]

LOL

in 5000 images... 

i think so

[Abbas Ali]

In that case run the following query in phpMyAdmin (Replace cpg1410_ with your table prefix).

Code Select Expand


UPDATE cpg1410_pictures SET title=filename;


Remember to take a backup of the database before you do so. Running update queries directly from phpMyAdmin is quite risky in case you make mistake.

Above query will set the title of each picture in your gallery to its filename overwriting any previous titles.

[Nibbler]

You can do this via admin tools.

[Abbas Ali]

Oops, missed that. Apparently even Devs don't know the full functionality of coppermine

[Gizmo]

Beat me to it Nibbler. You can have the file "title" changed to the file "name" minus the extension in the admin tools. So the title will read "jessicaalba" and not "jessicaalba.jpg" which is a much cleaner look. Is this OK or were you asking something that deals only with the title? It's a bit confusing I know.

[daniell]

gizmo that works for me