Is there a way to produce a list of filenames from a set of selected photos in digiKam?
I need to do some scripting based on filter results.
Seems like there would be an export tool that produced a database or spreadsheet of file data and metadata.
By accident, I found a workaround. I’ll present it here but if you happen to know other ways, I’m still interested.
Process in Windows 11
- Filter your current digiKam album however you like.
- From the Export file menu, choose any export method (Local or MediaWiki produce the least friction).
- Within the Export pop-up window, under the file list frame, click the Save the list icon.
- Choose a filename, destination directory, and click Save.
The list will export as XML format.
That’s interesting. Does the list contain more data than just the file name?
I usually solve your problem as follows:
- I tag all those images with a unique tag (e.g. file-export).
- then I do a query on the Database, e.g. by
echo “SELECT relativePath,Images.name FROM Images,Albums,ImageTags,Tags WHERE
Tags.name LIKE '%”$1"%’ AND ImageTags.tagid=Tags.id AND Images.id=ImageTags.imageid
AND Albums.id=Images.Album
AND (NOT Images.id IN (SELECT imageid FROM ImageTags,Tags WHERE ImageTags.tagid=Tags.id AND Tags.name=‘private’))
AND (NOT Images.id IN (SELECT imageid FROM ImageTags,Tags WHERE ImageTags.tagid=Tags.id AND Tags.name=‘hidden’))
;"
| sqlite3 YOURdigikam.db
To answer my own questio9n, NO only the filenames are output.
Dietrich
I’m using MariaDB Internal Server, does your SQL work with that as well as SQLite?
Thanks in advance,
Steve