🌍
English
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
Offline
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';
Offline
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).
Offline
Thank you TheChief and Tajio. Will check that out.
Offline