- Koha - lists.katipo.co.nz

OpenSQL Camp?
by gsl 07 Jan '09

07 Jan '09

By chance is anyone planning on going to the OpenSQL Camp 2008 in Charlottesville, Virginia, on Nov 14 - 16? http://www.firebirdsql.org/index.php?op=events Greg Lawson Rolling Hills Consolidated Library 1912 N. Belt Highway St. Joseph, MO 64506

1 0

Koha Usage problem
by hemanth kumar 07 Jan '09

07 Jan '09

Hi, I have installed koha 2.2.9 software in my system, my operting system is Windows XP. Everything is working fine but when i add a member it is not adding to the database, so please tell me the procedure to add members. Regards Hemanth HK Group

5 5

Koha and UTF-8 (again)
by "Thommy M. Malmström" 06 Jan '09

06 Jan '09

Once again I took the fight with Koha to try to make it work with non ASCII characters. I've set the the following variables for MySQL, Apache and PHP: vim /etc/apache2/apache2.conf AddCharset UTF-8 .utf8 AddDefaultCharset UTF-8 vim/etc/php5/apache2/php.ini default_charset = "utf-8" vim /etc/mysql/my.cnf [client] character_set_client=utf8 [mysql] default-character-set=utf8 [mysqld] init-connect = 'SET NAMES utf8' character-set-server=utf8 collation-server=utf8_swedish_ci /etc/rc3.d/S19mysql restart mysql> SHOW VARIABLES LIKE 'character_set%'; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | +--------------------------+----------------------------+ 8 rows in set (0.01 sec) mysql> SHOW VARIABLES LIKE 'collation%'; +----------------------+-----------------+ | Variable_name | Value | +----------------------+-----------------+ | collation_connection | utf8_general_ci | | collation_database | utf8_swedish_ci | | collation_server | utf8_swedish_ci | +----------------------+-----------------+ 3 rows in set (0.00 sec) However when I try to add an item it cuts of the text at the non ASCII char. Please look at the pictures here to see what I mean: http://thommym.blogspot.com/2009/01/koha-and-utf-8.html Also in I add text for members etc. with non ASCII chars in it it is cut at the non ASCII position. So, anyone to my rescue???

5 8

Library Elf
by Liz Rea 06 Jan '09

06 Jan '09

Are any libraries out there using Library Elf with Koha? If so, does it work? Geauga (I see you listed on Library elf website)? Hope everybody had a happy and safe new year! Liz Rea NEKLS Network Administrator http://tech.nekls.org | lrea(a)nekls.org

3 2

Re: [Koha] Library Elf
by Liz Rea 06 Jan '09

06 Jan '09

I found this out from the Library Elf People, thought it was worth passing along. Liz Rea NEKLS Network Administrator http://tech.nekls.org | lrea(a)nekls.org Begin forwarded message: > From: Jeff Chow <jchow(a)libraryelf.com> > Date: January 6, 2009 5:19:08 AM CST > > Hi Liz, > > We do have a few Koha libraries on Elf. It should work. We would > have to label it as beta for awhile until enough users sign up and > we get some testing results. It costs $150 USD for the first year. > After that it depends on how many cards are in Elf at the time of > renewal. > > 1 - 150 signed up cards = $150/yr > 151 - 250 signed up cards = $250/yr > 251 - 500 signed up cards = $350/yr > > There is nothing you have to do to on your side to make it work with > Elf other than to take out a few books and put some items on hold. > If this interests you, please fill out this form which is necessary > in order to configure your library for Elf: > > http://www.libraryelf.com/requestalibrary.aspx > > We can generally have things working within 24-48 hours. I'll send > an invoice once we have your library configured and working. > > Let me know if you have any more questions. > > Best regards, > -- Jeff Chow, > www.libraryelf.com > >

1 0

Z39.50 Incoming: Revisited
by carpentercarselibrary＠gmavt.net 06 Jan '09

06 Jan '09

Galen answered a question posed on Thu, Oct 30, 2008 at 4:41 PM by Lenora Oftedahl--re allowing outside clients to access a Koha database--thusly: "Assuming you're using Koha 3 with Zebra and that Zebra is configured to expose a public Z39.50 service, you would need to report the following: * server name * Z39.50 port * database name - by default, that will usually be 'biblios' The default Zebra configuration for MARC21 uses the Bib-1 attribute set." Could someone tell me the exact steps I need to take to configure Zebra to expose my Koha 3 db as a public Z39.50 service? Thanks! Richard Pritsky Carpenter-Carse Library PO BOX 127 Hinesburg, VT 05461 802-482-2878 www.carpentercarse.org

