- Koha - lists.katipo.co.nz

Re: [Koha] SIPServer abaility
by Tajoli Zeno 26 Apr '16

26 Apr '16

Hi, Il 22/04/2016 18:36, Joseph Hogan ha scritto: > Hello, > OK' it is used for tools hooked up to the computer to help check books > out? Like hand scaenrs of RFID scanenrs? sorry the delay. The answer is yes, this is the normal use of SIP procotol in Koha (and in others ILS). I strongly suggest to read this paper from 3M: http://mws9.3m.com/mws/mediawebserver.dyn?6666660Zjcf6lVs6EVs66S0LeCOrrrrQ- Bye Zeno Tajoli -- Zeno Tajoli / SVILUPPO PRODOTTI/ - Automazione Biblioteche Email: z.tajoli(a)cineca.it Fax: 051/6132198 *CINECA* Consorzio Interuniversitario - Sede operativa di Segrate (MI)

2 1

Koha 3.22.6 security release
by Julian Maurice 26 Apr '16

26 Apr '16

The Koha community is proud to announce the release of Koha 3.22.6. This is a security release and contains many bugfixes. The full release notes are available at https://koha-community.org/koha-3-22-6-security-release/ -- Julian Maurice <julian.maurice(a)biblibre.com> BibLibre

1 0

Reg. Speech To Text Integration in KOHA OPAC
by Dr.Avaneesh Kumar Singh 26 Apr '16

26 Apr '16

Dear All, I am head Librarian at KIIT Group of Colleges, Gurgaon, India. Being an Open source enthusiast, I have implemented KOHA in our Library and also trying to modify / customize it. At present I am working on integrating speech recognition (Speech to Text) and speech synthesis (Text to Speech) to KOHA OPAC. I tried to integrate Google Speech API (Links given below), but couldn't make it https://developers.google.com/web/updates/2013/01/Voice-Driven-Web-Apps-Int… https://www.google.com/intl/en/chrome/demos/speech.html https://dvcs.w3.org/hg/speech-api/raw-file/tip/speechapi.html I would highly appreciate if you could guide me in this direction. THANKING YOU With Best Regards *Dr. Avaneesh Kumar SinghLibrarianKIIT Group of colleges Gurgaon, Haryana - 122102Mob. : +91-8447642084*

2 1

Please assist: "ALL items fields MUST be mapped to the same tag" issue
by Mr Patrick Beddy 25 Apr '16

25 Apr '16

Good day. I have been struggling to resolve a "MARC bibliographic framework test" issue, and hope that someone in this forum can assist me. I used the default MAR framework structure, and in preparation for importing stock from our old library system, I created some new sub-fields under Koha tag 995. All existing and new sub-fields had constraints linked to Tab 10. Under "Koha to MARC mapping" and the "items" section, all fields used link to subfields of tag 995. However, When I run "MARC bibliographic framework test", the only error I get is "item fields: ALL items fields MUST be mapped to the same tag, and they must all be in the 10 (items) tab" Can anyone give some help on how to clear this problem. My setup: Koha version: 3.22.02.000 OS version ('uname -a'): Linux debian 3.2.0-4-686-pae #1 SMP Debian 3.2.57-3 i686 GNU/Linux Perl version: 5.014002 MySQL version: mysql Ver 14.14 Distrib 5.5.44, for debian-linux-gnu (i686) using readline 6.2 Many thanks ================================================== Please report any abuse sent from any Treverton user to abuse(a)treverton.co.za ==================================================

1 0

koha rebuild
by Mohamed Awad 24 Apr '16

24 Apr '16

hello, When I clear record and passes it 16 hours were not rebuild ignores deletion how can i resolve this problem because i forget rebuild daily when i clean my items. with regards,

2 1

Re: [Koha] Circ Notices not working since migration
by Eric Bégin 24 Apr '16

24 Apr '16

