- Koha - lists.katipo.co.nz

Generating data enty report
by shejith ennazhiyil 23 May '14

23 May '14

Koha can generate a report how many cataloging are done by each staff Members regards, shejith

2 1

Fw: Koha 3.16.0 released
by Olugbenga Adara 23 May '14

23 May '14

Ooops. Forgot to cc. the list Olugbenga Adara ----- Forwarded Message ----- >From: Olugbenga Adara <gbengaadara(a)yahoo.com> >To: Galen Charlton <gmc(a)esilibrary.com> >Sent: Thursday, May 22, 2014 5:07:57 PM >Subject: Re: [Koha] Koha 3.16.0 released > > > >Well done. Good stuff. Thanks once again to all developers for this awesome software > > >Olugbenga Adara > >Skype: gbengaadara >Blog: http://gbengaadara.blogspot.com >Twitter: http://twitter.com/gbengaadara >Profile: http://www.linkedin.com/in/gbengaadara > > > >>________________________________ >> From: Galen Charlton <gmc(a)esilibrary.com> >>To: Koha-List <koha(a)lists.katipo.co.nz> >>Sent: Thursday, May 22, 2014 5:00:08 PM >>Subject: [Koha] Koha 3.16.0 released >> >> >>Hi, >> >>The Koha community is pleased to announce the release of version >>3.16.0 of the Koha library automation system. >> >>Koha 3.16 is an enhancement and bugfix release. Changes of particular >>note include: >> >>* There is now the ability to use different templates for notices >>based on how the notice is to be sent. For example, is now possible to >>use different wording for email and SMS hold notifications. >>* Users can now unselect active facets when refining search results. >>* Search history can be now displayed and managed in the staff interface. >>* Loan checkins can now be backdated to an arbitrary date. >>* Holds can now be individually suspended and resumed from the OPAC. >>* Creating orders from staged files now offers much more flexibility. >>* The public reports service can now accept report parameters. >>* There is experimental support for Plack for development use. >>* The index update script can now operate as a daemon, allowing the >>indexes to be updated within seconds of a catalog record getting >>updated. >> >>There are many more enhancements, detailed in the release notes. >> >>There are also a number of improvements under the hood, particularly >>for internationalization. It is now possible to mark strings in the >>Perl source code for translation, and translation of strings in the >>JavaScript source code can now include placeholders. Also, a newer >>version of jQueryUI is now used by the staff interface. >> >>Koha can be downloaded from http://download.koha-community.org. Debian >>packages of Koha 3.16.0 will be available shortly. >> >>Additional details, including the release notes, can be found at >>http://koha-community.org/koha-3-16-0-released/ >> >>Regards, >> >>Galen >>-- >>Galen Charlton >>Manager of Implementation >>Equinox Software, Inc. / The Open Source Experts >>email: gmc(a)esilibrary.com >>direct: +1 770-709-5581 >>cell: +1 404-984-4366 >>skype: gmcharlt >>web: http://www.esilibrary.com/ >>Supporting Koha and Evergreen: http://koha-community.org & >>http://evergreen-ils.org >>_______________________________________________ >>Koha mailing list http://koha-community.org >>Koha(a)lists.katipo.co.nz >>http://lists.katipo.co.nz/mailman/listinfo/koha >> >> >> > >

1 0

On a format of 'Framework code'
by zolot 23 May '14

23 May '14

Hi Koha-community, I have the following questions to "Koha 3.14 Manual (en)". 1) Does a Koha-term 'framework' denote the same object as a 'Field Definition Table' in CDS/ISIS ? 2) What format has a 'Framework code' in the window 'Add framework' ? Example ? (A path to this window: Home > Administration > MARC frameworks > Add framework). Wishes, Gennady

2 1

Re: [Koha] Koha 3.16.0 released
by Adalid Ortiz 23 May '14

23 May '14

Felicidades !!! Just a week ago upgraded from Koha 3.14 to 3.14 at http://clavius.tij.uia.mx Adalid Ortiz Iberto Tijuana Biblioteca Loyola -- Este correo electronico puede contener informacion confidencial y privilegiada, por lo que se prohibe el uso, reproduccion, retransmision o divulgacion no autorizada, parcial o total, de su contenido. Si usted no es el destinatario del presente correo, por favor notifiquelo al remitente mediante reenvio a su correo electronico y borrelo de inmediato. Para conocer el aviso de privacidad le pedimos acceder a la siguiente liga: http://www.iberotijuana.edu.mx/?doc=/avisoprivacidad/index.html -- Los acentos han sido removidos intencionalmente para facilitar la lectura del mensaje independiente a la codificacion del mismo.

