- Koha - lists.katipo.co.nz

Data Export- Libsuite Software
by Sandeep Bhavsar 06 Jun '13

06 Jun '13

Dear All Has any one have exported the data from Libsuite software. I would like to import our Libsuite data to Koha ( MARC) -- * Regards * * * *Sandeep Bhavsar* B.com, M.Lib.I.Sc SET, M.Phil, American Library Association - FERA 2011 Librarian Dr. V N Bedekar Institute of Management Studies Thane (W) 400601 Mumbai INDIA Mobile : 9987049099 www.vpmthane.org

1 0

LDAP (Active Directory) Authentication broken after an upgrade to 3.12
by Mesfin Teshome 06 Jun '13

06 Jun '13

Hi Robin, It says invalid username or password. Mesfin ________________________________ From: "koha-request(a)lists.katipo.co.nz" <koha-request(a)lists.katipo.co.nz> To: koha(a)lists.katipo.co.nz Sent: Thursday, June 6, 2013 3:00 AM Subject: Koha Digest, Vol 92, Issue 10 Send Koha mailing list submissions to koha(a)lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request(a)lists.katipo.co.nz You can reach the person managing the list at koha-owner(a)lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..." Today's Topics: 1. Re: LDAP (Active Directory) Authentication broken after an upgrade to 3.12 (Robin Sheat) ---------------------------------------------------------------------- Message: 1 Date: Thu, 06 Jun 2013 11:06:35 +1200 From: Robin Sheat <robin(a)catalyst.net.nz> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] LDAP (Active Directory) Authentication broken after an upgrade to 3.12 Message-ID: <1370473595.12617.79.camel@zarathud> Content-Type: text/plain; charset="UTF-8" Mesfin Teshome schreef op wo 05-06-2013 om 13:13 [-0700]: > Active directory authentication in Koha is no more working after an > upgrade from Koha 3.10 to Koha 3.12. Here is my koha-conf.xml file When you say it doesn't work, what do you mean? It says "incorrect password", or it gives you an error? -- Robin Sheat Catalyst IT Ltd. ? +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D ------------------------------ _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 92, Issue 10 ************************************

1 0

Import holdings as a separate file to MARC bib. records
by Iming Chan 06 Jun '13

06 Jun '13

Dear all, I have successfully migrated MARC bib. records from our old system to Koha 3.12. The old system can only export holdings (items) in csv format, which I have successfully converted to MARC with Koha 952 tags (using MarcEdit). A few examples below: =LDR 00292nam a2200145Ia 45e0 =008 130605s9999\\\\xx\\\\\\\\\\\\000\0\und\d =952 \\$2ddc =952 \\$aCPL =952 \\$bCPL =952 \\$g7.95 =952 \\$o423.1 MACQ =952 \\$p30094000001781 =952 \\$tIn Manager's Office =952 \\$yBK =997 \\$c26 =LDR 00278nam a2200145Ia 45e0 =008 130605s9999\\\\xx\\\\\\\\\\\\000\0\und\d =952 \\$2ddc =952 \\$71 =952 \\$aMPL =952 \\$bMPL =952 \\$g72.50 =952 \\$oLS 025.32 ANG =952 \\$p30094000002920 =952 \\$yBK =997 \\$c51 =LDR 00278nam a2200145Ia 45e0 =008 130605s9999\\\\xx\\\\\\\\\\\\000\0\und\d =952 \\$2ddc =952 \\$aMPL =952 \\$bMPL =952 \\$g0.00 =952 \\$oPER 051 REA =952 \\$p10000032 =952 \\$t1999 Sept. =952 \\$yBK =997 \\$c78 =LDR 00277nam a2200145Ia 45e0 =008 130605s9999\\\\xx\\\\\\\\\\\\000\0\und\d =952 \\$2ddc =952 \\$aMPL =952 \\$bMPL =952 \\$g0.00 =952 \\$oPER 051 REA =952 \\$p10000033 =952 \\$t1999 Oct. =952 \\$yBK =997 \\$c78 Our old system Control Number is stored on 997$c tag and this number is also found in each of our holdings record. So it is logical to match holdings to bibliographic records using 997$c tag (instead of the ISBN 020$a or ISSN 022$a). So I have setup a new matching rule using 997$c in our Koha system. However, after I imported the holdings MARC file to the reservoir using the Staged MARC Import function, it informed me that no matches were found (when I have selected 997$c as the match point)! Have I missed something? Your assistance will be greatly appreciated. Iming ----- Iming Chan Translib Information Service Melbourne, Australia -- View this message in context: http://koha.1045719.n5.nabble.com/Import-holdings-as-a-separate-file-to-MAR… Sent from the Koha-general mailing list archive at Nabble.com.

