[Digikam-users] How to populate a sqlite digiKam database

[Peter Shute]

Another approach is to try to get all the metadata into the images, then just import them. I.e. add a stars1 tag to all images with 1 star, a flag tag to all flagged images, etc.

Then do the reverse operation once imported. It's a bit of work, but might turn out to be faster than translating one database schema into another.

This approach assumes the files are of a type capable of storing tags, and that the Nikon software lets you filter and tag the results.


--------------------------
Sent using BlackBerry

----- Original Message -----
From: Gilles Caulier <caulier.gilles at gmail.com>
To: digiKam - Home Manage your photographs as a professional with the power of open source <digikam-users at kde.org>
Sent: Thu Apr 08 05:03:49 2010
Subject: Re: [Digikam-users] How to populate a sqlite digiKam database

Laurent,

We have a full documention of Database schema. Look there :

http://websvn.kde.org/*checkout*/trunk/extragear/graphics/digikam/project/DBSCHEMA.ODS

If you write a script to do it, we will interrested to host it in
digiKam repository as a 3rd-party code.

There is also a file in bugzilla to be able to import database
contents from other photo management programs.

Gilles Caulier

2010/4/7 Laurent Espitallier <laurent.espitallier at laposte.net>:
> Hi,
>
> I need to import data from a Nikon Picture Project database for a colleague
> in my company
>
> Picture Project uses Access .mdb files protected with "Nikon" password.
>
> I thought I could export each .mdb file to CSV then insert data (digiKam
> tags) in sqlite database with some scripts or with "Sqlite Manager" Firefox
> addon.
>
> How would you do it (I'd like to know tables and fields to meet minimum for
> example) and is there any tool or language to make it easier ?
>
> Thanks.
>
> _______________________________________________
> 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