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

[Chris Cormack]

* 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: Digital signature
Url : http://lists.katipo.co.nz/pipermail/koha/attachments/20101008/ca1eaf68/attachment-0001.pgp