Re: [Koha] How to import loans data into Koha?

2017-08-15 Thread Mark Alexander
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.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] How to import loans data into Koha?

2017-08-15 Thread Mark Alexander
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
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


[Koha] How to import loans data into Koha?

2017-08-15 Thread Chris Brown
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
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha