- Koha - lists.katipo.co.nz

koha or mysql 5 bug?
by Wojciech Zatorski 07 Feb '06

07 Feb '06

Hello , i have small problem with mysql 5 (with mysql 4 no problemos)...: [Tue Feb 07 10:01:42 2006] [error] [client 10.0.1.5] DBD::mysql::st execute fail ed: Unknown column 'biblio.biblionumber' in 'on clause' at /opt/koha224_cide/int ranet/modules/C4/SearchMarc.pm line 392., referer: http://212.14.16.131:8002/cgi -bin/koha/search.marc/search.pl?type=intranet [Tue Feb 07 10:01:42 2006] [error] [client 10.0.1.5] DBD::mysql::st fetchrow_has href failed: fetch() without execute() at /opt/koha224_cide/intranet/modules/C4/ SearchMarc.pm line 394., referer: http://212.14.16.131:8002/cgi-bin/koha/search. marc/search.pl?type=intranet any idea why is problem with "ON" ?:> bye -- <wojciech(a)zatorski.net> tel. +48 509-855-239; GG: 1500861; Skype: zatorski http://www.Zatorski.Net -- I know not with what weapons World War III will be fought, but World War IV will be fought with sticks and stones. -- Albert Einstein

2 3

Help with z395
by Alfred 07 Feb '06

07 Feb '06

I am sure this is somewhere on a past list and I've probably looked right at it. My Debian Sarge Install seems good BUT z39.5 just does not seem to show up anywhere. It is started in the background under user www-data. How can I test it? Search via Koha? Maybe I am wrong in thinking that it should help me in adding books etc? It seems from what I have read so far is that it will pull info from other servers regarding a book that I Search or Add to my biblio this way I do not need to add all the information? Thanks Al

1 0

migrating to koha + overdue reports
by Köllhofer 06 Feb '06

06 Feb '06

Hi, Our library is currently using a german library system called BOND. We are not really satisfied with it and intend to migrate to KOHA 3.0 as we really like the new features (esp. koha-opac: amazon-api, spellchecking, suggest). I've heard that there is already a mailing list for german koha users but I couldn't find the archive. So I'm asking you guys here, is there anyone who has already converted the biblios & patron data from BOND to MARC or has any kind of clue? It would be great to save the time analysing the BOND db schema. I also had a question concerning the overdue reports. Will it be possible to automatically generate overdue reports once a week that can be mailed by post? I could only find the manual email notification in koha 2.x. Thanks for your help, Deniz

1 0

Subject-problem
by Unni Knutsen 06 Feb '06

06 Feb '06

The Oslo University College (Faculty of Journalism, Library and Information Science) has entered a partnership with a Kenyan NGO. In this connection we are currently testing out KOHA. Our partner has asked us to help in developing a library in a Nairobi slum area. An open source library system seems to be a good choice! We have set up the system and most things run smoothly. However, we have not been able to figure out how the *650 subfields can be retrieved in the OPAC and in the cataloguing program. We therefor ask for advise on how to establish a proper connection between different subfields, for example $a and $x. The way things are now, we can`t manage to retrieve subjects with information (text) in both $a and $x subfields, or in the $x subfield alone. Regards Unni Knutsen Høgskolen i Oslo p48/R423 22 45 26 56 -- Unni Knutsen Høgskolen i Oslo p48/R423 22 45 26 56

1 0

Subject-problem
by Unni Knutsen 06 Feb '06

06 Feb '06

The Oslo University College (Faculty of Journalism, Library and Information Science) has entered a partnership with a Kenyan NGO. In this connection we are currently testing out KOHA. Our partner has asked us to help in developing a library in a Nairobi slum area. An open source library system seems to be a good choice! We have set up the system and most things run smoothly. However, we have not been able to figure out how the *650 subfields can be retrieved in the OPAC and in the cataloguing program. We therefor ask for advise on how to establish a proper connection between different subfields, for example $a and $x. The way things are now, we can`t manage to retrieve subjects with information (text) in both $a and $x subfields, or in the $x subfield alone. Regards Unni Knutsen Høgskolen i Oslo p48/R423 22 45 26 56

1 0

Re: [Koha] Item Call Number
by Amzari Abu Bakar 03 Feb '06

03 Feb '06

Yup, I'm from KL, Malaysia. Are you from Malaysia too? If so, it is good. It is hard to find someone working on Koha here. I have 2-3 friends working on Koha too. They are all in different expertise. i.e: Linux, Server/Hardware, Networking, and Databases. But currently lack of Perl programmer and person who can figure out Koha Cataloging Modules. Currently, I am planning to setup Koha for several School and Special Libraries in Malaysia. As for now, in Malaysia, there are lack of library system within budget for these libraries. Actually there are some, but still lack of functionality and support. When I came over Koha, I got excited. I show to several friends, they also get excited with Koha. So , we have been working on Koha for several month on part time basis. Figure out on How to implement Koha in different type of libraries, OS, Network Environement and etc. If you are happen to be in Malaysia, maybe we can met sometimes, exchanging ideas and expertise. Anyway, Thanks for the tips. I'll try, if I can figure out on activating my ISBD view. Amzari Abu Bakar FingerClick Solutions --- Elanjelian Venugopal <tamiliam(a)gmail.com> wrote: > Hey Amzari, > > Are you writing from Malaysia? If you are, great! > Recently, I set up Koha at > a local library at KL, and translated their OPAC > into Tamil. > > Anyway, coming to your question: where do you want > to display the call > number - in the ISBD (which, I believe, you have not > activated), or in your > MARC view? Either way, you have to first activate it > at the subfield > section. I did it my going directly into the MySql > database. Look in the > data subfolder. > > elan. > > > On 02/02/06, Amzari Abu Bakar <amzari79(a)yahoo.com> > wrote: > > > > Hi all, > > > > Maybe this is a silly question, but I hope there > is > > somebody who can assist me. > > > > I try to catalog via Koha. Everything seems fine > but I > > didn't manage to get my call number display > correctly. > > I intend to use LC Call Number as my Local Call > > Number. Which Koha-MARC subfield should be link? > > > > maybe, those who are interested can check out my > > temporary setup koha site at > > > > http://mykoha.dyndns.org > > > > It will be online for several days, as I just host > it > > in my PC. Currently only 3 items cataloged. Try > search > > for "Linux". > > > > It will display 2 items found, and call number: > > QA76.76.O63 instead of QA76.76.O63 D688 2004. For > your > > information, I catalog QA76.76.O63 under tag 050a > and > > D688 2004 under tag 050b. My concern is, how can I > > display complete call number on my OPAC? > > > > *. Currently, my biblioitems.classification link > to > > field 050a. Which koha fields I should link to my > call > > number? > > > > Appreciate those who can help. Thank you in > advance. > > > > __________________________________________________ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam > protection around > > http://mail.yahoo.com > > _______________________________________________ > > Koha mailing list > > Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

3 2

Item Call Number
by Amzari Abu Bakar 03 Feb '06

03 Feb '06

Hi all, Maybe this is a silly question, but I hope there is somebody who can assist me. I try to catalog via Koha. Everything seems fine but I didn't manage to get my call number display correctly. I intend to use LC Call Number as my Local Call Number. Which Koha-MARC subfield should be link? maybe, those who are interested can check out my temporary setup koha site at http://mykoha.dyndns.org It will be online for several days, as I just host it in my PC. Currently only 3 items cataloged. Try search for "Linux". It will display 2 items found, and call number: QA76.76.O63 instead of QA76.76.O63 D688 2004. For your information, I catalog QA76.76.O63 under tag 050a and D688 2004 under tag 050b. My concern is, how can I display complete call number on my OPAC? *. Currently, my biblioitems.classification link to field 050a. Which koha fields I should link to my call number? Appreciate those who can help. Thank you in advance. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

