Thanks for the advice, Chris! On 1:59 PM, Chris Cormack wrote:
* Ian Bays (ian.bays@ptfs-europe.com) wrote:
Hi, There is a table in Koha that holds "old issues" which is very similar to "issues". We have loaded this on some implementations to good effect. The table layout is below and you will have to use sql to load it. Good luck...
Hi
To add to Ian's excellent advice, once you have loaded those in, you will want to update the counts on the item, and also the due date on the items. The count is less important, but it does show on the moredetails page so its good to have, but you do want to know if an item is out or not for the search.
So you can do this one of two ways run some sql like
UPDATE items,issues SET items.onloan = issues.date_due WHERE items.itemnumber = issues.itemnumber;
To update the due dates, and then run misc/maintenance/sync_items_in_marc_bib.pl
Or you can craft a script that does gets the dates, and the issues count for each item, and calls something like this
ModItem({issues => $issue_count->{iscount}, onloan => $issues->{date_due} }, $item->{biblionumber}, $item->{itemnumber});
Chris
-- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand
-- Linda Culberson lculber@mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives& History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Facsimile: 601/576-6824