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 mass fill fields  (Read 2277 times)

0 Members and 1 Guest are viewing this topic.

paperlife

  • Coppermine newbie
  • Offline Offline
  • Posts: 14
how to mass fill fields
« on: May 11, 2012, 12:49:21 am »

when i select Modify My Album :> edit files. i get a lot of file info

ex:
title
description
author
subject...etc.

is there a way to fill in (for example) author, and copy that field into every picture or upload (especially in the album list) ?

sure would be helpful, i would like to copy/ paste author, subject across a few hundred pix.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: how to mass fill fields
« Reply #1 on: May 11, 2012, 09:16:55 am »

IMHO the easiest way would be to use a simple SQL query. Maybe there's also a plugin, but I assume you already searched for it in the plugin contributions board and haven't found one.

Regarding the SQL stuff, see http://www.w3schools.com/sql/sql_update.asp

If you need further help, please post more details (which fields should be changed to what, etc.).
Logged

paperlife

  • Coppermine newbie
  • Offline Offline
  • Posts: 14
Re: how to mass fill fields
« Reply #2 on: May 12, 2012, 11:51:20 am »

thanks...and i want to learn how to use SQL, and cubes such...

its the meta-data or info fields  i want to apply to all images.
i enter an album, and i have 300 pics i took at a picnic, 200 of them from me, 100 from friends.
i would like to enter the fields (like author, subject etc) into them all, but as of now, i would have to copy/paste each field individually, and would like to have a way to either :

-copy the info from one box into all other images in that album
-copy the info from one box into select images, or 1-50, etc...

i can rename them all with command line, but that doesn't fill in the fields, which helps with searches, and such
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: how to mass fill fields
« Reply #3 on: May 15, 2012, 11:12:47 am »

Use the following query at your own risk!

Quote
UPDATE cpg15x_pictures SET user1 = 'Paste your info here' WHERE aid = '1234'

The above query will change the custom field for image descriptions 1 for all pictures of the album with the ID '1234'.
Logged
Pages: [1]   Go Up
 

Page created in 0.021 seconds with 20 queries.