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

[Ian Bays]

  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...

mysql> desc old_issues;
+-----------------+-------------+------+-----+-------------------+-------+
| Field           | Type        | Null | Key | Default           | Extra |
+-----------------+-------------+------+-----+-------------------+-------+
| borrowernumber  | int(11)     | YES  | MUL | NULL              |       |
| itemnumber      | int(11)     | YES  | MUL | NULL              |       |
| date_due        | date        | YES  |     | NULL              |       |
| branchcode      | varchar(10) | YES  |     | NULL              |       |
| issuingbranch   | varchar(18) | YES  |     | NULL              |       |
| returndate      | date        | YES  |     | NULL              |       |
| lastreneweddate | date        | YES  |     | NULL              |       |
| return          | varchar(4)  | YES  |     | NULL              |       |
| renewals        | tinyint(4)  | YES  |     | NULL              |       |
| timestamp       | timestamp   | NO   |     | CURRENT_TIMESTAMP |       |
| issuedate       | date        | YES  |     | NULL              |       |
+-----------------+-------------+------+-----+-------------------+-------+
11 rows in set (0.00 sec)

mysql> desc issues;
+-----------------+-------------+------+-----+-------------------+-------+
| Field           | Type        | Null | Key | Default           | Extra |
+-----------------+-------------+------+-----+-------------------+-------+
| borrowernumber  | int(11)     | YES  | MUL | NULL              |       |
| itemnumber      | int(11)     | YES  | MUL | NULL              |       |
| date_due        | date        | YES  |     | NULL              |       |
| branchcode      | varchar(10) | YES  |     | NULL              |       |
| issuingbranch   | varchar(18) | YES  |     | NULL              |       |
| returndate      | date        | YES  |     | NULL              |       |
| lastreneweddate | date        | YES  |     | NULL              |       |
| return          | varchar(4)  | YES  |     | NULL              |       |
| renewals        | tinyint(4)  | YES  |     | NULL              |       |
| timestamp       | timestamp   | NO   |     | CURRENT_TIMESTAMP |       |
| issuedate       | date        | YES  |     | NULL              |       |
+-----------------+-------------+------+-----+-------------------+-------+
11 rows in set (0.00 sec)


On 07/10/2010 19:03, Linda Culberson wrote:
>    Is there documentation and/or methodology of migrating the circulation
> history of items from our current ILS into Koha? I know there is a field
> for how many times an item has been checked out, and I know there is
> offline circulation, but what I'm unclear about whether it is the best
> method to use to migrate our current circulation history  information
> into Koha. Thanks in advance.
>


-- 
Ian Bays
Director of Projects
PTFS Europe.com
mobile: +44 (0) 7774995297
phone: +44 (0) 800 756 6803
skype: ian.bays
email: ian.bays at ptfs-europe.com