- Koha - lists.katipo.co.nz

Re: [Koha] Help with MARC record matching rules
by Joel Ewy 25 May '14

25 May '14

I'm posting through GMANE, which I now see appears to have checked out since the 9th, and I'm not presently subscribed to the mail list. So if you reply to my previous message I won't be able to see it. If you want to reply to my email address I should be able to see it there. I'll try to subscribe and re-post my question. JCE

1 0

Help with MARC record matching rules
by Joel Ewy 24 May '14

24 May '14

Anybody know how to properly specify matching rules for importing marc records? I take it that if the rule works, it should show a match in the appropriate column on the "Manage staged MARC records" page before importing. I don't trust my zebra indices, and it appears that the match checks are supposed to match directly between the imports and the database. That's what I want. All I get is "no_match", so I assume I've specified the matching rules incorrectly. What am I doing wrong here? Matching rule code: MatchISBN Description: Match the ISBN Required Match threshold: 100 Required Match points Match point 1 | Add match point | Remove this match point Search index: ISBN Score: 101 Matchpoint components Tag: 020 Subfields: a Offset: 0 Length: 0 Normalization rule: Required match checks Match check 1Add match check | Remove this match check Source (incoming) record check field Tag: 020 Subfields: a Offset: 0 Length: 0 Normalization rule: Target (database) record check field Tag: 020 Subfields: a Offset: 0 Length: 0 Normalization rule:

1 0

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 22 May '14

22 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