- Koha - lists.katipo.co.nz

RE: [Koha] Database description
by Williams, Olwen - SAL 23 Jul '02

23 Jul '02

Chris and I converted all the data for Horowhenua when we were developing Koha. Their previous system was an A/Rev system called Catalist. I created delimited files from that, and Chris and I imported them. It needed some massaging to make it fit, but we managed to do it several times during the course of the change-over. -----Original Message----- From: Owen Leonard [mailto:oleonard@athenscounty.lib.oh.us] Sent: Wednesday, July 24, 2002 4:51 AM To: koha(a)lists.katipo.co.nz Subject: [Koha] Database description Hi everybody, As we get further along in evaluating Koha and closer to an actual switch, we're starting to address thorny issues like database transfers. This brings up a couple of issues you all might be able to help us with. First, is there a good write-up of the database structure, with descriptions of all the fields? Some stuff is self-explanatory, like 'surname' and 'firstname' in the borrowers table, but others are more obscure. Second, is there any library out there that's made the switch from another library automation system, doing a full database transfer in the process? If so, we'd love to hear about how they approached it. Thanks, Owen ---- Web Site Developer Athens County Library Services http://www.athenscounty.lib.oh.us _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Database description
by Owen Leonard 23 Jul '02

23 Jul '02

Hi everybody, As we get further along in evaluating Koha and closer to an actual switch, we're starting to address thorny issues like database transfers. This brings up a couple of issues you all might be able to help us with. First, is there a good write-up of the database structure, with descriptions of all the fields? Some stuff is self-explanatory, like 'surname' and 'firstname' in the borrowers table, but others are more obscure. Second, is there any library out there that's made the switch from another library automation system, doing a full database transfer in the process? If so, we'd love to hear about how they approached it. Thanks, Owen ---- Web Site Developer Athens County Library Services http://www.athenscounty.lib.oh.us

3 2

Re: question
by Pat Eyler 22 Jul '02

22 Jul '02

On Mon, 22 Jul 2002, Jodeen Wink wrote: > Dear Sir, Hi Jodeen, I'll try to take your questions a bite at a time below: > > Can I use this software in my home library, even if I don't have any > intention of integrating with other libraries? Yes, you certainly can. A couple of the developers (at least) are doing just that. > How do I catalog my collection on this system? > I tried to catalog on it and could only search what I assumed was an > existing collection. It sounds like you loaded the sample data. > What if I am starting from scratch and there is no existing collection > to search? What I'd recommend is a) take a look at the new version of the manual (coming out 'Real Soon Now'), and b) talk to the people on the koha users list (I'm cc'ing them on the reply). I'm not a librarian, so any answers I give you are liable to confuse more than help. ;) -pate > > Thank you > > Jodeen Wink >

2 1

Troubleshooting Apache Server
by Larry Currie 20 Jul '02

20 Jul '02

Good morning. I have been trying to get version 1.2.1 of Koha up and working, but I'm having trouble getting the Apache server to run successfully. In particular, I keep getting a critical "error (13) permission denied: make_sock: could not bind to port 198" when I attempt to follow a borrower card number link from the URL http://198.31.79.73:8081/cgi-bin/koha/member.pl after performing a member search or when I go to look at the details of an item record. Would someone with expertise in this area be able to join me on the #koha-support channel sometime today or tomorrow to help me get to the bottom of this problem? I'm on Pacific Coast Standard time. Micheas on the list suggested that I execute these two commands to begin to see what is happening: $ netstat | grep ESTABLISHED tcp 0 20 bcsl:ssh user-73-89.calacad:2060 ESTABLISHED tcp 0 0 localhost:34622 localhost:34623 ESTABLISHED tcp 0 0 localhost:34623 localhost:34622 ESTABLISHED uname -a Linux bcsl 2.4.2-2smp #1 SMP Sun Apr 8 20:21:34 EDT 2001 i686 unknown Larry Currie -- Lawrence W. Currie User Services Librarian California Academy of Sciences Golden Gate Park San Francisco, CA 94118 lcurrie(a)calacademy.org (415) 750-7108 (415) 750-7106 fax http://www.calacademy.org/research/library/

2 1

From The Kaitiaki
by Pat Eyler 20 Jul '02

20 Jul '02

