- Koha - lists.katipo.co.nz

Re: [Koha] Problem in importing Patron Records
by Paul 05 Jun '12

05 Jun '12

At 03:09 PM 6/5/2012 +0530, Prajeesh wrote: >Dear all > >I tried to import a .csv file to my Koha installation (version 3.06.01.000) >and got the following errors. I have checked the Branch code and the >Category Code. It is give correct in the .csv file. Is there any bug >reported in this version regarding patron import. Please help me. The .csv >file is attached. The file was not attached. Did you use the default Koha format for dates as YYYY-MM-DD? From the errors, you appear to be using DD/MM/YYYY (but this could just be your sys pref for output.) Paul > Import Patrons Import results : > > - 0 imported records > - 0 overwritten > - 0 not imported because already in borrowers table and overwrite > disabled > - 2 not imported because they are not in the expected format > - 2 records parsed > - Back to Tools<http://192.168.1.2:8000/cgi-bin/koha/tools/tools-home.pl> > > Feedback: > > - Parsing upload file patron_import BPT2011 (copy).csv > - Content-Type : text/csv > - Content-Disposition : form-data; name="uploadborrowers"; > filename="patron_import BPT2011 (copy).csv" > - headerrow : > > Error analysis: > > - Header row could not be parsed > - Line 2 could not be parsed! > "BPT11/05" "Thomas" "Anilda " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" > "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/05" > - Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF; > surname: UNDEF). > "BPT11/05" "Thomas" "Anilda " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" > "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/05" > - Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF; > surname: UNDEF). > "BPT11/05" "Thomas" "Anilda " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" > "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/05" > - Line 3 could not be parsed! > "BPT11/06" "R" "Anjana " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" > "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/06" > - Line 3 Critical field "categorycode" missing (borrowernumber: UNDEF; > surname: UNDEF). > "BPT11/06" "R" "Anjana " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" > "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/06" > - Line 3 Critical field "branchcode" missing (borrowernumber: UNDEF; > surname: UNDEF). > "BPT11/06" "R" "Anjana " "Ms" "Kerala" 682015 "India" "MAIN" "BPT" > "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/06" > > > >-- >With Regards > >Prajeesh Bhaskaran > Mahatma Gandhi University Library >Kottayam, Kerala- 686 560 >http://kerala-lis.blogspot.com/. >_______________________________________________ >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://UltraMarine.ca>, <http://AandC.org> and <http://MarDoc.ca>

1 0

CAS Server/koha
by Samuel desseaux 05 Jun '12

05 Jun '12

Hi! I want to link koha to a CAS Server (only for the professionnal side). In the administration tool, it seems to be easy. But, does koha need specific perl modules? I've enabled mod-proxy on apache and add this part in the virtualhost <IfModule mod_proxy.c> ProxyRequests Off <Proxy *> Order Allow,Deny Allow from All AuthName "Acces Koha" AuthType CAS Require valid-user ***** * * * </Proxy> Beste regards samuel

2 1

Unable to input MARC field
by Stew Wilson 05 Jun '12

05 Jun '12

Hi Everyone, I'm very much a Koha newbie, so sorry if it's a silly question: I have made myself a customised MARC framework. During this process I accidentally deleted tag 260. So I added it again as a new tag and just copied the details from the default framework. So now when I go into the edit record screen of a book I can see tag 260, but I can't add any information to it. I can see a cursor in each subfield, but I can't type anything into it. I guess this is something to do with authorities, but sadly I have no idea if this is true, or how to fix it. Is anyone able to point me in the right direction? Cheers, Stew

1 0

sort by Popularity
by Howell, Lynda 04 Jun '12

04 Jun '12

Can anyone explain the basis for the sort by "Popularity" in the Koha OPAC? Is it based on checkout frequency? # of copies owned? User ratings? ...? Thanks! Lynda. -------------------------------- Lynda Howell Systems Librarian / Technologist Union Institute & University 62 Ridge Street, Suite 2 Montpelier, Vermont 05602 (802) 828-8618 lynda.howell(a)myunion.edu

