[Koha] delete inventory of one library

[Rachel Hollis]

No need to apologize Chris. I do have command line access to the DB. I am a librarian but there are people here that can help me... er, stop me from breaking things. ;-)

Rachel Hollis, librarian

-----Original Message-----
From: Chris Cormack [mailto:chris at bigballofwax.co.nz]
Sent: Wednesday, January 26, 2011 2:48 AM
To: Rachel Hollis
Cc: Koha at lists.katipo.co.nz
Subject: Re: [Koha] delete inventory of one library

On 21 January 2011 11:07, Rachel Hollis
<Rachel.Hollis at stevenshenager.edu> wrote:
> Greetings friends, we have three libraries on our Koha 3.03 and one of them now needs to be removed along with its inventory.
>
> This library shares a Library and Group (Libraries and Groups) as well as Patrons but has 6 separate Item Types and a separate Location (LOC under Authorized Values). The library does not use Acquisitions but does have issuing rules. There are materials currently charged out. (Some data appears to be inconsistent: search results show numbers available and on loan, but detailed biblios show different numbers available or on display.)
>
> We could check in each of the charged items, delete the item records, then delete the biblio. However there are approximately 4900 item records in the inventory. I've also considered migrating the part of the database we'll be keeping to another server. Is there another, better solution?
>
Hi Rachel

Sorry for the late reply, do you have commandline access to the db?

Chris

This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited.