December 2003 - Koha - lists.katipo.co.nz

List of what each field in the various tables do
by Freddie Cash 21 Apr '04

21 Apr '04

We're just starting out with Koha 2.0 to see if it could be used as a replacement for Follett. However, we are running into a few snags that should be fairly simple to fix. Our major snag is lack of documentation for the internals of Koha. For instance, is there a description of the various database tables, and what each field is used for? This would make mapping fields to MARC fields much simpler. We're running into problems with our mappings, especially with the distinction between items and biblioitems, for instance. Is this kind of low-level documentation available anywhere?? -- Freddie Cash District HelpDesk / Network Admin fcash(a)sd73.bc.ca helpdesk(a)sd73.bc.ca (250) 377-HELP [(250) 377-4357]

5 4

Can't add member to Koha
by Greg Prapat 07 Jan '04

07 Jan '04

Dear Koha mailing list members, Anyone knows how to fix the error "Premature end of script headers: newmember.pl". Thank you. Happy new year 2004, Greg

2 2

Z39.50client won't give up searching
by Edward M. Corrado 07 Jan '04

07 Jan '04

I installed Koha 2.0.0RC1 the other day. I decided to use the Z39.50 search feature to add a book. The first search I tried apparently didn't find anything, however I was able to find items by Eric Raymond when I searched for him by name, so it does manage to search the US Library of Congress (The only Z39.50 server I have is the default Library of Congress one). However, I see to have an issue with the other searches I tried - they client won't give up searching for them (excerpts from log file below). It has tried many (hundreds?) of times for each search over the last 30 minutes and is still trying. When I killed the daemon and started it back up, it kept on trying the same searches. Is there a way to tell the client to give up searching for something if it isn't found after X amount of attempts? Edward Corrado BTW: I have no idea how the z39.50 client decided to search for me (but I did have only one record in the database at the time of this z39.50 search and it had me as the author. Processing isbn="0131411551" at Library of Congress z3950.loc.gov:7090 voyager USMARC (11 forks) z3950.loc.gov:7090 done. Library of Congress ==> answered : no records found at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 168. Processing isbn="0131411*" at Library of Congress z3950.loc.gov:7090 voyager USMARC (11 forks) z3950.loc.gov:7090 done. DBD::mysql::st execute failed: Lost connection to MySQL server during query at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 123. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 124. Library of Congress ==> USMARC at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 156. Library of Congress ==> answered : no records found at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 168. Processing isbn="0131411*" at Library of Congress z3950.loc.gov:7090 voyager USMARC (11 forks) z3950.loc.gov:7090 done. Library of Congress ==> USMARC at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 156. starting loop Library of Congress ==> answered : 10000 found at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 170. Library of Congress ==> USMARC at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 156. Library of Congress ==> USMARC at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 156. Library of Congress ==> answered : no records found at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 168. Processing author="Corrado, Edward" at Library of Congress z3950.loc.gov:7090 voyager USMARC (11 forks) z3950.loc.gov:7090 done. Library of Congress ==> answered : no records found at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 168. Processing isbn="0-13-141155-1" at Library of Congress z3950.loc.gov:7090 voyager USMARC (12 forks) z3950.loc.gov:7090 done. starting loop Library of Congress ==> USMARC at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 156. Library of Congress ==> answered : no records found at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 168. Processing author="Corrado, Edward" at Library of Congress z3950.loc.gov:7090 voyager USMARC (11 forks) z3950.loc.gov:7090 done. DBD::mysql::st execute failed: Lost connection to MySQL server during query at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 123. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 124. Library of Congress ==> USMARC at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 156. Library of Congress ==> answered : no records found at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 168. Processing isbn="0-13-141155-1" at Library of Congress z3950.loc.gov:7090 voyager USMARC (12 forks) z3950.loc.gov:7090 done. starting loop Library of Congress ==> USMARC at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 156. Library of Congress ==> USMARC at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 156. Library of Congress ==> answered : no records found at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 168. Processing author="Corrado, Edward" at Library of Congress z3950.loc.gov:7090 voyager USMARC (11 forks) z3950.loc.gov:7090 done. Library of Congress ==> answered : no records found at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 168. Processing isbn="0-13-141155-1" at Library of Congress z3950.loc.gov:7090 voyager USMARC (12 forks) z3950.loc.gov:7090 done. starting loop Library of Congress ==> USMARC at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 156. Library of Congress ==> answered : no records found at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 168. Library of Congress ==> USMARC at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 156. Library of Congress ==> answered : no records found at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 168.

4 10

RE: [Koha] Koha development work
by Davoodifar, H. Sam (EDU-E&Y) 05 Jan '04

05 Jan '04

