Recovering from a corrupt db

[David Talmage-2]

I think my digikam db is corrupt.  Many of my images now contain incorrect
tags.

I need a little help automating the recovery from this problem.  Is there a
shell script I can make that will visit each album and write the metadata to
images? That would save me a tremendous amount of work.

Here are the steps I propose to take to recover.  In each album, write
metadata to images.  Delete the digikam db files.  Import all of my images into
digikam and instruct digikam to read the metadata from images.  Manually
correct the tags.

I believe that doing it this way will preserve all of the tags I've created,
although they may not be with the right images.

I've already spent many hours over several weeks correcting the tags.  Alas,
it takes so long to do anything in digikam that I don't think I can finish
before the end of the year even if I do nothing else eight hours per day. (I
reported this slowness in message id 2906874.HmxYp8ShDY@facteur).


_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Jean-François Rabasse]

On Tue, 11 Dec 2012, David Talmage wrote:

> I think my digikam db is corrupt.  Many of my images now contain incorrect
> tags.
>
> I need a little help automating the recovery from this problem.  Is there a
> shell script I can make that will visit each album and write the metadata to
> images? That would save me a tremendous amount of work.

Hello David,

Could you please be a bit more explicit ?
You say « write THE metadata to images », but the metadata coming from
where ?
If it's current metadata from your Digikam DB, you don't need a script at
all, the Tools menu provides the Write metadata to All images.

Or do you use xmp sidecar files along your images, and look for a script
to extract data from sidecar files and write to images ?

Regards,
Jean-François
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[David Talmage-2]

On Wednesday, December 12, 2012 02:07:59 PM Jean-François Rabasse wrote:

> On Tue, 11 Dec 2012, David Talmage wrote:
> > I think my digikam db is corrupt.  Many of my images now contain incorrect
> > tags.
> >
> > I need a little help automating the recovery from this problem.  Is there
> > a
> > shell script I can make that will visit each album and write the metadata
> > to images? That would save me a tremendous amount of work.
> ...
> Could you please be a bit more explicit ?
> You say « write THE metadata to images », but the metadata coming from
> where ?

The metadata comes from the database, I guess.  Some of my image files already
contain the tag metadata.  Not all of them do. I'm using Album->Write Metadata
to Images for this.

> If it's current metadata from your Digikam DB, you don't need a script at
> all, the Tools menu provides the Write metadata to All images.

In my copy of 2.8.0, the Tools meny has no entry for that. There is a
Maintenance entry and it has "Sync image metadata with Database". If I read
that correctly, digikam will copy metadata from each file into the database.  
That's not what I need.

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Jean-François Rabasse]

On Wed, 12 Dec 2012, David Talmage wrote:

>> If it's current metadata from your Digikam DB, you don't need a script at
>> all, the Tools menu provides the Write metadata to All images.
>
> In my copy of 2.8.0, the Tools meny has no entry for that. There is a
> Maintenance entry and it has "Sync image metadata with Database". If I read
> that correctly, digikam will copy metadata from each file into the database.
> That's not what I need.

Hi David,

Ok, I draw back my comment, I have a different version.
And I don't know how « Sync image metadata with Database » is to be
understood. Sync which way, images to DB or DB to images ?
Digikam developpers, help !!! :-)

Jean-François
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[maderios]

On 12/12/2012 02:53 PM, Jean-François Rabasse wrote:

>
> On Wed, 12 Dec 2012, David Talmage wrote:
>
>>> If it's current metadata from your Digikam DB, you don't need a
>>> script at
>>> all, the Tools menu provides the Write metadata to All images.
>>
>> In my copy of 2.8.0, the Tools meny has no entry for that. There is a
>> Maintenance entry and it has "Sync image metadata with Database". If I
>> read
>> that correctly, digikam will copy metadata from each file into the
>> database.
>> That's not what I need.
>
> Hi David,
>
> Ok, I draw back my comment, I have a different version.
> And I don't know how « Sync image metadata with Database » is to be
> understood. Sync which way, images to DB or DB to images ?
> Digikam developpers, help !!! :-)
>

Which kind of db, mysql or sqlite ?
--
Maderios

"Art is meant to disturb. Science reassures."
"L'art est fait pour troubler. La science rassure" (Georges Braque)

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[David Talmage-2]

On Thursday, December 13, 2012 04:42:21 PM maderios wrote:

> On 12/12/2012 02:53 PM, Jean-François Rabasse wrote:
> > On Wed, 12 Dec 2012, David Talmage wrote:
> >>> If it's current metadata from your Digikam DB, you don't need a
> >>> script at
> >>> all, the Tools menu provides the Write metadata to All images.
> >>
> >> In my copy of 2.8.0, the Tools meny has no entry for that. There is a
> >> ...
> > ...
> > And I don't know how « Sync image metadata with Database » is to be
> > understood. Sync which way, images to DB or DB to images ?
> > Digikam developpers, help !!! :-)
>
> Which kind of db, mysql or sqlite ?

It's SQLite.

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users