- Koha - lists.katipo.co.nz

SQL - Request for change in shelving location
by SATISH 01 Apr '16

01 Apr '16

Hi, My Koha (3.16) has been installed from packages method on ubuntu 12.4 LTS Desktop. I have to set huge number of items (various barcode) among many Records into Shelving location called = Reference Section. I mean, I have pick specified barcode (item) from each record to a location called "Reference section". Previously, While entering bibliographic details, I did not set specific barcode(item) into location =referece section, and now doing manually one by one will consume huge time, therefore, I request, Using SQL how to set following two specific conditions for the specified barcode (item) having barcode numbers from "1, 2, 3..to 100" set to: 1) 7- Not for Loan to "Not for Loan" (Previously this field is empty) 2) c-Shelving Location to " Reference section" (Previously this field was set to shelving location called "General Stock" Can koha community, please help me to save my time for doing this job using "sql" ?? thank you in advance, Satish MV Librarian Govt. Engineering College, Hassan, Karnataka. INDIA --

4 9

Bug 9021 does not work in India and needs to be mentioned as such in the docs
by Indranil Das Gupta 01 Apr '16

01 Apr '16

Hi all, Need a spot of help from you good peeps at Bywater :) This post[1] from Kyle w.r.t bug 9021 is causing a whole bunch of confusion among the Indian users of Koha. SMS support is an obvious much sought after feature and Kyle's fix seems like a wonderful thing, except that for India it simply does not work and thus needs a exception disclaimer added to it. I request that the post be updated with a note like this : "This feature may not work at all in India due to Indian telecom rules. Users in India are strongly advised to explore their legal exposure in using this feature with a lawyer in India" @Nicole - when you expand the manual, this exception needs to be mentioned. Let me explain why. Warning long read. :) Due to the nature of legal and telecom regulatory framework in India, bug 9021 will for 99% of 500+ million cell phones in India. Briefly, we have a policy of "sender pays" - receiving texts is free, sending is not. That is the first blocker for the email to sms scheme. The facility is offered only on high cost business application packages where there is a reverse charge mechanism of making the recipient pay the data charge. Further TRAI (Telecom Regulatory Authority of India) has clamped user to user (not system to user) smses at max of 200 per day, which makes it unsuitable for a busy circulation system. Further India has national number portability (NNP) - i.e. a cell phone user can shift from telco to telco, without a change of numbers. So these days it is often impossible to tell from number if say it is from Vodafone or Idea Cellular or Airtel (as user may have shifted between them, but kept the old number under NNP facility. This impacts the +91<10-digit-number>@telco.tld scheme of the patch. Further, under TRAI rules, promotional texts can be sent to only to cell phone users who are not listed in the national do-not-disturb (DND) list and only between 9 AM -- 9PM IST. Sending to non-DND and outside the time window is a fairly serious prosecutable criminal offence. System alerts and notification texts that need to be sent any time 24/7 have to be sent using what is called the "transactional route" by TRAI. Users (say a library) who want to send out these alerts have to do the following before they can send out a text: (a) sign up with a transactional bulk message service provider (b) register their sms templates with TRAI for approval (c) get their users (the text recipients) to opt-in Legally in India if you wanted to send e.g. an overdue alert to your user without clearing a,b and c above you can be open yourself up to criminal prosecution and as well as see action as perpetrator of a civil wrong. FWIW, SMSes sent user to user typically costs between 10 - 30 times more than a transactional bulk sms text (system to user). BTW, the list that Nicole found lists a whole bunch of Indian service providers. Let me clarify that this is dated document and none of those Indian references work. They got their because about 8 - 10 years back that sort of feature used to work in India as well. But as the number of spam texts ballooned this access was withdrawn. [1] http://bywatersolutions.com/2016/02/26/koha-sms/ cheers -- 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

2 1

Scholarship Program for Koha ILS and MARC 21 program in Bangladesh
by Suzon Das 31 Mar '16

31 Mar '16

Hello Everyone, I am glad to inform you that Daffodil Int. University Library of Bangladesh, highly IT incorporated Library, announced the Full Free Scholarship opportunity for its Training Program on Koha ILS and MARC 21 for the topper students in Information Science and Library Management of University of Dhaka, the pioneer university in LIS education. The Scholarship will be started from the upcoming 9th phase program.

1 0

upload
by regina kivuyo 31 Mar '16

31 Mar '16

Thanks for help me to change file format by using mark editor , now i failed to upload after try to upload i got the message i think no data importated i am attaching my file help plsease Stage MARC records for import MARC staging results : - 1 records in file - 1 records not staged because of MARC error - 0 records staged - Did not check for matches with existing records in catalog - 0 item records found and staged - Manage staged records <http://192.168.1.2:8080/cgi-bin/koha/tools/manage-marc-import.pl?import_bat…> - Back <http://192.168.1.2:8080/cgi-bin/koha/tools/tools-home.pl> -- regina

3 2

"Return to Advanced Search" button
by Gabriela Zoller 31 Mar '16

31 Mar '16

Hi, During the webinars about Koha 3.22, we were shown a "return to advanced search" button that took you from a results list back your the advanced search screen, with fields still populated w/your search terms. But when I run an advanced search in the 3.22 demo OPAC, the button doesn't come up. Is it not activated in the demo OPAC? (I want to share it w/colleagues when I show them 3.22 features/changes) Thanks, Gabriela _______________________ Gabriela Zoller Cataloging and Metadata Librarian Presbyterian Historical Society 425 Lombard Street Philadelphia, PA 19147-1516 ph: 215-928-3881 fax: 215-627-0115 gzoller(a)history.pcusa.org Learn more on our website<http://www.history.pcusa.org/> | Follow us on Facebook<http://www.facebook.com/pages/Presbyterian-Historical-Society/109477905406> | Sign Up for e-newsletters<http://pcusa.us2.list-manage.com/subscribe?u=d250adcb775dd16a5851f4a36&id=4…>| Make a gift<http://www.history.pcusa.org/support/>

2 1

Re: [Koha] No results found!
by Paul A 31 Mar '16

31 Mar '16

At 06:30 PM 3/31/2016 +0300, regina kivuyo wrote: >i installed koha after that install the database ,the import data from mrc >format , the start work with zebra ,now i can search any thing , it give me >the error both in opac and staff client >what to do now help please [It would be helpful if you could say which version of Koha, if it was a packet or tarball installation, and on what operating system.] Is Zebra running? What is the output of: you@yourserver:/$ ps -aux | grep zebra If it is running, did you re-index biblios and authorities? Paul

1 0

No results found!
by regina kivuyo 31 Mar '16

31 Mar '16

i installed koha after that install the database ,the import data from mrc format , the start work with zebra ,now i can search any thing , it give me the error both in opac and staff client what to do now help please -- regina -- regina

1 0

(no subject)
by regina kivuyo 31 Mar '16

31 Mar '16

i installed koha after that install the database ,the import data from mrc format , the start work with zebra ,now i can search any thing , it give me the error both in opac and staff client what to do now help please -- regina

1 0

Re: [Koha] Strange character in bywater coverflow plugin
by Mark Tompsett 31 Mar '16

31 Mar '16

Greetings, I’m sorry, but does it even display properly in the staff client? When there is a problem in opac-detail and the opac-export, it is a problem that isn’t plugin specific. Are all your tables and db unicode? GPML, Mark Tompsett From: Hugo Agud Sent: Thursday, March 31, 2016 6:54 AM To: Mark Tompsett Subject: Re: [Koha] Strange character in bywater coverflow plugin hi Mark That's one of our demo server, always updated to koha 3.22.5 ; ).... and yes, the data from mysql report is fine... I think it should be some part of the plugin, that it doesn't expect non english charset 2016-03-31 12:51 GMT+02:00 Mark Tompsett <mtompset(a)hotmail.com>: Greetings, Is there a codification problem in the plugin or [] have [we] done something wrong with the configuration? http://demo2.orex.es/cgi-bin/koha/opac-detail.pl?biblionumber=136 I don't think it is a plugin issue. Which version of Koha are you using? And did you check your data was imported/entered properly? GPML, Mark Tompsett -----Original Message----- From: Hugo Agud Sent: Thursday, March 31, 2016 4:24 AM To: Koha list Subject: [Koha] Strange character in bywater coverflow plugin Good morning We have been testing the wonderful plugin coverflow from bywatersolutions, and we have seen that spanish charactes like á, é or í for example appears wrong in the coverflow You may take a look: http://demo2.orex.es/ Thanks a lot! -- *Hugo Agud - Orex Digital * *www.orex.es <http://www.orex.es>* <http://www.orex.es/> [image: http://orex.es] <http://orex.es> <http://www.orex.es> Director Passatge de la Llançadera, 3 · 08338 Premià de Dalt - Tel: 93 539 40 70 hagud(a)orex.es · http://www.orex.es/ No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 árboles y el consumo de 250.000 litros de agua. Aviso de confidencialidad Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni está autorizado a recibirlo por el remitente), no está autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema. _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha -- Hugo Agud - Orex Digital www.orex.es Director Passatge de la Llançadera, 3 · 08338 Premià de Dalt - Tel: 93 539 40 70 hagud(a)orex.es · http://www.orex.es/ No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 árboles y el consumo de 250.000 litros de agua. Aviso de confidencialidad Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni está autorizado a recibirlo por el remitente), no está autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.

2 1

Strange character in bywater coverflow plugin
by Hugo Agud 31 Mar '16

31 Mar '16

Good morning We have been testing the wonderful plugin coverflow from bywatersolutions, and we have seen that spanish charactes like á, é or í for example appears wrong in the coverflow You may take a look: http://demo2.orex.es/ Is there a codification problem in the plugin or we have done something wrong with the configuration? Thanks a lot! -- *Hugo Agud - Orex Digital * *www.orex.es <http://www.orex.es>* <http://www.orex.es/> [image: http://orex.es] <http://orex.es> <http://www.orex.es> Director Passatge de la Llançadera, 3 · 08338 Premià de Dalt - Tel: 93 539 40 70 hagud(a)orex.es · http://www.orex.es/ No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 árboles y el consumo de 250.000 litros de agua. Aviso de confidencialidad Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni está autorizado a recibirlo por el remitente), no está autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.

2 1