Exporting/importing tagged face database

[Mateusz Konieczny]

Is there an existing tool/setting to export/import data created during
face tagging?

I am also willing to create software to do this do documentation where
and how this data is stored also would be useful (though obviously I
prefer to discover that needed software already exists).

I want to create backup of this data. I really would like to
tag faces on my photos and Digikam seems to be currently the best
available tool but I want to avoid lock-in (especially as face tagging
will consume hundreds of hours for my photo collection).

Note that I am not looking for folder with sqlite database file - I
want to export this data to some format that will be easily processed.

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

[Mateusz Konieczny]

Is there an existing tool/setting to export/import data created during
face tagging?

I am also willing to create software to do this do documentation where
and how this data is stored also would be useful (though obviously I
prefer to discover that needed software already exists).

I want to create backup of this data. I really would like to
tag faces on my photos and Digikam seems to be currently the best
available tool but I want to avoid lock-in (especially as face tagging
will consume hundreds of hours for my photo collection).

Note that I am not looking for folder with sqlite database file - I
want to export this data to some format that will be easily processed.
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Richard Mortimer-2]

Hi,

On 31/05/2016 10:41, Mateusz Konieczny wrote:
> Is there an existing tool/setting to export/import data created during
> face tagging?
I'm not aware of any existing software that will do this. But...

>
> I am also willing to create software to do this do documentation where
> and how this data is stored also would be useful (though obviously I
> prefer to discover that needed software already exists).
>
> I want to create backup of this data. I really would like to
> tag faces on my photos and Digikam seems to be currently the best
> available tool but I want to avoid lock-in (especially as face tagging
> will consume hundreds of hours for my photo collection).
>
> Note that I am not looking for folder with sqlite database file - I
> want to export this data to some format that will be easily processed.

I'm not sure what you mean by easily processed. But why do you discount
the SQLite database? That is a public domain database format that is
widely supported on just about every computing platform. You can use SQL
queries to access the data. If you prefer to keep the data outside of a
database you can dump the data using the sqlite3 commandline and the
.dump command. That will give you a SQL copy of the data that you can
process/manipulate in your favourite scripting language.

I would not discount the use of a sqlite database. Your data is
certainly not locked in and the digikam schema/data layout is public so
if you do ever need to transfer to a different application it should be
easy to do.

That said if there are existing interchange formats then I'm sure that
an exporter/importer will be of interest to the community.

Regards

Richard


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

[Stephan Olbrich-2]

Am Dienstag, 31. Mai 2016, 11:41:30 CEST schrieb Mateusz Konieczny:

> Is there an existing tool/setting to export/import data created during
> face tagging?
>
> I am also willing to create software to do this do documentation where
> and how this data is stored also would be useful (though obviously I
> prefer to discover that needed software already exists).
>
> I want to create backup of this data. I really would like to
> tag faces on my photos and Digikam seems to be currently the best
> available tool but I want to avoid lock-in (especially as face tagging
> will consume hundreds of hours for my photo collection).
>
> Note that I am not looking for folder with sqlite database file - I
> want to export this data to some format that will be easily processed.

Why don't you let digikam write the data into the exif information?

Regards,
Stephan

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

[Mateusz Konieczny]

On Wed, 01 Jun 2016 17:39:48 +0200
Stephan Olbrich <[hidden email]> wrote:

> Why don't you let digikam write the data into the exif information?

That would be probably the best solution. What would be the best way to
access this data? Is there some documentation about format of this data
(except analysing Digikam source code)?
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Mateusz Konieczny]

On Tue, 31 May 2016 11:27:47 +0100
Richard Mortimer <[hidden email]> wrote:

> On 31/05/2016 10:41, Mateusz Konieczny wrote:
> > Is there an existing tool/setting to export/import data created
> > during face tagging?
> I'm not aware of any existing software that will do this. But...
>
> >
> > I am also willing to create software to do this do documentation
> > where and how this data is stored also would be useful (though
> > obviously I prefer to discover that needed software already exists).
> >
> > I want to create backup of this data. I really would like to
> > tag faces on my photos and Digikam seems to be currently the best
> > available tool but I want to avoid lock-in (especially as face
> > tagging will consume hundreds of hours for my photo collection).
> >
> > Note that I am not looking for folder with sqlite database file - I
> > want to export this data to some format that will be easily
> > processed.
> I'm not sure what you mean by easily processed. But why do you
> discount the SQLite database? That is a public domain database format
> that is widely supported on just about every computing platform. You
> can use SQL queries to access the data. If you prefer to keep the
> data outside of a database you can dump the data using the sqlite3
> commandline and the .dump command. That will give you a SQL copy of
> the data that you can process/manipulate in your favourite scripting
> language.
>
> I would not discount the use of a sqlite database. Your data is
> certainly not locked in and the digikam schema/data layout is public
> so if you do ever need to transfer to a different application it
> should be easy to do.

Maybe I was to quick to consider database as dead end. Unfortunately
"Database schema" at https://www.digikam.org/docs links nowhere (to
https://quickgit.kde.org/?p=digikam.git) but at least it means that
database schema is supposed to be documented somewhere...
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Gilles Caulier-4]

yes, in source code, there is a project sub dir with LibreOffice spreadsheet with DB schema.

For obscure reason, the dir where document are hosted cannot be accessed through git web interface.

But DB do not use exif info has schema. Look in Exiv2 shared library document to see where face tags are stored in XMP. Exif is not dedicated for that.

Also we follow MWG to store face tags region : http://www.metadataworkinggroup.org/pdf/mwg_guidance.pdf

Gilles Caulier

2016-06-01 19:33 GMT+02:00 Mateusz Konieczny <[hidden email]>:

On Tue, 31 May 2016 11:27:47 +0100
Richard Mortimer <[hidden email]> wrote:

> On 31/05/2016 10:41, Mateusz Konieczny wrote:
> > Is there an existing tool/setting to export/import data created
> > during face tagging?
> I'm not aware of any existing software that will do this. But...
>
> >
> > I am also willing to create software to do this do documentation
> > where and how this data is stored also would be useful (though
> > obviously I prefer to discover that needed software already exists).
> >
> > I want to create backup of this data. I really would like to
> > tag faces on my photos and Digikam seems to be currently the best
> > available tool but I want to avoid lock-in (especially as face
> > tagging will consume hundreds of hours for my photo collection).
> >
> > Note that I am not looking for folder with sqlite database file - I
> > want to export this data to some format that will be easily
> > processed.
> I'm not sure what you mean by easily processed. But why do you
> discount the SQLite database? That is a public domain database format
> that is widely supported on just about every computing platform. You
> can use SQL queries to access the data. If you prefer to keep the
> data outside of a database you can dump the data using the sqlite3
> commandline and the .dump command. That will give you a SQL copy of
> the data that you can process/manipulate in your favourite scripting
> language.
>
> I would not discount the use of a sqlite database. Your data is
> certainly not locked in and the digikam schema/data layout is public
> so if you do ever need to transfer to a different application it
> should be easy to do.

Maybe I was to quick to consider database as dead end. Unfortunately
"Database schema" at https://www.digikam.org/docs links nowhere (to
https://quickgit.kde.org/?p=digikam.git) but at least it means that
database schema is supposed to be documented somewhere...

_______________________________________________
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