digiKam › digikam-users

Migrating from F-Spot to digiKam: how to import tags?

Classic

List

Threaded

9 messages Options

Rafael Coninck Teigão

Migrating from F-Spot to digiKam: how to import tags?

Hello, everyone.

First of all, I'd like to say that I'm really impressed by how
lightweight digiKam is and how fast it was able to import around 6k
photos I have.

Speaking of 6000 :-)... all my photos were managed by F-Spot, and all
of them are cataloged in tags such as: Places -> USA -> California ->
Carmel -> 17 ml rd. All these tags are stored in a photos.db file and
most of my photos also have multiple tags.

Is there a way for me to import these tags to digiKam? Is it possible
for them to keep nested, such as the example above?

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

Gilles Caulier-4

Re: Migrating from F-Spot to digiKam: how to import tags?

Which F-Spot database is ? SQlite ? If yes, and if we know the database schema, this can be done in digiKam DB migration tool introduced with 1.3.0 version. Of course, source code need to be implemented.

Gilles Caulier

2010/12/31 Rafael Coninck Teigão <[hidden email]>

Hello, everyone.

First of all, I'd like to say that I'm really impressed by how
lightweight digiKam is and how fast it was able to import around 6k
photos I have.

Speaking of 6000 :-)... all my photos were managed by F-Spot, and all
of them are cataloged in tags such as: Places -> USA -> California ->
Carmel -> 17 ml rd. All these tags are stored in a photos.db file and
most of my photos also have multiple tags.

Is there a way for me to import these tags to digiKam? Is it possible
for them to keep nested, such as the example above?

Thanks a lot,
Rafael.
_______________________________________________
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

Rafael Coninck Teigão

Re: Migrating from F-Spot to digiKam: how to import tags?

It's SQlite, yes!

I tried using the migration tool, it didn't work, of course, since the
schema is different.

I also tried using the attached python script, but I don't know enough
python/sqlite to debug the error (I did manage to fix a few bugs,
though.)

This script is from
http://blog.mekk.waw.pl/archives/12-Moving-images-from-F-Spot-to-digiKam.html

It would be really nice to have to tool to do it, since ubuntu 10.10
removed f-spot in favor of the somewhat incomplete shotwell.

Maybe someone can help me fix the script?

Cheers!

On Fri, Dec 31, 2010 at 3:49 PM, Gilles Caulier
<[hidden email]> wrote:

> Which F-Spot database is ? SQlite ? If yes, and if we know the database
> schema, this can be done in digiKam DB migration tool introduced with 1.3.0
> version. Of course, source code need to be implemented.
>
> Gilles Caulier
>
> 2010/12/31 Rafael Coninck Teigão <[hidden email]>
>>
>> Hello, everyone.
>>
>> First of all, I'd like to say that I'm really impressed by how
>> lightweight digiKam is and how fast it was able to import around 6k
>> photos I have.
>>
>> Speaking of 6000 :-)... all my photos were managed by F-Spot, and all
>> of them are cataloged in tags such as: Places -> USA -> California ->
>> Carmel -> 17 ml rd. All these tags are stored in a photos.db file and
>> most of my photos also have multiple tags.
>>
>> Is there a way for me to import these tags to digiKam? Is it possible
>> for them to keep nested, such as the example above?
>>
>> Thanks a lot,
>> Rafael.
>> _______________________________________________
>> 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

fspot_to_digikam.py (9K) Download Attachment

Johannes Wienke-3

Re: Migrating from F-Spot to digiKam: how to import tags?

Hey,

can F-Sport write XMP data? If yes, they can be imported by digiKam.

Regards,
Johannes

Am 31.12.2010 19:20 schrieb Rafael Coninck Teigão:

> It's SQlite, yes!
>
> I tried using the migration tool, it didn't work, of course, since the
> schema is different.
>
> I also tried using the attached python script, but I don't know enough
> python/sqlite to debug the error (I did manage to fix a few bugs,
> though.)
>
> This script is from
> http://blog.mekk.waw.pl/archives/12-Moving-images-from-F-Spot-to-digiKam.html
>
> It would be really nice to have to tool to do it, since ubuntu 10.10
> removed f-spot in favor of the somewhat incomplete shotwell.
>
> Maybe someone can help me fix the script?
>
> Cheers!
>
> On Fri, Dec 31, 2010 at 3:49 PM, Gilles Caulier
> <[hidden email]> wrote:
>> Which F-Spot database is ? SQlite ? If yes, and if we know the database
>> schema, this can be done in digiKam DB migration tool introduced with 1.3.0
>> version. Of course, source code need to be implemented.
>>
>> Gilles Caulier
>>
>> 2010/12/31 Rafael Coninck Teigão <[hidden email]>
>>>
>>> Hello, everyone.
>>>
>>> First of all, I'd like to say that I'm really impressed by how
>>> lightweight digiKam is and how fast it was able to import around 6k
>>> photos I have.
>>>
>>> Speaking of 6000 :-)... all my photos were managed by F-Spot, and all
>>> of them are cataloged in tags such as: Places -> USA -> California ->
>>> Carmel -> 17 ml rd. All these tags are stored in a photos.db file and
>>> most of my photos also have multiple tags.
>>>
>>> Is there a way for me to import these tags to digiKam? Is it possible
>>> for them to keep nested, such as the example above?
>>>
>>> Thanks a lot,
>>> Rafael.
>>> _______________________________________________
>>> 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

