Hi Paul,<br><br><div class="gmail_quote">On Wed, Mar 30, 2011 at 7:11 PM, Paul <span dir="ltr"><<a href="mailto:paul.a@aandc.org">paul.a@aandc.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
At 12:38 PM 11/26/2010 -0500, Jared Camins-Esakov wrote:<br>
>Is there a way to do a bulk import of "authorized values"? Â I have not been<br>
<div class="im">>able to find KOHA user interface support for this.<br>
><br>
</div><div class="im">>INSERT INTO authorised_values (category, authorised_value, lib) VALUES<br>
>('LOC', 'MILITARY', 'Military'), ('LOC', 'ANOTHER', 'Another location...');<br>
<br>
</div>Before I start adding more "Authorized values" to a near-production Koha<br>
db,<br></blockquote></div><br>I'll let others answer the other questions, however, I trust that before you add, subtract, do-any-sort-of-foo to your near-production DB, you make a quick backup of it using mysqldump.... Then you can try all sorts of things w/out worry.<br>
<br>Better yet, setup a cron job to run a dump at regular intervals so you can "roll back" if need be.<br><br>Kind Regards,<br>Chris<br>