Export Gallery1 Metadata.

shemseger

Joined: 2013-05-14
Posts: 5
Posted: Wed, 2013-05-15 20:04

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?

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Thu, 2013-05-16 00:56
 
shemseger

Joined: 2013-05-14
Posts: 5
Posted: Thu, 2013-05-16 16:59

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

 
shemseger

Joined: 2013-05-14
Posts: 5
Posted: Thu, 2013-05-16 17:03

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

 
shemseger

Joined: 2013-05-14
Posts: 5
Posted: Thu, 2013-05-16 17:10

Like I said, the ultimate goal is to get this data into a table...

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Thu, 2013-05-16 17:31

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

 
shemseger

Joined: 2013-05-14
Posts: 5
Posted: Thu, 2013-05-16 17:41

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