Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: how to mass fill fields  (Read 2253 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.018 seconds with 20 queries.