19 July, 2002 To the Koha community; Bon Dia, Well, I've heard a little bit of feedback on modules, and it seems that most of you are leaning toward the idea of using more existing Perl modules and needing fewer Koha specific functions. If you still want to toss in your thoughts, please do -- we need to come to closure on this pretty soon though, so don't delay. I'd still like to hear from people who are using Koha. If you've got a success story (or non-success story), please send it to me (<kaitiaki(a)koha.org>). I'd like to be able to use some of your stories to help publicize Koha. (And if you've had problems, perhaps we can find a way to fix them.) To help get a bit more data about Koha users (how many of you are there, where are you located, etc). We're starting to put together a survey. It will be hosted on the web, and I'll be sure to announce it here. Documentation The librarian specific manual has been written (thanks to Rosalie and her band of merry librarians). Nick has given it a first review, and it is now in the hands of another reviewer (Brig McCoy, who's a new contributor). With this, the manual is basically complete. It's not done though. Look for more information to be included as we go along. If you think we've missed something in our efforts so far, please lend a hand. Translations The French translations are continuing apace. The manual has gone through a first draft and is being reviewed. The French Koha website is nearing completion, and the 'From the Kaitiaki' notes are being translated regularly. A second librarian has contacted me about a Spanish translation. Cristian and Enrique have been meeting together and have volunteered to start translating Koha and providing support to Latin American (especially Chilean) libraries interested in using Koha. Let's wish them well. Community One of the most exciting things happening in the world of Koha is the increasing amount of visibility we're getting. I've recently had email from New Zealand and New Caladonea about articles being written about Koha. I've heard from people interested in seeing Koha translated into Arabic. We've also seen some evidence that Koha is now in use on five continents. We're also starting to get some notice outside the library world, most recently we were mentioned in the Linux Weekly News (in their 'Development Section'). Wow! The future is looking bright. Thanks again to everyone who has been putting time and energy into making Koha into such a great application. Obrigado -pate Pat Eyler Kaitiaki of the Koha Project

1 0

Re: Your password!
by tpark＠voicenet.com 16 Jul '02

16 Jul '02

1 0

Importing Marc-Records
by Dorian Meid 16 Jul '02

16 Jul '02

Hi, I've managed to import some Records from the Library of congress, but as most of our books are in german I wanted to connect to a german z39.50 server. I tried: Server Port Database User Password Supported-format ubsun01.biblio.etc.tu-bs.de 2020 opac opac opac USMARC, UNIMARC, MAB2,SUTRS ubsun01.biblio.etc.tu-bs.de2020 bac opac opac USMARC, MAB2, SUTRS 134.99.136.10 2020 opac opac opac USMARC, UNIMARC, SUTRS, MAB2 leia.bth.rwth-aachen.de 2020 gkneu opac opac USMARC Unfortunately I got no results (not even a "no records returned" message"). What is the problem? Or better: What is the solution? Dorian

2 1

Importing Marc-Records
by Alan Millar 16 Jul '02

16 Jul '02

> From: Dorian Meid <dnmeid(a)tfh-berlin.de> > I've managed to import some Records from the Library of congress, but as > most of our books are in german I wanted to connect to a german z39.50 > server. > I tried: > Server Port Database User Password Supported-format > ubsun01.biblio.etc.tu-bs.de 2020 opac opac opac USMARC, UNIMARC, > MAB2,SUTRS > ubsun01.biblio.etc.tu-bs.de2020 bac opac opac USMARC, MAB2, SUTRS > 134.99.136.10 2020 opac opac opac USMARC, UNIMARC, SUTRS, MAB2 > leia.bth.rwth-aachen.de 2020 gkneu opac opac USMARC > > Unfortunately I got no results (not even a "no records returned" > message"). > What is the problem? > Or better: What is the solution? I can't tell you what the problem is. The Z39.50 part of Koha is definitely new and needs more experience, debugging, and documentation. For the solution, in my opinion this is a developer-level question. The best thing to do is probably to see if these Z39.50 sources work with another tool, such as yaz-client. No, I don't know how to use it. Like I said, this is a new part of Koha and needs more testing. Thanks for helping out with it! :-) - Alan ---- Alan Millar --==> am12(a)bolis.com <==--

1 0

Hash Error
by Tom Albrecht 16 Jul '02

16 Jul '02

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi all, I had been evaluating Koha for a few weeks now, and I haven't really touched it for a little over a week because of work. I had installed 1.2.1 fresh then, and was getting an error. When I recently came back to continue testing and evaluating (and debugging), I thought installing 1.2.2RC3 might fix my problem, so I installed all the .pl files from 1.2.1RC3, and it didn't seem to help. Here's my issue... I installed Koha, and the sample data. When I go to the OPAC screen a search on "book", I get a whole bunch of "HASH(0x840da9c)" statements (with different values). Am I doing something incorrect? Tom Albrecht III - -- Download my GnuPG public key http://taz.cs.wcupa.edu/~talbrech/copperhead.asc Download GnuPG at http://www.gnupg.org -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE9M1LqEBkclKlERsURAtehAJ9N/v/vCYPh7uwbkPvEVnnxcdkZJACffCda 5MVJjJvOgnWiNtB8zO5SfEo= =N1NE -----END PGP SIGNATURE-----

2 1

Concernimg Class, Location, Marc and more
by Olugbenga Adara 15 Jul '02

15 Jul '02

Hello all, 1. I found out that it is only the dewey classification that shows up in the OPAC search result. However i need the LCCN to appear as Library of Congress Catalogue Number is used in the library i installed koha for and not dewey. How do i fix this ? 2. How do i indicate shelf location. I could not see anywhere i could do this using acqui simple. This library has several big rooms and we would like to indicate the shelf and room code in the OPAC search results. by the way i am using 1.2.1 3. I want to import data into koha from tinlib. i am not sure it can export in Marc but i know it can export in comma delimited text. Any idea ? how reliable is the marc import tool? 4. i am trying to install the z.3950 in koha but got lot of errors while installing yaz. Do i need any other module? I am using redhat 7.1. If i do manage to finally get it working, can i easily import data into koha from the library of congress using the isbn alone? thanks for your anticipated replies ===== Olugbenga Adara MCP Consultant, 3om Services, 75, Lebanon Street, Dugbe, Ibadan, Nigeria. Tel: 234-2-2412090 Mobile: 234-803-3220288 __________________________________________________ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com

1 0