SUMMARY I would like to suggest a function to be implemented in Digikam. A command to export the metadata of some selected images to a CSV file would be useful. Does this possibility exist today? Thank you SOFTWARE/OS VERSIONS Windows: Qt Version: 10
No, this feature do not exists. But if you use XMP sidecar, all album items will have a supplemental XML file with all database information duplicated, for interroperability. This is not enough ? Gilles Caulier
I ask myself, with the huge number of metadata fields, how many columns should the CVS file have? Maik
Plenty (:=)))... At least 50 i think... Gilles
Good estimate ((:-)) A typical JPEG out of the camera about 50 columns. exiftool -r -all -csv image.jpg > image.csv Maik
how to be useful the following: File name Title Description TAG Date Author ... let's say about 8 columns
Look this project on github : https://github.com/jensb/digikam-select It's a ruby script. I'm not sure if it do exactly what's you want but it's a first start. I don't know if is support the new database schema, but at least extracting most common file properties must be fine. I think it support only sqlite database, but i'm not sure... Gilles Caulier
It is interesting to have the command integrated in digikam. :-).
I checked the XMP files generated by Sidecar. Unfortunately there are no fields: title Description TAG and therefore the XMP file cannot be used to copy or export data. Thank you
Seriously (:=)))... Check well in different XMP namespace. All is there... Of course you need to enable right options in DK/Setup/Metadata view. Gilles Caulier
Created attachment 119048 [details] XMP sidecar example generated by digiKam Tag, comments, rating color and flag label, are here, in different namespace for interroperability.
Thanks, I saw the XMP file settings. Isn't there a simple method to copy the TAGs attributed to a file and then paste them with a CTRL + V? Thank you
No this method is not yet implemented and we have already a report about this subject. Gilles Caulier
In fact it is impossible to export the metadata (Title, Description, TAG, Filename) of a series of images. I installed "DB Browser" but I can't configure it to export the data I need. Do you have any indication to give me? Thank you
When you said "it's impossible to export...", you talk about XMP side car or the script from https://github.com/jensb/digikam-select ? Gilles Caulier
In the Sidecar files I see Title, Description TAG for the photos but not for the videos, maybe I have not selected the correct options? To put together the data of all the photos I should make a macro with Libreoffice Calc. With digikam-select on Ruby, I haven't tried, but I don't see in the options the possibility to export TAG, filename, title and description, am I wrong? Thank you
video are read only files for metadata => use option to write sidecar for read only file in Metadata setup panel. digikam-select => if this script do not extract file properties from database, well what's the goal of this script ??? (:=)))... Gilles Caulier
Right : the digikam-select extract file name depending of file properties. With this one : https://github.com/teuben/DigikamScripts The first script will extract comment property. It can be extended easily to deal with others properties. Gilles Caulier
Look this project too : https://github.com/paulhurleyuk/DigikamR Gilles Caulier
Thank you very much for the resources you sent me. In the coming days I will try to study them well. DigikamR should do what I want. If it were implemented in Digikam it would be very convenient. Thanks again!
The solution proposed in: https://github.com/paulhurleyuk/DigikamR which uses R to perform operations on the database is very interesting. I installed R and the various libraries needed. Unfortunately the example refers to the old version of the Digikam database. Entering the command lines will result in several errors of objects not found in the database. Unfortunately I don't know where to put my hands. Do you have any ideas? Thank you
I noticed that in the MP4 movie files the METADATA> XMP and IPTC tab does not show the KEYWORD and TAG fields. The contents of the TAG field do not even appear in the Sidecar file. Is it possible to make the contents of these fields appear? Thank you
*** Bug 462440 has been marked as a duplicate of this bug. ***
*** Bug 479808 has been marked as a duplicate of this bug. ***