- Koha - lists.katipo.co.nz

Help, Web Installer
by Arshad Iqbal 09 Mar '16

09 Mar '16

Hi On the 3rd step of koha web installer i am facing this error please help me. Can't use an undefined value as an ARRAY reference at /usr/lib/i386-linux-gnu/perl5/5.20/DBI.pm line 2064. Muhammad Arshad Iqbal

1 0

General IRC meeting 9 March 2016 at 20:00 UTC
by Brendan Gallagher 08 Mar '16

08 Mar '16

Hello - Just a reminder that there is a General IRC Meeting tomorrow. Here is the link to the agenda. https://wiki.koha-community.org/wiki/General_IRC_meeting_9_March_2016 You'll also find a time converter in the wiki link so you can adjust to your local time. Thanks, Brendan -- --------------------------------------------------------------------------------------------------------------- Brendan A. Gallagher ByWater Solutions CEO

1 0

opac reading history
by Celtic Studies Library 08 Mar '16

08 Mar '16

Hi We are unable to see parton's reading history. We can only see what they currently have on loan. opac privacy and opac reading history are set to ALLOW. Is there something we are missing? Many thanks Margaret -- School of Celtic Studies Dublin Institute for Advanced Studies 10 Burlington Road Dublin 4 +353 1 6140182 www.celt.dias.ie/library @SCSLIbrary

2 1

Notes on Self Checkout
by Aparrish 08 Mar '16

08 Mar '16

Hello all, Offering some hopefully constructive criticism of the self-checkout module et cetera. Details: I've just finished upgrading to Koha 3.22.04, with Perl 5.02. The following are enabled: AllowSelfCheckReturns AutoSelfCheckAllowed AutoSelfCheckID AutoSelfCheckPass (with the info of a staff user who had first circulate, and later superlibrarian permissions) WebBasedSelfCheck 1. First off, the information in the Koha manual in section 5.12 has been unchanged since version 3.8. I believe the code snippet that's meant to be pasted into IntranetUserJS is incorrectly formatted. I can't get it to work, after having removed the line breaks and fiddling with various things. To access the SCO, therefore, I've used a plain HTML hyperlink which is inserted in "opacheader". This works fine. 2. It turns out that users must be assigned a card number in order to use either the barcode OR the username/password logins to the SCO. This was probably a dumb error on my part, but it's not a totally obvious dependency either as far as the u/p login is concerned. Anyway, after that the SCO allows a patron with no permissions to log in, either with barcode or with u/p, and check out books by barcode. The SCO correctly displays a blue message with the right username. 3. In 3.22 the bug where one would return to opac-main logged in as the checkout staff user has been fixed; however it now redirects to a log-in screen rather than the catalog main page, which I don't really like. I'll toy with this. The most seamless Apple Inc. solution would be to return someone to the main screen still logged into their patron account, but perhaps the recent SCO bugfixes have ruled this out. 4. In the SCO files by default the "koha" header in the top left corner is pointed to /opac/sco/sco-main.pl. This is useless. I fix this by editing /usr/share/koha/opac/htdocs/opac-tmpl/bootstrap/en/includes/masthead-sco.inc, and replacing the link in line 7 with /cgi-bin/koha/opac-main.pl so that someone can click "Koha" to escape the SCO. This seems much more intuitive to me. (Adding a "home" link would serve the same purpose, but this is easier.) 5. Very ambitious - I would really like the capacity to dump the contents of the cart into the self-checkout so that it is a one-click process (barring the login), but I think I lack the programming knowledge for this. Some sort of simple script which saved the contents of the cart and then injected barcodes one by one into the self-checkout, automatically, is what I'm envisioning. Most of the parts required seem to be already there. I will experiment and probably open this as its own question at some later point. Any pro bono contribution to this would be very much appreciated. At this point the only actual PROBLEM is that SCO users are unable to return books through the SCO. I click the return button on an active checkout and nothing happens - the page reloads and the item is still checked-out. It seems like all the right preferences are on. If I figure this out I'll post; if anyone else has resolved please let me know. Thanks, Andrew -- View this message in context: http://koha.1045719.n5.nabble.com/Notes-on-Self-Checkout-tp5877806.html Sent from the Koha-general mailing list archive at Nabble.com.

1 2

Problem with Check expiration in Serials
by Elaine Bradtke 08 Mar '16

08 Mar '16

