Importing barrowing information

[Br. Francis Therese Krautter]

Hello,

I am still working on importing data into koha.  We have a rather large database and I am trying to move it over, most of it has moved so far, but one major importation I can't figure out how do is all the currently borrowed books.  I can't find a marc field or a koha variable that looks like it contains this information.  There are over 1000 books currently checked out, I really don't want to have to do it by hand!

-BFT

_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha

[Chris Cormack-6]

2009/11/9 Br. Francis Therese Krautter <br.ftherese@...>:
> Hello,
> I am still working on importing data into koha.  We have a rather large
> database and I am trying to move it over, most of it has moved so far, but
> one major importation I can't figure out how do is all the currently
> borrowed books.  I can't find a marc field or a koha variable that looks
> like it contains this information.  There are over 1000 books currently
> checked out, I really don't want to have to do it by hand!

This is stored in the issues table, not in the MARC.

Chris
_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha

[Agnes Rivers-Moore]

This is a fairly complicated process, it depends how much of the
circulation data you hope to transfer.

You can add some of it to the 952 field in a MARC record - this can
accommodate fields such as $l (letter l) number of times borrowed, and
$q due date of item if currently checked out. If you can tell where this
information resides in your old system, you can write a script to insert
it to the MARC records and them the bulk MARC import process will
include that in the item details.

However this does not tell you who has each item. That would need to be
imported to the issues table, as Chris says, and link to the borrowers
table for the details of the person who has the item. Issues link to the
borrower table through 'borrowernumber' and to the items table through
'itemnumber', and needs data such as branchcode, issuingbranch,
date_due, issuedate, and timestamp.

There is also oldissues, which holds the history of all completed checkouts.

HTH
Agnes


Br. Francis Therese Krautter wrote:

> Hello,
>
> I am still working on importing data into koha.  We have a rather
> large database and I am trying to move it over, most of it has moved
> so far, but one major importation I can't figure out how do is all the
> currently borrowed books.  I can't find a marc field or a koha
> variable that looks like it contains this information.  There are over
> 1000 books currently checked out, I really don't want to have to do it
> by hand!
>
> -BFT
> ------------------------------------------------------------------------
>
> _______________________________________________
> Koha mailing list
> Koha@...
> http://lists.katipo.co.nz/mailman/listinfo/koha
>  
> ------------------------------------------------------------------------
>
> This email was Anti Virus checked by Astaro Security Gateway. http://www.astaro.com

--

Agnes Rivers-Moore
Assistant Librarian
Hanover Public Library

_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha

[Magnus Enger]

2009/11/8 Br. Francis Therese Krautter <br.ftherese@...>:
> Hello,
> I am still working on importing data into koha.  We have a rather large
> database and I am trying to move it over, most of it has moved so far, but
> one major importation I can't figure out how do is all the currently
> borrowed books.  I can't find a marc field or a koha variable that looks
> like it contains this information.  There are over 1000 books currently
> checked out, I really don't want to have to do it by hand!
> -BFT

Hi!

I had this same problem on behalf of a customer recently. What I did
was i massaged the "current loans" (about 12.000 of them) exported
from their old system into the format that the "Offline Circulation
Utility" expects. Then I imported the loans with the "Offline
Circulation File (.koc) Uploader". Have a look at the relevant part of
the manual towards the bottom of this page:
http://koha.org/documentation/manual/3.2/circulation/offline-circulation-utility
Don't worry about installing the actual offline client for now, what
you want to do is just to re-create the format of the file that the
client creates - it's documented here:
http://wiki.koha.org/doku.php?id=koha_offline_circulation_file_format

This approach seems to have worked well, and it means you don't have
to worry about putting all the right things in all the right fields in
all the right tables in the database, as you would if you were going
to create some SQL to import the data...

On the other hand, this approach means you need the barcode of the
patron and the barcode of the book in order to import the loan. In my
case I only had the patronID and the itemID in the file of exported
current loans, so I had to combine data from the MARC-dump (to turn
itemIDs into item barcodes) and the exported list of patrons (to turn
patronIDs into patron barcodes) to get the result I wanted.

Regards,
Magnus Enger
libriotech.no
_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha