- Koha - lists.katipo.co.nz

Web Installer: authorities_normal_marc21 incorrect integer value & mysql 5.6 warning message on password
by Victor Pang 15 Aug '13

15 Aug '13

I just ran through Step 3 of Web Installer and I encountered this error in authorities_normal_marc21.sql: ERROR 1366 (HY000) at line 272: Incorrect integer value: '' for column 'linkid' at row 1 and peeking into that file is this error SQL statement line: INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES How do I correct this error? I am using MySQL 5.6.13 on Mac OS X 10.8.3. Also, MySQL 5.6.x now warns users when you enter your password on the command line via "-p<password>" or "-p" and prompted: Warning: Using a password on the command line interface can be insecure. So I got all these warnings for every SQL files imported. In fact, when the Web Installer imports the database structure, it ended with the warning message and I couldn't continue without starting from Step 1 again. Luckily, the Web Installer knows when it stops and let me continue to set the basic default settings. -- View this message in context: http://koha.1045719.n5.nabble.com/Web-Installer-authorities-normal-marc21-i… Sent from the Koha-general mailing list archive at Nabble.com.

2 2

(no subject)
by Richard Maileseni 14 Aug '13

14 Aug '13

Hi My name is Richard. Im an IT student from the island of Tonga currently studying in NZ, Im working on a project which is generally to do a migration of our current library system from spidus to Koha. Just wondering if any of yous have done something along that line and if you could give me pointers into how i could do this,. Thanks!! -- Richard W. Maileseni Mob: 027-934-2039 PH: 042367222 Email: lisiate.maileseni(a)tti.to facebook: www.facebook.com/rmaileseni scype: ma_richie ~\\~

1 0

Putting zebrasrv.pid in the "/etc/rc.local" file in 'Single Installation Mode" (Was Re: Koha 3.10.x Centos installation document)
by Andi Sugandi 14 Aug '13

14 Aug '13

Hi, On Fri, Mar 22, 2013 at 7:36 PM, volkan sonmez <volkansonmez(a)sdu.edu.tr> wrote: [...] > Koha wiki link : http://wiki.koha-community.org/wiki/Koha_3.10_on_Centos_6.3_x86_64 I had read the English version here: http://wiki.koha-community.org/wiki/Koha_3.10_on_Centos_6.3_x86_64_en Great thanks for this tutorial. :) I have a question in section: "In order to run zebra services at system startup add lines below to “/etc/rc.local” file": How to put "zebrasrv.pid" in the "/etc/rc.local" file in 'Single Installation Mode" (for example in: ~/public_html/koha)? AFAIK, the "zebrasrv.pid" files usually exist in: ../var/lock/zebradb/authorities/zebrasrv.pid , and ../var/lock/zebradb/biblios/zebrasrv.pid Thanks in advance. Best regards, -- Andi Sugandi.

1 0

Call for news for the August newsletter
by Daniel Grobani 13 Aug '13

13 Aug '13

Dear Koha kommunitarians, I'm harvesting news for this month's newsletter. Please send me by the 20th anything you think your fellow community members might like to know about. "News" can be as short as a sentence or as long as a paper. I especially encourage you to send me a line or two for the gossip/society column about what you're currently working on. And if you know of a go-live not announced on the list, please be sure to let me know about it. Thanks, Daniel Grobani

1 0

koha as a ready-made VM appliance?
by Manos PETRIDIS 13 Aug '13

13 Aug '13

I wonder if there would be interest out there for a ready-made koha VM appliance, available for customers of the main computing clouds (Amazon, Microsoft, et al). It came to me that in order for a library to cater for a circulation of over 10 million transactions, it would have to service a lot of branches, be equally accessible by all as far as throughput is concerned, and be able to gracefully handle transient loads. I use koha myself, running as a VM running on Oracle VM Virtualbox, but this is hardly scalable. A cloud implementation seems to fit the bill. n fact it could be a godsend for small libraries that can't invest even in the smaller koha local set-up. Perhaps someone could even "sell" his/her expertise in setting-up koha and supporting libraries under this scheme. The software may be open and free, the know-how is not. So, has anyone tried it so far? Kind regards, Manos PETRIDIS Athens , Greece

3 4

Heritage to Koha
by Barry Cannon 13 Aug '13

13 Aug '13

