PDA

View Full Version : Update Timestamps with EXIF after the fact


chezmojo
01-20-2008, 01:46 PM
Perhaps this is already somewhere on the forum, but is there way to have pixelpost update timestamps to the EXIF data after a post has been created?

I did a completely bonehead thing and uploaded literally hundreds of images (and added text/tags for each one) without the "read timestamp from EXIF" checked. Now I'm faced with looking up the timestamp for each image and entering it by hand... Is there a way to tell Pixelpost either to change the timestamps for existing images to the EXIF data, or for me to re-upload the image and switch to the EXIF timestamp?

My goal here is to have my images sorted by when they were taken--right now they are stamped by when they were uploaded--without having to re-type all the text and retag everything.

I'm using v1.7.0

Here is the host info:

PHP-version 4.4.7 (Pixelpost's min requirement: PHP version: 4.3.0 )
Session save path /tmp
MySQL version 5.0.51-log (Pixelpost's min requirement: MySQL: 3.23.58 )
GD-lib bundled (2.0.28 compatible) with JPEG support
File Uploads to Pixelpost site are possible.
Server Software Apache/1.3.33 (Unix)
EXIF Pixelpost is using exifer v1.5 for EXIF-information.

chezmojo
01-22-2008, 01:57 PM
bump

Dkozikowski
01-22-2008, 02:04 PM
you'll have to do it all manually i'm afraid. or start from scratch :(

chezmojo
01-22-2008, 02:38 PM
Is there at least an easy way to hack images_edit.php to include the same date/time options as new_image.php? At least that way I wouldn't have to find each source image on my hard drive and lookup the EXIF data manually...

Dkozikowski
01-22-2008, 03:30 PM
let me look into it

austriaka
01-22-2008, 05:41 PM
I had the same situation months ago and found no easy way :-(
I did it directly in the database, looked out the date in the serialized exif string in the exif field and replaced the datetime field with it, changing the format according to the datetime string. But still it is heavy work :-(

You can open more entries to edit at once in mysqladmin, but you have to take care not to destroy anything. In any case be sure to make a database backup before

Dkozikowski
01-22-2008, 06:41 PM
I am just about done creating an addon for you. With a click of a button, all your post times will use the EXIF date.

kevincrafts
01-22-2008, 06:54 PM
What will your addon do if there is no exif date?

I am just about done creating an addon for you. With a click of a button, all your post times will use the EXIF date.

Dkozikowski
01-22-2008, 07:10 PM
Get it while it's fresh, http://www.pixelpost.org/extend/addons/update-to-exif-datetime/

Dkozikowski
01-22-2008, 07:10 PM
What will your addon do if there is no exif date?

Spit out the image ID and skip over it.