4 3

New Tutorial: Installing Koha on Ubuntu
by agiesler＠wisc.edu 06 Jan '09

06 Jan '09

I've posted an a fairly extensive guide for installing Koha 3.0 on Ubuntu 8.10. I hope some of you find it helpful. The guide assumes you're comfortable with technology but don't have experience with Linux or Koha. It begins with Ubuntu installation then walks through LAMP configuration, Koha installation, troubleshooting the installation process, and setting up sample data for testing. It ends with a reflection on some issues to consider before attempting a live Koha implementation. The result won't be a production system, but a test system to help you to understand and evaluate Koha. In case you find errors or omissions there's a link at the bottom of each page that will let you post comments. http://www.blazingmoon.org/guides/k3-on-u810-1.html ---------------------------------------- Andy Giesler www.blazingmoon.org University of Wisconsin-Madison

4 3

Importing records
by John Wesley Simpson 05 Jan '09

05 Jan '09

Howdy, I've been using Readerware from http://www.readerware.com/ to maintain my library. I have just installed Koha, and am having difficulty understanding how to get my library loaded into it. With Readerware, I can load a list of ISBN's from a text file and have Readerware automatically fill in the rest of the data for the books. How do I do this in Koha? So far, it appears that I can do this, but only one ISBN at a time? -- John Wesley Simpson Hibbs <john(a)swajime.com> SwaJime's Cove

8 11

Re: [Koha] error occurs when adding new biblio
by John Wesley Simpson Hibbs 05 Jan '09

05 Jan '09

