- Koha - lists.katipo.co.nz

installing with script installer.pl
by Gerard Henry 05 Jun '04

05 Jun '04

hello, first installing koha with script installer.pl on a solaris 8 machine, everything went fine, until this: CREATING DATABASE Creating the MySQL database for Koha... /usr/local/mysql/bin/mysql Ver 11.16 Distrib 3.23.49, for sun-solaris2.8 (sparc) Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Usage: /usr/local/mysql/bin/mysql [OPTIONS] [database] blabla... ERROR CREATING DATABASE It sounds like arguments are wrong, but how can i control it? i verify i can log in my db: machine-root% mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 11520 to server version: 3.23.49-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> If anybody can help? Thanks in advance, -- Gerard HENRY

2 3

Periodical items - magazines.
by Silva, Ernesto - Webmaster 05 Jun '04

05 Jun '04

Hi, As I'm evaluating Koha and contacted some libraries that are already using it they told me that Koha version 1.4 didn't have the chance to manage magazines. I'm not a librarian but apparently every magazine publication has to be added to the database as a new (kind of) biblio and must have a reference to the master record of the magazine. Even worse they told me that they usually make an special procedure to add some "important" articles as a new (kind of) biblio with a reference to the specific monthly (to say something) magazine issue. Are this things "doable" with Koha version 2.0 ?? Regards, -- Ernesto Silva - Webmaster - Universidad ORT Uruguay Cuareim 1451. Montevideo. Montevideo - 11100. Uruguay. Email: silva(a)ort.edu.uy "Men and nations will act rationally when all other possibilities have been exhausted." Katz law.

2 1

Online help on Koha => REQUEST FOR HELP
by Paul POULAIN 04 Jun '04

04 Jun '04

Hello, I just commit on CVS a new feature, that will be available for 2.2 : online HELP On each template, a "HELP" link has been added. it opens a popup, filled with an help template. the help template is in the help/ directory. The help.pl files builds the online help using the name of the caller page (referer). If the user clic on "help" when on page "admin/itemtypes.pl", the "help/admin/itemtypes.tmpl" is opened. If the "help/admin/itemtypes.tmpl" does not exists, a default "sorry, no help on this topic" page is shown. Works fine, but now, the big work has to be done : create the online help pages... So, we need candidate to create the "help files". The help file can be a simple text file, only with cariage returns. If there are some candidate here, please say here which file or part of Koha you can do, and send me the help files. I'll include them in the official release, with HTML code added where needed. This task should not be done by a developper, but by librarians. Anyone sending me files will have it's name added to the contributor list, in "about" page of Koha. His name will be reminded forever by ppl all around the world -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

2 2

Re: [Koha] Newbie Wiki Update and Address
by M Brooke Helman 03 Jun '04

03 Jun '04

