Topic: How to Add Many Titles at Once (Read 2050 times)

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

apanda · « **Reply #1 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

News:

Author Topic: How to Add Many Titles at Once (Read 2050 times)

apanda

How to Add Many Titles at Once

apanda

Re: How to Add Many Titles at Once