Bug: Canon CRW Creation Datetime not correct

[ThomasOB]

Hi,

I have the same issue as this posting except with Canon CRW files.

https://daminion.net/user-forum/index.php?/topic/969-moving-from-idimager-5-sql-have-several-questions/page__view__findpost__p__3524

" -----------------------------------------------

Posted 10 March 2013 - 08:05 AM

Moving from idimager 5 SQL - have several questions

....

2) The creation date appears to be reading the file system "created" date, not the "media creation date" or "date taken" stored in the files metadata. Is there any way to show media creation date? Some of the files I have from 2002 are showing up as 2009 due to this, but the file properties in windows explorer shows the correct date of 2002 in metadata. I wasn't able to find any option for showing this date in daminion.

" -----------------------------------------------

 

I am using latest the free Desktop version 911.

 

From my investigations with exiftool 9.44, import does not read the MakerNotes:DateTimeOriginal tag but uses the file system time which will be incorrect as I have copied the files manually to the PC.

 

As I have already imported them, I can correct the Creation Datetime by setting 1.) the CreateDate tag and 2.) the file system created time ( File:FileCreatedDate ) using exiftool and Rescan the folder. I need to do step 1. so that Rescan will notice information has changed and then pick up the new file system date.

 

I thought I had a simple solution using SQLite SQL UPDATE to correct the CreatedTIme field in the Files table but Daminion did not recognise the new value.

 

Regards,

Tom.

[Murat]

Hi,

I have the same issue as this posting except with Canon CRW files.

 

Daminion checks a set of metadata fields to get the right Capture date. Could you please send us a sample image file? If you'll copy the right date using the ExifTool to EXIF:OriginalDateTime it should be properly imported by Daminion. But let's check your sample image before.

[ThomasOB]

Daminion checks a set of metadata fields to get the right Capture date. Could you please send us a sample image file? If you'll copy the right date using the ExifTool to EXIF:OriginalDateTime it should be properly imported by Daminion. But let's check your sample image before.

 

Thanks for your prompt reply, however OriginalDateTime is not a valid EXIF tag.

 

.CRW files are RAW Canon files. Too big to attach but please see the complete list of tags from the file.

crw.txt

[Murat]

Thanks for your prompt reply, however OriginalDateTime is not a valid EXIF tag.

 

Why? I need to check the original file. You can upload it our ftp or share via the Dropbox. I've sent the ftp details by private message.

 

Daminion determines the capture date by checkeing the below fields in accordance to their order:

 

• EXIF:DateTimeOriginal
  
• XMP:Photoshop:DateCreated
  
• IPTC:DateTimeCreated
  
• XMP:XMP:CreateDate
  
• File:CreationTime
  

 

And if your file contains EXIF:DateTimeOriginal - Daminion will use even it was written incorrectly.

[Lummo]

I know that it's been a while. I stumbled across this thread while searching for problems with timestamps on files on SD Card on a Canon EOS 6D. I was investigating an apparent problem with the timestamps on my Canon EOS 6D with the latest formware (1.1.4, 19-Apr-2014). I am in New Zealand. My camera is set to local time which is currently NZST at GMT +12 hours. My camera is set up to record RAW and JPG for each shot.

 

I took a test shot at 14:04 05-May-2014, removed the SD card and intserted into a reader. A DOS box shows the following timestamps:

 

C:\>dir/t:C w:\dcim\100canon\*.* ! Created date and time

06/05/2014 02:04 13,799,362 _MG_0097.CR2

06/05/2014 02:04 3,269,385 _MG_0097.JPG

 

C:\>dir/t:w w:\dcim\100canon\*.* ! Last Written date and time

06/05/2014 02:04 13,799,362 _MG_0097.CR2

06/05/2014 02:04 3,269,385 _MG_0097.JPG

 

C:\>dir/t:A w:\dcim\100canon\*.* ! Accessed date and time

05/05/2014 12:00 13,799,362 _MG_0097.CR2

05/05/2014 12:00 3,269,385 _MG_0097.JPG

 

The Created and Last Written dates seem to be at local time plus 12:00 (the offset from GMT?). The Last Accessed date seems to have the date correct but the wrong time.

 

ExifTool shows:

 

P:\>exiftool -*date* -sort w:\dcim\100canon\*97.*

======== w:/dcim/100canon/_MG_0097.CR2

Create Date : 2014:05:05 14:04:07

Create Date : 2014:05:05 14:04:07.00

Date/Time Original : 2014:05:05 14:04:07

Date/Time Original : 2014:05:05 14:04:07.00

File Access Date/Time : 2014:05:05 12:00:00+12:00

File Creation Date/Time : 2014:05:06 02:04:06+12:00

File Modification Date/Time : 2014:05:06 02:04:08+12:00

Modify Date : 2014:05:05 14:04:07

Modify Date : 2014:05:05 14:04:07.00

======== w:/dcim/100canon/_MG_0097.JPG

Create Date : 2014:05:05 14:04:07

Create Date : 2014:05:05 14:04:07.00

Date/Time Original : 2014:05:05 14:04:07

Date/Time Original : 2014:05:05 14:04:07.00

File Access Date/Time : 2014:05:05 12:00:00+12:00

File Creation Date/Time : 2014:05:06 02:04:08+12:00

File Modification Date/Time : 2014:05:06 02:04:08+12:00

Modify Date : 2014:05:05 14:04:07

Modify Date : 2014:05:05 14:04:07.00

 

The 'file' dates reported are the same as from DOS (which you'd expect). The EXIF dates are correct for the time that I tool the photo. There seems to be a bug in the Canon firmware that causes the wrong timestamp to be writen to the file metadata when the file is created. I plan to report this to Canon.

[Lummo]

Please belay my previous post. The bug is probably not in my Canon. I tried the SD Card from my Panasonic Lumix G3 and got exactly the same results! That set me thinking. I have been using the card reader slot on my Epson BX305XW multi-function printer. So I fired up my laptop and looked at the cards with that. A DOS command window on the laptop reports correct dates and times for the image files. So now I have to go and bug Epson instead of Canon.