#1 2025-01-01 23:37:45

Tharius
Member
2020-05-08
22

How to find an image in a virtual gallery by the path?

Hi everyone,

I am merging a collection from another computer into my Piwigo photo collection. I had previously merged a donation of photos from this person so a great many are duplicates.

To manage this I took a backup of my uploads directory and locally used DupeGuru to help me filter out the duplicated photos. All is well on this front. In some cases however, the file names from the duplicate photo in the donated collection describe the picture and should be retained as a comment before I delete the dupe.

Given all this information, it means I know exactly what the Piwigo filename is for my file. However since I'm using virtual albums I can't directly use this information to find the file within the gallery to add a comment to. Or at least I haven't figured out how, and so that's why I come to you.

How can I use the filename of my file to find the photo within Piwigo either in the standard gallery or using admin tools?

I understand already that I could simply upload the files, perform a CRC dupe check and possibly find the original that way, but I expect many, many of these files will have slightly different or missing metadata that could cause a crc check to fail.

Thanks!

PS: Edited to clarify the intention more directly, no the search by filename does not work. At present I am using SQL query "SELECT id FROM `piwigo_images` WHERE `path` LIKE "%20200509011541-e00d0118.jpg%";" to find my information and then feeding that back to the edit photo URL. I'm looking for an in app solution.

Thanks again!

Last edited by Tharius (2025-01-02 17:04:43)

Offline

 

#2 2025-01-02 07:57:20

Schneider-Fotografie
Extension maintainer
Berlin
2023-04-16
160

Re: How to find an image in a virtual gallery by the path?

"How to find an image in the gallery by the filename?"

Simply enter the file name in the search.


-Schneider-Photography- Gallery
----------------------------------
BYB | Block You Bots
„Stay human. I block the rest.“

Offline

 

#3 2025-01-02 16:41:36

Tharius
Member
2020-05-08
22

Re: How to find an image in a virtual gallery by the path?

Schneider-Fotografie wrote:

"How to find an image in the gallery by the filename?"

Simply enter the file name in the search.

Hello and thank you.

No, this matches the original file name that it had before it was moved into a virtual album.

For example, if my file was "asdf.jpg" and I upload it, it gets stored at (i.e.) "uploads/2020/05/09/202009095000001_abcdef.jpg"

If I had the original file name then yes, your answer would be correct. What I have is the latter information however.

Thanks!

Offline

 

Board footer

Powered by FluxBB