signature.asc (270 bytes) Download Attachment

Rafael Coninck Teigão

Re: Migrating from F-Spot to digiKam: how to import tags?

I believe it's XMP (just have to figure out how to write it for photos
I've already tagged.)

Is there a particular way to import it or should I just use the import
database tool?

Also, is it possible to retain the hierarchy of tags?

Thanks,
Rafael.

Happy new year, BTW!

On Fri, Dec 31, 2010 at 4:50 PM, Johannes Wienke <[hidden email]> wrote:

> Hey,
>
> can F-Sport write XMP data? If yes, they can be imported by digiKam.
>
> Regards,
> Johannes
>
> Am 31.12.2010 19:20 schrieb Rafael Coninck Teigão:
>> It's SQlite, yes!
>>
>> I tried using the migration tool, it didn't work, of course, since the
>> schema is different.
>>
>> I also tried using the attached python script, but I don't know enough
>> python/sqlite to debug the error (I did manage to fix a few bugs,
>> though.)
>>
>> This script is from
>> http://blog.mekk.waw.pl/archives/12-Moving-images-from-F-Spot-to-digiKam.html
>>
>> It would be really nice to have to tool to do it, since ubuntu 10.10
>> removed f-spot in favor of the somewhat incomplete shotwell.
>>
>> Maybe someone can help me fix the script?
>>
>> Cheers!
>>
>> On Fri, Dec 31, 2010 at 3:49 PM, Gilles Caulier
>> <[hidden email]> wrote:
>>> Which F-Spot database is ? SQlite ? If yes, and if we know the database
>>> schema, this can be done in digiKam DB migration tool introduced with 1.3.0
>>> version. Of course, source code need to be implemented.
>>>
>>> Gilles Caulier
>>>
>>> 2010/12/31 Rafael Coninck Teigão <[hidden email]>
>>>>
>>>> Hello, everyone.
>>>>
>>>> First of all, I'd like to say that I'm really impressed by how
>>>> lightweight digiKam is and how fast it was able to import around 6k
>>>> photos I have.
>>>>
>>>> Speaking of 6000 :-)... all my photos were managed by F-Spot, and all
>>>> of them are cataloged in tags such as: Places -> USA -> California ->
>>>> Carmel -> 17 ml rd. All these tags are stored in a photos.db file and
>>>> most of my photos also have multiple tags.
>>>>
>>>> Is there a way for me to import these tags to digiKam? Is it possible
>>>> for them to keep nested, such as the example above?
>>>>
>>>> Thanks a lot,
>>>> Rafael.
>>>> _______________________________________________
>>>> 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

pshute

Re: Migrating from F-Spot to digiKam: how to import tags?

In reply to this post by Rafael Coninck Teigão

There's an old thread about this here:
http://ubuntuforums.org/archive/index.php/t-412863.html
They ended up adding the tags to the files with a 3rd program, but that may not be necessary now.

I also found a reference here:
http://trac.yorba.org/wiki/PhotoTags
To an F-Spot extension to update all the files.

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

----- Original Message -----
From: Rafael Coninck Teigão <[hidden email]>
To: digiKam - Home Manage your photographs as a professional with the power of open source <[hidden email]>
Sent: Sat Jan 01 06:04:06 2011
Subject: [Digikam-users] Re: Migrating from F-Spot to digiKam: how to import tags?

I believe it's XMP (just have to figure out how to write it for photos
I've already tagged.)

Is there a particular way to import it or should I just use the import
database tool?

Also, is it possible to retain the hierarchy of tags?

Thanks,
Rafael.

Happy new year, BTW!

On Fri, Dec 31, 2010 at 4:50 PM, Johannes Wienke <[hidden email]> wrote:

_______________________________________________
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

Johannes Wienke-3

Re: Migrating from F-Spot to digiKam: how to import tags?

In reply to this post by Rafael Coninck Teigão

Am 31.12.2010 20:04 schrieb Rafael Coninck Teigão:
> I believe it's XMP (just have to figure out how to write it for photos
> I've already tagged.)
>
> Is there a particular way to import it or should I just use the import
> database tool?
>
> Also, is it possible to retain the hierarchy of tags?

