Bug 30049 - Add ability to download a list as a list of items as spreasheet/CSV
Summary: Add ability to download a list as a list of items as spreasheet/CSV
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Lists (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-02-08 17:55 UTC by Esther Melander
Modified: 2022-08-04 15:50 UTC (History)
2 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Esther Melander 2022-02-08 17:55:03 UTC
Currently the only options for downloading a list in the list tab is iso2709, RIS, Bibtex. It would be nice to be able to download a list as an Excel or LibreOffice Calc file, perhaps a CSV too. The ability to download a spreadsheet is available in other areas of Koha, and it would be nice if it was available in Lists.
Comment 1 Katrin Fischer 2022-02-08 23:28:10 UTC
Hi Esther, have a look at tools > CSV profiles. You can make up your own spreadsheet format to export the cart and lists there.
Comment 2 Esther Melander 2022-04-26 16:45:06 UTC
Katrin, my team looked at the option to create a CSV profile. From what we can tell this would allow us to create a CSV profile that will download a bibliographic record. Our intent is to download a list containing a title, author, and call number, in other words an item oriented list rather than a bibliographic list. I filed bug #30557 explaining the need for an item list.  In a multi-branch installation, individual libraries view and use lists as an item list even though they are not. 

It would be nice to be able to either print or download an item list as a spreadsheet. For multi-branch installations it would be nice to limit the list to a specific library. It is possible to do this through a report but it would be nice if it is available in the list tool.
Comment 3 Katrin Fischer 2022-06-25 16:24:11 UTC
Hi Esther, that clarifies. I have changed the bug description a little to make it clearer. 

The CSV option for a list of records is already there - you'd like an item based list.
Comment 4 Benjamin Daeuber 2022-08-04 15:50:05 UTC
We looked into this as a development a few years ago, but ultimately decided against it since it sounded like it would take a ground up rewrite of the "list" functionality. That said, we are definitely interested in pursuing it if anyone has any ideas. The way I see this is almost like making "lists" an extension of the search function. You could use facets to limit the list, then print or export the items that remain. Staff use lists to identify materials for displays or projects and extending them so you could at least see the items attached would be helpful. Open to any ideas on this point.