In order to populate the database (especially with data entered in EXIFManager), here are my changes:

1. database MySQL
The date_creation field in the database has to be modified to store the time, so that it can be set with the picture-taken datetime:

table "images" field "date_creation" => change from "DATE" to "DATETIME"

2. include/config_local.inc.php

$conf['use_exif'] = true; // activate EXIF mapping
$conf['use_exif_mapping'] = array( // enter here the fields that will be used to populate the database
  'date_creation' => 'DateTimeOriginal',
  'name' => 'ImageDescription',
  'comment' => 'UserComment',
  'author' => 'Artist',
  );

These changes allow to populate the database fields in this way:
- date_creation with picture-taken datetime (given by the camera)
- name with ImageDescription (can be set with EXIFManager)
- comment with UserComment (can be set with EXIFManager)
- author with Artist (can be set with EXIFManager)

3. Unfortunately, these mapping does not correctly work as-is, and this file has to be modified:
admin/include/functions_metadata.php

function get_sync_exif_data($file)
{
  $result = array();
  $exif = exif_read_data ($filename,0,true);
  $result['date_creation'] = $exif['EXIF']['DateTimeOriginal'] ;
  $result['name'] = trim($exif['IFD0']['ImageDescription']);
  $result['author'] = trim($exif['IFD0']['Artist']);
  $result['comment'] = trim(substr($exif['IFD0']['UserComment'],8));
  if ($result['comment']==="") $result['comment'] = trim(substr($exif['EXIF']['UserComment'],8));
  return $result;
}

This last point is not very clean (redundancy with the $conf['use_exif_mapping'] array), but correctly works.
Note how the UserComment is got: the "ASCII   " header is ignored and the field is read from [IFD0] or [EXIF] "folder".

4. Last detail: the thumbnails tool-tip can display <comment>/<name> instead of file size.
include/category_default.inc.php

$thumbnail_title = $row['comment']." / ".$row['name'] ;

Last edited by phgiraud (2006-08-31 14:12:52)