Martin, Your command is set to run everytime the minute is 1 (00:01, 01:01, 02:01, ...) on monday only. Try */15 * * * * to run it every 15 minutes :) Eric BéginSolutions inLibro inc. -------- Message d'origine -------- De : Martin House <martin.house(a)gmail.com> Date : 23/04/2016 10:21 (GMT-05:00) À : koha(a)lists.katipo.co.nz Objet : [Koha] Circ Notices not working since migration None of our circulation notices are working anymore since our migration to 3.22. I have checked and notices appear to be queued. I fear that something is wrong with how I have setup crontab. Here is what I have for one of them: 1 * * * 2 /usr/share/koha/bin/cronjobs/process_message_queue.pl Can someone help me shed some light on this? It's been really, really frustrating to have this core function not working. Thank! Martin Martin House martin.house(a)gmail.com "An unexamined life is not worth living." _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Circ Notices not working since migration
by Martin House 24 Apr '16

24 Apr '16

None of our circulation notices are working anymore since our migration to 3.22. I have checked and notices appear to be queued. I fear that something is wrong with how I have setup crontab. Here is what I have for one of them: 1 * * * 2 /usr/share/koha/bin/cronjobs/process_message_queue.pl Can someone help me shed some light on this? It's been really, really frustrating to have this core function not working. Thank! Martin Martin House martin.house(a)gmail.com "An unexamined life is not worth living."

2 1

[RESOLVED] Re: How to login using the Koha SIPServer implementation
by Indranil Das Gupta 23 Apr '16

23 Apr '16

Hi all, Yay! figured it out :-) . Was a small config file issue on the libki server component side. cheers -idg On Fri, Apr 22, 2016 at 10:27 AM, Indranil Das Gupta <indradg(a)gmail.com> wrote: > Hi all, > > First off, I'm not really sure if this is the proper forum for this > question (Libki mailing list on sf or the github issue tracker may be > a better place). > > Basically, I've been trying to get LibKi working with Koha's > SIPServer. I'm linking to the syslog output here - > http://pastebin.com/rP9VH5wb > > From what I can see, I'm being able to fetch the user credentials > correctly and yet I'm not logging in. Some help would be great! > > thanks in anticipation > > -idg > > -- > Indranil Das Gupta > > Phone : +91-98300-20971 > Blog : http://indradg.randomink.org/blog > IRC : indradg on irc://irc.freenode.net > Twitter : indradg > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- > Please exchange editable Office documents only in ODF Format. No other > format is acceptable. Support Open Standards. > > For a free editor supporting ODF, please visit LibreOffice - > http://www.documentfoundation.org -- Indranil Das Gupta Phone : +91-98300-20971 Blog : http://indradg.randomink.org/blog IRC : indradg on irc://irc.freenode.net Twitter : indradg -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards. For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org

1 0

Re: [Koha] Report question
by Paul A 23 Apr '16

23 Apr '16