3 3

Re: [Koha] OPAC Navigation/Browse Buttons
by Owen Leonard 04 Jun '12

04 Jun '12

On Sun, Jun 3, 2012 at 11:33 PM, Joel Harbottle <Joel.Harbottle(a)hotmail.com.au> wrote: > Hi Owen, > > Our Koha system is presently version 3.6.1 and we don't have the > 'OpacBrowseResults' system preference listed anywhere under OPAC or > Searching in System Preferences, could you provide some light on this > please? I'm including the Koha list in my reply since the conversation started there and this information might be useful to others. According to version control the browse feature should be in 3.6.1, but the system preference wasn't added until 3.6.5. So you should have the feature but you won't be able to turn it off until you upgrade. You're on 3.6.1 but you don't see the browse feature on OPAC detail pages? -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

2 2

National level workshop on Koha: 30 Jun - 01 July 2012 at GIPE, Pune (India)
by gipelibrary pune 04 Jun '12

04 Jun '12

Dear Professionals I am pleased to announce a "National level workshop on Koha: an Integrated Library Management Software" from Saturday - Sunday, 30 Jun and 01 Jul 2012. Purpose of this workshop is to familiarize participants with Koha, an open source software. Hands on Training during this workshop will provide all the technical know-how to the participants from the installation, customization, backup / restore, upgrade as well as running various modules of the software. Venue: Gokhale Institute of Politics and Economics (GIPE), Pune Workshop Timings: 10.00 am to 05.30 pm (30 Jun - 01 Jul 2012) Workshop Contents Introduction to LibLiveCD and Installation of LibLiveCD Koha Introduction & Features Overview Koha System Set-up Hands on training on Acquisitions, Cataloging, Circulation, Serial Control & OPAC MARC 21 Introduction Conversion of Existing Data to Koha Koha Multilingual Support Data Import and Export Koha backup/restore Koha upgrade OPAC Customization Koha System Administration Resource Persons Dr. Nanaji Shewale, GIPE, Pune Dr. Sunita Barve, NCRA, Pune Workshop Registration Fees - Rs. 1000/- only Registration Fees includes Workshop Kit on CD-ROM and Working Lunch. We will also assist the participants to migrate existing library to Data KOHA. Accommodation is available at extra cost. Payment: A Demand Draft / Cheque drawn on any Nationalized Bank in favour of “Gokhale Institute of Politics and Economics (GIPE)", payable at Pune should reach the following address on or before Monday, 22 Jun 2012. Dr Nanaji Shewale Koha Workshop Coordinator Gokhale Institute of Politics and Economics (GIPE) B M C C Road, Deccan Gymkhana Pune 411004 (India) Last Date for Registration: Monday, 18 Jun 2012. For any clarifications, you are welcome to contact me at 020 25679940, 0 9423531433 or gipelibrary(a)gmail.com or my colleague Ms Shilpa Kad at 0 9763740109. Registration Form Participants Name: -------------------------------------- Name and Address of the Organization: ---------------------------------------------------------- ---------------------------------------------------------- Email (Personal): ---------------------------------------- Email (official): ---------------------------------------- Mobile: ---------------------------------------- Telephone: ---------------------------------------- Do you require accommodation (at extra cost) during the workshop? Yes/No Demand Draft Number: ------------------------------------- Name of the Bank: ---------------------------------------- Amount: ------------------------------------------ Date: ------------------------------------------ Signature of the participant: Thanking you Dr Nanaji Shewale Librarian Gokhale Institute of Politics and Economics B M C C Road, Deccan Gymkhana Pune 411004 (India) T: 91 20 25679940 (Direct) M: 0 9423531433 T: 91 20 25654288, 25650287 Ext 401 Email: gipelibrary(a)gmail.com http://www.gipepune.com http://www.gipe.ac.in

1 0

Re: [Koha] koha-httpd.conf and cPanel
by Arslan Farooq 04 Jun '12

