[Digikam-users] Confused about "created" date/time on some photos

[Mikolaj Machowski]

On Monday 15 June 2009 20:50:53 Michael Liddle wrote:

Hello,

Mail below maybe of some interest to you if I understand correctly:

Re: [Digikam-users] Problem concerning the displayed creation date of files 
without EXIF data.


From: 
Thomas <tzsnoopy at gmx.de>
  To: 
"digiKam - Home Manage your photographs as a professional with the power of 
open source" <digikam-users at kde.org>
  Date: 
2009-05-24 13:02
   
> What you need is to put modification date somewhere in digikam database but 
I 
> don't know where...

Still, I do not know where digikam gets the creation date from if there
is no metadata in the file. 
But "database" was a good hint. I could take the modifications dates
(which are in my case the real dates of taking the movies) and set them
as creation dates by directly modifying the digikam database.

For all people with a similar problem, here is the way I did it:
I opened the digikam database file (in my case: digikam4.db), which is a
sqlite database, with sqliteadmin running under wine. There I performed
the following SQL query:

UPDATE ImageInformation
SET creationDate = (SELECT Images.modificationDate FROM Images WHERE
ImageInformation.imageid = Images.id)
WHERE digitizationDate is null

The "WHERE digitizationDate is null" is used to adjust the creation date
only of those files without metadata.

For me this query worked fine. But of course someone should only try
this if he/she knows what this stuff is doing. Adapting the digikam
database directly could destroy it! So always make a backup before.

So, I am happy now :o)
Thanks for the hint with the database. And maybe, I could help somebody
with the sql stuff.

Best wishes
Thomas