Export an author list

DeBig · 01-25-2018, 06: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, 01:42 PM

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

kovidgoyal · 01-25-2018, 01: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, 02: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, 08: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 · 08-03-2024, 09: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?

kovidgoyal · 08-04-2024, 02:01 AM

author_sort is not a separate field. Read the author sort value from the authors table for each author and output that instead if thats what you want to do. See the docs of the DB interface for th efunctions you can use for that.

01-25-2018, 06: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, 01:51 PM	#3
kovidgoyal creator of calibre Posts: 44,564 Karma: 24495948 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, 02: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, 08: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 05:00 PM
Export job list	antk	Calibre	2	07-11-2015 12:43 PM
export library list	nazareno	Library Management	10	02-08-2015 02:03 PM
Export list to excel?	Belle2Be	Library Management	7	01-15-2014 07:14 AM
How-to Question: Export list	Mixx	Library Management	7	05-28-2013 09:51 PM

01-25-2018, 01:42 PM	#2
theducks Well trained by Cats Posts: 30,452 Karma: 58055868 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.

08-04-2024, 02:01 AM	#7
kovidgoyal creator of calibre Posts: 44,564 Karma: 24495948 Join Date: Oct 2006 Location: Mumbai, India Device: Various	author_sort is not a separate field. Read the author sort value from the authors table for each author and output that instead if thats what you want to do. See the docs of the DB interface for th efunctions you can use for that.