[Koha] delete inventory of one library

Chris Cormack chris at bigballofwax.co.nz
Wed Jan 26 22:48:11 NZDT 2011


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


More information about the Koha mailing list