November 2002 - Koha - lists.katipo.co.nz

he panui Koha [30 Nov 2002]
by Pat Eyler 30 Nov '02

30 Nov '02

he panui Koha 30 November 2002 Kia ora, We've just finished celebrating Thanksgiving here in the States, and I think that we've got a lot of things to be thankful for right here in the Koha project. # From the Kaitiaki It's almost the end of November, and the holidays are nearly upon us. It looks like we're going to be able to ring in the New Year with a better, faster, more capable Koha -- and with many more libraries using it. More and more people recognize Koha, and we're getting more press than ever before. It looks like we'll be featured in the Linux Journal early in 2003, and may have a few more articles after that. (If you're at all interested in writing an article about Koha, please feel free to contact me at katiaki(a)koha.org -- I'd be happy to talk with you.) Development There have been several big events on the development side of Koha this week. Paul has just released Koha 1.3.2, the next alpha version of the forthcoming 2.0 series. This release features: * Many improvments in MARC management from 1.3.1. * acquisition.simple now works : you can upload marc files in a breeding farm. When you search for an ISBN/ISSN in the acquisition screen, if you choose the "New biblio" option and the biblio is in the breeding farm, it's automatically retrieved and can be modified. * installer now install marc21 in english or unimarc in french datas. * marc parameters complete documentation : see http://www.saas.nsw.edu.au/wiki/index.php?page=UserDoc If the 2.0 release sounds exciting to you and you've got some MARC, Perl, or HTML background, please consider jumping in and helping with 2.0 development. There are opportunities for people of all skill levels. Just because we're getting ready to roll 2.0 out the door doesn't mean we plan on slowing down. We've already got our eyes on the horizon. Steve Tonnesen has agreed to take on the role of 2.1/2.2 release manager, this will be a big task as we start to build new functionality onto the MARC base which Paul is building with 2.0. We've also released two Releases For Comment (RFCs): the first is for a serials module, the second is for a 'foraging OPAC'. A serials module is one of the big features missing from Koha at this point. Once we've gotten a good idea of what we need to have in this module, we'll be able to start developing it. The 'foraging OPAC' is an interesting interface into the catalog, imagine browsing through the collection as though you were walking through the library. Another analog would be a Yahoo-like hierarchical view of the collection where the patron would be able to navigate through categorizations to find a set of books related to what she wanted to find. Community A big event in the world of Koha this week has been the dual face lifts at HLT. Not only did they complete the renovation of their main library, but they've moved to a new set of templates for their Koha OPAC. You can see their beautiful new interface at http://opac.library.org.nz -- congratulations are due to Rosalie and all her gang! There have been some new additions to the wiki that you might want to take a moment to look at (and maybe even update) them. Wikis are a great tool for collecting and distributing information within a community. They're very easy to use, and (especially in this case) worth spending some time on. The first new page is a listing of libraries using or migrating to Koha. If you fit into this category, please add yourself to http://www.saas.nsw.edu.au/wiki/index.php?page=KohaUsers -- having an idea of how many users we have will help us recruit developers, recommend Koha to other libraries, and seek grants (or other funding) to add new features. The second new page is a listing of Koha Interest Groups (or KIGs). This page (at http://http://www.saas.nsw.edu.au/wiki/index.php?page=KohaInterestGroups -- and sub-pages) contains a list of KIGs that are starting to form and some hints for starting a KIG. These kinds of groups will be key to getting Koha to the next level of acceptance. Hopefully, they'll also end up being a useful and fun group for the members -- providing a chance to get together and talk about Koha, find help for problems, and lobby for new development. Please think about getting involved with your local KIG. French Nicolas Morin has taken on a more formal role as the manager of the translation of Koha into French. Please join with me in congratulating him on this new position. Nicolas has been working hard on Koha for quite a while. He's helped to translate the fr.koha.org web site, translated these newsletters, worked with the French library and library education communities, and generally been a great help to the whole community. Spanish Fransisco M. Marzoa Alonso has recently begun the effort of translating the Koha templates into Spanish. His efforts are being coordinated with other translators and proof-readers on the new Spanish mailing list (see above). If you're interested in helping Fransisco, please join the mailing list and get involved. e iti noa ana na te aroha -pate Pat Eyler Kaitiaki/manager the Koha project

1 0

Need help on catalogueentry table
by fabien 29 Nov '02

29 Nov '02

Hi, I'm currently importing data to Koha in order to put our library online. I am converting an old database via Access and ODBC to import it into Koha. I would like to know a bit more about the way subjects are connected. I've done an import into the bibliosubject table so far and it works but I would like my subjects to be interconnected and I guess the table catalogueentry does it. Most of the fields are pretty obvious (or so it seems) but I have a question about ENTRYTYPE, which is a varchar(2), what does it refer to? I guess that each book is described by is biblionumber and the subjects go in the fields catalogueentry, see, seealso, seeinstead, am I right???... Could someone give me a few explanations on this? I would also need to know what classification in biblioitem is... Is it a general category like non fiction or something like this or ....???? Is it this classification that shows on the advanced search /cat page?? Thanks for any help you could provide, Fabien

1 0

Catalogueentry table
by Fabien Olivry 29 Nov '02

29 Nov '02

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, I'm currently importing data to Koha in order to put our libray online. I have to convert an old database via Access and ODBC to import it into Koha. I would like to know a bit more about the way subjects are connected. I've done an import into the bibliosubject table so far and it works but I would like my subjects to be interconnected and I guess the table catalogueentry does it. Most of the fields are pretty obvious (or so it seems) but I have a question about ENTRYTYPE, which is a varchar(2), what does it refer to? I guess that each book is described by is biblionumber and the subjects go in the fields catalogueentry, see, seealso, seeinstead... Could someone give me a few explanations on this? I would also need to know what classification in biblioitem is... Is it a general category like non fiction or something like this or ....???? Is it this classification that shows on the advanced search /cat page?? Thanks for any help you could provide, Fabien -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE95+MpQGYRKu88EYQRApg3AJ4n+PAl469OXdTLKw1Ksb2zc75mYQCfT+hL hA5C/KXH4x5VSwu/sJlPIFw= =+kKa -----END PGP SIGNATURE-----

1 0

proprietary integration
by Adam Thick 28 Nov '02

28 Nov '02

Hi all. I've recently been looking into sitting opac on top of a proprietary system, DB text. If anyone has any ideas or information I'd be happy to hear about them. My intitial reaction to doing something like this was to create something in perl that syncs up DB text and KOHA by dumping the records into MARC and automatically uploading them to the KOHA db. But I'm happy to investigate other alternatives if others have had success? I'm also happy to hear any horror stories. Cheers, Adam Thick.

2 1

A problem inserting
by Emiliano Marmonti 28 Nov '02

28 Nov '02

Hi everybody, We´re testing the use of Koha over Solaris 8. After re-installing Perl and other modules I think it´s working. Now we have a problem when trying to insert a new branch. Everything looks well but no new branch is inserted. When I see the Koha_error log it says the following: DBD::mysql::st execute failed: No Database Selected at /var/apache/cgi- bin/koha/admin/branches.pl line 176, <KC> line 4. DBD::mysql::st execute failed: No Database Selected at /var/apache/cgi- bin/koha/admin/branches.pl line 36, <KC> line 4. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /var/apache/cgi-bin/koha/admin/branches.pl line 39, <KC> line 4. DBD::mysql::st execute failed: No Database Selected at /var/apache/cgi- bin/koha/admin/branches.pl line 36, <KC> line 4. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /var/apache/cgi-bin/koha/admin/branches.pl line 39, <KC> line 4. DBD::mysql::st execute failed: No Database Selected at /var/apache/cgi- bin/koha/admin/branches.pl line 176, <KC> line 4. DBD::mysql::st execute failed: No Database Selected at /var/apache/cgi- bin/koha/admin/branches.pl line 36, <KC> line 4. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /var/apache/cgi-bin/koha/admin/branches.pl line 39, <KC> line 4. It looks like no Database is selected but in /etc/koha.conf is correctly specified. Also I´ve tested that the user could insert, select, etc via mysql command line... Any suggestions? Thanks a lot Emiliano Marmonti. ------------------------------------------------- This mail sent through IMP: http://horde.org/imp/

2 2

Z39.50 search tool
by Silvia Hernandez M. 27 Nov '02

27 Nov '02

Hi, I hope you can help me, I have installed koha 1.2.2 from the installer.pl included with the software. Then, I started with the test-drive sited in the page http://opac.mysite:8080/cgi-bin/koha/acqui.simple/addbooks.pl I entered a ISBN number and then when I followed the link Z39.50 search tool, and I was taken to the page http://opac.mysite:8080/cgi-bin/koha/acqui.simple/marcimport.pl?z3950queue=… 50&test=testvalue&rand=45846498.4121782&query=9688809055&type=isbn&S-1=on&manualz3950 server=otherserver%3A210%2FDATABASE where I got the following error: No Z39.50 search daemon running: no file /var/log/koha/processz3950queue.pid. There is a launcher for the Z39.50 client daemon in your intranet installation directory under ./scripts/z3950daemon/z3950-daemon-launch.sh. This script should be run as root, and it will start up the program running with the privileges of your apache user. Ideally, this script should be started from a system init directory so that is running after the machine starts up. How can I launch the z3950-daemon? and what should I do to make the script starts from the system init directory each time my pc starts up? Silvia Hernandez-M. INAOE, Mexico.

2 1

Re: [Koha] Can't modify records
by Jim Thomas 27 Nov '02

27 Nov '02

> > We are seeing two problems with the box. First, the koha web pages take > > a loooong time to load. I suspect this is a DNS problem, but I'm not > > sure. I'm usre now. I removed bind from the system and made it just use our regular DNS server. The slowness problem went away. > > > > The second problem is enough to make my wife question the feasibility of > > using Koha - after she enters a new book into the catalog, she cannot > > modify it to correct any typos. She finds the modify page OK, but the > > machine just ignores the modify button. The cursor doesn't change when > > she positions it over the button - it's as if shes clicking a > > non-button. Rachel Hamilton-Williams wrote: > > Hi Jim > > As always it's a bit tricky to figure this out without being able to see it - > but is there a chance if we can't have access to the box that your wife could > do some screen shots so we know were she "is" when it stops working? Here are the steps we can take to see the problem: Bring up the admin page (/usr/local/koha/intranet/htdocs) Search for a book in the "Catalog" box by typing in a keyword and pressing enter. Click on a book title. That brings me to a page that has non-functional Modify and Delete buttons: /usr/local/koha/intranet/cgi-bin/koha/detail.pl? I have omitted the search criteria following the "detail.pl?" because I doubt that it's relevant. > > I'm assuming she is using simple acquisitions to get stuff into the system? I dunno. How could I tell? -- Jim Thomas Principal Applications Engineer Bittware, Inc jthomas(a)bittware.com http://www.bittware.com (703) 779-7770 There's a fine line between clever and stupid

4 5

Some kind of Table Problem?
by Veronica Lencinas 26 Nov '02

26 Nov '02

Hello, thank you for the help with Acquisitions. My systems parameters are now set. But there seems to be more trouble. As we install the sampledata we had the following problems: 1. "Biblio" table (as installed by Koha) seems to miss one column. Actual installation has: biblionumber author title unititle notes serial seriestitle copyrightdate timestamp 2. some other tables seems to be missing (ethnicity, shelfcontents, bookshelf) I have some trouble to complete the whole acquisition process with the "normal" interface and also with the Catalogue Search (at the librarians interface). Should I install Koha again? Veronica Lencinas Errorlog: [Tue Nov 26 18:15:48 2002] [error] [client 200.16.22.190] script not found or unable to stat: /u sr/local/koha/intranet/cgi-bin/acqui/whitcoulls.html DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/lo cal/koha/intranet/modules/C4/Search.pm line 877, <KC> line 20. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/koha/intranet/mo dules/C4/Search.pm line 880, <KC> line 20. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 9 at /usr/lo cal/koha/intranet/modules/C4/Biblio.pm line 138, <KC> line 10. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/lo cal/koha/intranet/modules/C4/Biblio.pm line 150, <KC> line 20. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/lo cal/koha/intranet/modules/C4/Biblio.pm line 161, <KC> line 30. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 9 at /usr/lo cal/koha/intranet/modules/C4/Biblio.pm line 138, <KC> line 10. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/lo cal/koha/intranet/modules/C4/Biblio.pm line 150, <KC> line 20. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/lo cal/koha/intranet/modules/C4/Biblio.pm line 161, <KC> line 30. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/lo cal/koha/intranet/modules/C4/Biblio.pm line 231, <KC> line 40. DBD::mysql::st execute failed: You have an error in your SQL syntax near ')' at line 2 at /usr/l ocal/koha/intranet/modules/C4/Biblio.pm line 238, <KC> line 40. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/lo cal/koha/intranet/modules/C4/Search.pm line 760, <KC> line 10. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/koha/intranet/mo dules/C4/Search.pm line 763, <KC> line 10. DBD::mysql::st execute failed: You have an error in your SQL syntax near 'and biblioitems.biblio number=' at line 7 at /usr/local/koha/intranet/modules/C4/Search.pm line 841, <KC> line 20. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/koha/intranet/mo dules/C4/Search.pm line 842, <KC> line 20. Ahora podés usar Yahoo! Messenger desde tu celular. Aprendé cómo hacerlo en Yahoo! Móvil: http://ar.mobile.yahoo.com/sms.html

2 1

koha under solaris or Mac OS X?
by Christopher L Brown-Syed 26 Nov '02

26 Nov '02

Has anyone experimented with running Koha under Sun's Solaris or Apple's version of Linux? Please reply off-list, thanks. cbs -- Christopher Brown-Syed, PhD <clb24(a)buffalo.edu> or <cbrownsyed(a)cogeco.ca> Visiting Assistant Professor, School of Informatics, Univ. at Buffalo

2 1

Acquisitions interface
by Veronica Lencinas 25 Nov '02

25 Nov '02

Hello, we are installing Koha and have some problems with the acquisitions of Koha. At the Test Drive on the Koha site the script is http://hlt.katipo.co.nz/cgi-bin/koha/acqui.simple/addbooks.pl where I can add new items to the library. But the acquisition script installed in my computer is just http://my.host/acquisitions/ where I can make orders, but not catalog. My Kohaversion is 1.2.2 What's wrong, or what kind of errors did I made? Thank you very much. Veronica Lencinas Cordoba, Argentina Ahora podés usar Yahoo! Messenger desde tu celular. Aprendé cómo hacerlo en Yahoo! Móvil: http://ar.mobile.yahoo.com/sms.html

2 1