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
2009/11/9 Br. Francis Therese Krautter <br.ftherese@gmail.com>:
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
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@lists.katipo.co.nz 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
2009/11/8 Br. Francis Therese Krautter <br.ftherese@gmail.com>:
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-uti... 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
participants (4)
-
Agnes Rivers-Moore -
Br. Francis Therese Krautter -
Chris Cormack -
Magnus Enger