On Sun, 2009-01-04 at 18:09 -0700, Jesse Weaver wrote: > > > > On Sun, Jan 4, 2009 at 5:26 PM, John Wesley Simpson Hibbs > <john(a)swajime.com> wrote: > > > On Sun, 2009-01-04 at 16:19 -0700, Jesse Weaver wrote: > > > > > > > On Sun, Jan 4, 2009 at 12:08 PM, John Wesley Simpson Hibbs > > <john(a)swajime.com> wrote: > > > > I've manually deleted the inaccessible records from > > the koha sql database, and moved newer records #18 - > > #21 into their place. > > Now, though, it seems I can't get rid of the "gap" > > in the numbering sequence. When I go to add a new > > record, the next biblio number assigned is higher > > than it ought to be. > > The last record in the database is now #17, and yet > > when I add a record it is assigned #22. > > How can I fix this? > > > > # mysql -Dkoha -ukohaasuper -pkoha4mylibrary -e > > "select biblionumber,isbn from biblioitems" > > > > +--------------+----------------+ > > | biblionumber | isbn | > > +--------------+----------------+ > > | 1 | NULL | > > | 2 | 003071592X (pb | > > | 3 | 003069549X : | > > | 4 | 002093081X : | > > | 5 | 0030536111 | 0 | > > | 6 | 0025349201 | > > | 7 | 0025907859 : | > > | 8 | 0026019604 | > > | 9 | 0028610873 | > > | 10 | 002870763X | > > | 11 | 0028619811 | > > | 12 | 002862114X (pb | > > | 13 | 0028627288 | > > | 14 | 0028627423 | > > | 15 | 0028633822 | > > | 16 | 0028639235 | > > | 17 | 002864171X | > > | 22 | 0060158719 : | > > | 23 | 006016848X (cl | > > +--------------+----------------+ > > > > > > > > On Thu, 2009-01-01 at 21:45 -0600, John Wesley > > Simpson Hibbs wrote: > > > > > > > > > > Has anybody found a solution to > > > http://lists.katipo.co.nz/public/koha/2008-December/016248.html ? > > > > > > I'm getting exactly the same error: > > > > > > Koha error > > > The following fatal error has occurred: > > > > > > > > > Can't call method "fields" on an undefined value at /usr/share/koha/lib/C4/Biblio.pm line 1642. > > > > > > Apache > > > Server version: > > > Apache/2.2.8 (Ubuntu) > > > Server built: Jun 25 2008 > > > 13:54:13 > > > Koha > > > 3.00.00.107 > > > Koha DB > > > 3.0000107 > > > MySQL > > > mysql Ver 14.12 Distrib > > > 5.0.51a, for > > > debian-linux-gnu (i486) > > > using readline 5.2 > > > OS > > > Linux lamentations > > > 2.6.24-22-generic #1 SMP > > > Mon Nov 24 18:32:42 UTC > > > 2008 i686 GNU/Linux > > > Perl > > > 5.008008 > > > > > > I don't think I'm the only one experiencing this > > > problem... > > > This google search comes up with 112 hits: > > > http://www.google.com/search?q=koha+%22Can%27t > > > +call+method+fields+on+an+undefined+value%22+% > > > 22line+1642%22 > > > > > > -- > > > John Wesley Simpson Hibbs <john(a)swajime.com> > > > SwaJime's Cove > > > > > > _______________________________________________ > > > Koha mailing list > > > Koha(a)lists.katipo.co.nz > > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > -- > > John Wesley Simpson Hibbs <john(a)swajime.com> > > SwaJime's Cove > > > > _______________________________________________ > > Koha mailing list > > Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > > > (In reference to your numbering problem) > > > > This is part of MySQL's design, and is not something Koha > > has control over, though it shouldn't cause you any > > problems. > > > > It is possible to change this counter, but you'll still have > > holes in the future if you delete records in the middle of > > the numbering sequence. > > > > -- > > Jesse Weaver > > Software Developer, LibLime > > Jess, > > Ok, just for grins, would you mind sharing with me how I can > go about changing the counter? > Whether it's malignant or not, it is really annoying me... > BTW, Mr. Adrian Monk is on tv tonight, and I'm sure he'd agree > with me. > > > > -- > John Wesley Simpson Hibbs <john(a)swajime.com> > SwaJime's Cove > > > So you have a bit of CDO (the letters should be in ALPHABETICAL ORDER, > dangit)? ;) > > Anyway, the SQL you need is: > > ALTER TABLE biblio SET AUTO_INCREMENT = 18 > > (after you delete the biblios after the jump) > > -- > Jesse Weaver > Software Developer, LibLime Jesse, Awesome, thank you, very much. :-D So, what I've done, for anybody else who might want to know: UPDATE biblio SET biblionumber = 21 where biblionumber = 24; UPDATE biblioitems SET biblioitemnumber = 21, biblionumber = 21 WHERE biblioitemnumber = 24 ; ALTER TABLE biblio AUTO_INCREMENT = 24; ALTER TABLE biblioitems AUTO_INCREMENT = 24; This worked perfectly (unless I've messed up something else that I don't know about yet). :-) So, if I might ask another question... I can do a search for say "guide", and get several books listed. It seems, though, that I cannot do a search for "*". How can I list all (24) of the books in the library? 24 down, ~1450 to go... -- John Wesley Simpson Hibbs <john(a)swajime.com> SwaJime's Cove

1 0

Questions on Koha 3.0
by Marie Wardall 05 Jan '09

05 Jan '09

I have a few questions that I hope someone can help me with. Sorry for all the questions and if the questions are duh questions. 1. Label Layouts (printing barcodes & Spine labels) unable to edit or create a new layout for barcodes—currently using the layouts that are there leaves us with title author information overlapping the barcode. How can I edit or create a new layout? I've followed the directions from the manual and have been able to do it in it an older version of Koha. 2. In Circulation when I have a patron up and I'm on the Checkout tab there are buttons across the top ie: Edit, Change Password, Add Child, Print, & More. I don't recall changing anything with these buttons but we are now missing the Print and the More buttons. Print allowed us to print a quick reminder for a student to take home with them about an overdue and the More button allowed us to set permissions for Patrons. If you know how to get those buttons back that would be great. 3. Along with the Print Button....When the page printed out before we had a replacement price listed on it along with the title, author, format, date due and status. We'd like to get replacement price to show up again when we get the Print and More buttons back. Does anyone know where we would do this? Thanks in advance for any help anyone can give us on these issues. Marie Marie J. Wardall Library Media Specialist Mountain Bay Elementary School 8602 Schofield Ave. Weston, WI 54476 mwardall(a)dce.k12.wi.us Phone: 715-355-0302 ext. 5824 Change Today, Change Tomorrow, Keep Changing

4 3