[Bug 39394] New: Client-side conversion of CSV to Excel and ODS formats
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39394 Bug ID: 39394 Summary: Client-side conversion of CSV to Excel and ODS formats Change sponsored?: --- Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Reports Assignee: koha-bugs@lists.koha-community.org Reporter: mathsabypro@gmail.com QA Contact: testopia@bugs.koha-community.org Since ODS generation can cause issues (https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23685), and Excel generation is not currently possible, why not using libraries such as https://sheetjs.com/ (and other tools like https://www.papaparse.com/ or web workers for big files?) to convert the generated CSV to Excel or ODS in the browser ? It could be used for reports but also other CSV generated by Koha. We will try this approach in my library, as a local customization. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39394 trevor.diamond@mainlib.org changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |trevor.diamond@mainlib.org --- Comment #1 from trevor.diamond@mainlib.org --- Maybe this isn't the place (and I would be happy to take this elsewhere) but WHY is it "currently not possible" to get Excel files from reports? Basically any table in Koha has 4 export options: Excel, CSV, Copy, Print. It's a little odd to not also see the Excel option when trying to download a report result. This bug is addressing a gap in Koha that I would like to better understand why the gap exists, but if this is the best way to resolve the missing format, then I will follow this bug with interest! -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39394 --- Comment #2 from Mathieu Saby <mathsabypro@gmail.com> --- I believe the perl libraries for exporting in Excel format are very old and could cause memory issues. https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23685#c7 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39394 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dcook@prosentient.com.au -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39394 --- Comment #3 from Owen Leonard <oleonard@myacpl.org> --- (In reply to trevor.diamond from comment #1)
but WHY is it "currently not possible" to get Excel files from reports? Basically any table in Koha has 4 export options: Excel, CSV, Copy, Print.
Just to clarify a little about why these things are different: tables which offer the Excel, CSV, etc. option are controlled by a third-party JavaScript library (DataTables) which includes this functionality. Saved SQL report results don't use the DataTables plugin because such reports could have thousands of results, and parsing that amount of data client-side with the DataTable plugin could crash the browser. Saved SQL report results are instead processed by Perl scripts in order to produce the requested file format for download. For this we depend on a third-party Perl library. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39394 --- Comment #4 from trevor.diamond@mainlib.org --- Thanks for providing this context, yall! -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39394 Michaela Sieber <michaela.sieber@kit.edu> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |michaela.sieber@kit.edu See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=42190 --- Comment #5 from Michaela Sieber <michaela.sieber@kit.edu> --- Please see Bug 42190 - Add datatables to reports it does give users the option to use the DataTables Export options in Report results including Excel. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org