How do I export the metadata from Gallery1 into a spreadsheet or a database? Without upgrading or importing into a newer version of Gallery?
We have an old Gallery running on version 1.5.1 housing 4TB of high-res photos, and we want to put it into ContentDM. I'm trying to wrap my head around the flatfile database it uses. How can I convert that data into a speadsheet?
Posts: 8339
http://codex.galleryproject.org/Other_Clients
-s
________________________________
All New jQuery Minislideshow for G2/G3
Posts: 5
This is useful, thank you, but these all appear to be plugins for just displaying images from Gallery, mostly Gallery2, I still don't see anything here that exports tabular data. We need to get the metadata from the Gallery (Titles, descriptions, etc.) not the images.
-shem
Posts: 5
I was poking around some more, and found this:
http://codex.galleryproject.org/Downloads:PHP_Deserialize
doesn't do exactly what I want, but it does parse the files into something more usable.
-shem
Posts: 5
Like I said, the ultimate goal is to get this data into a table...
Posts: 8339
This is something specific to your needs, you will either have to write something yourself or hire someone. I pointed you to the only known possibilities.
It should certainly be easy enough to use php's deserialize to read the .dat files and parse the info you need.
Most of us have not seen a G1 in many years.
-s
________________________________
All New jQuery Minislideshow for G2/G3
Posts: 5
That's what I figured. Well, thanks for the info, my task was to find out whether or not something already existed, and research our options. Now we know and we can move forward with creating a work order.
Thanks again.
-shem