1 0

Re: [Koha] Report help needed
by Paul A 23 May '14

23 May '14

It could be just the way that my email client is formatting characters, but you may have a problem with the " and ' (double and single quote marks.) I read them below as â, â, and â Maybe you used a text editor that allows "curlies" rather than "straights"? Best -- Paul At 05:57 PM 5/20/2014 +0100, Elaine Bradtke wrote: >I'll admit, I'm the queen of cut and paste. What I don't know about SQL >would fill a book. > >Using a report I already have on hand: >SELECT ExtractValue(b.marcxml, >'//datafield[@tag="245"]/subfield[@code="a"]'), ExtractValue(b.marcxml, >'//datafield[@tag="260"]/subfield[@code="a"]'),ExtractValue(b.marcxml, >'//datafield[@tag="260"]/subfield[@code="c"]'), monthname(datecreated) AS >month, year(datecreated) AS year, biblionumber AS biblionumber >FROM biblio >LEFT JOIN biblioitems b USING (biblionumber) >WHERE datecreated BETWEEN <<Between (yyyy-mm-dd)>> AND <<and (yyyy-mm-dd)>> > >I tried to add some fields as per a request from one of our staff who would >like a rather thorough list of items added to the catalogue within a time >frame. > >SELECT ExtractValue(b.marcxml, >'//datafield[@tag=â100â]/subfield[@code="a"]'), ExtractValue(b.marcxml, >'//datafield[@tag="245"]/subfield[@code="a"]'), ExtractValue(b.marcxml, >'//datafield[@tag="245"]/subfield[@code=âbâ]â), ExtractValue(b.marcxml, >'//datafield[@tag="245"]/subfield[@code=âcâ]â), ExtractValue(b.marcxml, >'//datafield[@tag="260"]/subfield[@code="a"]'), ExtractValue(b.marcxml, >'//datafield[@tag=â773â]/subfield[@code=âtâ]â), >ExtractValue(b.marcxml, >'//datafield[@tag=â773â]/subfield[@code=âgâ]â), >ExtractValue(b.marcxml, >'//datafield[@tag="260"]/subfield[@code=âbâ]â), ExtractValue(b.marcxml, >'//datafield[@tag="260"]/subfield[@code="c"]'), ExtractValue(b.marcxml, >'//datafield[@tag=â300â]/subfield[@code=âaâ]â), >ExtractValue(b.marcxml, >'//datafield[@tag=â020â]/subfield[@code=âaâ]â), >ExtractValue(b.marcxml, >'//datafield[@tag=â022â]/subfield[@code=âaâ]â), >ExtractValue(b.marcxml, >monthname(datecreated) AS month, year(datecreated) AS year, biblionumber AS >biblionumber >FROM biblio >LEFT JOIN biblioitems b USING (biblionumber) >WHERE datecreated BETWEEN <<Between (yyyy-mm-dd)>> AND <<and (yyyy-mm-dd)>> > > >The first report works. The second doesn't. I'm sure it's a syntax error, >or something like that, but I'm blundering around in the dark. > > >Her request was for the following info: 100 field = Author | 245 = Title >proper (including subtitles and statement of responsibility) | 773(?) = >Periodical title |260 = place, publisher, and date | 300 = Extent | 020 = >ISBN / 022 = ISSN > > >Can anyone help? > >-- >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) >_______________________________________________ >Koha mailing list http://koha-community.org >Koha(a)lists.katipo.co.nz >http://lists.katipo.co.nz/mailman/listinfo/koha --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://NavalMarineArchive.com> and <http://UltraMarine.ca>

2 1

CAS Authentication Errors
by Justin Rittenhouse 22 May '14

22 May '14

