[Koha] Export authorized values

Eric Phetteplace ephetteplace at cca.edu
Wed Jul 18 05:23:36 NZST 2018


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 at 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 at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>


More information about the Koha mailing list