- Koha - lists.katipo.co.nz

Strange email
by Chrispin Simasiku Sitali 22 May '14

22 May '14

I have just received some strange or rather inappropriate message from Carrie (meetcarrie(a)hotmail.com) soliciting for my "friendship" . Should this be appearing on the mailing list? What should I do on my part to stop this rot or shouldn't people overseeing the mailing list do something? How did this Carrie get on the mailing list in the first place? Thank you -- Charles Lwanga College of Education, P. O. Box 660193, Monze, ZAMBIA. Mobile: +26 0979 869471 +26 0966 869471 SKYPE: Libsitali

2 1

***UNCHECKED*** Pictures of libraries running Koha?
by Dan Scott 21 May '14

21 May '14

Hi: I'm giving a few talks in the next couple of months about the schema.orgRDFa integration that Koha offers, and I was hoping I might be able to put together some composite images that show libraries (big and small, around the world) that are now more connected to the web of linked data as a result of that effort. Ideally the pictures would be made available under something like a CC-BY-SA license so that they could be reshared with the appropriate attribution. A set of pictures like this seems like it would be fun and useful to have in general on the koha-community.org site, and I wasn't able to find anything existing along those lines, so perhaps this wouldn't be all about satisfying a nice-to-have for me... That said, if a collection like this already exists, I would greatly appreciate a pointer :) Thanks, Dan

4 6

Report help needed
by Elaine Bradtke 21 May '14

21 May '14

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)

4 3

***UNCHECKED*** Importing Loan History
by Arup Raychaudhury 21 May '14

21 May '14

Will there be any problem if I import transaction history through offline circulation process? I have around 500000 transactions. -- Arup Raychaudhury Indian Statistical Institute 203 BT Road Kolkata 700108. INDIA Phone: 91-33-2575-2106 Fax: 91-33-2578-1412

3 2

Corrected Link for the Reno Internet Librarian Job
by Keener, Nancy 21 May '14

21 May '14

http://www.washoecounty.us/humanresources/careers/jobs.htm Nancy Keener Systems Librarian I.T.O.S.C. Chair Washoe County Library System Reno, Nevada 775 327-8347 nkeener(a)washoecounty.us

1 0

Password Encryption
by amutsikiwa＠uzlib.uz.ac.zw 21 May '14

21 May '14

Hi I have uploaded a number of patron records via a pup script. However, the password are not working. I have used md5 function. I would like to know which encryption method is used for passwords in Koha. Kind Regards, Admire Mutsikiwa ICT Projects Manager Libraries University of Zimbabwe Tel:+263-4-303276 "It is easy to dodge our responsibilities, but we cannot dodge the consequences of dodging our responsibilities." Josiah Charles Stamp, 1880-1941, former director of the Bank of England

5 4

On basic differences of MARC, MARC21 and UNIMARC
by zolot 21 May '14

21 May '14

Hello all, "Koha 3.14. Manual (en)" considers "MARC", "MARC21" and "UNIMARC". What principle differences exist between these formats ? My database (more preciesely, isis-catalog, 100 000 records) has been created in accordance with Ukrainian standard "UKRMARC". Which of the indicated formats must be chosen for preferences ? What criteria need to be followed for the choice of marc-format ? Thank you, Gennady

2 1

couldnot found catalog with error rebuild-zebra
by Lehuy 21 May '14

21 May '14

Dear All, I installed koha-common (3.14) on ubuntu 14.04 success but when I try to index catalog by importing marc file I got some error as below and I could not searching $ sudo koha-rebuild-zebra -v -f library given is experimental at /usr/share/koha/lib/Koha/DateUtils.pm line 133. when is experimental at /usr/share/koha/lib/Koha/DateUtils.pm line 134. when is experimental at /usr/share/koha/lib/Koha/DateUtils.pm line 139. when is experimental at /usr/share/koha/lib/Koha/DateUtils.pm line 144. Smartmatch is experimental at /usr/share/koha/lib/C4/Search.pm line 534. Useless use of '\'; doesn't escape metacharacter '(' at /usr/share/koha/lib/C4/AuthoritiesMarc.pm line 848. Pls. let see attached marc file for importing. Intranet Log file: [Wed May 21 15:44:19.532114 2014] [cgi:error] [pid 47015] [client 192.168.1.15:53392] AH01215: [Wed May 21 15:44:19 2014] DateUtils.pm: given is experimental at /usr/share/koha/lib/Koha/DateUtils.pm line 133., referer: http://192.168.1.53:8080/cgi-bin/koha/tools/manage-marc-import.pl [Wed May 21 15:44:19.532511 2014] [cgi:error] [pid 47015] [client 192.168.1.15:53392] AH01215: [Wed May 21 15:44:19 2014] DateUtils.pm: when is experimental at /usr/share/koha/lib/Koha/DateUtils.pm line 134., referer: http://192.168.1.53:8080/cgi-bin/koha/tools/manage-marc-import.pl [Wed May 21 15:44:19.532784 2014] [cgi:error] [pid 47015] [client 192.168.1.15:53392] AH01215: [Wed May 21 15:44:19 2014] DateUtils.pm: when is experimental at /usr/share/koha/lib/Koha/DateUtils.pm line 139., referer: http://192.168.1.53:8080/cgi-bin/koha/tools/manage-marc-import.pl [Wed May 21 15:44:19.533050 2014] [cgi:error] [pid 47015] [client 192.168.1.15:53392] AH01215: [Wed May 21 15:44:19 2014] DateUtils.pm: when is experimental at /usr/share/koha/lib/Koha/DateUtils.pm line 144., referer: http://192.168.1.53:8080/cgi-bin/koha/tools/manage-marc-import.pl [Wed May 21 15:44:19.972496 2014] [cgi:error] [pid 47015] [client 192.168.1.15:53392] AH01215: [Wed May 21 15:44:19 2014] Search.pm: Smartmatch is experimental at /usr/share/koha/lib/C4/Search.pm line 534., referer: http://192.168.1.53:8080/cgi-bin/koha/tools/manage-marc-import.pl

1 0

***UNCHECKED*** KOHA users.
by Jerwyn Fernandez 21 May '14

21 May '14

Good day! Our library was able to launch KOHA recently and I would like to include it in the KOHA users around the world. How does our library will be included in the list? Here is our URL http://library.southville.edu.ph/ Thank you and best regards, -- *BE AMAZING. BE SOUTHVILLE.* Jerwyn G. Fernadez, RL Basic Education Librarian Southville International School and Colleges Tel: 825-6374 loc.117/146 *Like us https://www.facebook.com/sisc.monarchs <https://www.facebook.com/sisc.monarchs>* *Follow us https://twitter.com/SISCMonarchs <https://twitter.com/SISCMonarchs>* * www.southville.edu.ph <http://www.southville.edu.ph/>* * https://www.youtube.com/watch?v=CEeXh3JyXRg <https://www.youtube.com/watch?v=CEeXh3JyXRg>* *http://library.southville.edu.ph*<http://library.southville.edu.ph>

3 3

Patron self-register from OPAC
by Anthony Mao 21 May '14

21 May '14

Hi, One question. How can I let 'Don't have an account? Register here.' appear at OPAC main page? At Manual 3.14, Chapter 12. OPAC, 6. OPAC Self Registration, it describe as it. But I can not find it on my OPAC. Bywater Solutions' demo site show those words only. Other demo sites have no such words. http://koha-community.org/demo/ -- Wishing you all the best. . . . Anthony Mao 毛慶禎＋886 2 29052334 (voice) + 886 2 29017405 (FAX)

6 6