Our little (24K items) library has successfully moved from Mandarin to Koha as of Tuesday. I was able to import the catalog, patrons, and checkouts (issues) from Mandarin by writing scripts to convert Mandarin-generated data to Koha-compatible data. The one missing thing is holds (reserves). I'm still looking for a way to generate a holds report in Mandarin, but assuming I can generate such a report, I don't see a way to import hold information into Koha. I was able to use KOC files to import issues, but the KOC file format doesn't support holds. I was wondering if there is some other way to import holds programmatically, or if anyone else has had to deal with this problem when migrating to Koha.
Hi Mark, holds information is stored differently in every ILS and at the moment there exists no generic tool to import holds into Koha. For a migration you could try to map the data you get out of Mandarin to the columns in Koha's reserves table and then use a script or SQL to fill it. It can be useful to place a few different holds in Koha first to see what data is required/set by Koha itself. Hope this helps, Katrin On 11.08.2017 16:23, Mark Alexander wrote:
Our little (24K items) library has successfully moved from Mandarin to Koha as of Tuesday. I was able to import the catalog, patrons, and checkouts (issues) from Mandarin by writing scripts to convert Mandarin-generated data to Koha-compatible data.
The one missing thing is holds (reserves). I'm still looking for a way to generate a holds report in Mandarin, but assuming I can generate such a report, I don't see a way to import hold information into Koha. I was able to use KOC files to import issues, but the KOC file format doesn't support holds. I was wondering if there is some other way to import holds programmatically, or if anyone else has had to deal with this problem when migrating to Koha. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Excerpts from Katrin Fischer's message of 2017-08-15 12:47:45 +0200:
holds information is stored differently in every ILS and at the moment there exists no generic tool to import holds into Koha. For a migration you could try to map the data you get out of Mandarin to the columns in Koha's reserves table and then use a script or SQL to fill it. It can be useful to place a few different holds in Koha first to see what data is required/set by Koha itself.
Thank you. That makes sense, and I was already thinking of doing something like this. But there aren't a large number of holds, and it might be less time-consuming to enter them manually than to study the database tables and write the script.
If you don't have a lot of holds reentering might be the best solution. Hope your migration goes well! Katrin On 15.08.2017 14:55, Mark Alexander wrote:
Excerpts from Katrin Fischer's message of 2017-08-15 12:47:45 +0200:
holds information is stored differently in every ILS and at the moment there exists no generic tool to import holds into Koha. For a migration you could try to map the data you get out of Mandarin to the columns in Koha's reserves table and then use a script or SQL to fill it. It can be useful to place a few different holds in Koha first to see what data is required/set by Koha itself. Thank you. That makes sense, and I was already thinking of doing something like this. But there aren't a large number of holds, and it might be less time-consuming to enter them manually than to study the database tables and write the script.
Just to add a +1 to your idea of doing it manually if you don't have many. Not only do you need to construct the holds but get them in the right order and handle copies that have been chosen to satisfy a hold but not picked up. On 15/08/2017 13:55, Mark Alexander wrote:
Excerpts from Katrin Fischer's message of 2017-08-15 12:47:45 +0200:
holds information is stored differently in every ILS and at the moment there exists no generic tool to import holds into Koha. For a migration you could try to map the data you get out of Mandarin to the columns in Koha's reserves table and then use a script or SQL to fill it. It can be useful to place a few different holds in Koha first to see what data is required/set by Koha itself. Thank you. That makes sense, and I was already thinking of doing something like this. But there aren't a large number of holds, and it might be less time-consuming to enter them manually than to study the database tables and write the script.
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
--- This email has been checked for viruses by AVG. http://www.avg.com
-- Ian Bays Director of Projects, PTFS Europe Limited Content Management and Library Solutions
participants (3)
-
Ian Bays -
Katrin Fischer -
Mark Alexander