How to populate a sqlite digiKam database

[Laurent Espitallier]

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
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Gilles Caulier-4]

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 <[hidden email]>:

> 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
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-users
>
>

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

[pshute]

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 <[hidden email]>

To: digiKam - Home Manage your photographs as a professional with the power of open source <[hidden email]>

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 <[hidden email]>:

> 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

> [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

[ym12de]

Gilles,
I try to move my photos from kphotoalbum to digikam and am interested in
the scripts you mention below .. unfortunately I was unable to locate
them on bugzilla .. would you have a link at hand ?
Hans

Am 07.04.2010 21:03, schrieb Gilles Caulier:

> 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<[hidden email]>:
>    
>> 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
>> [hidden email]
>> https://mail.kde.org/mailman/listinfo/digikam-users
>>
>>
>>      
> _______________________________________________
> Digikam-users mailing list
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-users
>
>    

--

Hans Schwarz

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

[Mike Turchenkov]

Laurent Espitallier <laurent.espitallier@...> writes:

>
>
> 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<span title="les tables et les

champs à remplir

> impérativement">)
> and is there any tool or language to make it easier ?
> Thanks.
>
>
> _______________________________________________
> Digikam-users mailing list
> Digikam-users@...
> https://mail.kde.org/mailman/listinfo/digikam-users
>

Hi, could you please tell if there is some solution?
How did you edit sqlite database? It seems to be quite dangerous without
learning source code.

Scipting interface for tag manipulation would be nice.

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