At 09:09 AM 4/22/2016 -0500, Coehoorn, Joel wrote: >This is one of those things that would be EASY in Sql Server, Oracle, or >Postgresql, which all have a split() function that can produce a set >suitable for use with an IN() clause. Given that the query below works perfectly on CLI (using real values 1, 2, 3 rather than the << input, input2, input3 >> construct), maybe we should look at the code that prepares the MySQL query, rather than just saying that MySQL doesn't remove the single quotes. I haven't had time to chase down whether it's Koha or a standard library that adds the quote marks, but wherever it is, it should be fairly trivial to remove them. Best -- Paul >Sadly, MySql has failed to keep pace with other DB platform, going even >back before it's acquisition by Oracle. It lacks split and a few other >functions, uses non-compliant NULL handling by default, does not have CTEs, >Windowing Functions, a lateral join/APPLY operation, or a FULL JOIN >operation. I'd really love the option of running Postgresql instead. These >days, it outclasses MySql in pretty much every category, and has done so >for nearly a decade now. > > > >Joel Coehoorn >Director of Information Technology >402.363.5603 >*jcoehoorn(a)york.edu <jcoehoorn(a)york.edu>* > >The mission of York College is to transform lives through >Christ-centered education and to equip students for lifelong service to >God, family, and society > >On Fri, Apr 22, 2016 at 1:48 AM, Graham, Stephen <s.graham4(a)herts.ac.uk> >wrote: > > > Thanks FranÃ§ois, I suspected as much. I've tried doing things like: > > > > 35','36','37 > > > > , but the report tool just escapes the ' with a backslash. Very > > frustrating! > > > > I guess I could use an OR, but I don't know how many values would be > > passed each time. I guess I'll need to write a custom cgi script which > > outputs some JSON for what I want. > > > > Cheers, Stephen > > > > -----Original Message----- > > From: Koha [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Francois > > Charbonnier > > Sent: 21 April 2016 17:14 > > To: koha(a)lists.katipo.co.nz > > Subject: Re: [Koha] Report question > > > > Hi Stephen, > > > > I don't see any workaround but right now, it can't work. > > > > Let's say the <<BIBIDS>> value is : 34,35,36 > > > > With the IN operator, you have to get the query this way : IN(34,35,36) > > but with the <<BIBIDS>>, you'll get IN('34,35,36') instead. The query will > > look for the expression '34,35,36' which is not a biblionumber. > > Therefore, you don't have any result. > > > > I guess you could use multiple "OR"... > > > > Hope it helps! > > > > FranÃ§ois Charbonnier, > > Bibl. prof. / Chef de produits > > > > TÃ©l. : (888) 604-2627 > > francois.charbonnier(a)inLibro.com <mailto:francois.charbonnier@inLibro.com> > > > > inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com> Le > > 2016-04-21 11:16, Graham, Stephen a Ã©crit : > > > Hi All - I want to set up a SQL report that can take a variable number > > of the same value. My SQL looks like: > > > > > > select > > > biblionumber, > > > concat (branchname, ', ', lib) as location, itemcallnumber, if(onloan > > > is null,'Available',onloan) onloan from > > > items,authorised_values,branches where biblionumber in (<<BIBIDS>>) > > > and authorised_values.category = 'LOC' > > > and items.location = authorised_values.authorised_value > > > and items.homebranch = branches.branchcode > > > > > > I want the <<BIBIDS>> value to be able to receive several values when I > > run the report from the staff client, but I cannot get it to work. Any > > advice/tips much welcome! > > > > > > Stephen > > > > > > Stephen Graham > > > Online Information Manager > > > Information Collections and Services > > > Library and Computing Services > > > University of Hertfordshire > > > Hatfield AL10 9AB > > > UK > > > Tel. 01707 286111 Ext: 77751 > > > Email s.graham4(a)herts.ac.uk > > > > > > _______________________________________________ > > > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > _______________________________________________ > > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > >_______________________________________________ >Koha mailing list http://koha-community.org >Koha(a)lists.katipo.co.nz >https://lists.katipo.co.nz/mailman/listinfo/koha

2 1

Report question
by Graham, Stephen 23 Apr '16

23 Apr '16

Hi All - I want to set up a SQL report that can take a variable number of the same value. My SQL looks like: select biblionumber, concat (branchname, ', ', lib) as location, itemcallnumber, if(onloan is null,'Available',onloan) onloan from items,authorised_values,branches where biblionumber in (<<BIBIDS>>) and authorised_values.category = 'LOC' and items.location = authorised_values.authorised_value and items.homebranch = branches.branchcode I want the <<BIBIDS>> value to be able to receive several values when I run the report from the staff client, but I cannot get it to work. Any advice/tips much welcome! Stephen Stephen Graham Online Information Manager Information Collections and Services Library and Computing Services University of Hertfordshire Hatfield AL10 9AB UK Tel. 01707 286111 Ext: 77751 Email s.graham4(a)herts.ac.uk

4 4