3 3

Re: [Koha] Item Call Number
by KL Nasveschuk 02 Feb '06

02 Feb '06

Hello, I never tried the demo. I have been working with Koha for sometime but don't have it running in a production environment. I do have every record and copy loaded into Koha from 5 libraries at Wareham Public Schools in Wareham, MA. That's about 41,000 records all done by bulkmarcimport. Bulkmarcimport works very good, but for that many records could take 5-6 hours depending on the computer they are going to. You need to set up where things are going in advance, or some data will be missing. I'm not a librarian, but do have a Master's in network and database technology. I think it's a a great piece of software, but again I'm not a librarian. It does need to tweeked along the way to get it to do what you want it to do, but that's the nature of Open Source. You can take a look at my test site. http://www.wareham.mec.edu:8000 Kent N On Thu, 2006-02-02 at 12:42 -0500, Jennifer Wilms wrote: > Hello. I've been subscribing to this list because I am thinking of using > Koha for our library. If you have a free second today, could you send a > response to let me know how your experience has been going? I tried the > demo but it didn't work well at all - I had an awful time trying to upload > a MARC record. Have you tried this? Aside from your call number question, > has Koha worked well for you? > > Thanks in advance for your time. > > -- Jennifer Wilms, Library Manager > Cleveland Museum of Natural History > > > > At 11:42 AM 2/2/2006, you wrote: > >I have a similar problem with call numbers not showing where you would > >think they should be. Any suggestions on this. > > > >I'm using the NPL theme. > > > >Here is an example: > > > >Search for "whale" in OPAC returns hits. "Call number" for all hits is > >empty, however "Available at" has the branch with local call number in > >parentheses. This makes sense because the call number sound follow the > >branch. > > > >If I open an individual record from OPAC, the "Call number" is again > >missing and "Location" contains the branch with local call number in > >parentheses. This also makes sense. > > > > > >If I go in through kohaadmin and look at a particular record with copies > >"barcode" shows up correctly > >"Local call number" shows up correctly > >"homebranch" shows up correctly > >"holdingbranch" shows up correctly > > > >items.itemcallnumber is mapped to 952h. I populated tag 952h with the > >local call number when I loaded the data using bulkmarcimport. > > > >Try it: > > > >http://www.wareham.mec.edu:8000/ > >Search for "whale" > > > >#2) > >How can I deal with duplicate barcodes in different branches? I have > >branches that used to be independent now they are part of a system of 5 > >schools. If I go to check out a book, sometimes it will take the barcode > >from a different branch. > > > > > >Kent N > > > > > >On Thu, 2006-02-02 at 06:37 -0800, Amzari Abu Bakar wrote: > > > Hi all, > > > > > > Maybe this is a silly question, but I hope there is > > > somebody who can assist me. > > > > > > I try to catalog via Koha. Everything seems fine but I > > > didn't manage to get my call number display correctly. > > > I intend to use LC Call Number as my Local Call > > > Number. Which Koha-MARC subfield should be link? > > > > > > maybe, those who are interested can check out my > > > temporary setup koha site at > > > > > > http://mykoha.dyndns.org > > > > > > It will be online for several days, as I just host it > > > in my PC. Currently only 3 items cataloged. Try search > > > for "Linux". > > > > > > It will display 2 items found, and call number: > > > QA76.76.O63 instead of QA76.76.O63 D688 2004. For your > > > information, I catalog QA76.76.O63 under tag 050a and > > > D688 2004 under tag 050b. My concern is, how can I > > > display complete call number on my OPAC? > > > > > > *. Currently, my biblioitems.classification link to > > > field 050a. Which koha fields I should link to my call > > > number? > > > > > > Appreciate those who can help. Thank you in advance. > > > > > > __________________________________________________ > > > Do You Yahoo!? > > > Tired of spam? Yahoo! Mail has the best spam protection around > > > http://mail.yahoo.com > > > _______________________________________________ > > > Koha mailing list > > > Koha(a)lists.katipo.co.nz > > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > >_______________________________________________ > >Koha mailing list > >Koha(a)lists.katipo.co.nz > >http://lists.katipo.co.nz/mailman/listinfo/koha > > Jennifer Wilms, MLIS > Library Manager > Cleveland Museum of Natural History > 1 Wade Oval Drive, University Circle > Cleveland, OH 44106 > 216-231-4600 x3222 > library(a)cmnh.org > >

