Is there a way to export a list of all authors to a csv file?

LadyKate · 05-01-2015, 12:59 AM

I've just been wondering if there is a way to export the authors and/or author sort to a csv. I have not seen a way to do so but think it would be great to be able to look at the author list that way.

eschwartz · 05-01-2015, 01:08 AM

Did you try making a catalog?

You *could* also use a sqlite browser to dump the authors table of the metadata.db

kovidgoyal · 05-01-2015, 01:21 AM

calibre-debug -c 'from calibre.library import db; db = db().new_api; print "\n".join(db.all_field_names("authors"))'

Divingduck · 05-01-2015, 07:34 AM

Kovid,
in windows I'll get an error. There you need to replace ' to " and " to '.

calibre-debug -c "from calibre.library import db; db = db().new_api; print '\n'.join(db.all_field_names('authors'))"

I use it for build a text file via cmd that way:

calibre-debug -c "from calibre.library import db; db = db().new_api; print '\n'.join(db.all_field_names('authors'))" >AllAuthors.txt

anishmittal · 02-01-2022, 02:10 PM

calibre-debug -c 'from calibre.library import db; db = db().new_api; print ("\n".join(db.all_field_names("authors")))' | LC_COLLATE=C sort

05-01-2015, 12:59 AM	#1
LadyKate Fanatic Posts: 515 Karma: 1470724 Join Date: Jul 2013 Location: Quebec CA Device: android 4 (samsung tablet and asus tablet)	Is there a way to export a list of all authors to a csv file? I've just been wondering if there is a way to export the authors and/or author sort to a csv. I have not seen a way to do so but think it would be great to be able to look at the author list that way.

05-01-2015, 07:34 AM	#4
Divingduck Wizard Posts: 1,166 Karma: 1410083 Join Date: Nov 2010 Location: Germany Device: Sony PRS-650	Kovid, in windows I'll get an error. There you need to replace ' to " and " to '. calibre-debug -c "from calibre.library import db; db = db().new_api; print '\n'.join(db.all_field_names('authors'))" I use it for build a text file via cmd that way: calibre-debug -c "from calibre.library import db; db = db().new_api; print '\n'.join(db.all_field_names('authors'))" >AllAuthors.txt Last edited by Divingduck; 05-01-2015 at 02:35 PM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
export list of books in a csv file	jcarlier	Conversion	8	09-07-2013 10:59 PM
Bulk update of Calibre from .csv file, is it possible ?	Play-with-Books	Library Management	7	09-12-2012 06:08 AM
Import books from a CSV file	EricBr	Library Management	1	12-02-2011 12:35 PM
Import books from excel, csv or similar list?	BadGandalf	Library Management	34	02-11-2011 02:32 PM
Export to CSV/XLS?	highwaykind	Calibre	19	05-31-2009 03:35 PM

05-01-2015, 01:08 AM	#2
eschwartz Ex-Helpdesk Junkie Posts: 19,421 Karma: 85400180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	Did you try making a catalog? You could also use a sqlite browser to dump the authors table of the metadata.db

05-01-2015, 01:21 AM	#3
kovidgoyal creator of calibre Posts: 45,616 Karma: 28549044 Join Date: Oct 2006 Location: Mumbai, India Device: Various	calibre-debug -c 'from calibre.library import db; db = db().new_api; print "\n".join(db.all_field_names("authors"))'

02-01-2022, 02:10 PM	#5
anishmittal Junior Member Posts: 8 Karma: 10 Join Date: Nov 2021 Device: Kindle Paperwhite 5 (2021)	calibre-debug -c 'from calibre.library import db; db = db().new_api; print ("\n".join(db.all_field_names("authors")))' \| LC_COLLATE=C sort

Advert

Advert