Export authorized values
(Using Koha 17.11) As I can do with "MARC frameworks", I want to make a backup of "Authorized values". How can I do? Thank you.
Hi Narcis, I don't think that there's a function to export the authorized values, at least not on the staff side of the catalog. You could always write a report that pulls all the data and then save it as a CSV. This is the minimal SQL needed to do so: SELECT * FROM authorised_values ORDER BY category That'll pull everything and kind of sort it into groups based on which value category the data belongs to. Best, ERIC PHETTEPLACE Systems Librarian libraries.cca.edu | vault.cca.edu | 510.594.3660 5212 Broadway, Oakland, CA 94618 1111 8th St., San Francisco, CA 94107 Preferred Pronoun(s): he/him :(){ :|: & };: On Tue, Jul 17, 2018 at 7:36 AM Narcis Garcia <informatica@actiu.net> wrote:
(Using Koha 17.11) As I can do with "MARC frameworks", I want to make a backup of "Authorized values".
How can I do?
Thank you. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
There are also authorised_value_categories (for the categories) and authorised_values_branches (for the branch limitations). *Bug 10198* - Add the ability to import and export authorized values (there is not patch here) On Tue, 17 Jul 2018 at 14:23 Eric Phetteplace <ephetteplace@cca.edu> wrote:
Hi Narcis,
I don't think that there's a function to export the authorized values, at least not on the staff side of the catalog. You could always write a report that pulls all the data and then save it as a CSV. This is the minimal SQL needed to do so:
SELECT * FROM authorised_values ORDER BY category
That'll pull everything and kind of sort it into groups based on which value category the data belongs to.
Best,
ERIC PHETTEPLACE
Systems Librarian
libraries.cca.edu | vault.cca.edu | 510.594.3660
5212 Broadway, Oakland, CA 94618 <https://maps.google.com/?q=5212+Broadway,+Oakland,+CA+94618&entry=gmail&source=g>
1111 8th St., San Francisco, CA 94107 <https://maps.google.com/?q=1111+8th+St.,+San+Francisco,+CA+94107&entry=gmail&source=g>
Preferred Pronoun(s): he/him
:(){ :|: & };:
On Tue, Jul 17, 2018 at 7:36 AM Narcis Garcia <informatica@actiu.net> wrote:
(Using Koha 17.11) As I can do with "MARC frameworks", I want to make a backup of "Authorized values".
How can I do?
Thank you. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Thanks; next step will be the import. I commented the bug #10198 El 17/07/18 a les 19:23, Eric Phetteplace ha escrit:
Hi Narcis,
I don't think that there's a function to export the authorized values, at least not on the staff side of the catalog. You could always write a report that pulls all the data and then save it as a CSV. This is the minimal SQL needed to do so:
SELECT * FROM authorised_values ORDER BY category
That'll pull everything and kind of sort it into groups based on which value category the data belongs to.
Best,
ERIC PHETTEPLACE
Systems Librarian
libraries.cca.edu <http://libraries.cca.edu> | vault.cca.edu <http://vault.cca.edu> | 510.594.3660
5212 Broadway, Oakland, CA 94618
1111 8th St., San Francisco, CA 94107
Preferred Pronoun(s): he/him
:(){ :|: & };:
On Tue, Jul 17, 2018 at 7:36 AM Narcis Garcia <informatica@actiu.net <mailto:informatica@actiu.net>> wrote:
(Using Koha 17.11) As I can do with "MARC frameworks", I want to make a backup of "Authorized values".
How can I do?
Thank you. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> https://lists.katipo.co.nz/mailman/listinfo/koha
participants (3)
-
Eric Phetteplace -
Jonathan Druart -
Narcis Garcia