- Koha - lists.katipo.co.nz

Re: [Koha] Mellon Awards for Technology Collaboration
by BWS Johnson 09 Jun '06

09 Jun '06

Salve! >In fact, it's just as well, since from the developer's point of view, >we wouldn't want to accept a grant that couldn't benefit the whole >community, rather than just one company or person. > Um, that seems to be a large part of the spirit of this grant. They are looking for collaboration between non profits (say The Horowhenua Library Trust, The Nelsonville Public Library) and open source projects (Koha). The grant is not meant to go to a given library or non profit - it's meant to be invested into the open source software that organisation is utilising. See: "Following Trustee approval of the Award Committee's decision in mid-September, recipients will be asked to submit plans, developed in collaboration with the organization's leadership, for the use of the award to further the organization's engagement with open source development. It is expected that these plans will involve a one to two-year time horizon and include provisions for a follow-up report to the Program in Research in Information Technology." I just don't see why this would be so much different from how Koha started - luckily for us HLT and Katipo got together to make things happen. I would think that anyone who has invested in the project - like HLT and NPL (I'm sure there are others) would be a dead ringer for getting this grant. I also don't see how $25k or $100k reinvested in Koha could be bad for the other members of the community. I'd also argue that the world wide impact of Koha would really make it a strong contender for the $100k grant. The only wrench it would throw in the works would be that if someone ended up with the grant, they'd have to sort out the tax paperwork. Which is not all that big of a deal in the large scheme of things. Cheers, Brooke @ Hinsdale MA

1 0

Re: [Koha] Mellon Awards for Technology Collaboration
by BWS Johnson 09 Jun '06

09 Jun '06

Salve! >I recently saw that the Mellon Foundation is giving awards to groups >which have contributed significantly to Open Source projects which >help the typical constituency of the Mellon Foundation (this includes >libraries!). Hooray! This is totally a librarian project :D I am more than happy to submit a nomination, if it's okay with you all. I'd like to point out that they'll take multiple nominations, so it won't preclude other folks from nominating Koha if I nominate it. I intend to state how much money Koha has saved me as well as highlighting how very well suited Koha is to this award. It really does all of the stuff the foundation is looking for. There's a deadline of 4 August on this, so we should come together quickly to get something in. One final observation - the application calls for identifying 1-2 individuals most responsible for the project. This is one reason why it would be ideal to have more than one person nominate. We could identify more than 2 people that way :D (I wouldn't go past say 4, that way we don't look unorganised.) Because in my mind, the people that are most responsible for things and would be our best spokespeople would be Stephen Hedges Paul Poulain and Joshua Ferraro. I don't think Chris, Pate or any of the other folks that really laid the foundations for Koha are out of the question, of course. I do very much appreciate everyone elses efforts, but this application would force us to pick 2 people for the contact role so I feel very much pressed to do just that. I'm sure that the panel will realise that there are more than two people to contact and have contributed significant amounts to the project. Would you three be willing to be mentioned on the nomination petition as contacts? If none of you have the time, we really ought to find someone that can serve, but you all have always been there for me for the least of questions :D 1,000 words is very short, so this shouldn't take too long if you guys really want to nominate the project. Thanks so much for the excellent suggestion! I always knew that grants were out there that would be perfect for this project, but I never had the time to research those on top of my own library duties. Cheers, Brooke @ Hinsdale MA

2 1

Koha CD availability - Complimentary copies?
by John Siegel 08 Jun '06

08 Jun '06

Hello: I'm currently enrolled in the MLS program at the University of Maryland, and I am researching "open source" software. I was wondering if Koha was available on CD via a complimentary copy? Specifically, if a library only has a dial-up connection, is there a source that will send a complimentary copy of Koha through the mail to that particular library? Please feel free to respond to me off-list: johnsiegel76(a)yahoo.com. Sincerely, John Siegel __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

2 1

Continuing z39.50 madness
by Daehenoc 07 Jun '06

