- Koha - lists.katipo.co.nz

Reports
by Thommy M. 16 Nov '07

16 Nov '07

Someone who can give me a step by step explanation on how to get a listings of all books (Title, author, ISBN, etc.) in our Koha library?

1 0

Overdue list
by root 16 Nov '07

16 Nov '07

Guys! We have been running v2.2.4 and the overdue report (overdue.pl) had several instances where just a due date and borrowers name is displayed (ie no title or author). This week we upgraded to v2.2.9 rather hoping that this problem might go away, but it hasn't. Checking the issues table, we see that for these offending items, the returndate, lastreneweddate, return and renewals fields are all NULL. If we delete the row from the issues table, then the lines are removed from the overdue report. We are reluctant to do this in case we break something. Does anyone know why we have these strange lines on the overdue report (ie what causes the problem) and how we can fix it? Apart from this annoyance, v2.2.9 is going swimmingly. A big congrats to the developers! -- Regards Martin Woolley ICT Support Handsworth Grammar School Isis Astarte Diana Hecate Demeter Kali Inanna ************************************************************* This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify postmaster(a)bgfl.org The views expressed within this email are those of the individual, and not necessarily those of the organisation *************************************************************

1 0

Biblio reecord import
by Rick Welykochy 14 Nov '07

14 Nov '07

Hi all, I have a bunch of bibliographic records from a proprietary system, in CSV format. I need to import those into Koha. I think it best to write a script or modify an existing one to do the job in the shell. Can anyone point me to where to begin researching this? Is there an import example script? I would also like to know which tables in Koha/2.2.9 are required to be populated by the new bibliographic data. My guess are the following: biblio biblioitems and possibly bibliosubject bibliosubtitle cheers rickw -- _________________________________ Rick Welykochy || Praxis Services Those who make the most connections hog the most bandwidth. -- Rick Welykochy

2 2

Re: [Koha] Adding a new template to the OPAC and Intranet
by Rick Welykochy 14 Nov '07

14 Nov '07

Henri-Damien LAURENT wrote: > Yes, you're right. >> An unanswered question is how do the perl scripts and the >> HTML::Template facility pass around the information on which >> template is currently is use, i.e. 'MYTEMPLATE' must make >> it into the HTML somehow. > you have a system preference called opactheme or template for intranet > in order to choose the template flavour. > If you set opactheme or template to MYTHEME, it will be OK. > > But maybe you could wish to do that on rel30 rather than version 2.2, > since rel30 is about to be released. Thanks! I made a copy of the templates under a new name, fired up my browser and voila. Koha lists it as an template option in the admin area for both the OPAC and Intranet. cheers rickw -- _________________________________ Rick Welykochy || Praxis Services Those who make the most connections hog the most bandwidth. -- Rick Welykochy

1 0

Re: [Koha] Cataloguer's blues
by Joshua Ferraro 14 Nov '07

14 Nov '07

On 11/13/07, a.maclennan(a)rgu.ac.uk <a.maclennan(a)rgu.ac.uk> wrote: > Hi, Joshua > Thanks for getting back to me. I see I've been a bit verbose - my core > question was: " can I tell the install script that MySQL now lives at > /opt/lampp/bin/mysql". Is there a way to change the install script in > this regard? Hmmm...so the issue you're having is that the installer doesn't realize that MySQL is, in fact, installed? Sorry if I'm being dense, but I'm not sure why that would matter :-) Cheers, -- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf(a)liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS > > -----Original Message----- > From: Joshua Ferraro [mailto:joshua.ferraro@liblime.com] > Sent: 13 November 2007 02:40 > To: Alan MacLennan (absam) > Cc: Koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Cataloguer's blues > > Hi Alan, > > I'd try posting this to a red hat or mysql list, or try to hit someone > up on IRC. I'm not sure too many of us Kohaers use Red Hat, so we won't > be much help I'm afraid. > > Cheers, > > -- > Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE > President, Technology migration, training, maintenance, support > LibLime Featuring Koha Open-Source ILS > jmf(a)liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS > > > On 11/10/07, a.maclennan(a)rgu.ac.uk <a.maclennan(a)rgu.ac.uk> wrote: > > Hi, my name is Alan, and I'm a cataloguer. Sorry - wrong group. :-) I > want to insatll Koha on a Redhat 8 server, to give the students a chance > to catalogue on a real system. Downloaded the latest stable version, > took about a day to sort out the dependencies, and the installer chokes > at the MySQL bit. Now, this is my fault, because, having run an old > MySQL/Apach/PHP setup for years, I wanted to try blogs and wikis, and so > went for a XAMPP setup. Foolishly, I copied the new my.cnf over the old > one, thinking that would work, and it doesn't, and I didn't save the old > one. So, how can I, or can I, tell the install script that MySQL now > lives at /opt/lampp/bin/mysql and not at the new my.cnf script, which > dies becaus it seems not to be compatible with the old installation. > Maybe someone could do me a favour and post a my.cnf for a bog-standard > installation of MySQL in /usr/bin, or give me some advice, please? > (Yeah, I know - leave the computers alone, and stick to the 5" x 3" > cards ...) Now, when I try mysql -p with the new my.cnf, it tells me to > consider upgrading the client. You can't seem to download earlier > versions any more, and the 5 version has another heap of dependecies. > Sometimes, it hardly seems worth chewing through the restraints in the > morning ... > > > > TIA, > > > > Alan > > > > Alan MacLennan > > Lecturer/Course Leader > > Aberdeen Business School > > Robert Gordon University > > Garthdee Rd, Aberdeen AB10 7QE > > T: 01224 263910 F: 01224 263553 E: a.maclennan(a)rgu.ac.uk > > _______________________________________________ > > Koha mailing list > > Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > >

