Automatic folder structure detection, I'm desperate for this feature Options

[Usher]

Hello!
I've been searching for a GOOD picture gallery program for ages now, and so far I've come up with a simple conclusion: Go basic, such as 'picy' and have real ease up updating, but no nice features; Go full out, such as 'Gallery2' and get way more than you need, and a slow slow slow bloated pos. At long last I think I have found the perfect middle-ground in Zenith, and am eager to implement it, but I have one HUGE problem that I refuse to waste hours of my life fixing: Uploading pictures.
Let me explain. I have tons of pictures in an already existant folder structure on my linux box, exactly in the sub categories i would want them in, and although most currently lack good names, I'm happy with where they are. When I installed Zenith, the only way to bring those pictures in, that i can find, is to use the 'batch upload', which requires I take them all out of their folder structure and recreate that same structure in categories, and reimport. End result: I will have all my files in their exact same folder organization, with the exact same names, but Zenith will know about them.....and I'll be 4 hours older and many shades more grey on top.
I attempted to create a few categories and put the pictures there manually to test, and the 'create thumbnails' functionality worked, but they never showed up in Zenith, I assume because they are not in the database. So what I need desperately is some functionality to have categories and subcategories automatically created, and files detected and added to the database, even if there is no special info like a description added by default. Otherwise I must go find some other solution, and I don't look forward to that.

Please please please help me out! You have an incredible piece of software here!

Thanks,

~Usher

[usr.c]

Hi, Thanks for the comments. I'll go ahead and write a script to do just that for you and hopefully have it ready before the weekend.

I'll keep you posted.

[Usher]

Thanks SO much!
How can I donate? I want to make sure to support you, since this is such an awesome piece of code!

[usr.c]

Try this. Upload it to your main installation directory and run it from your browser. Then Run the "Rebuild Thumbnails" tool in the Admin CP to create your thumbnails.

Make sure
*All directories under uploads are readable
*You've already setup your gallery (the script uses variables from your config.php file)

Currently, it sets the keywords and title fields to the filename.

I didn't get a chance to test it on more than one of my test galleries, but it should be ok. If anything weird happens, let me know.

Attached File(s)

 automatic_file_structure_detector.php ( 5.36K ) Number of downloads: 86

 

[Usher]

Two things,
When I run the script you made, it appears to work properly, but it makes duplicate entries of any categories that already exist. So categories such as 'Other' get added again, so that there are two 'Other' folders, and if I run the script again, it makes a third copy, etc...

Second, after runing the script, I ran the 'rebuild thumbnails' and this is what was output. I only put pictures in the 'Other' folder as a test.
Let me know how I can help out.

Warning: imagecreatetruecolor() [function.imagecreatetruecolor]: Invalid image dimensions in /var/www/unaliased/zenith/image_man.php on line 103

Warning: Cannot modify header information - headers already sent by (output started at /var/www/unaliased/zenith/image_man.php:103) in /var/www/unaliased/zenith/admincp.php on line 132

Warning: Cannot modify header information - headers already sent by (output started at /var/www/unaliased/zenith/image_man.php:103) in /var/www/unaliased/zenith/head.php on line 52
Powered by Zenith Picture Gallery

[usr.c]

Be sure to empty your pictures and categories table before running the script.

About the other issue, you've only got images in your directories right?

[Usher]

Thanks for the tip, clearing out that table worked well, but the thumbnail rebuild still isn't working. The only file other than .JPG's in that folder is the index.htm file, and everything is set to 777 just in case. I'll see what more I can do later today.

Thanks again

[Usher]

I fixed it! 2 things were causing problems, one, I changed the thumbnail size, and after doing so, the recreate thumbnails worked. 2) My files ended with a *.JPG, renamed to *.jpg and it worked.

Thanks so much!

[Usher]

Ok, so I've had some time here at work, and I think i've made a new and improved script that everyone can benefit from.
By default, the script will no longer make any changes to your database, if you add a '?execute=true' it will allow sql changes, if you add 'add=true' it will add pictures, and 'update=false' will disable what I call intelligent moved picture detection.

What I have added:
1. Error proofing
-Will not change anything if run by accident
-Will not create duplicate categories
-Will not create duplicate picture entries

2. Intelligent picture addition
-If it finds a picture who's description is already in the DB, it will check to see if the DB entry still exists, if not, it assumes the file was moved, and simply changes the category for that picture
-This means if you move folders and run this script, all your files will be added
-Thumbs will not be added to the picture list (Note: Filenames containing the thumb suffix that are not thumbs will also be ignored)

3. Detailed logging
-Tells you everything it did or didn't do

NOTES:
This script will be slow, as it does a LOT of sql lookups
This is not error-proof, it could end up with moved pictures showing up as linked to the wrong copy of similarly named files, so search info/comments get put on the wrong pic, but hey, it's a good attempt.

PLEASE PLEASE PLEASE back up your database before running this script so that you make sure it doesn't break your pretty site, I don't take responsibility for anything it breaks.

Let me know what you think!


Edit: Had a typo on order of checking.....check out the newer version as of 7:50am

This post has been edited by Usher: Apr 20 2008, 02:47 PM

Attached File(s)

 automatic_file_structure_detector.php ( 13.83K ) Number of downloads: 77

 

[usr.c]

Great, thanks a lot.