We're running 3.20.7 and just getting around to testing out some of the features in the Serials module. We set up a dummy record to try things like notices, etc. and when I clicked on Check Expiration all I got was an error message. Any idea what the following means? I get the gist of it - something's missing somewhere. I can't find any system preferences that look remotely like they might address this. There really is only one 'branch' in our system. Global symbol "$branch" requires explicit package name at /home/koha/koha-test/intranet/cgi-bin/serials/checkexpiration.pl line 84. Global symbol "$branch" requires explicit package name at /home/koha/koha-test/intranet/cgi-bin/serials/checkexpiration.pl line 84. Execution of /home/koha/koha-test/intranet/cgi-bin/serials/ checkexpiration.pl aborted due to compilation errors. -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)

4 4

Re: [Koha] Notes on Self Checkout
by BRANNON, CHRISTOPHER 08 Mar '16

08 Mar '16

Regarding 5 - Why would anyone checkout items they don't have in their hands? Checking out from the cart seems like a good way to confuse everyone if the item can't be found. ___________________________ Christopher Brannon IT Coordinator 702 E Front Ave Coeur d'Alene, ID 83814 (208)769-2315 Ext. 456 cbrannon(a)cdalibrary.org www.cdalibrary.org Keep tabs on us at: Date: Tue, 8 Mar 2016 09:26:04 -0700 (MST) From: Aparrish <cspsyntech(a)gmail.com> To: koha(a)lists.katipo.co.nz Subject: [Koha] Notes on Self Checkout Message-ID: <1457454364078-5877806.post(a)n5.nabble.com> Content-Type: text/plain; charset=us-ascii Hello all, Offering some hopefully constructive criticism of the self-checkout module et cetera. Details: I've just finished upgrading to Koha 3.22.04, with Perl 5.02. The following are enabled: AllowSelfCheckReturns AutoSelfCheckAllowed AutoSelfCheckID AutoSelfCheckPass (with the info of a staff user who had first circulate, and later superlibrarian permissions) WebBasedSelfCheck 1. First off, the information in the Koha manual in section 5.12 has been unchanged since version 3.8. I believe the code snippet that's meant to be pasted into IntranetUserJS is incorrectly formatted. I can't get it to work, after having removed the line breaks and fiddling with various things. To access the SCO, therefore, I've used a plain HTML hyperlink which is inserted in "opacheader". This works fine. 2. It turns out that users must be assigned a card number in order to use either the barcode OR the username/password logins to the SCO. This was probably a dumb error on my part, but it's not a totally obvious dependency either as far as the u/p login is concerned. Anyway, after that the SCO allows a patron with no permissions to log in, either with barcode or with u/p, and check out books by barcode. The SCO correctly displays a blue message with the right username. 3. In 3.22 the bug where one would return to opac-main logged in as the checkout staff user has been fixed; however it now redirects to a log-in screen rather than the catalog main page, which I don't really like. I'll toy with this. The most seamless Apple Inc. solution would be to return someone to the main screen still logged into their patron account, but perhaps the recent SCO bugfixes have ruled this out. 4. In the SCO files by default the "koha" header in the top left corner is pointed to /opac/sco/sco-main.pl. This is useless. I fix this by editing /usr/share/koha/opac/htdocs/opac-tmpl/bootstrap/en/includes/masthead-sco.inc, and replacing the link in line 7 with /cgi-bin/koha/opac-main.pl so that someone can click "Koha" to escape the SCO. This seems much more intuitive to me. (Adding a "home" link would serve the same purpose, but this is easier.) 5. Very ambitious - I would really like the capacity to dump the contents of the cart into the self-checkout so that it is a one-click process (barring the login), but I think I lack the programming knowledge for this. Some sort of simple script which saved the contents of the cart and then injected barcodes one by one into the self-checkout, automatically, is what I'm envisioning. Most of the parts required seem to be already there. I will experiment and probably open this as its own question at some later point. Any pro bono contribution to this would be very much appreciated. At this point the only actual PROBLEM is that SCO users are unable to return books through the SCO. I click the return button on an active checkout and nothing happens - the page reloads and the item is still checked-out. It seems like all the right preferences are on. If I figure this out I'll post; if anyone else has resolved please let me know. Thanks, Andrew -- View this message in context: http://koha.1045719.n5.nabble.com/Notes-on-Self-Checkout-tp5877806.html Sent from the Koha-general mailing list archive at Nabble.com. ------------------------------ Subject: Digest Footer _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ End of Koha Digest, Vol 125, Issue 14 *************************************

