Migrate checkouts with koc file
Good morning, I would like to migrate check-outs from Millennium to Koha. It just occurred to me I could probably do this with offline circulation. I'm writing to ask for help creating a properly formatted .koc file that I can upload. From the web, I've gleaned this is just a delimited text file with a special header and a .koc extension. I am not permitted to install the Firefox or Windows utilities for offline circ in order to try to generate an example .koc file. I see a little info the .koc file in the Wiki, but I'm not sure if it is current and comprehensive. In this 2019 blog, http://kohageek.blogspot.com/2019/09/importing-of-check-out-entries.html, I found a link to a template for the .koc file, but it's in Google Drive, where I also don't have permission to download from. In short, is there a way to make my own .koc file from scratch by supplying the extension, necessary columns, and required header? Thanks for your time, Tasha Bales Enterprise Services http://isesi.web.boeing.com/ Library Services Catalog upgrade is coming! For the latest news and FAQ regarding the upgrade, see Library Announcements<http://library.web.boeing.com/help/announcements.html>. Questions? Please contact library@boeing.com<mailto:library@boeing.com>.
Hi Tasha By curiosity I checked the master.koc referred and the only content on it is this three tab separated values: Version=1.0 Generator=koct-firefox GeneratorVersion=0.1 Hope helps Regards, Alvaro |----------------------------------------------------------------------------------------| Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le ven. 10 déc. 2021 à 12:47, Bales (US), Tasha R <tasha.r.bales@boeing.com> a écrit :
Good morning,
I would like to migrate check-outs from Millennium to Koha. It just occurred to me I could probably do this with offline circulation. I'm writing to ask for help creating a properly formatted .koc file that I can upload. From the web, I've gleaned this is just a delimited text file with a special header and a .koc extension.
I am not permitted to install the Firefox or Windows utilities for offline circ in order to try to generate an example .koc file. I see a little info the .koc file in the Wiki, but I'm not sure if it is current and comprehensive. In this 2019 blog, http://kohageek.blogspot.com/2019/09/importing-of-check-out-entries.html, I found a link to a template for the .koc file, but it's in Google Drive, where I also don't have permission to download from.
In short, is there a way to make my own .koc file from scratch by supplying the extension, necessary columns, and required header? Thanks for your time,
Tasha Bales Enterprise Services http://isesi.web.boeing.com/
Library Services Catalog upgrade is coming! For the latest news and FAQ regarding the upgrade, see Library Announcements<http://library.web.boeing.com/help/announcements.html>. Questions? Please contact library@boeing.com<mailto:library@boeing.com>.
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Tasha, the format should still work as described on the wiki: https://wiki.koha-community.org/wiki/Koha_offline_circulation_file_format It really is just a text file with a specific header, as you say. An advantage for migrations is that it works with cardnumbers and barcodes, a disadvantage is that you can't set the due dates. They will be calculated from the circulation rules when the transactions are uploaded to Koha. Hope this helps, Katrin On 10.12.21 19:32, Alvaro Cornejo wrote:
Hi Tasha
By curiosity I checked the master.koc referred and the only content on it is this three tab separated values:
Version=1.0 Generator=koct-firefox GeneratorVersion=0.1 Hope helps
Regards,
Alvaro
|----------------------------------------------------------------------------------------| Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire
Le ven. 10 déc. 2021 à 12:47, Bales (US), Tasha R <tasha.r.bales@boeing.com> a écrit :
Good morning,
I would like to migrate check-outs from Millennium to Koha. It just occurred to me I could probably do this with offline circulation. I'm writing to ask for help creating a properly formatted .koc file that I can upload. From the web, I've gleaned this is just a delimited text file with a special header and a .koc extension.
I am not permitted to install the Firefox or Windows utilities for offline circ in order to try to generate an example .koc file. I see a little info the .koc file in the Wiki, but I'm not sure if it is current and comprehensive. In this 2019 blog, http://kohageek.blogspot.com/2019/09/importing-of-check-out-entries.html, I found a link to a template for the .koc file, but it's in Google Drive, where I also don't have permission to download from.
In short, is there a way to make my own .koc file from scratch by supplying the extension, necessary columns, and required header? Thanks for your time,
Tasha Bales Enterprise Services http://isesi.web.boeing.com/
Library Services Catalog upgrade is coming! For the latest news and FAQ regarding the upgrade, see Library Announcements<http://library.web.boeing.com/help/announcements.html>. Questions? Please contact library@boeing.com<mailto:library@boeing.com>.
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Awesome, thank you! I was overthinking as usual. I only have one server right now and was afraid I might break something terribly if I winged it. Tasha Bales Enterprise Services http://isesi.web.boeing.com/ From: Alvaro Cornejo [mailto:cornejo.alvaro@gmail.com] Sent: Friday, December 10, 2021 11:32 To: Bales (US), Tasha R <tasha.r.bales@boeing.com> Cc: koha@lists.katipo.co.nz Subject: [EXTERNAL] Re: [Koha] Migrate checkouts with koc file Importance: High EXT email: be mindful of links/attachments. Hi Tasha By curiosity I checked the master.koc referred and the only content on it is this three tab separated values: Version=1.0 Generator=koct-firefox GeneratorVersion=0.1 Hope helps Regards, Alvaro |----------------------------------------------------------------------------------------| [https://drive.google.com/uc?id=1lpgSKUunPpKrvmS1rja7umnEgiqBa_vD&export=download] Stay safe / Cuídate/ Reste sécurisé 7 Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. q Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le ven. 10 déc. 2021 à 12:47, Bales (US), Tasha R <tasha.r.bales@boeing.com<mailto:tasha.r.bales@boeing.com>> a écrit : Good morning, I would like to migrate check-outs from Millennium to Koha. It just occurred to me I could probably do this with offline circulation. I'm writing to ask for help creating a properly formatted .koc file that I can upload. From the web, I've gleaned this is just a delimited text file with a special header and a .koc extension. I am not permitted to install the Firefox or Windows utilities for offline circ in order to try to generate an example .koc file. I see a little info the .koc file in the Wiki, but I'm not sure if it is current and comprehensive. In this 2019 blog, http://kohageek.blogspot.com/2019/09/importing-of-check-out-entries.html, I found a link to a template for the .koc file, but it's in Google Drive, where I also don't have permission to download from. In short, is there a way to make my own .koc file from scratch by supplying the extension, necessary columns, and required header? Thanks for your time, Tasha Bales Enterprise Services http://isesi.web.boeing.com/ Library Services Catalog upgrade is coming! For the latest news and FAQ regarding the upgrade, see Library Announcements<http://library.web.boeing.com/help/announcements.html>. Questions? Please contact library@boeing.com<mailto:library@boeing.com><mailto:library@boeing.com<mailto:library@boeing.com>>. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Excerpts from Bales (US), Tasha R's message of 2021-12-10 17:46:06 +0000:
In short, is there a way to make my own .koc file from scratch by supplying the extension, necessary columns, and required header? Thanks for your time,
Yes, you can do this. I did this as part of a migration from Mandarin to Koha. I wrote a Ruby script that parsed a Mandarin report for "loan list by patrons", and massaged it into a .koc file. This probably won't help, but just in case, that script and a few others I had to write to do the migration are here: https://gitlab.com/bloovis/marc -- Surely I deserve some kind of recognition for all the bad things I haven't done. --Ashleigh Brilliant
participants (4)
-
Alvaro Cornejo -
Bales (US), Tasha R -
Katrin Fischer -
Mark Alexander