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