Export an author list

DeBig · 01-25-2018, 05:21 AM

Hello,
Is there any way to export an author list ? I would like a two column file (maybe a .csv) similar to the table we obtain by managing an author in Calibre. Such a list cannot easily be derived from a book catalog because most entries have multiple authors.
I need it because the authors names in my Calibre data base are without errors, normalized under only one form, and i want write a preprocessing module to correct new entries.authors

theducks · 01-25-2018, 12:42 PM

SQLlite spy: authors table
Just don't change anything you see there.

kovidgoyal · 01-25-2018, 12:51 PM

At a terminal/command prompt

Code:

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

Authors will be in authors.txt

DaltonST · 01-25-2018, 01:48 PM

Yes, easily. See the attached. It can do for any metadata value what you wish for authors. JS+ is the acronym for the "Job Spy" toolbox having (currently) 43 tools. https://www.mobileread.com/forums/sh...d.php?t=269911

The .csv file has 2 columns, the first being the "count", and the second being the chosen metadata column value having that count.

DaltonST

DeBig · 01-26-2018, 07:48 AM

Thank you for your answers !

SQLlitespy is the exact solution for me : csv table with author name and author_sort. And thank you for introducing me to SQLlitespy (shame on me

).

The Kovid python code outputs only author name without author_sort, and I am unable to expand it (shame on me

).

And I didn't know the beautiful JS+ (shame on me

) - but how to select author_sort ?

baursak · Today, 08:14 AM

Quote:

Originally Posted by kovidgoyal

At a terminal/command prompt

Code:

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

Authors will be in authors.txt

When I use 'author_sort' instead of 'authors' - it will not work

No way to output list in LNFN format?

01-25-2018, 05:21 AM	#1
DeBig Junior Member Posts: 8 Karma: 10 Join Date: Jan 2018 Device: Kobo Aura	Export an author list Hello, Is there any way to export an author list ? I would like a two column file (maybe a .csv) similar to the table we obtain by managing an author in Calibre. Such a list cannot easily be derived from a book catalog because most entries have multiple authors. I need it because the authors names in my Calibre data base are without errors, normalized under only one form, and i want write a preprocessing module to correct new entries.authors

01-25-2018, 12:51 PM	#3
kovidgoyal creator of calibre Posts: 44,175 Karma: 22670164 Join Date: Oct 2006 Location: Mumbai, India Device: Various	At a terminal/command prompt Code: calibre-debug -c "from calibre.library import db; db = db().new_api; print('\n'.join(db.all_field_names('authors')))" > authors.txt Authors will be in authors.txt

01-25-2018, 01:48 PM	#4
DaltonST Deviser Posts: 2,265 Karma: 2090983 Join Date: Aug 2013 Location: Texas Device: none	Yes, easily. See the attached. It can do for any metadata value what you wish for authors. JS+ is the acronym for the "Job Spy" toolbox having (currently) 43 tools. https://www.mobileread.com/forums/sh...d.php?t=269911 The .csv file has 2 columns, the first being the "count", and the second being the chosen metadata column value having that count. DaltonST Attached Thumbnails

01-26-2018, 07:48 AM	#5
DeBig Junior Member Posts: 8 Karma: 10 Join Date: Jan 2018 Device: Kobo Aura	Thanks Thank you for your answers ! SQLlitespy is the exact solution for me : csv table with author name and author_sort. And thank you for introducing me to SQLlitespy (shame on me ). The Kovid python code outputs only author name without author_sort, and I am unable to expand it (shame on me ). And I didn't know the beautiful JS+ (shame on me ) - but how to select author_sort ?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can you export a list of tags?	bhagerty	Library Management	17	12-14-2022 04:00 PM
Export job list	antk	Calibre	2	07-11-2015 11:43 AM
export library list	nazareno	Library Management	10	02-08-2015 01:03 PM
Export list to excel?	Belle2Be	Library Management	7	01-15-2014 06:14 AM
How-to Question: Export list	Mixx	Library Management	7	05-28-2013 08:51 PM

01-25-2018, 12:42 PM	#2
theducks Well trained by Cats Posts: 30,163 Karma: 57532198 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	SQLlite spy: authors table Just don't change anything you see there.

Advert

Advert