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

Fri Sep 23 13:12:20 BST 2011

I think the last chance is to try if F5  restores the link.
I can only reproduce the situation by changing something no matter how 
less, only modification date change is enough to break the link.
If you for example work with jpg and you recreated them from raw, they 
are not the same images any more to digikam.

If F5 does not work, probaly the only way to fix it is by manipulation 
of the db.

Maybe you can repost your question with ¨how to fix broken links in 
sqlite¨, maybay this attracts attention of people with knowledge in the 
field.

Good luck,
Rinus

Op 23-09-11 11:34, Larry schreef:
> Hi, the assumptions are correct.
>
> I have deleted file with file manager (dolphin). Unfortunately I don't
> remember whether dk was open at that time or not.
>
> I'm using digikam on my OpenSuse 11.4 distro, in case it makes any difference.
>
> Regards
> Larry
>
> On Fri, Sep 23, 2011 at 10:22 AM, sleepless<sleeplessregulus at hetnet.nl>  wrote:
>> 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
>> _______________________________________________
>> 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
>