starred/audiobookshelf
1
0
Fork 0
mirror of https://github.com/advplyr/audiobookshelf.git synced 2026-05-30 23:40:40 +02:00
Code Issues 1.0k Packages Projects Releases 10 Wiki Activity

[Enhancement]: Export reports as .csv so that I can do stuff with filtered lists of books #1372

New Issue
Open
opened 2026-04-24 23:42:33 +02:00 by adam · 9 comments
adam commented 2026-04-24 23:42:33 +02:00
Owner
Copy Link
Copy Source

Originally created by @iconoclasthero on GitHub (Sep 12, 2023).

Describe the feature/enhancement

So here's the use case I have right now: I have two main folders one is opus (newer) and one is mp3 (legacy). The current format of new books is Last, First; Author, Second -- Title: Subtitle (YYYY). I moved all the books that had been in nested "read" folders to a separate folder and retreed them so that it would be Last. First; Author, Second/Title: Subtitle (YYYY) regardless of format. Now the old (i.e. mp3 books) were not in so rigid a format (often omitting year, subtitle not separated with :, etc.) and did not have covers or .nfo files included. I have filtered this library for all books that are missing covers... Now I want to export that list so I can go and get all the covers. A .csv offers the advantage that I can either parse it manually or use a spreadsheet. I can see other use cases for "reports", but I'm not going to complicate things with them.

Originally created by @iconoclasthero on GitHub (Sep 12, 2023). ### Describe the feature/enhancement So here's the use case I have right now: I have two main folders one is opus (newer) and one is mp3 (legacy). The current format of new books is Last, First; Author, Second -- Title: Subtitle (YYYY). I moved all the books that had been in nested "read" folders to a separate folder and retreed them so that it would be Last. First; Author, Second/Title: Subtitle (YYYY) regardless of format. Now the old (i.e. mp3 books) were not in so rigid a format (often omitting year, subtitle not separated with `:`, etc.) **and did not have covers or .nfo files included**. I have filtered this library for all books that are missing covers... Now I want to export that list so I can go and get all the covers. A .csv offers the advantage that I can either parse it manually or use a spreadsheet. I can see other use cases for "reports", but I'm not going to complicate things with them.
adam added the enhancement label 2026-04-24 23:42:33 +02:00
adam commented 2026-04-24 23:42:34 +02:00
Author
Owner
Copy Link
Copy Source

@strike84 commented on GitHub (Sep 16, 2023):

+1 For .csv export

@strike84 commented on GitHub (Sep 16, 2023): +1 For .csv export
adam commented 2026-04-24 23:42:34 +02:00
Author
Owner
Copy Link
Copy Source

@iconoclasthero commented on GitHub (Sep 17, 2023):

Someone suggested that I could just query the SQL database to get the info I need. I'm sure I can figure this out (and I'm sure anyone else who needs such info can figure it out as well. That said, it would still be easier if there was some way to run reports from ABS directly.

https://linuxhint.com/install_sqlite_browser_ubuntu_1804/

@iconoclasthero commented on GitHub (Sep 17, 2023): Someone suggested that I could just query the SQL database to get the info I need. I'm sure I can figure this out (and I'm sure anyone else who needs such info _can_ figure it out as well. That said, it would still be easier if there was some way to run reports from ABS directly. https://linuxhint.com/install_sqlite_browser_ubuntu_1804/
adam commented 2026-04-24 23:42:35 +02:00
Author
Owner
Copy Link
Copy Source

@aurokon commented on GitHub (Dec 18, 2023):

Just being able to export a list of everything in the library would be super nice. Author, title, and formats (audio/epub)

@aurokon commented on GitHub (Dec 18, 2023): Just being able to export a list of everything in the library would be super nice. Author, title, and formats (audio/epub)
adam commented 2026-04-24 23:42:35 +02:00
Author
Owner
Copy Link
Copy Source

@ZLoth commented on GitHub (Apr 6, 2024):

There is a library at https://phpspreadsheet.readthedocs.io/en/latest/ which allows for exporting data in Excel, OpenDocument, HTML, CSV, or PDF (with an additional library.

@ZLoth commented on GitHub (Apr 6, 2024): There is a library at https://phpspreadsheet.readthedocs.io/en/latest/ which allows for exporting data in Excel, OpenDocument, HTML, CSV, or PDF (with an additional library.
adam commented 2026-04-24 23:42:36 +02:00
Author
Owner
Copy Link
Copy Source

@SubjectiveDonut commented on GitHub (Apr 24, 2024):

Adding my name to the individuals who would love to be able to export a simple .csv of book titles and authors within our libraries. Thanks and keep up the great work.

@SubjectiveDonut commented on GitHub (Apr 24, 2024): Adding my name to the individuals who would love to be able to export a simple .csv of book titles and authors within our libraries. Thanks and keep up the great work.
adam commented 2026-04-24 23:42:37 +02:00
Author
Owner
Copy Link
Copy Source

@Xelveki commented on GitHub (Jul 9, 2024):

I'd also appreciate this feature.

@Xelveki commented on GitHub (Jul 9, 2024): I'd also appreciate this feature.
adam commented 2026-04-24 23:42:37 +02:00
Author
Owner
Copy Link
Copy Source

@iconoclasthero commented on GitHub (Jul 11, 2024):

There is a library at https://phpspreadsheet.readthedocs.io/en/latest/ which allows for exporting data in Excel, OpenDocument, HTML, CSV, or PDF (with an additional library.

That's a PHP-based solution?

abs is JavaScript: 65.3%; Vue: 33.7%. Is there a comparable library in JS that might be more easily integrated into the existing code?

@iconoclasthero commented on GitHub (Jul 11, 2024): > There is a library at https://phpspreadsheet.readthedocs.io/en/latest/ which allows for exporting data in Excel, OpenDocument, HTML, CSV, or PDF (with an additional library. That's a PHP-based solution? abs is JavaScript: 65.3%; Vue: 33.7%. Is there a comparable library in JS that might be more easily integrated into the existing code?
adam commented 2026-04-24 23:42:38 +02:00
Author
Owner
Copy Link
Copy Source

@ZLoth commented on GitHub (Jul 22, 2024):

https://developer.mescius.com/blogs/how-to-import-export-excel-xlsx-using-javascript ?

@ZLoth commented on GitHub (Jul 22, 2024): https://developer.mescius.com/blogs/how-to-import-export-excel-xlsx-using-javascript ?
adam commented 2026-04-24 23:42:39 +02:00
Author
Owner
Copy Link
Copy Source

@iconoclasthero commented on GitHub (Jul 30, 2024):

As I've been doing direct DB maintenance and other stuff with "CSV", the delimiter would have to be selectable since there are undoubtedly ,s in titles. I have no ~s, so that would work for me and—as the discrete ~ character is not used in Spanish or Portuguese—for most others as well.

@iconoclasthero commented on GitHub (Jul 30, 2024): As I've been doing direct DB maintenance and other stuff with "CSV", the delimiter would have to be selectable since there are undoubtedly `,`s in titles. I have no `~`s, so that would work for me and—as the discrete `~` character is not used in Spanish or Portuguese—for most others as well.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
authentication
backlog
bug
chapter editor
config-issue
ebooks
encoding/embedding
enhancement
help wanted
listening sessions & progress
planned
possible plugin
progress sync
pull-request
Mirrored from GitHub Pull Request
 sorting/filtering/searching
unable to reproduce
upload
users & permissions
waiting
No Label enhancement
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
adam (Adam Melkus)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/audiobookshelf#1372
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?