- Koha - lists.katipo.co.nz

Library Management Using KOHA
by ELOI 29 Aug '06

29 Aug '06

I am an Information Technology and we are given a project which is making a Library Management System using KOHA. Please advise. thanks! -- View this message in context: http://www.nabble.com/Library-Management-Using-KOHA-tf2181286.html#a6032232 Sent from the Koha - Discuss forum at Nabble.com.

3 2

looking for a simplified Chinese version of Koha
by wing newton 29 Aug '06

29 Aug '06

Greetings, Is there a simplified Chinese version of Koha ? Thanks. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

2 1

RE: [Koha] authority files -- does anyone have them?
by Bigwood, David 29 Aug '06

29 Aug '06

Christine, Years ago, when we did our retrospective conversion, we purchased the authority files. Since then I have downloaded any needed as I catalog. They are freely available at http://authorities.loc.gov/ I have also submitted additional cross references, new headings, and new LC classification numbers through the SACO program. There is no formal training, just follow the guidelines and you too can enhance the LCSHs. http://www.loc.gov/catdir/pcc/saco/ Until such time as our catalogs validate headings against the LC site on-the-fly and then send patron search requests to the LC site and match their term against the files and then submit that for searching against our catalogs I can't see authority files going away. Even then not. Because there can be local enhancements. Here in Texas a group of school librarians are adding the state education standards to the LC authority records so that teachers can search on the standard and pull up materials for their class. A big job, but when divided across many librarians across Texas not quite so daunting. The trend seems to be quite the reverse. Everybody on the Web is getting into the thesaurus, ontology game. There are more controlled vocabularies now than ever. Sincerely, David Bigwood bigwood(a)lpi.usra.edu Lunar & Planetary Institute http://www.lpi.usra.edu/library/whats_new.shtml Catalogablog http://catalogablog.blogspot.com -----Original Message----- From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Christine Forte Sent: Tuesday, August 29, 2006 10:37 AM To: koha(a)lists.katipo.co.nz Subject: [Koha] authority files -- does anyone have them? dear friends, i'd be interested in hearing from anyone who has downloaded, created, or purchased authority files for their catalog. (is everyone getting by just fine w/o them?) i like to see the authority lists for subjects, because i find it can help or inspire my searches, but maybe the trend is that authority files are slowly becoming obsolete. best regards, christine _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

authority files -- does anyone have them?
by Christine Forte 29 Aug '06

29 Aug '06

dear friends, i'd be interested in hearing from anyone who has downloaded, created, or purchased authority files for their catalog. (is everyone getting by just fine w/o them?) i like to see the authority lists for subjects, because i find it can help or inspire my searches, but maybe the trend is that authority files are slowly becoming obsolete. best regards, christine

1 0

issue between koha 2.5 and mysql 5.0
by Dana Huff 29 Aug '06

29 Aug '06

