forum.coppermine-gallery.net

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

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