[Digikam-users] How do I restore comments (captions), titles and tags from digiKamdatabase?
Larry CK
blackravener at gmail.com
Wed Sep 28 06:15:12 BST 2011
Thanks for the help.
I believe I had a corrupt database as I also notices that all other
meta-data (makernotes, camera info) is being removed from the images as
soon as I start digikam.
so what ended up doing in the end was extracting the data I need and
exporting it into CSV file; removing the database and dk config files
and starting from scratch.
regards
Larry
On 23/09/11 13:12, sleepless wrote:
> 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
>>
>
> _______________________________________________
> Digikam-users mailing list
> Digikam-users at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-users
More information about the Digikam-users
mailing list