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? |
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 > [hidden email] > https://mail.kde.org/mailman/listinfo/digikam-users > _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
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, but I have the metadata in the database. 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 7. copied images from a backup (subfolder) to the dk album. Again - file names didn't change. 8. Did image -> reread metadata from image to no avail 9. Checked Database - my tags, titles and caption are in the database question still remains - how do I get digikam to read metadata from the database and assign it back to the images On Thu, Sep 22, 2011 at 8:26 AM, sleepless <[hidden email]> 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 >> [hidden email] >> https://mail.kde.org/mailman/listinfo/digikam-users >> > > _______________________________________________ > Digikam-users mailing list > [hidden email] > https://mail.kde.org/mailman/listinfo/digikam-users > Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
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, but I have the > metadata in the database. > > 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 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<[hidden email]> 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 >>> [hidden email] >>> https://mail.kde.org/mailman/listinfo/digikam-users >>> >> _______________________________________________ >> Digikam-users mailing list >> [hidden email] >> https://mail.kde.org/mailman/listinfo/digikam-users >> > _______________________________________________ > Digikam-users mailing list > [hidden email] > https://mail.kde.org/mailman/listinfo/digikam-users > _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
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<[hidden email]> 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 >>>> [hidden email] >>>> https://mail.kde.org/mailman/listinfo/digikam-users >>>> >>> _______________________________________________ >>> Digikam-users mailing list >>> [hidden email] >>> https://mail.kde.org/mailman/listinfo/digikam-users >>> >> _______________________________________________ >> Digikam-users mailing list >> [hidden email] >> https://mail.kde.org/mailman/listinfo/digikam-users >> > > _______________________________________________ > Digikam-users mailing list > [hidden email] > https://mail.kde.org/mailman/listinfo/digikam-users > _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
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<[hidden email]> 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 >>>>> [hidden email] >>>>> https://mail.kde.org/mailman/listinfo/digikam-users >>>>> >>>> _______________________________________________ >>>> Digikam-users mailing list >>>> [hidden email] >>>> https://mail.kde.org/mailman/listinfo/digikam-users >>>> >>> _______________________________________________ >>> Digikam-users mailing list >>> [hidden email] >>> https://mail.kde.org/mailman/listinfo/digikam-users >>> >> >> _______________________________________________ >> Digikam-users mailing list >> [hidden email] >> https://mail.kde.org/mailman/listinfo/digikam-users >> > > _______________________________________________ > Digikam-users mailing list > [hidden email] > 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. _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
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<[hidden email]> 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 >>>>>> [hidden email] >>>>>> https://mail.kde.org/mailman/listinfo/digikam-users >>>>>> >>>>> _______________________________________________ >>>>> Digikam-users mailing list >>>>> [hidden email] >>>>> https://mail.kde.org/mailman/listinfo/digikam-users >>>>> >>>> _______________________________________________ >>>> Digikam-users mailing list >>>> [hidden email] >>>> https://mail.kde.org/mailman/listinfo/digikam-users >>>> >>> >>> _______________________________________________ >>> Digikam-users mailing list >>> [hidden email] >>> https://mail.kde.org/mailman/listinfo/digikam-users >>> >> >> _______________________________________________ >> Digikam-users mailing list >> [hidden email] >> 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. 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 > [hidden email] > https://mail.kde.org/mailman/listinfo/digikam-users _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
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 <[hidden email]> 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<[hidden email]> >>>>> 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 >>>>>>> [hidden email] >>>>>>> https://mail.kde.org/mailman/listinfo/digikam-users >>>>>>> >>>>>> _______________________________________________ >>>>>> Digikam-users mailing list >>>>>> [hidden email] >>>>>> https://mail.kde.org/mailman/listinfo/digikam-users >>>>>> >>>>> _______________________________________________ >>>>> Digikam-users mailing list >>>>> [hidden email] >>>>> https://mail.kde.org/mailman/listinfo/digikam-users >>>>> >>>> >>>> _______________________________________________ >>>> Digikam-users mailing list >>>> [hidden email] >>>> https://mail.kde.org/mailman/listinfo/digikam-users >>>> >>> >>> _______________________________________________ >>> Digikam-users mailing list >>> [hidden email] >>> 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 >> [hidden email] >> https://mail.kde.org/mailman/listinfo/digikam-users > > _______________________________________________ > Digikam-users mailing list > [hidden email] > https://mail.kde.org/mailman/listinfo/digikam-users > Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
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<[hidden email]> 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<[hidden email]> >>>>>> 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 >>>>>>>> [hidden email] >>>>>>>> https://mail.kde.org/mailman/listinfo/digikam-users >>>>>>>> >>>>>>> _______________________________________________ >>>>>>> Digikam-users mailing list >>>>>>> [hidden email] >>>>>>> https://mail.kde.org/mailman/listinfo/digikam-users >>>>>>> >>>>>> _______________________________________________ >>>>>> Digikam-users mailing list >>>>>> [hidden email] >>>>>> https://mail.kde.org/mailman/listinfo/digikam-users >>>>>> >>>>> _______________________________________________ >>>>> Digikam-users mailing list >>>>> [hidden email] >>>>> https://mail.kde.org/mailman/listinfo/digikam-users >>>>> >>>> _______________________________________________ >>>> Digikam-users mailing list >>>> [hidden email] >>>> 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 >>> [hidden email] >>> https://mail.kde.org/mailman/listinfo/digikam-users >> _______________________________________________ >> Digikam-users mailing list >> [hidden email] >> https://mail.kde.org/mailman/listinfo/digikam-users >> > _______________________________________________ > Digikam-users mailing list > [hidden email] > https://mail.kde.org/mailman/listinfo/digikam-users > _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
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<[hidden email]> 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<[hidden email]> >>>>>>> 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 >>>>>>>>> [hidden email] >>>>>>>>> https://mail.kde.org/mailman/listinfo/digikam-users >>>>>>>>> >>>>>>>> _______________________________________________ >>>>>>>> Digikam-users mailing list >>>>>>>> [hidden email] >>>>>>>> https://mail.kde.org/mailman/listinfo/digikam-users >>>>>>>> >>>>>>> _______________________________________________ >>>>>>> Digikam-users mailing list >>>>>>> [hidden email] >>>>>>> https://mail.kde.org/mailman/listinfo/digikam-users >>>>>>> >>>>>> _______________________________________________ >>>>>> Digikam-users mailing list >>>>>> [hidden email] >>>>>> https://mail.kde.org/mailman/listinfo/digikam-users >>>>>> >>>>> _______________________________________________ >>>>> Digikam-users mailing list >>>>> [hidden email] >>>>> 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 >>>> [hidden email] >>>> https://mail.kde.org/mailman/listinfo/digikam-users >>> _______________________________________________ >>> Digikam-users mailing list >>> [hidden email] >>> https://mail.kde.org/mailman/listinfo/digikam-users >>> >> _______________________________________________ >> Digikam-users mailing list >> [hidden email] >> https://mail.kde.org/mailman/listinfo/digikam-users >> > > _______________________________________________ > Digikam-users mailing list > [hidden email] > https://mail.kde.org/mailman/listinfo/digikam-users _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
Free forum by Nabble | Edit this page |