Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

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

0 Members and 1 Guest are viewing this topic.

apanda

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
How to Add Many Titles at Once
« 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
Logged

apanda

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: How to Add Many Titles at Once
« 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
Logged
Pages: [1]   Go Up
 

Page created in 0.017 seconds with 19 queries.