November 2003 - Koha - lists.katipo.co.nz

List of what each field in the various tables do
by Freddie Cash 21 Apr '04

21 Apr '04

We're just starting out with Koha 2.0 to see if it could be used as a replacement for Follett. However, we are running into a few snags that should be fairly simple to fix. Our major snag is lack of documentation for the internals of Koha. For instance, is there a description of the various database tables, and what each field is used for? This would make mapping fields to MARC fields much simpler. We're running into problems with our mappings, especially with the distinction between items and biblioitems, for instance. Is this kind of low-level documentation available anywhere?? -- Freddie Cash District HelpDesk / Network Admin fcash(a)sd73.bc.ca helpdesk(a)sd73.bc.ca (250) 377-HELP [(250) 377-4357]

5 4

Re: [Koha] Going completely on-line with Koha
by baljkas＠mb.sympatico.ca 23 Dec '03

23 Dec '03

Saturday, November 29, 2003 17:22 CST Hi, David, Good luck with going online. Just from what other library folk have experienced in the past, it may be wise to keep at least one set of your card catalogue (I assumed that was what you meant by "on-paper", although if it is a book catalogue, that is even easier) for the first year or so as staff transition to relying on the Koha ILS. Don't know about generating new acq reports, but as for your other question >[...]is there a way to add jacket cover photos or Web-based links >relevant to a book or its author? I had asked this question earlier this year. The answer at the time was "no, not yet" In responding, Paul indicated what would be needed to be added to do it, which was well beyond me. I can dig his answer up if you want. Otherwise, as Paul stated at the time, it was *not* a high priority for the developers, although I still think it would be a great little bell & whistle for Koha to consider adding soon. Cheers, Steven F. Baljkas library tech at large Koha neophyte Winnipeg, Manitoba, CANADA

8 10

Re: [Koha] Going completely on-line with Koha
by Stephen Hedges 29 Nov '03

29 Nov '03

David - At Nelsonville Public Library, we login to MySQL and issue the following command to get our monthly acquisition statistics: SELECT biblioitems.itemtype, COUNT(biblioitems.itemtype) AS count FROM items,biblioitems WHERE YEAR(items.dateaccessioned)=2003 AND MONTH(items.dateaccessioned)=11 AND biblioitems.biblioitemnumber=items.biblioitemnumber GROUP BY biblioitems.itemtype; You'll need to change this by putting in the correct year and month, of course. The report is subdivided by item type. BTW, when you first start using Koha, _every_ item will be "new." But after that first month, the report should be accurate. Stephen Hedges > Dear Librarians, > > At our small school (Thailand) we are using Koha > and would like to do away with > our on-paper catalog system. We have updated to > the most recent stable version > of > Koha but do not see a way to get a weekly or > monthly report of new books > (acquisitions). It appears this is the main > stumbling block to going completely > online. Any experience and/or advice would be > appreciated. > > Oh, and is there a way to add jacket cover photos > or Web-based links relevant > to > a book or its author? > > Thank you in advance for your help. > > Sincerely, > > David Bucknell > > -- > http://iteachnet.org/~david > > -------------------------------------------------- > -------------- > This message was sent using IMP, the Internet > Messaging Program. > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha >

1 0

Going completely on-line with Koha
by David Bucknell 29 Nov '03

29 Nov '03

Dear Librarians, At our small school (Thailand) we are using Koha and would like to do away with our on-paper catalog system. We have updated to the most recent stable version of Koha but do not see a way to get a weekly or monthly report of new books (acquisitions). It appears this is the main stumbling block to going completely online. Any experience and/or advice would be appreciated. Oh, and is there a way to add jacket cover photos or Web-based links relevant to a book or its author? Thank you in advance for your help. Sincerely, David Bucknell -- http://iteachnet.org/~david ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.

1 0

Fw: [Koha] Koha usage in Mexico or Latinamerica?
by JAVIER RICARDO MEJIA C. 28 Nov '03

28 Nov '03

> Hi erik i´m using koha and i live in latinamerica > > > > Javier >

1 0

Koha usage in Mexico or Latinamerica?
by Erik Peterson 26 Nov '03

26 Nov '03

Anyone using Koha in Mexico or Latin America? We are implementing Koha at the Peterson Schools in Mexico City and would like to be in touch w/ others in our geography. Thanks, Erik -- ___________________________________________________________ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm

2 1

problems upgrading to pre5 / z3950
by Dwiggins, David 22 Nov '03

22 Nov '03

I was running Koha 1.23 on our Redhat Linux 7.3 box. I tried running the upgrade script. It seemed to work, and the data appears to be in the database. But after the upgrade, most of the scripts refused to run, complaining about not being able to locate modules. I played with this for a bit, and was able to get it working by simply moving the old koha directory and running the install script as if I were setting up a new installation. (Although I just noticed that MARCdetail.pl seems to still doing this, and catmaintain.pl simply returns <html> and nothing else.) But now I have another problem. Since the upgrade, there doesn't appear to be a way to use the z3950 search to pull in bibliographic records on new materials. I am pretty sure that I have the z3950 daemon running correctly, but there is simply no option on the acquisition screen for doing a z3950 search. Obviously something is fishy about my installation. Can any offer guidance on what might have gone wrong/how to fix it? Thanks in advance, David Dwiggins Systems Editor/Library Manager The Tennessean 1100 Broadway Nashville, TN 37203 615-259-8332 ddwiggins(a)tennessean.com

3 3

Can't locate Net/Z3950.pm
by Erik Peterson 21 Nov '03

21 Nov '03

