How to import loans data into Koha?
Gentle Reader, We are migrating records from a few small community libraries (currently held as a fancy spreadsheet) into Koha 17.05. I have figured out how to migrate the biblio records, items and patron data but I was wondering if there is a way to import data on current issues (loans)? All we really need to import is the item ID, the patron ID and the due-back date. Is there a tool to do this? Or is it a question of populating the issues table directly? If so, does anyone have a script to do this? Any pointers gratefully received ... Chris Brown
Excerpts from Chris Brown's message of 2017-08-15 21:06:52 +0100:
We are migrating records from a few small community libraries (currently held as a fancy spreadsheet) into Koha 17.05. I have figured out how to migrate the biblio records, items and patron data but I was wondering if there is a way to import data on current issues (loans)? All we really need to import is the item ID, the patron ID and the due-back date.
I did this by writing a script to convert the loan list generated by our our old library system (Mandarin) into a KOC file (Koha Offline Circulation File), and then importing that. The KOC file format is defined here: https://wiki.koha-community.org/wiki/Koha_offline_circulation_file_format
Excerpts from Mark Alexander's message of 2017-08-15 19:03:46 -0400:
Excerpts from Chris Brown's message of 2017-08-15 21:06:52 +0100:
[...] but I was wondering if there is a way to import data on current issues (loans)? All we really need to import is the item ID, the patron ID and the due-back date.
I did this by writing a script to convert the loan list generated by our our old library system (Mandarin) into a KOC file (Koha Offline Circulation File), and then importing that. [...]
I forgot to mention that each row in the the KOC file has a date, but it is the issue date, not the due-back date. When Koha imports the file, it will calculate the due-back dates using the circulation rules that you should have already defined.
participants (2)
-
Chris Brown -
Mark Alexander