| Summary: | Add a new tool to export database metadata to a CVS file. | ||
|---|---|---|---|
| Product: | [Applications] digikam | Reporter: | Maurizio <mail> |
| Component: | Plugin-Bqm-WishForNewTools | Assignee: | Digikam Developers <digikam-bugs-null> |
| Status: | REPORTED --- | ||
| Severity: | wishlist | CC: | 806197556, caulier.gilles, metzpinguin, st11x |
| Priority: | NOR | ||
| Version First Reported In: | 6.0.0 | ||
| Target Milestone: | --- | ||
| Platform: | Microsoft Windows | ||
| OS: | Microsoft Windows | ||
| Latest Commit: | Version Fixed In: | ||
| Sentry Crash Report: | |||
| Attachments: | XMP sidecar example generated by digiKam | ||
|
Description
Maurizio
2019-03-24 09:21:15 UTC
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. *** |