Hello Partha, There are indeed several issues with running Koha on MySQL 5.0 and not just with Windows so Im posting this on the Koha general list also. First, to log in to Koha you need to make some changes to your MySQL authentication. With the default installation you will get something like: >> DBI connect('mycomputer:localhost','koha',...) failed: Client does not support >> authentication protocolrequested by server; consider upgrading MySQL client at >> C:\usr\koha225\modules/C4/Context.pm line 409. You can overcome the problem by editing line 1808 of Install.pm from: print system("$mysqldir/bin/mysql -u$mysqluser -e \"insert into user (Host,User,Password) values ('$hostname','$user',password('$pass'))\" mysql\;"); to: print system("$mysqldir/bin/mysql -u$mysqluser -e \"insert into user (Host,User,Password) values ('$hostname','$user',OLD_PASSWORD('$pass'))\" mysql\;"); (Thanks to Andrew Koebrick (Andrew.Koebrick(a)state.mn.us) for that solution.) Or, of course, you can execute the mysql command manually to do the same thing if you dont use the install script and which you probably didnt do to install Koha on Windows; anyway, that is what I did. Then there is a new reserved word in MySQL 5 return which is used as a field name in the issues table in Koha. So in any place that is referenced it must be enclosed in single quotes, or back-quotes. I havent found an instance of that in the Koha modules or scripts but Im still looking. It will be an issue if you write any of your own sql scripts for ad-hoc reporting. Finally, there are a couple of modules that must be modified because of changes in the SQL syntax rules with MySQL 5. Theses are in intranet/modules/C4: Search.pm 918c918 < on additionalauthors.biblionumber =biblio.biblionumber --- > on (additionalauthors.biblionumber =biblio.biblionumber) 989c989 < biblio.biblionumber=bibliosubtitle.biblionumber --- > (biblio.biblionumber=bibliosubtitle.biblionumber) 1305c1305 < left join itemtypes on biblioitems.itemtype = itemtypes.itemtype --- > left join itemtypes on (biblioitems.itemtype = itemtypes.itemtype) 1494c1494 < from biblio, biblioitems --- > from biblioitems, biblio 1496,1497c1496,1497 < biblio.biblionumber = bibliosubtitle.biblionumber < left join itemtypes on biblioitems.itemtype=itemtypes.itemtype --- > (biblio.biblionumber = bibliosubtitle.biblionumber) > left join (itemtypes on biblioitems.itemtype=itemtypes.itemtype) SearchMarc.pm 344,346c344,346 < FROM biblio, marc_biblio < LEFT JOIN biblioitems on biblio.biblionumber = biblioitems.biblionumber < LEFT JOIN itemtypes on itemtypes.itemtype=biblioitems.itemtype --- > FROM marc_biblio, biblio > LEFT JOIN biblioitems on (biblio.biblionumber = biblioitems.biblionumber) > LEFT JOIN itemtypes on (itemtypes.itemtype=biblioitems.itemtype) That seems to have taken care of my problems with Koha 2.2.5 and MySQL 5.0. Dana Huff Madrid, Spain dana(a)sefovan.org ________________________________________ From: koha-win32-bounces+dana=sefovan.org(a)nongnu.org [mailto:koha-win32-bounces+dana=sefovan.org@nongnu.org] On Behalf Of P. S. Mukhopadhyay Sent: Tuesday, August 29, 2006 8:18 AM To: Koha-win32(a)nongnu.org Subject: Re: [Koha-win32] need help Hello friends, Is any one of us using MySQL 5.0 as backend RDBMS for Koha on Windows? I'm running it through MySQL 3.23.58 but facing problems with MySQL 5.x. What is the problem? Pl. suggest. Partha DLISc, Vidyasagar University

1 0

How to link the field
by young librarian 29 Aug '06

29 Aug '06

Dear friends hi I am using koha window version. Server information is as follows: Koha version2.2.4 OS version Microsoft Windows XP [Version 5.1.2600] Perl version5.008007 MySQL versionmysql Ver 12.22 Distrib 4.0.26, for Win32 (ia32) Apache version The thing is I want to link the marc field 520a (summary) with opac module sothat the information could be shown in the opac. Any body will help me thanx in advance. lucky India --------------------------------- How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates.

2 1

Please remove me from mailing list
by Jennifer Anne Peck 28 Aug '06

28 Aug '06

Please remove me from mailing list as I am receiving more messages than I have time to read. Thankyou. Jenny (Jennifer) Peck (GDIM)

1 0

www.koha.org is down
by 毛慶禎 27 Aug '06

27 Aug '06

Hi, http://www.koha.org is down. What happen? I am going to present Koha on International Conference on Open Source at Taiwan, 2006/09/01 - 2006/09/03 I need some pictures for my presentation. -- Best regards 毛慶禎, Anthony Mao, mao at lins dot fju dot edu dot tw ICQ 30941847 Department of Library and Information Science http://www.lins.fju.edu.tw/mao/index.htm TEL +886 2 29052334, FAX +886 2 29017405 Fu-jen Catholic University, Taipei, Taiwan, R.O.C.

3 2

Annual leave
by howard_dahdah＠idg.com.au 27 Aug '06

27 Aug '06

1 0

Getting books into the database
by thaetviking 24 Aug '06

24 Aug '06

I have been given the joy of redoing everything in our library because of some ineptness. I need quick answers if possible. We are running Follett and the novell server died and I was given the task of dealing with this after the person who ran it was fired. I would like to move to open source but was wondering can you convert the tables for follet? Also can you scan the barcode on a book and have it up the information on the web kind of like CDDB? Since we already have barcodes made for each book can we use the pre-generated ones as their identifier? I really appreciate any help. I am not sure were exactley the DB is so the last two questions may be more to the meat of what I need? -- View this message in context: http://www.nabble.com/Getting-books-into-the-database-tf2158615.html#a59638… Sent from the Koha - Discuss forum at Nabble.com.

2 1