Batch Comments

[Peaces]

Is there a batch process or excel file or automated way I can add the same comments/keywords to multiple files in the same category without going into each individual file page?

I will have over 4000 images uploaded which are broken down into 8 categories. There are comments and keywords that will be the same for every image in a specific category.

I am just not looking forward to editing every image when the information will be exactly the same.

Suggestions? Thanks!

[rinaldos]

if it is possible, use phpmyadmin...... Be careful, Backup your database before!

try this.....

UPDATE 4images_images 
SET
`image_description` = 'your description',
`image_keywords` = 'your keywordst'
WHERE `cat_id` = 'your category id';



Gruß

[Peaces]

I have never used phpmyadmin so I will probably not wnat to try it.
Thank you for offering a good suggestion.
Warren

[Peaces]

Ok, some follow up questions from my ignorance of not knowing php.

When I go into phpmyadmin, where do I place the code you suggested? Do I look for a particular location?

I have 8 categories... do I put the code into phpmyadmin 8 times or do I put it in for one category and it runs the script then I change it for the next category and then again for each category?

[V@no]

Do you mean "description" instead of "comments"?
If so, then try first [MOD] Batch Copy/Move/Edit Images

[Peaces]

Yes, I meant Descriptions and Keywords.

Thanks for the response. I got instructions from my Host as to applying the script.

I appreciate the help!

[4ella]

@ V@no.
I think he meant to put once descriptions and keywords for every category , for example I have Santa Teresa Gallura pictures which is the city on Sardinia (Italy) , I have 800 pics in this 1 category , I think that he meant to make once keywords (Santa Teresa Gallura , Sardinia , Sardegna , porto , cità , etc) and description (Santa Teresa Gallura is the small city on....) So one description and keywords for all pictures in each category batching these keywords in all 800 pics at once - with batch Copy /Edit /Move  he has to go everytime to Copy and Insert these keywords and description in each image separately . This would be a very useful Mod to make it once - not 800x. And then with Mod Batch Copy/Edit...  to repair some keywords of images - (add - delete)

@Peaces
If you are searching for this as I described above I don't think that you will find it here yet , I was searching for the same and till now didn't find it

[Peaces]

4ella,

You are exactly correct in your description of what I want to do. I have over 4000 pics to edit. I am going to try the myphpadmin script suggested by rinaldos to make it happen and will return to share my experience.

V@no,

Thank you for sharing your MOD! I have uploaded it and it looks great for many edits that I will want to do going forward.

[V@no]

with batch Copy /Edit /Move  he has to go everytime to Copy and Insert these keywords and description in each image separately . This would be a very useful Mod to make it once - not 800x.

You can search for all images in one category, and then batch edit their description/keywords with a single form:

[Peaces]

AWESOME! I will go try it.

[4ella]

   I didn't noticed that it works also for whole category , I'm silent now 

[Peaces]

OK, Sorry for my ignoance... I selected the Category... not sure how to select all the photos other than I know how many are in the category and change the number in "results per page".

Do I select a "Quick Edit" choice?  ex... Description? That does not get me to a screen like what you show.

Am I missing a step in getting to the Batch screen like your screen prints?

[Peaces]

OK, I understnd choosing all images in a category. The only issue is not seeing the same screen (batch)  as what is in your post.

[4ella]

I don't see it too , I'm controlling all the Mod I installed a time ago , I dont see this screen as V@no has published , maybe I have something forgot when installing   

[Peaces]

OK, I took rinaldos recommendation:

UPDATE 4images_images
SET
`image_description` = 'your description',
`image_keywords` = 'your keywordst'
WHERE `cat_id` = 'your category id';

And went to myphpadmin on my Host site and ran the script. It works perfectly.