Piwigo.org

JJF · 2012-08-05 01:55:18

Hello everyone,
Has anyone come up with a method to mass update photo titles and descriptions?

My photos all exist in physical albums inherited from the album software I was using before Piwigo (album.pl - perl.bobbitt.ca/album/). About eight years' worth of album and photo titles, and their respective descriptions, all exist in text files. I would like to update Piwigo from a spreadheet or a delimited text file rather than retyping everything into Piwigo.

Thanks.
JJF

TheChief · 2012-08-05 10:09:09

You could create SQL statements and run it directly in you MYSQL Server.

For example:

update piwigo_images set title='title', comment='comment' where filename='IMG_1234.JPG';
update piwigo_images set title='title1', comment='comment1' where filename='IMG_6789.JPG';

Tadjio · 2012-08-05 15:45:14

Have a look at Piwigo Import Tree under Docs. http://piwigo.org/doc/doku.php

Pierrick wrote it and I used it to import all my Fotopic Gallery Backup files, including Descriptions.
Before you use it, it needs updating to put the Description in the Comments rather than the Name (Title).

JJF · 2012-08-05 17:41:45

Thank you TheChief and Tajio. Will check that out.

Piwigo.org

Announcement

#1 2012-08-05 01:55:18

Mass update or photo titles and descriptions?

#2 2012-08-05 10:09:09

Re: Mass update or photo titles and descriptions?

#3 2012-08-05 15:45:14

Re: Mass update or photo titles and descriptions?

#4 2012-08-05 17:41:45

Re: Mass update or photo titles and descriptions?

Board footer