Copy manage tags matrix to clipboard

[Rellwood]

Is there a way to copy the matrix for the manage tags editor? Would like to have the values exported to .csv. The .db file only shows the id's and not the number of times the tag is used. I have a custom column for the ENF plugin which is comma separated containing some 5000 total words that I need to weed down.

[DaltonST]

Originally Posted by Rellwood

Is there a way to copy the matrix for the manage tags editor? Would like to have the values exported to .csv. The .db file only shows the id's and not the number of times the tag is used. I have a custom column for the ENF plugin which is comma separated containing some 5000 total words that I need to weed down.

This SQL run in DB Browser for SQLite or whatever tool you are using to peruse metadata.db can be used to create a spreadsheet file.

SELECT book,name FROM books_tags_link,tags WHERE books_tags_link.tag = tags.id  ORDER BY name,book

book name

26720 Action & Adventure


The spreadsheet application should be able to easily create a summarized matrix based on Tag Name.


Or, create the list already summarized via:

SELECT name,count(*) FROM books_tags_link,tags WHERE books_tags_link.tag = tags.id  GROUP BY name

Action & Adventure 2




DaltonST


n.b. I added new comments to my answer to your CALM question from yesterday.