🌍
English
Hello,
on my self hosted Piwigo instance I imported thousands of photos that are now all in one huge folder. This folder cannot even be opened by the Piwigo iOS App. What would be the best way to get some structure in my photos? I wonder whether I have to create a folder per month or so to sort and copy the photos manually.
What is the Piwigo way to solve it?
Thanks for your help.
Regards
Offline
I am definitely not a Piwigo expert, but I have seen issues with very large numbers of database entries when using SQLite. What database backend are you using for Piwigo? If you are using SQLite, you would do well to switch it out for MariaDB or PostgreSQL.
On another note, tell us a little more about your use case. I doubt most people pile all of their photos into a single album (which is what it sounded like you were describing). Try sorting your pictures based on either categories, or timeline (like you yourself suggested).
Offline
Here is what I just did, I am using Warp AI Terminal on my Windows computer. (Also works on Linux and Mac)
I asked the AI to search for all image files (IMG_xxxx.*) on my computer. This would include years of camara and phone backups that I literally just put anywhere.
I then asked it to copy them into a single folder. It found over 20,000 of them.
Next I asked it to look at each image's meta_data and using the Date_Taken property, move each image file into a folder named by year, if there was no Date_Taken property move it into a folder called undated. (I would manually fix those)
I ended up with all 20,000 photos in directories from 2000-2025. Sweet. I didn't have to write one line of code (not that I couldn't have), but I didn't need to.
Finally I copied that folder into a new one, and started culling them by flipping the View to Extra Large Images and going through each year. We tended to take 10 photos of our son eating his 1st birthday cake, and honestly only needed one to document the occasion.
Once done, I only had 700 photos in 25 directories. And it really only took a few hours. Then you can either use RemoteSync-UI, or figure out the FTP built-in Sync.
i hope this helps.
Paul
Offline