View Single Post
Old 12-29-2014, 10:11 PM   #13
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,820
Karma: 30277270
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.

Click image for larger version

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

SQLite Browser and CSVFileView are both free to use

BR

Last edited by BetterRed; 12-29-2014 at 10:21 PM.
BetterRed is offline   Reply With Quote