is there a way to extract the album photos to a excel sheet? is there a way to extract the album photos to a excel sheet?
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

is there a way to extract the album photos to a excel sheet?

Started by GoTTi, March 22, 2012, 09:05:55 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

GoTTi

courious, i would like to know if there is a way to extract the photos in the gallery to a excel sheet?

something that would have the data like:

picture description name - link to picture - name of image (jpg, bmp, png)

is this possible?

GoTTi

i was able to extract the mysql db with the pid numbers in them. i came up with another question....

on the gallery, i had images on there, then i played with the watermark and decided to have the images on there right now without the watermark, so i removed all the pictures and just reimported them. by doing that, it made the images have higher pid numbers then they actually needed. so right now the pid is up in the 800's when it should only be in the 400's. is there a way to have the pid's lowed on the mysql db and the site or does the mysqldb issue pid's on the images in chroniclogical order, no matter if the image is deleted or not?

ΑndrĂ©

It's not recommended to manipulate IDs. MySQL's auto_increment counter doesn't reset when you delete images. Even if you'd delete all of your images, it won't start at 1 when you upload new images. What's the problem of having higher IDs?