07 Jun '06

Hi all, I am still trying to get the biblio search working with this z39.50 daemon. I click on Catalogue, then 'Add biblio', then enter some data in the title and isbn fields, and click the Go button. The search fails to return any information and I click the 'Add New Biblio' button. From that screen I click on the 'z3950 search' and get the 'Z3950 Search Results' window up with the 'Still ?? requests to go' information bar. I find in the following files: #tail /usr/local/koha/log/z3950-daemon-20060519-0953.log DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 140. DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 143. DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 148. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 149. and in #tail /var/log/apache/koha/koha-error.log 220.239.73.84 - - [07/Jun/2006:22:01:43 +1000] "GET /cgi-bin/koha/z3950/search.pl?bibid=&random= HTTP/1.1" 200 1526 220.239.73.84 - - [07/Jun/2006:22:01:43 +1000] "GET /intranet-tmpl/default/en/includes/common-style.css HTTP/1.1" 200 7431 DBD::mysql::st execute failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at /usr/local/koha/intranet/modules/C4/Breeding.pm line 167. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Breeding.pm line 168. So I know the z3950 daemon is running and I walked through all the scripts that are used to call it and I know it is passed all the correct environment information: #cat /usr/local/koha/intranet/scripts/z3950daemon/z3950-daemon-options RunAsUser=www-data KohaZ3950Dir=/usr/local/koha/intranet/scripts/z3950daemon KohaModuleDir=/usr/local/koha/intranet/modules LogDir=/usr/local/koha/log It looks like the z3950 daemon doesn't know how to talk to the local mysql server - is there a place that I have to give the z3950 daemon a username and password for accessing the mysql database? Thanks, Greg

1 0

Mellon Awards for Technology Collaboration
by Daniel Kahn Gillmor 07 Jun '06

07 Jun '06

