Peter,<div><br><div><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Is there a way to do a bulk import of "authorized values"? I have not been<br>
able to find KOHA user interface support for this.<br></blockquote><div><br></div><div>"Koha" is not an acronym, so it need not be entirely capitalized. The name comes from a Maori tradition. See <a href="http://en.wikipedia.org/wiki/Koha_(custom)">http://en.wikipedia.org/wiki/Koha_(custom)</a></div>
<div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
If there is no user interface support for this, then can I *safely* add new<br>
authorised values to the SQL authorised_values table directly?<br></blockquote><div><br></div><div>Absolutely. This is how we populated our database with authorised values for our locations.</div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
I am wondering if I can do something like this:<br>
<br>
In MYSQL, to add a new "MILITARY" authorised value to LOC:<br>
1. SELECT * from authorised_values;<br>
And determine the next 'id' available, call it <id> in what follows.<br>
2. INSERT INTO authorised_values<br>
VALUES (<id>, 'LOC', 'military', 'MILITARY', NULL);<br></blockquote><div><br></div><div>Skip step 1. id will automatically be incremented. Use a query like the following:</div><div><br>INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC', 'MILITARY', 'Military'), ('LOC', 'ANOTHER', 'Another location...');</div>
</div><div><br></div>Regards,</div><div>Jared Camins-Esakov</div><div><br>-- <br>Jared Camins-Esakov<div>Freelance bibliographer, C & P Bibliography Services, LLC</div><div>(phone) +1 (917) 727-3445</div><div>(e-mail) <a href="mailto:jcamins@cpbibliography.com" target="_blank">jcamins@cpbibliography.com</a></div>
<div>(web) <a href="http://www.cpbibliography.com/" target="_blank">http://www.cpbibliography.com/</a></div><br>
</div></div>