Any libraries using Kyle Hall's Offline Circulation utility (KOC for short -- cheeky bugger, isn't he?): http://kylehall.info/index.php/projects/koha-tools/koha-offline-circulation/ Tips? Best practices? NEKLS for example does not recommend using the utility for checking in items ("you might miss a held item to be transferred"). Cheers, Cab Vinton, Director Sanbornton Public Library Sanbornton, NH
I know we are, of course, and Geauga County is. However, Biblibre is working on a new offline circ client that is a feature complete replacement for mine that works as a firefox plugin. It's not quite done, but when it is, the workflow will be much improved. Kyle http://www.kylehall.info Information Technology Crawford County Federated Library System ( http://www.ccfls.org ) On Tue, Sep 22, 2009 at 10:06 AM, Cab Vinton <bibliwho@gmail.com> wrote:
Any libraries using Kyle Hall's Offline Circulation utility (KOC for short -- cheeky bugger, isn't he?):
http://kylehall.info/index.php/projects/koha-tools/koha-offline-circulation/
Tips? Best practices?
NEKLS for example does not recommend using the utility for checking in items ("you might miss a held item to be transferred").
Cheers,
Cab Vinton, Director Sanbornton Public Library Sanbornton, NH _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Kyle Hall a écrit :
I know we are, of course, and Geauga County is. However, Biblibre is working on a new offline circ client that is a feature complete replacement for mine that works as a firefox plugin. It's not quite done, but when it is, the workflow will be much improved.
Hello, If anyone want to give a try, it's available here : https://addons.mozilla.org/fr/firefox/addon/14399 This version is just a replacement for Kyle PHP client part, just upload the .koc file on ~/Desktop on koha (no changes on server side) We did not tried it on a production site yet, so, try with care ! but we would be happy to have feedback. There is an RFC for improvement here : http://wiki.koha.org/doku.php?id=offline_circulation_firefox_plugin -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08
There is some documentation on this here: http://koha.org/documentation/manual/3.2/circulation/offline-circulation-uti... I'll gladly add additional tips :) Nicole On Tue, Sep 22, 2009 at 10:06 AM, Cab Vinton <bibliwho@gmail.com> wrote:
Any libraries using Kyle Hall's Offline Circulation utility (KOC for short -- cheeky bugger, isn't he?):
http://kylehall.info/index.php/projects/koha-tools/koha-offline-circulation/
Tips? Best practices?
NEKLS for example does not recommend using the utility for checking in items ("you might miss a held item to be transferred").
Cheers,
Cab Vinton, Director Sanbornton Public Library Sanbornton, NH _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Thank you, Kyle & Nicole. As a hosted library, we would have to ask LL to run the create_koc_db cronjob. Would it be possible to run a SQL report instead to create the required patron data file? Cab Vinton, Director Sanbornton Public Library Sanbornton, NH
Not at this time. I see no reason why there could not be a 'Download Offline Circ Borrowers File' page in Koha that would generate it on the fly. Of course, that would still require LL to implement it. If you can get a copy of your database sql, you could create your own local mysql database and run the script on that with minor modifications. Let me know and I'll help you out. There is another option: Download these queries as CSV files: SELECT borrowernumber, cardnumber, surname, firstname, address, city, phone, dateofbirth, sum( accountlines.amountoutstanding ) as total_fines FROM borrowers LEFT JOIN accountlines USING (borrowernumber) GROUP BY borrowernumber; SELECT issues.borrowernumber, issues.date_due, items.itemcallnumber, biblio.title, biblioitems.itemtype FROM issues, items, biblioitems, biblio WHERE issues.itemnumber = items.itemnumber AND items.biblionumber = biblioitems.biblionumber AND items.biblionumber = biblio.biblionumber AND returndate IS NULL Now you can use an sqlite tool to convert those csv files into sqlite v2 databases. The former is name 'borrowers', the latter is 'issues' This may help get you started: http://www.indigorose.com/forums/showthread.php?t=10497 Kyle http://www.kylehall.info Information Technology Crawford County Federated Library System ( http://www.ccfls.org ) On Tue, Sep 22, 2009 at 10:25 AM, Cab Vinton <bibliwho@gmail.com> wrote:
Thank you, Kyle & Nicole.
As a hosted library, we would have to ask LL to run the create_koc_db cronjob.
Would it be possible to run a SQL report instead to create the required patron data file?
Cab Vinton, Director Sanbornton Public Library Sanbornton, NH _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
participants (4)
-
Cab Vinton -
Kyle Hall -
Nicole Engard -
paul POULAIN