Hello, We are moving from a Heritage system to Koha and wondering if anyone has any experience with migrating the Circulation and Loans data? The Bibs and items etc are fine but the circulation data is proving tedious. Any tips/suggestions would be great. Thanks Barry

1 0

koha newer versions and digital library systems & institutional repositories
by schnydszch 13 Aug '13

13 Aug '13

Hi koha users and developers!who have tried here newer versions of koha ils integrated into dls or IRs? Can you please relate your experience or lead me to information how to do it. koha greenstone integration is 3.2 version of koha.dspace i don't know much yet.thanks in advance! -- View this message in context: http://koha.1045719.n5.nabble.com/koha-newer-versions-and-digital-library-s… Sent from the Koha-general mailing list archive at Nabble.com.

1 0

looking for report help
by Nicole Engard 12 Aug '13

12 Aug '13

I'm wondering if there is a way to find bibs that have multiple items attached where the items are not all of the same type? I think there are some nested queries involved in this - but I'm not really sure where to start. Thanks Nicole

2 2

Re: [Koha] buggy issue with 785 field display
by Hernandez, Heather 12 Aug '13

12 Aug '13

(Forgot to reply to the list as well! Sorry! --h2 ---------- Forwarded message ---------- From: Hernandez, Heather <heather_hernandez(a)nps.gov> Date: Mon, Aug 12, 2013 at 8:34 AM Subject: Re: [Koha] buggy issue with 785 field display To: Haik Zargaryan <haikzargaryan(a)yahoo.com> Hi, Haik-- Haik's record is coded: > 785 16$t Proceedings of Physics$w123456 > 785 16$t Biological Journal $w12345 > We found the same problem, and follow the instructions in the CONSER Editing Guide, by using a 580 note with the combination of 785 16 fields, since the first indicator "1" in the 785 field suppresses the note from being generated from the 785 field in the presence of a 580 field. From the CONSER Editing Guide (785 section): 6 Split into … and … When this indicator value is used, input a 580 note. With second indicator 6, some systems do not generate notes from field 785 so the use of a 580 field is necessary. The first indicator value in field 785 is set to "1." For further information, see field 580<https://desktop.loc.gov/template.htm?view=document&doc_action=setdoc&doc_ke…> . 245<https://desktop.loc.gov/template.htm?view=document&doc_action=setdoc&doc_ke…>00 Hospital practice. 580<https://desktop.loc.gov/template.htm?view=document&doc_action=setdoc&doc_ke…>## Split into: Hospital practice (Hospital ed.), and: Hospital practice (Office ed.) 785 16 $t Hospital practice (Hospital ed.) $x 8755-4542 $w (DLC)sn 84001694 785 16 $t Hospital practice (Office ed.) $x 8750-2836 $w (DLC)sn 84037744 245<https://desktop.loc.gov/template.htm?view=document&doc_action=setdoc&doc_ke…>00 Clinical and experimental hypertension. 580<https://desktop.loc.gov/template.htm?view=document&doc_action=setdoc&doc_ke…>## Split into: Clinical and experimental hypertension. Part A, Theory and practice, and: Clinical and experimental hypertension. Part B, Hypertension in pregnancy. 785 16 $t Clinical and experimental hypertension. Part A, Theory and practice $x 0730- 0077 $w (DLC) 83646221 785 16 $t Clinical and experimental hypertension. Part B, Hypertension in pregnancy $x 0730-0085 $w (DLC) 83646622 This is an example of a title split in our catalog tagged with the 580/785 16 combo: http://keys.bywatersolutions.com/cgi-bin/koha/opac-detail.pl?biblionumber=1… Hope this is helpful! Cheerio, heather ~~~~~~~~~~~~~~ Heather Hernandez Technical Services Librarian Cultural Resources and Museum Management Division San Francisco Maritime National Historical Park heather_hernandez(a)nps.gov 415-561-7032 (voice) 415-556-3540 (fax) http://www.nps.gov/safr/historyculture/library-collections.htm "The sailor does not pray for wind, he learns to sail."--Gustaf Lindborg

1 0

3.14 RM update #2 posted
by Galen Charlton 12 Aug '13

12 Aug '13

Hi, I have posted my second formal update on the status of 3.14 to: http://koha-community.org/koha-3-14-release-managers-update-2/ 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

1 0