Hello, We're having issues setting up CAS on a new instance of Koha. We have this working on a 3.6.4 server, but we've implemented 3.14.5 on a new server and can't get it to accept the CAS ticket. The CAS server is returning a valid ticket, but the OPAC displays a (not obvious) error: "Sorry, the CAS login failed." The following two lines appear in koha-opac-error_log: [Wed May 21 15:54:41 2014] [error] [client 10.41.57.78] [Wed May 21 15:54:41 2014] opac-user.pl: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at /usr/share/koha/lib/C4/Letters.pm line 220. [Wed May 21 15:54:41 2014] [error] [client 10.41.57.78] [Wed May 21 15:54:41 2014] opac-user.pl: Can't use an undefined value as an ARRAY reference at /usr/local/lib64/perl5/DBI.pm line 2064. We've set up the CAS options to match the 3.6.4 server, and it sends the request to CAS appropriately, but it won't accept the response. Are we missing something? Thanks for any help, Justin -- *Justin Rittenhouse* *Sr. Application Development Technician, Web and Software Engineering* *Hesburgh Libraries* 208 Hesburgh Library o: 574-631-3065 e: jrittenh(a)nd.edu

2 2

notes or statistics of transactions in Circulation
by schnydszch 22 May '14

22 May '14

Hello Koha community! I would like to ask if the feature I'll be mentioning is under development. In the Circulation module, a note or statistics can be attach to circulation transactions. In our library, some bosses ask their staffs to borrow books for them, and these bosses aren't even in the Patron's database of our Koha ILS. I'm thinking I can use the guardian option (parent-child) but these staffs and bosses are both adults, so it's actually awkward. Thus, I'm inquiring if there is development for such. And also, in one of the Koha projects I am currently involved with, they wanted to know if a certain material borrowed for photocopying can be tag such, so this feature on notes/statistics on circulation transactions came up again in my mind. If this feature is off the radar, then I would like to file a bug for this. Thanks and cheers Koha community! -- View this message in context: http://koha.1045719.n5.nabble.com/notes-or-statistics-of-transactions-in-Ci… Sent from the Koha-general mailing list archive at Nabble.com.

3 5

Check in check out fields losing focus
by Marty 22 May '14

22 May '14

Koha 3.15.00.029 on Debian Wheezy When checking out items I have to click every time in the check out box, because the focus disappears. This is most irritating. The same happens when I check in items, and it slows me down considerably. The librarians have not killed me yet, but they start looking like they want to. I tried to upgrade to 3.16.00 which runs perfectly fine on my laptop hoping that would solve the problem (I could be wrong of course), but I have missing perl modules I cannot install. I am missing: Data::Pagination HTTPD::Bench::ApacheBench Archive::Extract Test::WWW::Mechanize They all stop at cannot test without successful make. I did some googling and found a post that advised to install libchi-driver-memcached-perl, but that does not work either; The following packages have unmet dependencies: libchi-driver-memcached-perl : Depends: libchi-perl but it is not going to be installed E: Unable to correct problems, you have held broken packages. So, now I need some help. Especially to automatically return focus to check in / check out boxes Thanks, Marty

3 6

'add basket group' bug in Koha 3.14.6
by schnydszch 22 May '14

22 May '14

Hello Koha community! We were trying out the Acquisitions module of Koha ILS, the version as you can see in subject post is 3.14.6, and is installed in Debian 6.x. Whenever I close a basket wherein we're notified to create a basket group for it with the same name as the Basket name, there is no basket group created. I'm also trying to create a new Basket Group but to no avail. Can anybody confirm this too? Are we missing something? I was able to do this in Koha 3.14.5. Thanks in advance! -- View this message in context: http://koha.1045719.n5.nabble.com/add-basket-group-bug-in-Koha-3-14-6-tp579… Sent from the Koha-general mailing list archive at Nabble.com.

3 8

Redirect loop Error
by Saira Asghar 22 May '14

22 May '14

Dear All I am using Ubuntu based koha version 3.14.05 and have configured it on domain. Its working fine but some times its gives a message at client site "Redirect loop". Can any one please tell us its solution? After deleting cookies at client system its start working but its not a suitable solution because it is not possible to everyone to dell cookies from his system's browser for using the site. Is it possible to configure its cookies at server machine. So no any user has to face this redirect loop error. -- *Regards* Saira Asghar Librarian Namal College, 30-Kilometer Talagang Road, Mianwali, Pakistan. E-mail: saira.asghar(a)namal.edu.pk Ph: 0459 236995 Ext. 138

1 0