extracting a listing of images
|
tcjay
Joined: 2003-02-10
Posts: 42 |
Posted: Mon, 2010-05-10 15:10
|
|
I would like to extract a listing of the images and from the database but I am not sure where to find them in the database. I have found a listing of the pictures in g2_item but it only includes the item and description. I can not seem to find where the name of the image is stored. Maybe someone has done this before and can shed some light on the situation. TIA Tom |
|
Posts: 16504
I don't know of any easy way to get this out of the database, but if you're looking for the filenames, then it's pretty easy if you have SSH access to the server.
Navigate to your g2data/albums directory and type:
ls -lR
You can pipe that to a text file like so:
ls -lR > imagelist.txt
Then you can import that into Excel or anything you want to manipulate the data as you see fit.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here