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: a way to mass add comments?  (Read 2998 times)

0 Members and 1 Guest are viewing this topic.

T3rry

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 36
a way to mass add comments?
« on: October 21, 2004, 10:17:23 pm »

a way to mass add comments?

i did a batch file upload but in order for the shopping card mod to work the files need to have a descritpion entered, is there a way to have the batch upload thing automatically put the name of the file (or whatever) in the description section of each file....


or is there a way of doign it thought the DB or whatever so i dont ahve to click each file, enter the desc, and click save, that'll take for ever on the 1700 photos i have.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47844
  • aka "GauGau"
    • gaugau.de
Re: a way to mass add comments?
« Reply #1 on: October 22, 2004, 08:21:08 am »

you could run a database query (using a tool like phpMyAdmin or similar) like this
Code: [Select]
UPDATE `cpgprefix_pictures` SET `title` = 'Your title' WHERE `filepath` = 'the/folder/your/pics/reside/in/';or
Code: [Select]
UPDATE `cpgprefix_pictures` SET `title` = 'Your title' WHERE `aid` = '12345';You will of course have to set the proper table prefix and adjust the folder or aid to fit your needs. If you don't know your way around in phpMyAdmin, you should backup your database before running any queries against it, as improper use may break things.

Joachim

P.S. In the future, please post on the support board for the version of coppermine you're running, not on the "general discussion" board, as it is not meant for support requests like yours.
Logged

T3rry

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 36
Re: a way to mass add comments?
« Reply #2 on: October 22, 2004, 05:17:03 pm »

thanks, and sorry about the misplaced post.
Logged

T3rry

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 36
Re: a way to mass add comments?
« Reply #3 on: October 22, 2004, 05:29:34 pm »

FYI if anyone is intrested i found out that if you go in to admin tools and select to make the file name = the title this also works wihtout toying with the DB.
Logged
Pages: [1]   Go Up
 

Page created in 0.017 seconds with 20 queries.