Salvete! Salt-wager-ly to you too! (At least, that's what it seems to mean in esperanto, but it makes an odd greeting... ;-) ) It's hi (collective) in Latin. > http://www.saas.nsw.edu.au/koha_wiki/index.php?page=NewbieGuide This is a great help, thank you. May I include it in the 2.0.1 release? Holy cow! You bet! My thanks to both you and Stephen for the bug help. I'm going to keep working on the wiki as I get time, of course. The Koha community seems to give better support to their product on a whole than some library software vendors. :) Cheers, Brooke @ Hinsdale MA

1 0

Newbie Wiki Update and Address
by M Brooke Helman 03 Jun '04

03 Jun '04

Salvete! I've added to the Newbie Guide so that it now covers the entirety of the Parameters screen of the Intranet. The address of the wiki is http://www.saas.nsw.edu.au/koha_wiki/index.php?page=NewbieGuide I don't know everything by any stretch of the imagination, since the library I work in is tiny, I don't yet use many of the features that Koha has to offer. So, if friendly beings out there would like to lower themselves to reading through the wiki to edit gaps in my knowledge, or add insight to stuff I've posted, that would be wonderful. I hope to have more time to dedicate to documentation like this after I am fully automated. I have slightly under 1/4 of the library's bibliographic records on Koha (about 2300 records). I have two roadbumps right now - audiobooks and the summer reading programme. Hopefully I will be more responsible in the fall. I will add information about how I add records to Koha next. Cheers, Brooke

2 1

All I want from Santa (or possibly the great Paul Poulain ;)
by M Brooke Helman 03 Jun '04

03 Jun '04

Salvete! I love Koha so far. I am really grateful to the developers for this gift. It's really making a difference for the library. I was pleasantly surprised by how easy, quickly and smoothly the upgrade from 2.0rc3 to 2.0 went. I can't yet commit financial resources to the project, so I well understand that there are more important things for every one out in developer land to do. I also am not sure whether I'm noticing bugs, or asking for large or small features, so I'll put my requests here. I want to make it plain that my attitude here is very similar to the attitude I take towards Inter Library Loan. I will put my request out there in a bottle, and if someone picks it up and responds, stellar! I'm also aware that a lot of this is probably me setting stuff up wrong. If the fix can be posted, then great. I just need to be able to tell my tech guy (my fiance) what he needs to fix when he feels like it. On items with multiple 856u fields, the URLs are running into each other and making a mockery of your lovely database. There is clearly a pipe in the display, so I'm not sure why this is happening. I can cut and paste the url into the address box at the top one at a time, but it's so sweet to be able to have patrons click on the url attached to the record and have it go straight to the address. What am I doing wrong? Here's an example http://65.110.139.7/cgi-bin/koha/opac-detail.pl?bib=2174 On items with fictitious character subjects for characters with a first and last name, the comma that separates their name seems to be wreaking havoc with the subject headings. I could have sworn that this wasn't happening initially. This is important to me because it turns Baggins, Frodo into Baggins Frodo If I type Baggins, Frodo in the search box on the first page of the OPAC, it will find the right records. However, if I click on the subject link from the record itself, it seems to be searching for just Baggins or Frodo not Baggins, Frodo. So it doesn't link to anything. What am I doing wrong? You can see it at the same example: http://65.110.139.7/cgi-bin/koha/opac-detail.pl?bib=2174 I am having issues with the subtitle field. I've noticed that in other Koha catalogues it will not display until you hit the records page, but I can't even manage to get it to do that. Under my Marc Links page, I have it linked to the 245b remainder of title field. For now, I am being naughty, and squishing the subtitle into the 245a title field for important subtitles. How do I get the subtitle to show with my record screen? I.E. this screen http://65.110.139.7/cgi-bin/koha/opac-detail.pl?bib=4 I am having issues with the additional author field. Left Behind is co written by Tim LaHaye and Jerry Jenkins, for example. Theoretically, I ought to come up with every book they've written together even if I type Jenkins, Jerry in instead of LaHaye, Tim. Koha doesn't appear to search this field properly from a basic keyword search. However, clever programmers you are, if I enter Jenkins into the author field of an advanced search, it will in fact bring up the full list. I have the additional author field linked in Koha, so it does indeed appear on my records screen. I wish this was linked like the author field is, and would be searchable under a basic search. What am I doing wrong? Again the record is: http://65.110.139.7/cgi-bin/koha/opac-detail.pl?bib=4 I know I am asking for blood on this one. But it would be fantastic if we could please have an author search from the MARC biblio management screen http://65.110.139.7:8080/cgi-bin/koha/acqui.simple/addbooks.pl This is useful for me because on older books where there is no ISBN and the title is strange, sometimes it takes me a while to find the record. I know that I have to type a "The" if the title starts with "The" on this screen, but every now and then, I forget the title proper and have to turn the breeding farm on its ear to find my record. This is something I haven't even tried yet and have no clue where to start on. In Massachusetts, we fill out a form every year that's basically an inventory of our collections. I know that there's a shelf list function, and I see the stuff for inventory taking. I don't know how to use either. What I want to be able to generate is a raw number of records for a certain type of material. For instance, one of my item types is Adult Fiction. I now have all of my Adult Fiction in Koha. Rather than count each book by hand, I would like Koha to tell me how many Adult Fiction items are in the database. When I'm fully automated with Koha, I would like to be able to know how many of all of the item types I have in my library. In my dreams, I would love for Koha to be able to generate a report that tells me how much each item type circulates. (IE my fiction collection as a whole has circulated 13,000 times last year 4,800 of which were renewals.) In my wildest dreams, Koha would take that data and do nifty pie charts I could present to other librarians or officials. I definitely get the impression that I can at least get raw numbers. But how? Thanks so much, Brooke @ Hinsdale MA

2 1

BarCode Printing
by H S Rai 01 Jun '04

01 Jun '04

I thank list members for their support. On second try, I succeeded in installing Koha using installer. On getting some experience with it, I will come back again with my impression, views etc. It appers to be wonderful software. For the timing, I would like to know how to print barcode. Is it possible through Koha or some other program. Thanks in advance. -- H. S. Rai _____________________________________________________________________ http://www.grex.org/~hsrai | Alternate E-mail: hsraidce(a)iitr.ernet.in ___________________________|_________________________________________ : ####[ GNU/Linux One Stanza Tip (LOST) ]####################### Sub : Learning PERL techniques LOST #069 Is there a good place to learn snarky PERL TECHNIQUES ? One of my favorite is http://webtechniques.com where Randall Schwartz contributes a monthly sample, explaining line-by-line what his code does, and why. (Look under "Programming with Perl" in the archives.) ####[will (at) serensoft.com]################################# :

3 4

Perl version
by Eric G. Salayon 01 Jun '04

01 Jun '04

hi, what is the minimum version of perl KOHA will work? TIA! eric

2 1

Re: [Koha] All I want from Santa (or possibly the great Paul Poulain ;)
by Owen Leonard 01 Jun '04

01 Jun '04

> On items with fictitious character subjects for > characters with a first > and last name, the comma that separates their > name seems to be wreaking > havoc with the subject headings. This is a problem for us as well. Previously the subject headings got returned as one big string, completely unlinkable. We submitted a fix that got us to where we are now, while admitting to the problem you describe (http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=679) I think the script receives a comma-separated list of subject headings for the record, and they breaks it into an array on the comma, resulting in the mixed-up list you're seeing. We get the same thing. I guess we should submit a separate bug for this. > I am having issues with the subtitle field. I've > noticed that in other > Koha catalogues it will not display until you hit > the records page, but > I can't even manage to get it to do that. Absence of the subtitle (whether it be 245b or 245p) in search results is a huge problem for us. Following your chosen example, search results for Frodo Baggins will bring up the Lord of the Rings DVD, but because nothing else is displayed, you can't tell which volume it is. Our OPAC installation from CVS of rel_2_0 shows the subtitle in opac-detail.pl, so I'm not sure why you're not seeing it. If it's just the template, you could change that by hand if you wanted. If the subtitle's just not there, then you have another problem. You might check for it in the subtitles table. > I wish this [additional author] was linked like the > author field is, and > would be searchable under a basic search. Relating to both this question and the previous one, a LOT of work is being done to overhaul the search system to really take advantage of MARC records. This particular issue is being addressed, allowing author searches to hit the many different alternate author tags. > I know I am asking for blood on this one. But it > would be fantastic if > we could please have an author search from the > MARC biblio management > screen I'm guessing that once the work is done on the improved MARC searching, we can roll the regular advanced search into this one and not have distinct options. > What I want to be able to > generate is a raw number of > records for a certain type of material. There are a number of new reports being added in the next version, and this is one of them. > I definitely get > the impression that I > can at least get raw numbers. But how? Right now? Query MySQL directly! In the meantime, submit an enhancement bug for the kind of report you'd like to see. Perhaps in the meantime some other folks can chime in on how they get the reports they need. -- Owen ---- Web Developer Nelsonville Public Library http://www.athenscounty.lib.oh.us

2 1

branch restrictions
by Smylie, Robb 01 Jun '04

01 Jun '04

Hello, I am a new user to Koha and have been very impressed with the software so far. I have a question about the possibilities around restricting which books staff members can issue to users. I would like to have it so that staff members would not be able to issue books the borrowers if that book does not reside at that staff members specified branch. Is this possible at all? Has anyone else run into a need for this? Thanks in advance for your help. Robb Smylie Director of Systems and Software Development Teach For America One day, all children will have the opportunity to attain an excellent education. Join our movement: <http://www.teachforamerica.org/>

2 1