search

advplyr / audiobookshelf

Self-hosted audiobook and podcast server
https://audiobookshelf.org
GNU General Public License v3.0
6.34k stars 447 forks source link

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

Open iconoclasthero opened 1 year ago

iconoclasthero commented 1 year ago

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.

strike84 commented 1 year ago

+1 For .csv export

iconoclasthero commented 1 year ago

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/

aurokon commented 9 months ago

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

ZLoth commented 5 months ago

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.

andrewakessler commented 5 months ago

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.

Xelveki commented 2 months ago

I'd also appreciate this feature.

iconoclasthero commented 2 months ago

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?

ZLoth commented 2 months ago

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

iconoclasthero commented 2 months ago

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.