Can I print a list of tags and custom columns created in Calibre?

[KimbreLee]

I need to present a list of all the tags that have been created when uploading files. I would like to also see a list of the custom columns I have created. Anyway to print these lists?

[DaltonST]

Originally Posted by KimbreLee

I need to present a list of all the tags that have been created when uploading files. I would like to also see a list of the custom columns I have created. Anyway to print these lists?

For the list of all Tags (or other columns, standard or custom), along with the number of books that use each one, see: https://www.mobileread.com/forums/sho...9&postcount=25

As for the Custom Columns, the simplest way is to make a screenprint of the >Preferences>Add your own columns option in Calibre.

The harder way is to use a SQLite database browser to browse table custom_columns, export the data, and print it. An end-user tool for doing browsing is: http://sqlitebrowser.org/



DaltonST

[theducks]

another place for 'Custom' stuff is the db_prefs_backup.json file

Many of the rules are in clear text

Tags: I think a sqlite dump is probably a simple way. Not sure what you get from this as tags does not link TO their usage (Books link to tags)

[KimbreLee]

You guys are talking way over my head. I have no clue what to do with the link Dalton provided. Anyway you can dumb it down?

[DaltonST]

Originally Posted by KimbreLee

You guys are talking way over my head. I have no clue what to do with the link Dalton provided. Anyway you can dumb it down?

@KimbreLee:

The link is to a Job Spy example of one of its 19 GUI Tools that will do what you want to do.

If you install the plug-in Job Spy from the "Plug-in Updater" icon in Calibre, and then if you click the "Visualize Metadata" menu item underneath the Job Spy (JS+) icon on your toolbar, you will get what the example shown in the link shows you.

DaltonST

[meghane_e]

As an update, this thread info is still correct.
For complete newbies to JS+ needing to print tags or other columns:
(0. Install JS+ plugin)
1. On the opening menu dialog, go to"GUI Tools that are related to Metadata"
2. Towards the very bottom of the menu, select "Visualize Metadata"
3. A second dialog box with a nice simple layout comes up that allows
you to select various columns.
Good luck!

[BetterRed]

The calibredb command has sub commands to list custom columns and categories (tags)

Can't recall what properties they list, don't forget that custom columns and categories are stored for each library so you might need to use the --with-library option.

BR

[meghane_e]

I used calibredb list -f *genre > "genre_list.txt". The files have a line for each book showing id+buffer+genre. The (id+buffer) was 5 spaces for me but would vary per library.

I ended up writing a python script to strip the id+buffer and and print a comma-separated list of all genres plus an additional comma-separated list with each genre in quotes for use in Calibre template code (might as well).

ex.
List 1: Adventure, Fantasy, Mystery, Romance, Science Fiction
List 2: "Adventure", "Fantasy", "Mystery", "Romance", "Science Fiction"

Happy to share it, although my coding is clunky.