On 4 January 2011 11:24, Paul <paul.a@aandc.org> wrote:
At 09:23 AM 1/4/2011 +1300, you wrote:
On 4 January 2011 09:16, Paul <paul.a@aandc.org> wrote:
Happy new year to all.
Q: How do I edit our "Library Code" (koha-admin / branches / modify library), please? It does not appear in an editable text-box.
[we originally - and erroneously - entered our code with the "Canadian prefix" Ca, as CaOPIACS, and now need only OPIACS.]
Hi Paul
Happy new year, the short answer is, you can't. Not in the web interface. Because to do so means updating a whole pile of things, the borrowers table, items table, accountlines, reserves, the marc in biblioitems etc.
Does it actually matter, the description is displayed in most places ... ?
Chris (and Jane),
Thanks for replying, but not what we are looking for. The main reason to change is that a search at Library and Archives Canada <http://www.collectionscanada.gc.ca/illcandir-bin/illsear/l=0/c=1> relies on "OPIACS" and anyone searching for "CaOPIACS" cannot find us in the ILL system; also OPIACS is our "authority."
What we have done is to set up a second library called OPIACS (totally identical to the first CaOPIACS), but now, despite being prompted to delete the first one, it just will not delete. So the question is - should I just grep CaOPIACS and replace wherever found, or is there a more elegant and reliable (non-gui) method?
Its in the database, so Im not sure how you would grep that. The reason you can't delete it is because it is in use, probably in one of the tables you don't care about below.
We do not care at this point about "borrowers table, items table, accountlines, reserves, etc" because we have reentered all our holdings (with OPIACS as required in the data) in the second (valid) library after purging all biblio and item records in the first, and so far have not entered any patron, budget, etc data -- so there is nothing to lose.
The trick is to find what table has a row (or rows) that reference the old code, update those rows, then you can delete the library code.
I am sure we'll be purging again; we're in "pre-production mode" and refining our MarcEdit templates and mappings, and even 20,000 books only take a couple of minutes to delete and reload (plus zebra cron job.)
If you purge everything thats fine, if all you are doing is purging the bibliographic data, that is going to leave rows in other tables that may reference the old code. Chris