[Digikam-users] How do I restore comments (captions), titles and tags from digiKamdatabase?

[Larry CK]

On Thu 22 Sep 2011 10:17:31 BST, sleepless wrote:
> Op 22-09-11 10:55, sleepless schreef:
>> Op 22-09-11 09:57, Larry schreef:
>>> If I understand correctly, reread metadata from image is reading data
>>> stored in EXIF in the Photo (JPG) file itself. In my case, I no longer
>>> have the files that had the metadata written to,
> Ok that road is closed.
>>> but I have the
>>> metadata in the database.
> If you have the info in the db and it is still linked to the photo´s 
> (wich I think is impossible) but you can not write it to photo, you 
> should check Settings->configure digikam->metadata->metadata writing 
> mode.
>
> If that doesn´t help you can try Setting-.configure digikam-> 
> collections, remove your collection and add it again, maybe the link 
> between photos and db info will be restored, but this is pure 
> speculation.
> Please keep me informed.
> Rinus
>>>
>>> What happened in sequence was:
>>>
>>> 1. Taking pictures whilst camera time settings are incorrect
>>> 2. Transferring images (~1700) to dk album
>>> 3. Transferring another copy of the images to a subfolder within dk 
>>> album
>>> 4. Adding title, caption and tags to about 200 of the images. I did
>>> not change file names or edited images, however I have rotated some of
>>> the images
>>> 5. Deciding to correct timestamps and messing things up
>>> 6. Removed all images with messed up timestamps from dk album
>> If you send them to trash from within dk they should the info should 
>> not exist in the db
>>> 7. copied images from a backup (subfolder) to the dk album. Again -
>>> file names didn't change.
>> did you copy with filemanager and dk closed?
>>> 8. Did image -> reread metadata from image to no avail
>>> 9. Checked Database - my tags, titles and caption are in the database
>> if the tags exist in the db can you confirm they are still linked to 
>> the pictures or is it just orphanaged info
>>> question still remains - how do I get digikam to read metadata from
>>> the database and assign it back to the images
>> Did you ever explicitly write your tags to picture?
>> Are your original pictures available from trash
>>> On Thu, Sep 22, 2011 at 8:26 AM, 
>>> sleepless<sleeplessregulus at hetnet.nl> wrote:
>>>> Op 22-09-11 07:17, RaveNBlack schreef:
>>>>> I had an album with over 1700 photos in there. I have tagged (titles,
>>>>> captions and tags, some geotags) couple hundred of them when I 
>>>>> noticed
>>>>> that
>>>>> my timestamps are incorrect (I forgot to adjust my cameras clock 
>>>>> after
>>>>> crossing several timezones). I attempted to correct this, but 
>>>>> messed my
>>>>> timestamps even more. So I decided to start from scratch and have
>>>>> overwritten my pictures with messed up timestamps with untempered 
>>>>> images
>>>>> from a backup.
>>>>>
>>>>> I did not change file names and I have not edited (except for 
>>>>> rotating
>>>>> several images) any of the pictures (no color correction or 
>>>>> anything). I
>>>>> was
>>>>> hoping that once I transfer images from the backup digikam will read
>>>>> metadata from the database (SQLite) and reassign to the images as 
>>>>> file
>>>>> names
>>>>> are the same, file sizes are the same, etc. but that is not the case.
>>>>>
>>>>> How can I restore metadate from the database and assign it to the 
>>>>> images
>>>>> again?
>>>> I copied a picture outside of dk. Changed in dk timestamps. Used 
>>>> nautilus to
>>>> put the copy back in the open dk album. Image->reread metadata from 
>>>> image.
>>>> Now I had my original timestamp back and the formerly assigned tags 
>>>> are
>>>> still there.
>>>> This can be done for a whole album: Album->reread metadata from 
>>>> images.
>>>>
>>>> Second try I copied the image back outside of dk with dk closed, 
>>>> and again
>>>> all was restored.
>>>>
>>>> For deeper investigation how you can solve if possible, I need more 
>>>> specific
>>>> information what you did and what happened.
>>>>
>>>> Rinus
>>>>> -- 
>>>>> View this message in context:
>>>>> http://digikam.1695700.n4.nabble.com/How-do-I-restore-comments-captions-titles-and-tags-from-digiKamdatabase-tp3832430p3832430.html 
>>>>>
>>>>> Sent from the digikam-users mailing list archive at Nabble.com.
>>>>> _______________________________________________
>>>>> Digikam-users mailing list
>>>>> Digikam-users at kde.org
>>>>> https://mail.kde.org/mailman/listinfo/digikam-users
>>>>>
>>>> _______________________________________________
>>>> Digikam-users mailing list
>>>> Digikam-users at kde.org
>>>> https://mail.kde.org/mailman/listinfo/digikam-users
>>>>
>>> _______________________________________________
>>> Digikam-users mailing list
>>> Digikam-users at kde.org
>>> https://mail.kde.org/mailman/listinfo/digikam-users
>>>
>>
>> _______________________________________________
>> Digikam-users mailing list
>> Digikam-users at kde.org
>> https://mail.kde.org/mailman/listinfo/digikam-users
>>
>
> _______________________________________________
> Digikam-users mailing list
> Digikam-users at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-users

Metadata writing settings only give various options to write metadata 
to file and my problem is that I no longer have the files.

Removing and Adding collections didn't work

I also run a SQL Query SELECT images.name, imagecomments.comment, 
imagecomments.type FROM images, imagecomments WHERE images.id = 
imagecomments.imageid AND images.name LIKE 'DSCN0%' and sample of the 
result is

DSCN0379.JPG	a window	3
DSCN0379.JPG	it looked like some king of political agenda leaflets in 
the window	1

So the data is definitely in there.