1 0

Issues with Koha 2.2.4 Installation on windows
by Juvenal Sahiri 02 Feb '06

02 Feb '06

I just sent this message to Amzari Abu Bakar amzari79(a)yahoo.com after reading the posting on upgrading from 2.2.4 to 2.2.5. May be you can help: Quote" In the course of trying to get my Koha 2.2.4 installation to work, I came across your posting on [Koha] Koha Installation Upgrade 2.2.4 to 2.2.5 Windows Amzari Abu Bakar amzari79 at yahoo.com Mon Jan 23 23:26:38 NZDT 2006 The problem I was trying to solve is that entering opac in the url gives me blank "page not found" while http://localhost:8080/ gives me the OPAC library visitor page where I can submit a search. But I never succeeded in getting the intranet page, no matter what I tried. Here is the content of my koha.config in etc and and httpd.config in apache. koha.config: database=blank224 hostname=localhost user=koha pass=koha intranetdir=c:\usr\koha224\intranet opacdir=c:\usr\koha224\opac kohaversion=2.2.4 opachtdocs=c:\usr\koha224\opac\htdocs\opac-tmpl intrahtdocs=c:\usr\koha224\intranet\htdocs\intranet-tmpl includes=c:\usr\koha224\intranet\htdocs\intranet-tmpl\default\en\includes ==== httpd.config in apache: Listen 127.0.0.1:8080 NameVirtualHost * <VirtualHost _default_:*> ServerAdmin webmaster@dummy-opac DocumentRoot /usr/koha224/opac/htdocs ScriptAlias /cgi-bin/ /usr/koha224/opac/cgi-bin/ ServerName opac ErrorLog logs/opac-error_log CustomLog logs/opac-access_log common SetEnv PERL5LIB "c:/usr/koha224/intranet/modules" </VirtualHost> <VirtualHost *> ServerAdmin webmaster@dummy-opac DocumentRoot /usr/koha224/opac/htdocs ScriptAlias /cgi-bin/ /usr/koha224/opac/cgi-bin/ ServerName opac ErrorLog logs/opac-error_log CustomLog logs/opac-access_log common SetEnv PERL5LIB "c:/usr/koha224/intranet/modules" </VirtualHost> <VirtualHost *> ServerAdmin webmaster@dummy-opac DocumentRoot /usr/koha224/intranet/htdocs ScriptAlias /cgi-bin/ /usr/koha224/intranet/cgi-bin/ ServerName intranet ErrorLog logs/intranet-error_log CustomLog logs/intranet-access_log common SetEnv PERL5LIB "c:/usr/koha224/intranet/modules" </VirtualHost> I changed these values to those in your posting on the discussion list except for 2.2.5 which I kept as 2.2.4 It didn't make a difference. Appreciate your help Best regards Juvenal __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

1 0

Re: Follett to Koha migration
by KL Nasveschuk 31 Jan '06

31 Jan '06

