how to mass fill fields how to mass fill fields
 

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

Main Menu

how to mass fill fields

Started by paperlife, May 11, 2012, 12:49:21 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

paperlife

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.

Αndré

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.).

paperlife

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

Αndré

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