coppermine-gallery.com/forum

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: paperlife on May 11, 2012, 12:49:21 AM

Title: how to mass fill fields
Post by: paperlife 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.
Title: Re: how to mass fill fields
Post by: ΑndrĂ© 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.).
Title: Re: how to mass fill fields
Post by: paperlife 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
Title: Re: how to mass fill fields
Post by: ΑndrĂ© on May 15, 2012, 11:12:47 AM
Use the following query at your own risk!

QuoteUPDATE 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'.