My friend Marcin and I trying to run the ISBN lookup packages provided previously by someone on this list, and I thought I had the Z3950 libraries installed, but I gt the following error $ ./get_isbn.pl 0802414133 Can't locate Net/Z3950.pm in @INC (@INC contains: /etc/perl /usr/lib/perl5/site_perl/5.8.0/i686-linux /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl/5.6.1 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.0/i686-linux /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.0/i686-linux /usr/lib/perl5/5.8.0 /usr/local/lib/site_perl /usr/lib/perl5/site_perl/5.6.1 .) at ./get_isbn.pl line 3. BEGIN failed--compilation aborted at ./get_isbn.pl line 3. Any suggestions? Thanks -Erik -- ___________________________________________________________ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm

2 1

RE: [Koha] problems upgrading to pre5 / z3950
by Dwiggins, David 20 Nov '03

20 Nov '03

Here are the errors. This comes from me logging into the intranet side, going to catalog, and then going to catalog maintenance: [Tue Nov 18 19:17:29 2003] [error] [client 10.13.17.170] File does not exist: /usr/local/koha/intranet/htdocs/images/background-mem.gif [Tue Nov 18 19:17:43 2003] [error] [client 10.13.17.170] File does not exist: /usr/local/koha/intranet/htdocs/images/holder.gif could not find : /usr/local/koha/opac/htdocs/includes/cat-top.inc at /usr/local/koha/intranet/modules/C4/Output.pm line 368. When I click on "Circulation," I get: HTML::Template->new() : Syntax error in <TMPL_*> tag at /usr/local/koha/intranet/htdocs/intranet-tmpl/default/en/circ/circulatio n.tmpl : 80. at /usr/lib/perl5/site_perl/5.6.1/HTML/Template.pm line 2243. [Tue Nov 18 19:20:33 2003] [error] [client 10.13.17.170] Premature end of script headers: /usr/local/koha/intranet/cgi-bin/circ/circulation.pl And when I search for a book and then click on the title, I get this: [Tue Nov 18 19:22:09 2003] [error] [client 10.13.17.170] File does not exist: /usr/local/koha/intranet/htdocs/images/background-mem.gif Field XXX must have at least one subfield at /usr/lib/perl5/site_perl/5.6.1/MARC/Record.pm line 632 [Tue Nov 18 19:22:34 2003] [error] [client 10.13.17.170] Premature end of script headers: /usr/local/koha/intranet/cgi-bin/MARCdetail.pl I then tried hitting the "create empty biblio" link, and then clicking on the z3950 search link that appears on this page. At this point, I get the following repeated each time the page refreshes. search.pl : / / / at /usr/local/koha/intranet/cgi-bin/z3950/search.pl line 52. NO RANDOM at /usr/local/koha/intranet/cgi-bin/z3950/search.pl line 59. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/local/koha/intranet/modules/C4/Search.pmline 2438. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Search.pm line 2439. I tried deleting or moving everything I could think of relating to koha and running a fresh install with a new database. I appear to still be getting the same errors on this new, fresh copy. I am using simple acquisition, and in the new install I still don't have a way to do a z3950 search. I do have a backup of the data, but this system is not yet in production and the guy who has been doing most of our cataloging is out this week. So I'm taking the opportunity to leave it down while I mess around with it. If I have to, I could probably revert back to the old version. But I'd prefer to get upgraded to 2.0. Any help is greatly appreciated! David Dwiggins Systems Editor/Library Manager The Tennessean 1100 Broadway Nashville, TN 37203 615-259-8332 ddwiggins(a)tennessean.com -----Original Message----- From: koha-admin(a)lists.katipo.co.nz [mailto:koha-admin@lists.katipo.co.nz]On Behalf Of MJ Ray Sent: Monday, November 17, 2003 7:46 PM To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] problems upgrading to pre5 / z3950 On 2003-11-17 19:33:12 +0000 "Dwiggins, David" <DDWIGGIN(a)nashvill.gannett.com> wrote: > I tried running the upgrade script. It seemed to work, and the data > appears > to be in the database. But after the upgrade, most of the scripts > refused to > run, complaining about not being able to locate modules. Yes, I think the upgrade script in pre5 might write some wrong paths to the config file. The next release will use the installer routines instead. As you noticed, they work more often. > (Although I just noticed that MARCdetail.pl seems to still > doing this, and catmaintain.pl simply returns <html> and nothing > else.) MARCdetail still doing what? Can you give us some lines from koha-error.log around the time of the error, please? catmaintain I know about. There's bug 600 open on bugs.koha.org that is the cause of this. You can try the fix there (putting the path to includes in intranet-tmpl) as a short-cut, but a real fix should be along shortly. > But now I have another problem. Since the upgrade, there doesn't > appear to be > a way to use the z3950 search to pull in bibliographic records on new > materials. I am pretty sure that I have the z3950 daemon running > correctly, > but there is simply no option on the acquisition screen for doing a > z3950 > search. Are you using simple acqui, or normal? > Obviously something is fishy about my installation. Can any offer > guidance > on what might have gone wrong/how to fix it? Maybe, maybe not. You backed up just in case we can't help enough, right? -- MJR/slef My Opinion Only and possibly not of any group I know. Please http://remember.to/edit_messages on lists to be sure I read http://mjr.towers.org.uk/ gopher://g.towers.org.uk/ slef(a)jabber.at Creative copyleft computing services via http://www.ttllp.co.uk/ _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

2 1

Fines on Koha2.0.0-pre5-W32-R2
by JAVIER RICARDO MEJIA C. 19 Nov '03

19 Nov '03

Hi i´m testing the Koha2.0.0-pre5-W32-R2 and in the release notes said that in this version i can manage fines when the book is returned too late, but i can´t make these... somebody helpme to configure the system that they say me the user has a fines and the system show the bill in the FINES & CHARGES seccion. Thanks Javier

3 2