This is not in production use yet. It is not even on a production server. I believe Koha supports all tags however if you use tags in MARC records in the 9xx range that are not listed in the default setup you would have to create the tags first then upload your data using bulkmarcimport. Clean data. In Koha my itemtype is mapped to 300f tag. Later I found out that some of the schools never used the 300 tag at all. As a result itemtype for some records shows no icon, and if I searched by itemtype those would be excluded also. I would say that clean data is important. The process of going from Follett to Koha is difficult. I started from what Mike Reavey's wiki and added to that. For example, all the records that come out of Follett need to be funneled into a specific itemtype. For Koha, I used the 300f tag mapped to Koha biblioitems.itemtype. The itemtype information I got from the leader in the record (characters 06 and 07), then made a decision what itemtype they would fall under. I believe that you could map other fields to itemtypes as NPL has but, the data that I got out of Follett between schools was not the same from school to school. I had to pick something that I could rely on from school to school that said, for example, the record is a book or a sound recording, blah, blah.. How involved was everyone. The 5 schools are faced with the cost of upgrading to a web version of Follett (expensive), moving to a Windows server and ongoing support contracts. At this point I don't see any money now for any of that. That means they stay with what they have, which is 5 independent library systems running on 5 different servers. The librarians are are not particularly pleased to stay where they are and not upgrade. I offered to get this working as a prototype to demonstrate with their records, that there is an alternative. Some are more receptive to the idea than others. The bottom line is that there is no money for the upgrades. Another benefit of Koha is that OpenLDAP is used for authentication. Right now all students in Middle School and High School and all staff district wide have LDAP accounts that could also be used to access Koha. That in itself makes Koha perfect for this environment. There are roughly 2500 user accounts in LDAP already. We live in a "push button get banana world". If the icon a user clicks doesn't do exactly what it did last time, is the wrong color, or is on the right side of the screen instead of the left, there will be complaints. There will be objections because it isn't Follett. There will be objections no matter what happens. Nothing is written in stone, all I can do is demonstrate that it works, the accessibility is much better than the current Follett solution, the cost benefits across the board and the future savings. Hopefully, I can post my notes on installation and migration soon. I've done it enough times and am feeling more comfortable with migrating MARC records and what Koha requires. There are still some problems, but at this point nothing I can't resolve. In the mean time here's the URL to look at my demo site. It's been loaded with biblios and copies from 5 schools: http://www.wareham.mec.edu:8000 Kent N On Mon, 2006-01-30 at 10:37 -0600, Cory Jaeger wrote: > At this point I don't actually have a ton of procedure-specific questions. Just some general ones. > > 1) Does "biblios" include full MARC record info? 2) If so, would you say that having "clean" MARC records is important? 3) How automated was the process? 4) How happy was everyone involved with the results of the migration? 4) And perhaps most importantly, how do the librarian's like the Koha system compared to the Follett system? > > Cory A. Jaeger > Network Manager > D.C. Everest Area Schools > 6300 Alderson ST > Weston, WI 54476 > (715) 359-4221 x1393 > > >>> kent <klnasveschuk(a)klnconsulting.net> 1/30/2006 5:16:22 AM >>> > Hi Cory, > Sorry not to get back to you sooner. The version of Follett in use is > Version 5.00 Rev. 12-01-A Dec 19,2001 running on 5 separate Netware 5.1 > servers. I'm going to post my notes on the Internet shortly. I'll post > the URL so you can look at the site also. This is not the final version > to be used for production use. > > What I migrated was biblios and copies from 5 schools. Users come from > LDAP. > > Kent N > > On Fri, 2006-01-27 at 11:07 -0600, Cory Jaeger wrote: > > > > > > In your post at http://article.gmane.org/gmane.comp.misc.koha/5434 you mention that you have "migrated 41,000 records from Follett that runs on Netware to Koha..." > > > > We are evaluating the possibility of switching from Follett to Koha as well. Did you migrate from Circ+/Catalog+ or from the older (DOS based) Union catalog, or one of their other products? > > > > Cory A. Jaeger > > Network Manager > > D.C. Everest Area Schools > > 6300 Alderson ST > > Weston, WI 54476 > > (715) 359-4221 x1393 > > > > > > > > > > >

1 0