Managing tags

Rellwood · 04-07-2019, 01:12 PM

Is there a way to export the manage tags to a csv file after "managing" them?

A csv file that could indicate the tag, then the changes, and whether or not it has been deleted? This would be very helpful in importing to Calibre Spy or other libraries.

BetterRed · 04-07-2019, 06:38 PM

Use this calibredb sub command ==>> list_categories

However, as I have explained elsewhere, and not for the first time, you can't import tags independently, they MUST be attached to a book - i.e. a line in the book list.

BR

Rellwood · 04-08-2019, 03:03 PM

@BetterRed,

Thanks for the suggestion. However, I wasn't trying to import tags, and I find it easier to get those columns from the database file using sq browser. I was hoping to locate a record of the changes made using the manage authors/tags. There is no way of tracking the changes. If there is someplace in the database file or in the library .json or somewhere in the Roaming folder I would appreciate knowing.

BetterRed · 04-08-2019, 05:27 PM

What about DaltonST's Audit Trail plugin, have you looked at that?

Have you considered using a file synch utility that maintains revision history? Or adding triggers to the database to maintain an audit trail of adds, changes and deletes to specific tables (google sqllite audit trail)?

BR

hovering · 04-19-2019, 09:27 PM

Saw this on another 'similar' topic.. try using DB Browser (SQLite)
OPEN Database, find your folder select .db file. Once it loads go to File/ Export File as CSV

04-07-2019, 01:12 PM	#1
Rellwood Library Breeder (She/Her) Posts: 1,156 Karma: 1900479 Join Date: Apr 2015 Location: Fullerton, California Device: Kobo Aura HD (1) PW3 (4) PW3 2019 new edition (1)	Managing tags Is there a way to export the manage tags to a csv file after "managing" them? A csv file that could indicate the tag, then the changes, and whether or not it has been deleted? This would be very helpful in importing to Calibre Spy or other libraries.

04-07-2019, 06:38 PM	#2
BetterRed null operator (he/him) Posts: 20,570 Karma: 26954694 Join Date: Mar 2012 Location: Sydney Australia Device: none	Use this calibredb sub command ==>> list_categories However, as I have explained elsewhere, and not for the first time, you can't import tags independently, they MUST be attached to a book - i.e. a line in the book list. BR Last edited by BetterRed; 04-07-2019 at 06:42 PM.

04-08-2019, 03:03 PM	#3
Rellwood Library Breeder (She/Her) Posts: 1,156 Karma: 1900479 Join Date: Apr 2015 Location: Fullerton, California Device: Kobo Aura HD (1) PW3 (4) PW3 2019 new edition (1)	@BetterRed, Thanks for the suggestion. However, I wasn't trying to import tags, and I find it easier to get those columns from the database file using sq browser. I was hoping to locate a record of the changes made using the manage authors/tags. There is no way of tracking the changes. If there is someplace in the database file or in the library .json or somewhere in the Roaming folder I would appreciate knowing. Last edited by Rellwood; 04-08-2019 at 03:09 PM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need tips for managing tags	petzi	Library Management	36	08-27-2016 10:54 PM
Managing Tags	ballast	Library Management	4	08-18-2013 02:07 PM
Managing Tags	ddjohn	Library Management	4	02-17-2011 03:26 PM
Managing Tags	crossi	Calibre	4	01-12-2011 10:20 PM
Managing tags	jesscat	Calibre	5	01-06-2010 07:32 PM

04-08-2019, 05:27 PM	#4
BetterRed null operator (he/him) Posts: 20,570 Karma: 26954694 Join Date: Mar 2012 Location: Sydney Australia Device: none	What about DaltonST's Audit Trail plugin, have you looked at that? Have you considered using a file synch utility that maintains revision history? Or adding triggers to the database to maintain an audit trail of adds, changes and deletes to specific tables (google sqllite audit trail)? BR

04-19-2019, 09:27 PM	#5
hovering Member Posts: 15 Karma: 10 Join Date: Oct 2018 Device: nook	Saw this on another 'similar' topic.. try using DB Browser (SQLite) OPEN Database, find your folder select .db file. Once it loads go to File/ Export File as CSV