[Koha] Koha - migrating items' circulation history from current ILS

[Linda Culberson]

  Thanks for the advice, Chris!

On 1:59 PM, Chris Cormack wrote:
> * Ian Bays (ian.bays at 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 at 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