[Koha] Export authorized values

Jonathan Druart jonathan.druart at bugs.koha-community.org
Wed Jul 18 06:39:08 NZST 2018


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 at 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 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
> >
> _______________________________________________
> 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