Hi good folks involved with Koha-- I hope this isn't just repeating something y'all have already beaten to death; But I searched the mailing list archive for references to this subject and couldn't find anything, so here goes: I recently saw that the Mellon Foundation is giving awards to groups which have contributed significantly to Open Source projects which help the typical constituency of the Mellon Foundation (this includes libraries!). There appears to be an opportunity for a decent-sized chunk of cash (25K or 100K USD) for eligible groups who've contributed staff/time/other resources for projects that Mellon approves of. From the looks of things (to me, but i'm unaffiliated with Mellon), Koha would be a good project. It's not clear to me exactly what kind of organization would need to apply to get one of the awards, however. You can find more information about the awards here: http://rit.mellon.org/awards/ At any rate, keep up the good work! If this helps any of the long-standing Koha contributors breathe a little easier financially, so much the better! happy hacking, --dkg

2 1

importing data from Alexandria to Koha
by skeewhiz＠aol.com 06 Jun '06

06 Jun '06

Hello Paul, Thank you for your response. I understand how to use Alexandria well enough to take care of my student's needs in our library, but I am definitely going to need our technician's help to test Koha. I may email you with a few further questions. I am glad to know that there is someone out there who has made a similiar transition. Thanks again. Shaw ________________________________________________________________________ Check out AOL.com today. Breaking news, video search, pictures, email and IM. All on demand. Always Free.

1 0

Searching problem in 2.2.5
by James Weinheimer 06 Jun '06

06 Jun '06

All, We have installed version 2.2.5 on a Linux machine, and everything is working well except some of the searching. The keyword searching works fine, but in the advanced searching, the author, title and subject always retrieves zero, although the keyword, series title, and everything else works fine. Could you help me? Thanks, James Weinheimer <mailto:j.weinheimer@aur.edu> j.weinheimer(a)aur.edu Director of Library and Information Services The American University of Rome via Pietro Roselli, 4 00153 Rome, Italy voice- 011 39 06 58330919 ext. 327 fax-011 39 06 58330992

1 0

Re: Importing records from Excel file
by thandu venkat narayana 06 Jun '06

06 Jun '06

Dear Koha Users, I am using koha 2.2.4 on windows xp machine, I want to import all my libreary books data from Excel file. It is posiple or not if any one know about this importig records please give information about this. Thanks Venkat __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

1 0

Re: [Koha] A barcode question
by Steven F.Baljkas 06 Jun '06

06 Jun '06

Tuesday, June 6, 2006 00:15 CST Dear Heidi, et al., I have actually been thinking about your question since last Tuesday when -- while editing/fixing records converted from an Excel spreadsheet into tagged MARC format using MARCEdit (an excellent tool BTW available off the LC MARC Records, Systems and Tools page at URL <http://www.loc.gov/marc/marctools.html>) -- it dawned on me that I was going to have a hell of a time trying to get barcodes into the right places once I had everything else with the records neatened up. (BTW Venkat, if you are reading mail on the general list, it is your records I have been working on; lots of problems I'll brief you on in due course.) In any case, the thought I had was that it might be possible to export the MARC tagged format into a delimited text format and then ***import that into Excel or another program that could generate field code automatically*** (I lack the ability to write scripts to perform such "automagical" feats, although I am sure that is another, probably better solution). I think Excel could do this. It would only be a matter of deciding what structure the barcodes would need to have and their length. Once the barcodes were added into the correct field, I think it would be possible to go back across the bridge as it were, export them again as delimited text, receive them into MARCEdit for checking and then convert them into true MARC. At the very worst, Heidi, I have spent a little more than a week working on the records for Venkat, and while I couldn't assign barcodes, I was reassigning a lot of accession numbers and correcting errors in call numbers, easily more than 6000 in the 12793 records edited. It is a pain to do it all manually, but it is feasible for one persistent cataloguer to add barcodes manually if need be. For the record, it would be great if Koha could automatically generate the barcodes and really super if it could know where to insert these in the MARC records (since it can export MARC it must somehow 'know'), e.g. 852 $p and 952 $p. Perhaps a customisable, Koha-flavour-based add-on to shoot for sometime in version 3.x.x? As for printout of barcodes, Heidi, wasn't there something on the listserv a week or two back, around the same time as some discussion on spine labels? I remember Joshua had reported on some progress a little while back. IIRC someone once commented that you could extract the data directly from the MySQL database to do what you are desiring, Heidi. That is, IIRC ... Anyway, HTH a little. Cheers, Steven F. Baljkas library tech at large Koha neophyte Winnipeg, MB, Canada ============================================================ From: "h lowe" <heidilowe(a)gmail.com> Date: 2006/06/05 Mon AM 10:14:13 CDT To: koha(a)lists.katipo.co.nz Subject: [Koha] A barcode question First of all, thank you for your time, and i apologize if this question has been asked before. I didn't find in the 2005 or 2006 archives, but I may certainly have missed it. But, here is my question: I am helping a smallish library (about 6,000 volumes) migrate to Koha. We already have an online catalog, so to speak, but no barcodes, circulation, or any of that. Basically our plan is to export the records from the old catalog into MARC format and import into Koha using the bulkmarcimport.pl . We would like the Koha to automatically generate barcodes and print them with our own printer. However, in the user guide it says we must have marc support turned off to automatically generate barcodes. Is this still true? We need to use MARC-21. So if we cannot automatically generate barcodes I would like to know, so that we can plan to buy pre-printed ones instead (if we must). Ideally, what we would like to do is have the barcodes print with the call # on the bottom, and be printed in call number order (like a shelf list of barcodes?) I would also like to know if this is possible. Thank you very much in advance, Heidi Lowe ============================================================

1 0

Volume information to items
by Lenora Oftedahl 05 Jun '06

05 Jun '06

Hi. I'm trying to figure out how to add the volume and/or year information to the item record. I'd like to show which barcode goes to which volume, but can't find the field to do this. Thanx. Lenora Vancouver, WA

1 0