Advanced search  

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]

Pages: [1]   Go Down

Author Topic: Replace Date by Exif Date in DB  (Read 1663 times)

0 Members and 1 Guest are viewing this topic.

Grann0n

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
Replace Date by Exif Date in DB
« on: November 12, 2011, 09:51:20 pm »

Hi all,

I've one thousand and half pictures to upload (I made a new website and decided to install a fresh coppermine instead of using the old one) and I want to use the EXIF date for sorting pictures.

I found no MOD for the last version (and don't want to maintain one) and I'm looking for a SQL script or a batch process to replace the upload date in DB by the one coming for the EXIF.

Thanks for help
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Replace Date by Exif Date in DB
« Reply #1 on: November 15, 2011, 03:30:49 pm »

It's not recommended to manipulate the database. If you want to do that anyway, you have to ensure that all of your pictures have the needed EXIF data and Coppermine is able to read it. If you're sure that all data is available, you have to write a small script that reads the data from the exif table, calculates the timestamp from the correct exif field and write it to the corresponding row in the pictures table, for each picture.
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 19 queries.