Print Page - How to Add Many Titles at Once

Title: How to Add Many Titles at Once
Post by: apanda on October 12, 2006, 12:37:03 AM

Hi. I am moving a 2000 photo collection to Coppermine. Is there an efficient way to add Titles to the photos all at once?

I can make a table of filenames and Titles. Can I get this into the database some quick way? Perhaps I can figure out SQL and do it that way, but maybe there's a better way than that. Someone please let me know.

Andrew

Title: Re: How to Add Many Titles at Once
Post by: apanda on October 12, 2006, 01:03:44 AM

I did some more searching and found Ralf's reply. He suggests using SQL like this:

Update cpg_pictures
SET title = x
WHERE aid = y

I will try that unless I see a better solution here soon. Thanks for reading. Thanks, Ralf, for your answer.

Andrew

coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: apanda on October 12, 2006, 12:37:03 AM