Re: Tagging photos in bulk with data stored in excel

[P. Kellner]

If you are on Linux why not just write a script to do that with exiftools?

Sent from my Samsung device

-------- Original message --------
From: Joeriz <[hidden email]>
Date: 8/29/20 2:05 AM (GMT+09:00)
To: [hidden email]
Subject: [digiKam-users] Tagging photos in bulk with data stored in excel

I have thousands of photos of wildlife, with a corresponding excel file that
contains the species information for each photo. I would like to write each
species' name into the metadata of each of the photos. Doing it by hand
would take weeks, so it needs to be done in bulk, by importing the excel
file.

It seems like this option should be possible with Digikam, but I can't seem
to find any information on it.

Thanks a lot in advance!



--
Sent from: http://digikam.1695700.n4.nabble.com/digikam-users-f1735189.html

[Remco Viëtor]

On samedi 29 août 2020 09:28:12 CEST kellnerp wrote:
> If you are on Linux why not just write a script to do that with
> exiftools?Sent from my Samsung device
>

To the best of my knowledge, excel isn't available for Linux...

Apart from that, a script would be the best option, with export of the
relevant data from excel to an easy to parse format.

The only caveat would be for the case of raw files, where writing to the
metadata is strongly discouraged. But it might be possible to create/update
xmp files associated with the raw files.

But before that, OP might want to think about what he means exactly by
"writing each species' name into the metadata": does he want a caption, a
title, keywords (if so, just the species name?), is there location information
to be written as well, (and how), etc.

> -------- Original message --------
> From: Joeriz <[hidden email]>
> Date: 8/29/20  2:05 AM  (GMT+09:00)
> To: [hidden email]
> Subject: [digiKam-users] Tagging photos in bulk with data stored in excel
>
> I have thousands of photos of wildlife, with a corresponding excel file
> thatcontains the species information for each photo. I would like to write
> eachspecies' name into the metadata of each of the photos. Doing it by
> handwould take weeks, so it needs to be done in bulk, by importing the
> excelfile. It seems like this option should be possible with Digikam, but I
> can't seemto find any information on it.

Of course not, excel is only available under Ms-windows or MacOS, not under
Linux, and digikam is developed principally under Linux. And decoding an excel
spreadsheet is not simple (esp. since there is not just one excel file
format).

Remco

[Stuart T Rogers]

Just to point out that Libreoffice should be able to open Excel files
and they can then be converted easily to another format.

Stuart

On 29/08/2020 10:56, Remco Viëtor wrote:

> On samedi 29 août 2020 09:28:12 CEST kellnerp wrote:
>> If you are on Linux why not just write a script to do that with
>> exiftools?Sent from my Samsung device
>>
>
> To the best of my knowledge, excel isn't available for Linux...
>
> Apart from that, a script would be the best option, with export of the
> relevant data from excel to an easy to parse format.
>
> The only caveat would be for the case of raw files, where writing to the
> metadata is strongly discouraged. But it might be possible to create/update
> xmp files associated with the raw files.
>
> But before that, OP might want to think about what he means exactly by
> "writing each species' name into the metadata": does he want a caption, a
> title, keywords (if so, just the species name?), is there location information
> to be written as well, (and how), etc.
>> -------- Original message --------
>> From: Joeriz <[hidden email]>
>> Date: 8/29/20  2:05 AM  (GMT+09:00)
>> To: [hidden email]
>> Subject: [digiKam-users] Tagging photos in bulk with data stored in excel
>>
>> I have thousands of photos of wildlife, with a corresponding excel file
>> thatcontains the species information for each photo. I would like to write
>> eachspecies' name into the metadata of each of the photos. Doing it by
>> handwould take weeks, so it needs to be done in bulk, by importing the
>> excelfile. It seems like this option should be possible with Digikam, but I
>> can't seemto find any information on it.
>
> Of course not, excel is only available under Ms-windows or MacOS, not under
> Linux, and digikam is developed principally under Linux. And decoding an excel
> spreadsheet is not simple (esp. since there is not just one excel file
> format).
>
> Remco
>
>
>
>

--
Website: https://www.stella-maris.org.uk
or:      https//www.broadstairs.org

[Mick Sulley]

LibreOffice Calc will read Excel files, but doesn't translate macros.

When working with data in Excel format, if you know the basics of Python
I would recommend xlrd and xlwt  See
https://github.com/python-excel/tutorial

Mick

On 29/08/2020 10:56, Remco Viëtor wrote:

> On samedi 29 août 2020 09:28:12 CEST kellnerp wrote:
>> If you are on Linux why not just write a script to do that with
>> exiftools?Sent from my Samsung device
>>
> To the best of my knowledge, excel isn't available for Linux...
>
> Apart from that, a script would be the best option, with export of the
> relevant data from excel to an easy to parse format.
>
> The only caveat would be for the case of raw files, where writing to the
> metadata is strongly discouraged. But it might be possible to create/update
> xmp files associated with the raw files.
>
> But before that, OP might want to think about what he means exactly by
> "writing each species' name into the metadata": does he want a caption, a
> title, keywords (if so, just the species name?), is there location information
> to be written as well, (and how), etc.
>> -------- Original message --------
>> From: Joeriz <[hidden email]>
>> Date: 8/29/20  2:05 AM  (GMT+09:00)
>> To: [hidden email]
>> Subject: [digiKam-users] Tagging photos in bulk with data stored in excel
>>
>> I have thousands of photos of wildlife, with a corresponding excel file
>> thatcontains the species information for each photo. I would like to write
>> eachspecies' name into the metadata of each of the photos. Doing it by
>> handwould take weeks, so it needs to be done in bulk, by importing the
>> excelfile. It seems like this option should be possible with Digikam, but I
>> can't seemto find any information on it.
> Of course not, excel is only available under Ms-windows or MacOS, not under
> Linux, and digikam is developed principally under Linux. And decoding an excel
> spreadsheet is not simple (esp. since there is not just one excel file
> format).
>
> Remco
>
>
>