04 Jun '12

Hi Andi It is dedicated hosting (VDS/VPS). > > Hmm. But you are doing a manual install on some distro other than Debian or Ubuntu I suppose? I may not be able to help you with the manual installation. I did it a long time ago... and forgotten most of stuff. But I can tell you that on Debian the installation procedure is very easy and you won't have to configure virtual hosts. All you'll have to do is tell apache to listen to 8080 port (assuming the default 80 will be your OPAC). Anyway, I'm still new to this. You may want to wait for someone experienced to reply. They are busy in KohaCon however I think. Good Luck. arslan

2 1

Re: [Koha] Koha - Software error while adding or editing item records
by Subramanian Natarajan 04 Jun '12

04 Jun '12

Hi, Apologies that I missed your reply in the digested list emails, hence the delay in my reply. Thank you for your response. My answer to your questions below: By referring "bib" I meant bibliographic record. The result is the same either I download and save a MARC record from library of congress or I create a record using cataloging module. I tried to check the LC settings in Administration, but failed to find one. Where can I check the LC settings? My apache and mysql servers are set to work with UTF-8 by default. My mysqlconfig file: [root@pcmk-1 conf]# cat /etc/my.cnf [mysqld] datadir=/var/lib/mysql #socket=/var/lib/mysql/mysql.sock socket=/var/run/mysqld/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 default-character-set = utf8 character-set-server = utf8 skip-character-set-client-handshake [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [root@pcmk-1 conf]# Mysql status output: mysql> status -------------- mysql Ver 14.14 Distrib 5.1.61, for redhat-linux-gnu (x86_64) using readline 5.1 Connection id: 24788 Current database: Current user: root@dbsvr SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server version: 5.1.61 Source distribution Protocol version: 10 Connection: 192.168.1.33 via TCP/IP Server characterset: utf8 Db characterset: utf8 Client characterset: utf8 Conn. characterset: utf8 TCP port: 3306 Uptime: 14 days 2 hours 34 min 24 sec Threads: 1 Questions: 9515954 Slow queries: 0 Opens: 722 Flush tables: 1 Open tables: 64 Queries per second avg: 7.807 -------------- mysql> My apacheconfig file section with UTF-8 settings: # # Specify a default charset for all content served; this enables # interpretation of all content as UTF-8 by default. To use the # default browser choice (ISO-8859-1), or to allow the META tags # in HTML content to override this choice, comment out this # directive: # AddDefaultCharsetUTF-8 Following is the locale output from Scientific Linux 6.1 [root@pcmk-1 conf]# cat /etc/redhat-release Scientific Linux release 6.1 (Carbon) [root@pcmk-1 conf]# locale LANG=en_US.UTF-8 LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME="en_US.UTF-8" LC_COLLATE="en_US.UTF-8" LC_MONETARY="en_US.UTF-8" LC_MESSAGES="en_US.UTF-8" LC_PAPER="en_US.UTF-8" LC_NAME="en_US.UTF-8" LC_ADDRESS="en_US.UTF-8" LC_TELEPHONE="en_US.UTF-8" LC_MEASUREMENT="en_US.UTF-8" LC_IDENTIFICATION="en_US.UTF-8" LC_ALL= [root@pcmk-1 conf]# I am not very sure how to check the settings of UTF-8 for perl. I have followed the Koha installation manuals and I am not using Zebra server. More over, Koha gives the same error message while I try to check in or check out a book. The error message again: " Can't call method "subfield" on an undefined value at /usr/share/koha/lib/C4/Biblio.pm line 2992. " Thank you once again for your help. I can provide more details if you need. Please help. Subramanian Natarajan <gurujimani(a)yahoo.com> > Koha server is installed on Scienfic Linux 6.1 > > I ?have downloaded the bib records from LC using z39.50 gateway. I am getting the following error when I tried to add an item to the newly created bib record. What bib records? (ISBNs? Other search terms?) What are your LC settings in Administration? Are you sure Scienfic Linux 6.1 is configured correctly, particularly for UTF-8 on apache, perl and mysql? Hope that helps, -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op. http://koha-community.org supporter, web and library systems developer. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire (including development) at http://www.software.coop/