digiKam itself stores the tags with hierarchy in XMP, so parsing them is
not a problem. I don't if f-spot can write an appropriate structure.
This looks promising:
http://pozzi.ws/index.php?page=xmp-spot

Regards and happy new year,
Johannes

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

signature.asc (270 bytes) Download Attachment

jim junk

Re: Migrating from F-Spot to digiKam: how to import tags?

In reply to this post by pshute

It's been a long time since I've used Fspot but as I recall it included an option to write the tags to the image and not just to a database. Can you just have fspot write the tags to the images and then Digikam can just scan the images and build the database for you from the tags inside the images? It's always seem to me that writing the tags to the images is the best way to go assuming the the image format that your using will support it. If the database gets corrupted then you can just delete it and let the software rescan it.

> From: [hidden email]
> To: [hidden email]
> Date: Sat, 1 Jan 2011 06:15:49 +1100
> Subject: [Digikam-users] Re: Migrating from F-Spot to digiKam: how to import tags?
>
> There's an old thread about this here:
> http://ubuntuforums.org/archive/index.php/t-412863.html
> They ended up adding the tags to the files with a 3rd program, but that may not be necessary now.
>
> I also found a reference here:
> http://trac.yorba.org/wiki/PhotoTags
> To an F-Spot extension to update all the files.
>
>
> --------------------------
> Sent using BlackBerry
>
> ----- Original Message -----
> From: Rafael Coninck Teigão <[hidden email]>
> To: digiKam - Home Manage your photographs as a professional with the power of open source <[hidden email]>
> Sent: Sat Jan 01 06:04:06 2011
> Subject: [Digikam-users] Re: Migrating from F-Spot to digiKam: how to import tags?
>
> I believe it's XMP (just have to figure out how to write it for photos
> I've already tagged.)
>
> Is there a particular way to import it or should I just use the import
> database tool?
>
> Also, is it possible to retain the hierarchy of tags?
>
> Thanks,
> Rafael.
>
> Happy new year, BTW!
>
> On Fri, Dec 31, 2010 at 4:50 PM, Johannes Wienke <[hidden email]> wrote:
> > Hey,
> >
> > can F-Sport write XMP data? If yes, they can be imported by digiKam.
> >
> > Regards,
> > Johannes
> >
> > Am 31.12.2010 19:20 schrieb Rafael Coninck Teigão:
> >> It's SQlite, yes!
> >>
> >> I tried using the migration tool, it didn't work, of course, since the
> >> schema is different.
> >>
> >> I also tried using the attached python script, but I don't know enough
> >> python/sqlite to debug the error (I did manage to fix a few bugs,
> >> though.)
> >>
> >> This script is from
> >> http://blog.mekk.waw.pl/archives/12-Moving-images-from-F-Spot-to-digiKam.html
> >>
> >> It would be really nice to have to tool to do it, since ubuntu 10.10
> >> removed f-spot in favor of the somewhat incomplete shotwell.
> >>
> >> Maybe someone can help me fix the script?
> >>
> >> Cheers!
> >>
> >> On Fri, Dec 31, 2010 at 3:49 PM, Gilles Caulier
> >> <[hidden email]> wrote:
> >>> Which F-Spot database is ? SQlite ? If yes, and if we know the database
> >>> schema, this can be done in digiKam DB migration tool introduced with 1.3.0
> >>> version. Of course, source code need to be implemented.
> >>>
> >>> Gilles Caulier
> >>>
> >>> 2010/12/31 Rafael Coninck Teigão <[hidden email]>
> >>>>
> >>>> Hello, everyone.
> >>>>
> >>>> First of all, I'd like to say that I'm really impressed by how
> >>>> lightweight digiKam is and how fast it was able to import around 6k
> >>>> photos I have.
> >>>>
> >>>> Speaking of 6000 :-)... all my photos were managed by F-Spot, and all
> >>>> of them are cataloged in tags such as: Places -> USA -> California ->
> >>>> Carmel -> 17 ml rd. All these tags are stored in a photos.db file and
> >>>> most of my photos also have multiple tags.
> >>>>
> >>>> Is there a way for me to import these tags to digiKam? Is it possible
> >>>> for them to keep nested, such as the example above?
> >>>>
> >>>> Thanks a lot,
> >>>> Rafael.
> >>>> _______________________________________________
> >>>> 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

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

pshute

Re: Migrating from F-Spot to digiKam: how to import tags?

In reply to this post by Rafael Coninck Teigão

I've never used it, but my understanding from reading the links I provided, is that existing tags aren't written to the files after writing is enabled, only new ones, hence the use of other programs and F-Spot extensions.

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

From: jim junk
To: [hidden email]
Sent: Mon Jan 03 06:52:59 2011
Subject: [Digikam-users] Re: Migrating from F-Spot to digiKam: how to import tags?

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