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

[Thomas]

> 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