2 1

Tracking staff login/logout
by Bob Ewart 08 Mar '16

08 Mar '16

Is there a way to log staff (intranet) logins and logouts? We would like to have a report monthly of who and how long each staff member was logged in to Koha. -- Bob Ewart Stonewall National Museum & Archives

1 0

How to leave null value in SQL Report
by Vimal Kumar V. 08 Mar '16

08 Mar '16

Dear Friends, Here is a report which list books with accompanying materials (field 300$e). How can I leave null values in 300$e and list only exact values? SELECT ExtractValue(marcxml,'//datafield[@tag="300"]/subfield[@code="e"]') AS AccoMaterial, DATE_FORMAT(items.dateaccessioned, "%d %b %Y %h:%i %p") AS Date_accessioned,items.barcode,items.itemcallnumber,biblioitems.isbn,biblio.author,biblio.title,ExtractValue(marcxml,'//datafield[@tag="654"]/subfield[@code="a"]') AS SUBJECT,biblioitems.pages,biblioitems.publishercode,biblioitems.place,biblio.copyrightdate FROM items LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) WHERE items.homebranch=<<Home branch|branches>> AND biblioitems.itemtype = <<Item Type|itemtypes>> ORDER BY items.barcode ASC Regards, -- Vimal Kumar V. Technical Assistant Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.info Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in http://moovandan.blogspot.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

2 1

Package for 3.20.9 now available
by Galen Charlton 08 Mar '16

08 Mar '16

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Hi, The package for 3.20.9 is now available from the Koha APT repository debian.koha-community.org. As always, instructions for installing from the packages can be found at https://wiki.koha-community.org/wiki/Debian Regards, Galen - -- Galen Charlton gmcharlt(a)gmail.com -----BEGIN PGP SIGNATURE----- Version: Mailvelope v1.3.6 Comment: https://www.mailvelope.com wsFcBAEBCAAQBQJW3hydCRATSna3Q9mGMAAAGQAQAIF0TM6dRze87UylWQUM pDWnBoLh4rxRYlkpLon24neMfu+5ig3ixdKgXmHO1AVgknrrZhEyJqMFc92Z YEbJFawwnKUVRRjdoaDrC9uxKeok2ATRd/E3kwPHTXDtdC+mLJ4I8MVC4mlq sIvQEv1pbbIpCNOK60eODkXTLKeDmsVDH3e74JE8Eq2G8BeLBHj89Bgi3WIf 2P2kb6cHw4//v9I0UWOiH8IEkNB1EQDzfY9wODmHyd/yM4C98Ni8rQJpmmeY 95eo2N2tsrLB9o3Oqxnqt14T9Nu5qrxUGUsIhV9SsH+Zx1VGsIPblV5OTjvX yC8y6l0hh71bhmLL15skZzEEyfTQQ/o4FGKNNbkdeuRAE/cGqk9nL+4bFiDd /cUA56aigYQ34XuqDv84m8CGgnaKKxgAVMoyREaYIdMspDNmzJ/RZ3AYkqqm XSJX1OqU8x1nG5eqiviv7iBO/Hixax+qe1Se1NViYuoH8e5olC8XbejNycbi IejORQaFbf5WZzEdta6mqBJYUZB4Qb3KkdBdxfkdzqa1tjtc9c1lH85uksey OaDbyyAAVjpwcaY7S3xbF4KDXhHeD/gh4jhiAKH6mdaxuOc53cJ6HikpMa3V vrQ/B167P2vnf6lALKDw9v1ZYxpyWu2QESGuv8krGkOFkmhQgYEaT/rtL3F7 9R5t =R8MH -----END PGP SIGNATURE-----

1 0

Announcement of Koha-US March 2016 meeting
by Christopher Davis 07 Mar '16

07 Mar '16

Dear Colleagues, I would like to announce that the March 2016 meeting of the Koha-US users' group is scheduled for 11:00 am Central Time on Wednesday, the 9th. Please join our meeting by visiting <https://kslib.zoom.us/j/657929919>. The agenda for this meeting includes a report on NEKLS' upgrade to Koha 3.22 and a status report on the planning for the 2016 annual Koha-US meeting (in Monterey, California). Also, the meeting participants will vote on which logo the group will use. As always, Koha-US welcomes your agenda item ideas for this meeting; please email rhastings at nekls dot org with you ideas. I hope to see you at the meeting this Wednesday :-) Truly, Christopher Davis Secretary, Koha-US

1 0