![]() |
#1 |
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 |
![]() |
![]() |
![]() |
#2 |
Well trained by Cats
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 30,321
Karma: 58000000
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. |
![]() |
![]() |
![]() |
#3 |
creator of calibre
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 44,293
Karma: 23661992
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 |
![]() |
![]() |
![]() |
#4 |
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 |
![]() |
![]() |
![]() |
#5 |
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 ![]() |
![]() |
![]() |
![]() |
#6 | |
Connoisseur
![]() Posts: 91
Karma: 10
Join Date: Mar 2024
Location: Saint Petersburg, Russia
Device: Kindle Paperwhite (2021) Signature Edition
|
Quote:
![]() No way to output list in LNFN format? |
|
![]() |
![]() |
![]() |
#7 |
creator of calibre
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 44,293
Karma: 23661992
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.
|
![]() |
![]() |
![]() |
Tags |
author catalog, exporting files |
|
![]() |
||||
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 |