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

Fri Sep 23 10:22:53 BST 2011

Op 23-09-11 07:58, Larry CK schreef:
> 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.
So you say that you see in your album DSCN0379.JPG as a thumbnail and 
this refers to the actually existing DSCN0379.JPG, you can open it in 
image editor, and this JPG is at exactly the same path location as your 
formerly deleted one but you do not see the metadata in rightpane  while 
you are sure the info exist in the db and it is 100% the db that you are 
actually using at the moment. Are all those assumptions correct?

I think, you did still not answer the question if you deleted your 
pictures from within digikam or without digikam while digikam was not 
running.
Regards,
Rinus

> _______________________________________________
> Digikam-users mailing list
> Digikam-users at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-users