[Digikam-users] F-Spot --> Digikam

[Andy Choens]

> 
> While I'm not an SQL expert by anyone's definition of the term, I've
> encountered a similar need in another context.  Perhaps my solution will
> work for you.  Export the F-Spot DB as comma separated values.  Use the
> SQL COPY command to read the CSV file into the digikam DB.  It might not
> work directly.  You may have to build some temporary tables from which
> you SELECT and massage the right columns.
> 
> Dave Talmage

I think this is the right approach, but it's the insertion part I don't 
understand.

F-Spot has assigned a unique number to every photo in my collection. In the 
tags database, it tells me which tag is assigned to which photo id #, not the 
photo name.

Of course, with the fun and glory that is SQL (inner joins rule), I can easily 
get the F-Spot db to tell me what the REAL name of the file is.

So, I can easily generate a list of actual file names attached to Tag #1, 
Tag#2, etc.

I can export this into csv and edit it until my heart is content. But, I don't 
understand the insertion part.

Here's my problem. Digikam, like F-Spot assigns every photo a unique ID #. 
This unique number, not the actual file name, is used to to assign tags to 
photos (images in the digikam db).

I know that almost all of my photos have unique names, so I'm not too worried 
about needing to search on my file names.

I can figure out the digikam db structure, and modify text exported from 
f-spot, but I can't figure out how to search digikam's db for EACH and EVERY 
tag insertion before I insert it, so I can assign it to the right unique id 
#.

I just can't figure out the insertion side of life. If I am overlooking 
something obvious, I'm all ears.

--andy