3 5

Re: [Koha] LDAP (Active Directory) Authentication broken after an upgrade to 3.12
by Mesfin Teshome 06 Jun '13

06 Jun '13

Dear all, Active directory authentication in Koha is no more working after an upgrade from Koha 3.10 to Koha 3.12. Here is my koha-conf.xml file <ldapserver id="ADserverFQDN" listenref="ADserverFQDN"> <hostname>ldap://ADserverFQDN:389</hostname> <base>DC="domain",DC="domain"</base> <user>cn="######",DC="domain",DC="domain"</user> <pass>########</pass> <replicate>1</replicate> <update>1</update> <auth_by_bind>1</auth_by_bind> <principal_name>%s@"domain"</principal_name> <mapping> <firstname is="givenname"></firstname> <surname is="sn"></surname> <address is="postaladdress"></address> <city is="l"></city> <zipcode is="postalcode"></zipcode> <branchcode is="branch">CPL</branchcode> <userid is="samAccountName"></userid> <password is="userpassword"></password> <email is="mail"></email> <categorycode is="employeetype"></categorycode> <phone is="telephonenumber"></phone> </mapping> </ldapserver> What is this update about "7973 Allow for new type of LDAP authentication"? My koha-conf.xml was working fine before the upgrade. Mesfin

2 1

Utf-8 portguese special chars
by rafael 06 Jun '13

06 Jun '13

Hi everyone, I have a doubt about making koha display special chars in portugues. I have done the configurations in mysql and apache to utf-8 as described in the wiki. But what I find strange is that in the same screen there are chars that are correctly displayed, while others aren't. For example, in the image pasted in ( http://snag.gy/AkzLd.jpg ) I get the same portugues word "Preferência" displayed correctly and as preferÃªncia ... I have battled a lot with utf-8 in my life, but isn't it strange that in the same page exists this discrepancy? Thanks, Rafael

3 2

New SQL Reports - Records/ authorities added within time frame
by Cab Vinton 05 Jun '13

05 Jun '13

Enjoy. Cab Vinton Bib records added/deleted in time frame Developer: Nicole C. Engard, ByWater Solutions Module: Statistical (Catalog) Purpose: This report will show the bibs added/deleted at a branch in a time period. SELECT l.action, count(l.timestamp) AS 'bibs' FROM action_logs l LEFT JOIN borrowers p ON (p.borrowernumber=l.user) WHERE module='CATALOGUING' AND p.branchcode=<<Branch|branches>> AND date(l.timestamp) BETWEEN <<Between (yyyy-mm-dd)>> AND <<and (yyyy-mm-dd)>> AND l.info!='item' GROUP BY l.action Item records added/deleted in time frame Developer: Nicole C. Engard, ByWater Solutions Module: Statistical (Catalog) Purpose: This report will show the items added/deleted at a branch in a time period. IMPORTANT: Only works if you're logging cataloging actions. SELECT l.action, count(l.timestamp) AS 'items' FROM action_logs l LEFT JOIN borrowers p ON (p.borrowernumber=l.user) WHERE module='CATALOGUING' AND p.branchcode=<<Branch|branches>> AND date(l.timestamp) BETWEEN <<Between (yyyy-mm-dd)>> AND <<and (yyyy-mm-dd)>> AND l.info='item' GROUP BY l.action Authorities records added/deleted in time frame Developer: Nicole C. Engard, ByWater Solutions Module: Statistical (Catalog) Purpose: This report will show the authorities added/deleted at a branch in a time period. IMPORTANT: Only works if you're logging authority actions. SELECT l.action, count(l.timestamp) AS 'authorities' FROM action_logs l LEFT JOIN borrowers p ON (p.borrowernumber=l.user) WHERE module='AUTHORITIES' AND p.branchcode=<<Branch|branches>> AND date(l.timestamp) BETWEEN <<Between (yyyy-mm-dd)>> AND <<and (yyyy-mm-dd)>> GROUP BY l.action