2 1

Adding a new template to the OPAC and Intranet
by Rick Welykochy 14 Nov '07

14 Nov '07

Hello group, I am contemplating adding a new look and feel to an existing Koha install. I am currently using the NPL template. I would like to create a new template and have that template appear as an option in the Koha Administration area of the web site. Any pointers on how to proceed? I am curious as to where I would store the new files, perhaps in intranet/htdocs/intranet-tmpl/MYTEMPLATE/en and opac/htdocs/opac-tmpl/MYTEMPLATE/en An unanswered question is how do the perl scripts and the HTML::Template facility pass around the information on which template is currently is use, i.e. 'MYTEMPLATE' must make it into the HTML somehow. TIA rickw -- _________________________________ Rick Welykochy || Praxis Services Those who make the most connections hog the most bandwidth. -- Rick Welykochy

1 0

OPAC colors
by Megan Fuller 13 Nov '07

13 Nov '07

Hello, I am looking for help and/or guidance on how to change the OPAC colors. I have tried entering html code but had no luck. Thank you, Megan Fuller

1 0

koha3 install
by mourik jan c heupink 13 Nov '07

13 Nov '07

Hi all, Today I have installed a koha3 snapshot from today on sles10. It works, and I like it's looks. Congratulations. :-) However, I am running the NoZebra version, because I had the following problem, getting zebra to work: Starting Zebra like "zebrasrv -c /usr/share/koha/etc/koha-conf.xml" gives the following output: > 21:26:20-06/11 [log] zebra_start 2.0.18 /usr/share/koha/etc/koha-conf.xml > 21:26:20-06/11 [fatal] /usr/share/koha/etc/koha-conf.xml:1 missing colon after '<yazgfs>' > 21:26:20-06/11 [fatal] Failed to read config `/usr/share/koha/etc/koha-conf.xml' I've taken the koha-conf.xml from the tarball from git, only made changes to the usernames/passwords. What could be wrong here? Do I perhaps need a specific version of zebra..? Zebra: 2.0.18 Yaz: 3.0.14 All perl modules taken directly from MCPAN Regards, mourik jan

5 5

some problems
by library cdac 13 Nov '07

13 Nov '07

Dear Joshua, Koha users, I have the following problems. Can you please help me out? 1. I had uploaded some Marc records from library of Congress into the Koha reservoir and then tried using the addbiblio option to add into the biblioframework that we have created for our library. But while adding the record, it adds to the default framework. Can anyone let me know how to add it to the biblioframework other than the default one? 2. In our library we assign a unique number to each book which is called accession number. Which field in Koha corresponds to the accession number. 3. What is the difference between biblioitem number and biblionumber? Thanks and regards, --trupti

1 0

Cataloguer's blues
by a.maclennan＠rgu.ac.uk 13 Nov '07

13 Nov '07

Hi, my name is Alan, and I'm a cataloguer. Sorry - wrong group. :-) I want to insatll Koha on a Redhat 8 server, to give the students a chance to catalogue on a real system. Downloaded the latest stable version, took about a day to sort out the dependencies, and the installer chokes at the MySQL bit. Now, this is my fault, because, having run an old MySQL/Apach/PHP setup for years, I wanted to try blogs and wikis, and so went for a XAMPP setup. Foolishly, I copied the new my.cnf over the old one, thinking that would work, and it doesn't, and I didn't save the old one. So, how can I, or can I, tell the install script that MySQL now lives at /opt/lampp/bin/mysql and not at the new my.cnf script, which dies becaus it seems not to be compatible with the old installation. Maybe someone could do me a favour and post a my.cnf for a bog-standard installation of MySQL in /usr/bin, or give me some advice, please? (Yeah, I know - leave the computers alone, and stick to the 5" x 3" cards ...) Now, when I try mysql -p with the new my.cnf, it tells me to consider upgrading the client. You can't seem to download earlier versions any more, and the 5 version has another heap of dependecies. Sometimes, it hardly seems worth chewing through the restraints in the morning ... TIA, Alan Alan MacLennan Lecturer/Course Leader Aberdeen Business School Robert Gordon University Garthdee Rd, Aberdeen AB10 7QE T: 01224 263910 F: 01224 263553 E: a.maclennan(a)rgu.ac.uk

2 1