![]() |
#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,164
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 | |
|
![]() |
#3 |
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 |
![]() |
![]() |
![]() |
#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 ![]() |
![]() |
![]() |
Advert | |
|
![]() |
#6 | |
Connoisseur
![]() Posts: 88
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? |
|
![]() |
![]() |
![]() |
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 |