Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Replace Date by Exif Date in DB  (Read 1708 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
« previous next »
 

Page created in 0.02 seconds with 19 queries.