Greetings, We have just installed Koha on our server and trying to get it running. As a new user, I'm looking for its manual. I know that there's one on the Koha's site but not very useful...; Thanks, __Sam > -----Original Message----- > From: Pat Eyler [SMTP:pate@eylerfamily.org] > Sent: 2003-Dec-23 12:31 PM > To: koha(a)lists.katipo.co.nz > Subject: [Koha] Koha development work > > Since we're bandying about our desires for new Koha features, this seems > like a good time and place to ask for ideas of what you would like to see > added to (or changed in) Koha in the future. Ideally, I'd like to see > ideas submitted one per email, with a brief explanation. Replies to that > email to clarify, amend, support, or criticise (politely please) feature > requests are also welcome. > > thanks, > -pate > > Pat Eyler > Kaitiaki/manager migrant Linux sys admin > the Koha project ruby, shell, and perl geek > http://www.koha.org http://pate.eylerfamily.org > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha

5 6

serials module
by Regula Sebastiao 05 Jan '04

05 Jan '04

hi all thomas and i being librarians working with other systems than koha, but having a personal interest in the open source project, sat together this autumn and we discussed what features should go into a serials module. we posted our thoughts on the wiki http://www.saas.nsw.edu.au/wiki/index.php?page=KohaSerialsModule i think it would be a great if that feature coul figure in an enlarged koha as soon as possible :-) for any further questions please don't hesitate to contact one of us cheers from switzerland regula and thomas ________________________________________________________________________ Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html

2 1

Re: [Koha] Koha development work
by Owen Leonard 05 Jan '04

05 Jan '04

> Since we're bandying about our desires for new Koha features, this seems > like a good time and place to ask for ideas of what you would like to see > added to (or changed in) Koha in the future. Hoo boy! I'll start: I'd like to see a 'shopping cart'-like system for the OPAC: add individual search results to your 'cart', and when you're done you can review the list, email it, or print it out in various formats (like bibliographic-citation or full MARC). -- Owen ---- Nelsonville Public Library

2 1

RE: [Koha] Koha development work
by Owen Leonard 02 Jan '04

02 Jan '04

> > we have an > > IRC channel if you'd like to talk to the > > developers directly. > > > More information on the IRC channel, please? Indeed! I always have to do a Google search when I lose the address. I'm not sure if it's posted somewhere prominent. Here it is: irc://irc.katipo.co.nz:6667 And here's the address of the IRC logs: http://www.haz.cmsd.bc.ca/cgi-bin/kohalog.pl ...which isn't working for me at the moment, but is probably just down temporarily. IRC can be a great way to get a question answered *if* you can catch the right people :) With some developers in New Zealand, and some in Europe, it can be hard for someone in the U.S. to catch them during working hours. -- Owen

3 2

Re: [Koha] Z39.50client wont give up searching
by baljkas＠mb.sympatico.ca 31 Dec '03

31 Dec '03

Tuesday, December 30, 2003 17:35 CST Hi, Edward, About your message, 2 points > [snip] (The only Z39.50 server I have is the default Library of > Congress one). [snip] You might also want to try registering for free Z39.50 access via the National Library of Canada's Amicus service. As many of the same books are published simultaneously in Canada and the U.S., you will find many good MARC21-compliant records in our national database, too. Plus, sometimes, it can be a little easier to access, and there is the possibility of batching records for download. Find out more at URL <http://www.nlc-bnc.ca/7/2/g2-400-e.html> . You will want to use the Amicus registered service; don't worry - it won't cost you anything, is usually set up in under 24 hours and they'll never bother you with anything more than a very occasional new services/upgrade/planned downtime notice. Regarding your question > [snip] Is there a way to tell the client to give up searching for > something if it isn't found after X amount of attempts? IIRC it isn't a number of attempts but an amount of time setting you can choose. I've used a parallel search tool provided by our provincial library services branch and when it can't find things we often get a time-out type message (the time limit on trying is preset for all external users). Perhaps someone else on the list will know how to define this to help you stop the daemon from continuing ad absurdum. Cheers, Steven F. Baljkas library tech at large Winnipeg, Manitoba, Canada

2 1

RE: [Koha] Koha development work
by Mohamed Amin 25 Dec '03

25 Dec '03

hi all What about adding the facility to export MARC records from Koha, one thing else may be making Koha to act as a Z3950 server, so systems like Koha can integrate with each others and exchange records automaticaly. Mohamed Amin Network Administrator National Training Institute Egypt >Since we're bandying about our desires for new Koha features, this seems >like a good time and place to ask for ideas of what you would like to see >added to (or changed in) Koha in the future. Ideally, I'd like to see >ideas submitted one per email, with a brief explanation. Replies to that >email to clarify, amend, support, or criticise (politely please) feature >requests are also welcome. > >thanks, >-pate > >Pat Eyler >Kaitiaki/manager migrant Linux sys admin >the Koha project ruby, shell, and perl geek >http://www.koha.org http://pate.eylerfamily.org > >_______________________________________________ >Koha mailing list >Koha(a)lists.katipo.co.nz >http://lists.katipo.co.nz/mailman/listinfo/koha _________________________________________________________________ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail

2 1

Migration Branch Wish
by Joshua Ferraro 25 Dec '03

25 Dec '03

One idea I recently had would be to have a migration branch in CVS where folks can post/work-on migration scripts. It might ease the migration process for some libraries--especially if they are migrating from the same system that a Koha library did. Joshua

1 0