1 0

call no on opac
by KLib Tech Support 05 Jun '13

05 Jun '13

Hi, I want to show call no on OPAC, can any one help with process?

2 1

KohaCon 13 Registration Page
by Keener, Nancy 05 Jun '13

05 Jun '13

We have been having some trouble with the registration page for KohaCon 13. So far 63 people have registered and have had confirmations sent. If you have registered after May 30th, it may take a few days for your confirmation to arrive. If you don't receive a confirmation, please email me directly, and I will make sure we have your information. The conference is shaping up nicely, and I think you will find it worth the trip. A call for sponsorship will be coming out shortly. I look forward to meeting you all. Nancy Keener Systems Librarian I.T.O.S.C. Chair KohaCon 13 Chair Washoe County Library System Reno, Nevada 775 327-8347 nkeener(a)washoecounty.us

2 1

search on opac: no results
by Samuel Desseaux 04 Jun '13

04 Jun '13

Hi, We have a bug with the opac since a few days. Whatever the search give no results. I don't know what happen and it seems very strange. I put here all the logs i have. The ownership of the files are ok but something is missing.... koha@tst-koha:~/var/log$ ls koha-error_log koha-opac-error_log koha-zebradaemon.err koha-zebradaemon-output.log README koha@tst-koha:~/var/log$ tail -f koha-opac-error_log [Tue Jun 04 15:55:32 2013] [error] [client 138.195.30.33] [Tue Jun 4 15:55:32 2013] suggestion: Odd number of elements in anonymous hash at /home/koha/kohaclone/C4/AuthoritiesMarc.pm line 972., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-search.pl?idx=&q=design [Tue Jun 04 15:55:32 2013] [error] [client 138.195.30.33] [Tue Jun 4 15:55:32 2013] suggestion: Odd number of elements in anonymous hash at /home/koha/kohaclone/C4/AuthoritiesMarc.pm line 972., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-search.pl?idx=&q=design [Tue Jun 04 15:55:32 2013] [error] [client 138.195.30.33] [Tue Jun 4 15:55:32 2013] suggestion: Odd number of elements in anonymous hash at /home/koha/kohaclone/C4/AuthoritiesMarc.pm line 972., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-search.pl?idx=&q=design [Tue Jun 04 15:55:32 2013] [error] [client 138.195.30.33] [Tue Jun 4 15:55:32 2013] suggestion: Odd number of elements in anonymous hash at /home/koha/kohaclone/C4/AuthoritiesMarc.pm line 972., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-search.pl?idx=&q=design [Tue Jun 04 15:55:32 2013] [error] [client 138.195.30.33] [Tue Jun 4 15:55:32 2013] suggestion: Odd number of elements in anonymous hash at /home/koha/kohaclone/C4/AuthoritiesMarc.pm line 972., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-search.pl?idx=&q=design [Tue Jun 04 15:55:32 2013] [error] [client 138.195.30.33] [Tue Jun 4 15:55:32 2013] suggestion: Odd number of elements in anonymous hash at /home/koha/kohaclone/C4/AuthoritiesMarc.pm line 972., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-search.pl?idx=&q=design [Tue Jun 04 15:55:32 2013] [error] [client 138.195.30.33] [Tue Jun 4 15:55:32 2013] suggestion: Odd number of elements in anonymous hash at /home/koha/kohaclone/C4/AuthoritiesMarc.pm line 972., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-search.pl?idx=&q=design [Tue Jun 04 15:55:32 2013] [error] [client 138.195.30.33] [Tue Jun 4 15:55:32 2013] suggestion: Odd number of elements in anonymous hash at /home/koha/kohaclone/C4/AuthoritiesMarc.pm line 972., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-search.pl?idx=&q=design [Tue Jun 04 15:55:32 2013] [error] [client 138.195.30.33] [Tue Jun 4 15:55:32 2013] suggestion: Odd number of elements in anonymous hash at /home/koha/kohaclone/C4/AuthoritiesMarc.pm line 972., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-search.pl?idx=&q=design [Tue Jun 04 15:55:38 2013] [error] [client 138.195.30.33] File does not exist: /home/koha/kohaclone/koha-tmpl/images, referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-search-history.pl ^C koha@tst-koha:~/var/log$ tail -f koha-zebradaemon.err 20130529 14:03:41 koha-zebra-ctl.bibecp: client (pid 17514) exited with 1 status 20130529 14:03:41 koha-zebra-ctl.bibecp: client (pid 17515) exited with 1 status 20130529 14:03:41 koha-zebra-ctl.bibecp: terminating too quickly, waiting 30 seconds 20130529 14:04:11 koha-zebra-ctl.bibecp: client (pid 17521) exited with 1 status 20130529 14:04:11 koha-zebra-ctl.bibecp: client (pid 17522) exited with 1 status 20130529 14:04:11 koha-zebra-ctl.bibecp: client (pid 17523) exited with 1 status 20130529 14:04:12 koha-zebra-ctl.bibecp: client (pid 17524) exited with 1 status 20130529 14:04:12 koha-zebra-ctl.bibecp: client (pid 17525) exited with 1 status 20130529 14:04:12 koha-zebra-ctl.bibecp: terminating too quickly, waiting 30 seconds 20130529 14:04:19 koha-zebra-ctl.bibecp: fatal: terminated ^C koha@tst-koha:~/var/log$ tail -f koha-zebradaemon-output.log 14:03:41-29/05 [fatal] lock file /home/koha/var/lock/zebradb/biblios/zebrasrv.pid [Permission denied] 14:03:41-29/05 [fatal] lock file /home/koha/var/lock/zebradb/biblios/zebrasrv.pid [Permission denied] 14:03:41-29/05 [fatal] lock file /home/koha/var/lock/zebradb/biblios/zebrasrv.pid [Permission denied] 14:03:41-29/05 [fatal] lock file /home/koha/var/lock/zebradb/biblios/zebrasrv.pid [Permission denied] 14:03:41-29/05 [fatal] lock file /home/koha/var/lock/zebradb/biblios/zebrasrv.pid [Permission denied] 14:04:11-29/05 [fatal] lock file /home/koha/var/lock/zebradb/biblios/zebrasrv.pid [Permission denied] 14:04:11-29/05 [fatal] lock file /home/koha/var/lock/zebradb/biblios/zebrasrv.pid [Permission denied] 14:04:11-29/05 [fatal] lock file /home/koha/var/lock/zebradb/biblios/zebrasrv.pid [Permission denied] 14:04:12-29/05 [fatal] lock file /home/koha/var/lock/zebradb/biblios/zebrasrv.pid [Permission denied] 14:04:12-29/05 [fatal] lock file /home/koha/var/lock/zebradb/biblios/zebrasrv.pid [Permission denied] koha@tst-koha:~/var/log$ ps -aux | grep zebra Warning: bad ps syntax, perhaps a bogus '-'? See http://procps.sf.net/faq.html koha 17633 0.0 0.3 99752 8224 ? S May29 0:00 zebrasrv -f /home/koha/etc/koha-conf.xml koha 29582 0.0 0.0 9616 908 pts/0 S+ 16:05 0:00 grep zebra koha@tst-koha:~/var/log$ Thank you for your help samuel

2 1

Debian Wheezy
by kazi 04 Jun '13

04 Jun '13

Dear Community, How r u all. I upgraded Squzee to Wheezy well with koha 3.10.5. But when I upgraded koha-3.10 to 3.12 , its all features loaded well, and when indexing (rebuild zebra) is run, it looks works well. But the thing is when I search on opac or staff interface, it does not show results. After that when it (search) does not work well, I did fresh install of Wheezy, still the same problem arises. Could anyone please help me out what the problem is on. With regards, Kazi -- View this message in context: http://koha.1045719.n5.nabble.com/Debian-Wheezy-tp5755997.html Sent from the Koha-general mailing list archive at Nabble.com.

3 2