MobileRead Forums - View Single Post - Can Calibre output a list of JUST authors?

BetterRed · 12-29-2014, 11:11 PM

@Chandrak- I find this program ==>> DB Browser for SQLite useful to interrogate the on-disk database. It can export to a CSV, which can be read, sorted, and rearranged in this program ==>> CSVFileView or of course a spreadsheet such as Excel, Calc or Sheets. You wont see columns created from other columns in the on-disk database.

You can easily break the on-disk database with SQLiteBrowser, so it's best to copy the metadata.db file elsewhere and open it there.

Here's the list of authors in my test library as a CSV created with SQLite Browser and viewed with CSVFileView.

Click image for larger version

Name: Capture.JPG
Views: 280
Size: 90.6 KB
ID: 133125

SQLite Browser and CSVFileView are both free to use

BR

12-29-2014, 11:11 PM	#13
BetterRed null operator (he/him) Posts: 22,120 Karma: 30277960 Join Date: Mar 2012 Location: Sydney Australia Device: none	@Chandrak- I find this program ==>> DB Browser for SQLite useful to interrogate the on-disk database. It can export to a CSV, which can be read, sorted, and rearranged in this program ==>> CSVFileView or of course a spreadsheet such as Excel, Calc or Sheets. You wont see columns created from other columns in the on-disk database. You can easily break the on-disk database with SQLiteBrowser, so it's best to copy the metadata.db file elsewhere and open it there. Here's the list of authors in my test library as a CSV created with SQLite Browser and viewed with CSVFileView. SQLite Browser and CSVFileView are both free to use BR Last edited by BetterRed; 12-29-2014 at 11:21 PM.