1 0

Perl Module issues
by Marty 03 Jun '12

03 Jun '12

After succesfully (and without any problems) having upgraded koha to 3.8.0 from 3.06.04 on my dual booted laptop I attempted to do the same on the main machine, both running Debian Squeeze. Doing the regular $ ./koha_perl_deps.pl -u -m it came up with the following list (and an error, but that does not seem to be an issue); [Sun Jun 3 12:17:35 2012] koha_perl_deps.pl: Use of uninitialized value $version in numeric lt (<) at /usr/local/share/perl/5.10.1/Modern/Perl.pm line 25. [Sun Jun 3 12:17:35 2012] koha_perl_deps.pl: Use of uninitialized value $version in numeric lt (<) at /usr/local/share/perl/5.10.1/Modern/Perl.pm line 25. Installed Required Module is Module Name Version Version Required -------------------------------------------------------------------------------------------- DateTime 0 * 0.58 Yes DateTime::Event::ICal 0 * 0.08 Yes DateTime::Format::DateParse 0 * 0.04 Yes DateTime::Format::ICal 0 * 0.09 Yes DateTime::Set 0 * 0.28 Yes DateTime::TimeZone 0 * 1.26 Yes XML::RSS 0 * 1.31 Yes -------------------------------------------------------------------------------------------- Total modules reported: 7 * Module is missing or requires an upgrade. So I start doing the cpan magic, and while initially this list was getting shorter (I was down to 3 or 4 missing modules) it suddenly returned to the 7 missing modules. Huh? I installed/updated all 7 modules, but it does not seem to matter; Trying to do a sudo cpan DateTime::Set for example, results in DateTime::Set is up to date (0.31), and so for all the modules; they are either the required version or higher. The only module that did not install easily was XML::RSS, which I had to install with -force $ ./koha_perl_deps.pl -u -m keeps insisting that they are missing or require an upgrade... Trying with the courage of the desperate to run $ perl Makefile.PL --prev-install-log /usr/share/koha/misc/koha-install-log results in the following: Can't locate Data/OptList.pm in @INC (@INC contains: /home/biblios/Downloads/koha-3.8.0 /etc/perl /usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl .) at /usr/local/share/perl/5.10.1/Class/Load.pm line 8. BEGIN failed--compilation aborted at /usr/local/share/perl/5.10.1/Class/Load.pm line 8. Compilation failed in require at /usr/local/share/perl/5.10.1/DateTime/TimeZone/Local.pm line 9. BEGIN failed--compilation aborted at /usr/local/share/perl/5.10.1/DateTime/TimeZone/Local.pm line 9. Compilation failed in require at /usr/local/share/perl/5.10.1/DateTime/TimeZone.pm line 13. BEGIN failed--compilation aborted at /usr/local/share/perl/5.10.1/DateTime/TimeZone.pm line 13. Compilation failed in require at /home/biblios/Downloads/koha-3.8.0/C4/Context.pm line 107. BEGIN failed--compilation aborted at /home/biblios/Downloads/koha-3.8.0/C4/Context.pm line 107. Compilation failed in require at /home/biblios/Downloads/koha-3.8.0/C4/Installer.pm line 24. BEGIN failed--compilation aborted at /home/biblios/Downloads/koha-3.8.0/C4/Installer.pm line 24. Compilation failed in require at Makefile.PL line 31. BEGIN failed--compilation aborted at Makefile.PL line 31. Now I am at a loss what could be wrong or where to look. Any ideas are most welcome. Thanks, Marty

1 0

KohaCon12 conferees: please send news!
by Daniel Grobani 03 Jun '12

03 Jun '12

O you fortunate ones attending KohaCon12, Please remember those left behind and send your accounts of what we missed for publication in the June newsletter. Thanks from your community newsletter editor, Daniel Grobani

1 0