- Koha - lists.katipo.co.nz

Report question
by Graham, Stephen 22 Apr '16

22 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

SIPServer abaility
by Joseph Hogan 22 Apr '16

22 Apr '16

Hello, I read a recent message talking about the ability of Koha being able to use a SIPServer. I tried looking in the wiki for more information, but while it seems to explain how to set it up, I can not find a uapication for it? I use SIP server sfor VOIP telephony purposes. But, what is the use here in Koha? Thanks Joeph

2 1

Using build_oai_sets.pl with embed items option
by Pedro Amorim 22 Apr '16

22 Apr '16

Hello all, I've configured an OAI set mapping with the field 995$a equals "libcode", where 995$a holds the aquisition library code for the item. As this is an item field, not a biblio field, I have to run build_oai_sets.pl with '-i' option in order to embed items to the records. This is working fine, however, it's only indexing records which only have 1 item of 'libcode'. Every other biblio with, say, 5 items from different libraries and 1 from 'libcode' library are not indexing. I think the C4::Biblio::EmbedItemsInMarcBiblio function might be only considering the first item in a biblio, instead of checking all of them. Has anyone else come across this situation? Thanks, Pedro Amorim

2 6

How to login using the Koha SIPServer implementation
by Indranil Das Gupta 22 Apr '16

22 Apr '16

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

1 0

Re: [Koha] Report question
by Jorge de Cardenas 21 Apr '16

21 Apr '16

If you are comfortable with Perl, what I do quite often is create in the folder koha\intranet\cgi-bin\test the MyReport.pl that points a template MyReport.tt in koha\htdocs\intranet-tmpl\prog\en\modules\test. This way you can create an input form however you like. MyReport.pl would execute the SQL query and display the results in a table in MyReport.tt. What I do now is usually modify one of my reports when I need a new one. The first time I used one of the existing scripts and slowly modified it until I felt comfortable with the process. Hope this helps. Jorge > >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 -- Jorge de Cardenas | Head Systems Administrator 3512 Darrow Road, Stow, OH 44224 330 688-3295, ext 106 | FAX 330 688-0448 | www.smfpl.org | <http://www.facebook.com/SMFPL> <http://twitter.com/smfpl> <http://pinterest.com/smfpl/boards> If you have received this email in error please notify the system manager. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the institution.

1 0

Speech Recognition & Synthesis Integration on KOHA OPAC
by Dr. Avaneesh Singh 21 Apr '16

21 Apr '16

Hi All, I am head Librarian at KIIT Group of Colleges. Being an Open source enthusiast, I have implemented KOHA in our Library and also trying to modify / customize it. I was trying to integrate speech recognition (Speech to Text) and speech synthesis (Text to Speech) to KOHA OPAC. I was basically trying 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 appriceate if anyone working in this direction could help me out by kindly letting me know how to integrate any speech API's to KOHA OPAC. -- View this message in context: http://koha.1045719.n5.nabble.com/Speech-Recognition-Synthesis-Integration-… Sent from the Koha-general mailing list archive at Nabble.com.

1 0

MARC21 XSLT Details Page - 6xx field - Listing subject headings?
by Craig Butosi 20 Apr '16

20 Apr '16

Hi all, Has anyone successfully edited the XSLT stylesheet for the MARC21 details page to list subject headings (i.e., line feed or carriage return)? I'd really prefer a list look to the default inline look, which uses pipe as a separator. If so, would anyone be willing to share a snippet from your XSL file? Many thanks! Craig Butosi, MA, MLIS, B Mus (Hons.) LIBRARY SERVICES MANAGER the royal conservatory TELUS Centre for Performance and Learning 273 Bloor Street West Toronto, ON M5S 1W2 416.408.2824 x338 www.rcmusic.ca<http://www.rcmusic.ca/> Note: This email message and any attachments are intended only for the use of the individual to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the recipient of this email is not the intended recipient (or the employee or agent responsible for delivering the email to the intended recipient), you are hereby notified that any review, dissemination, distribution or copying or other use of this message is strictly prohibited. If you have received this communication in error, please notify the sender immediately by return email and delete this message and attachments from your system, thank you.

1 0

Koha OAI sets only working for small sets
by Pedro Amorim 20 Apr '16

20 Apr '16

Hello all, I'm using Koha 3.22 with debian packages. I've configured the OAI sets mappings and I'm trying simple sets for the moment, each test set is mapped to a different object type. After running build_oai_sets.pl -v, this is the output I get: Set '6': 335 biblios Set '1': 1 biblios Set '3': 105 biblios Set '2': 15 biblios Set '5': 172 biblios For some reason, it's not indexing the set 4 which should have around 1.2k records. The logs dont show anything related to this issue, I've been diving on the code for oai.pl and Sets.pm looking for maybe some limit on the number of records a set can have but found nothing. Does anyone have any information on this? Has someone tried to configure a medium/large oai set on Koha? Thank you, Pedro Amorim

1 1

enquiry
by mohammed abdelgadir 20 Apr '16

20 Apr '16

hi everybody what does Null barcode mean is it mean not exist number in my sequential Barcode numbers example If I have a barcode numbers from 1 to 10 the numbers 3-6 - 8 - 9 no exist how can i create report for Vacancies numbers.

1 0

Add links to Chinese manual
by Anthony Mao 20 Apr '16

20 Apr '16

Hi, The 3.22 manual has been translated to Traditional Chinese. Could some one add links at Documentation, https://koha-community.org/documentation/ 3.22 Manual (Chinese[Taiwan]) with url as, http://translate.koha-community.org/manual/3.22/zh-Hans-TW/html-desktop/ -- Wishing you all the best. . . . Anthony Mao 毛慶禎＋886 2 29052334 (voice) + 886 2 29017405 (FAX)

2 1