- Koha - lists.katipo.co.nz

Forced LIMIT on reports
by George Adams 06 May '08

06 May '08

I was confused why my custom report wasn't showing me what I thought it should. Running the same query in the MySQL command-line gave me 22 rows, but the equivalent Koha report only showed 20 rows. Finally, with some MySQL logging and grep'ing, I found this: /usr/share/koha/lib/C4/Reports.pm lines 335-340 # take this line out when in production if ($format eq 'csv' or $format eq 'tab'){ } else { $sql .= " LIMIT 20"; } So, er, could those lines be taken out? :-) _________________________________________________________________ Back to work after baby–how do you know when you’re ready? http://lifestyle.msn.com/familyandparenting/articleNW.aspx?cp-documentid=57…

2 1

Problem with issuing items
by Irene Sachs 05 May '08

05 May '08

Dear All We have version 2.2.9 installed on Windows XP and have a problem with issuing items. We have completed all the boxes in the parameters /issuing rules table, and have set the status for our library members, but when we try to issue them an item, Koha warns us that confirmation is needed before issuing any item, and that too many issues have already been issued (this particular member doesn't have any items currently on loan) The warning says: Too many issues (already issued / max : a 0 / 0). The system then asks us to confirm this issue or not. If we say yes the issue is successfully completed. Is this normal, or do we need to adjust some more parameters? I notice that someone reported the same problem in the Koha archive in December 2007 but I couldn't find a response. Can anyone help please? We also have another problem (which may be related) with the parameters / issuing rules table. When we complete all the fines boxes in the required format, ie. 50,7,1 (meaning 50 kwacha fine, after 7 days, per day) and save, when we re-open the table, the figures in the fine boxes have changed with 5 zeros being added to the 50 kwacha amount – eg. 5000000 - and this means that there is only space for the first ‘comma’ and the rest of the information has disappeared. Is this affecting the issues as well? Many thanks Irene _________________________________________________________________ Find the job of your dreams before someone else does http://mycareer.com.au/?s_cid=596064

2 1

backing up
by Thomas Clark Wilson 02 May '08

02 May '08

I have been successful in installing the Windows version of KOHA and it runs very well. I can export the MARC records to a text file. However, I see no mechanism whereby one could reload the records into another version of KOHA or into a new installation in the event of a crash. Anyone have any ideas on this? Thanks, TW -- Dr. Thomas Wilson, VSO Tanzania - Zanzibar Library Dar es Salaam, TANZANIA Tel: (+255) (0)75 4978468 Email: tom.wilson.87(a)alumni.concordia.ca

2 1

Re: [Koha] [Koha-devel] RFC: alternate borrower IDs
by Jesse 01 May '08

01 May '08

I don't think this would be world-shakingly useful at our public library, but I really like the implementation. +1 -- Jesse

1 0

Possible patch for Koha 2.2.9 expiry date problems
by Jesse Weaver 01 May '08

01 May '08

Attached is a patch for C4/Date.pm. This _should_ fix the expiry problem; please let me know if it works. -- Jesse

1 0

let me rephrase the question
by Thomas Clark Wilson 30 Apr '08

30 Apr '08

I meant that I can do backups by exporting the biblio records o a text file. However, if in the future I have to reload the records, how would I do it? Would anyone know? Thanks, TW -- Dr. Thomas Wilson, VSO Tanzania - Zanzibar Library Dar es Salaam, TANZANIA Tel: (+255) (0)75 4978468 Email: tom.wilson.87(a)alumni.concordia.ca

2 1

Re: [Koha] Help with installation on Fedora 8
by Ken Lomax 30 Apr '08

30 Apr '08

On Wed, 2008-04-30 at 06:37 -0400, Joshua Ferraro wrote: > Hey Ken, > > Could you resend your email, and make sure it's CCed to the koha list? > > Josh > > On Tue, Apr 29, 2008 at 7:53 PM, Ken Lomax <ken(a)lomax.gen.nz> wrote: > > Hi Joshua > > > > Thanks for your prompt reply. > > > > It basically appears to be a perl problem in that I cannot get all the > > perl modules to install and therefore cannot get past that point in the > > koha installer. Some modules do install, and quite easly. CPAN is working > > on the system and I have upgraded Bundle::CPAN without problems. It did > > require me to install perl-CPAN (with yum) on fedora 8 and once I realized > > that then CPAN itself is no longer a problem. > > > > The koha installer gives me a list of perl modules that are required and > > some optional modules. I have been installing these one-by-one (in the > > order given) using "perl -MCPAN -e 'install "abc::def"'. Some of these > > install easily and others that dont have given me clues as to required > > dependences (such as lexslt --which requires tcp_wrappers). My previous > > (and working) install did not allow me to install some of the optional > > barcode modules and in particular Barcode::Code128 is particularly > > troublesome on both old and new servers. > > > > However MARC::File::XML does not want to install and is not giving me any > > clues that I can find. A force install does not work. > > > > To me, it is a mute point as to whether this is a perl problem or a koha > > problem, although I understand your point. I do not use these modules for > > any other program. It appears that the developers are trying to solve this > > problem with the new install-CPAN.pl file in version 3, and I would love > > to use this if I can get over the permission problem. Do I need to put the > > tar.gz file in a special place? I currently have both it and the unzipped > > folder on the Desktop (/root/Desktop/koha-*) at the moment. > > > > I am not with my server at the moment, but can give more specific > > information this evening. What would you find particularly helpful? > > > > I have read INSTALL extensively and followed it as much as possible to the > > letter. I have not looked at INSTALL.debian as being for another distro, > > but will look at it tonight. > > > > Thanks and regards > > Ken Lomax > > > > > > > > > > > > > On Tue, Apr 29, 2008 at 6:36 PM, Ken Lomax <ken(a)lomax.gen.nz> wrote: > > >> Hi > > >> > > >> I have previously installed Koha on machines (twice successfully and > > >> twice > > >> unsuccessfully), although each time with *considerable* difficulty. > > >> > > >> I have a working 2.2.9 version on my server (which is also being used > > >> for > > >> other services). The is a small SOHO network and the server also > > >> provides > > >> other services to the network. It is to contain a very small (about 600 > > >> item) library for personal/professional use. > > >> > > >> I need to replace the server hardware and am setting up a machine with > > >> Fedora 8. I have spent the last four days trying to get Koha installed > > >> on > > >> this machine (both 2.2.9 and 3.0-beta) without success. > > > Wow, that's a long time. > > > > > >> I have been trying on a brand new and clean install. However I have not > > >> been able to get all the perl modules to install-in particular some of > > >> the > > >> XML ones, eg. MARC::File::XML. A number of others I have only been able > > >> to > > >> install with considerable research and manual installation of > > >> "dependencies". They quite often suggest that force install is used, > > >> but > > >> this also always fails. I was once able to get MARC::File::XML to > > >> install > > >> by downloading source, but the koha installer refused to accept that it > > >> was installed. > > >> > > >> The install-CPAN. pl installer on version 3.0 keeps telling me i do not > > >> have rights to access/install the .tgz file, even though I am working > > >> as > > >> root. > > > Hmmm, that might be a deprecated script, I'm not certain. Anyone else > > > know? > > > It sounds like MARC::File::XML install from CPAN isn't working on Fedora, > > > would you characterize that as a Koha install problem or a M::F::X > > > problem? > > > It would be great to have an RPM for Koha Perl modules available, but I > > > think > > > the developers are probably a bit tied up working on koha-specific issues > > > at the moment. > > > > > >> I also had considerable trouble with Zebra but eventually was able to > > >> install a rpm from the idzebra site from FC6. I think this was > > >> successful, > > >> but have been unable to confirm its operation. > > > Sounds like Zebra is also hard to install on Fedora ... again, is this a > > > Koha > > > install problem or a Zebra install one? > > > > > >> I have got to the end of my tether on this, and have not been able to > > >> find > > >> any other suggestions on the Internet. I apologise if there is > > >> something > > >> under my nose that I have not been able to find, but can any one give > > >> guidance or point me to sutable resources. I have looked at all the > > >> documentation on the koha.org site as well as doing google searches. > > >> Installing this program should *not* be this difficult. > > > Did you see the INSTALL and INSTALL.debian files in the Koha distribution? > > > > > >> I have considerable experience with fedora systems (please do not > > >> suggest > > >> installing an other distro--it is not an option for me and I dont want > > >> a > > >> flame war on that subject), but have only had minor experience with > > >> perl. > > >> I have been able to come to grips with perl -MCPAN -e 'install > > >> "xyz::abc"' but have little further experience. Is it a perl thing that > > >> I > > >> am not understanding? > > > Not sure yet, I think we need more information about the specific > > > problems you're > > > having. Is CPAN not working for you on Fedora? > > > > > > Cheers, > > > > > > -- > > > Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE > > > CEO migration, training, maintenance, support > > > LibLime Featuring Koha Open-Source ILS > > > jmf(a)liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS > > > > > > > > > > > >

1 0

Help with installation on Fedora 8
by Ken Lomax 30 Apr '08

30 Apr '08

Hi I have previously installed Koha on machines (twice successfully and twice unsuccessfully), although each time with *considerable* difficulty. I have a working 2.2.9 version on my server (which is also being used for other services). The is a small SOHO network and the server also provides other services to the network. It is to contain a very small (about 600 item) library for personal/professional use. I need to replace the server hardware and am setting up a machine with Fedora 8. I have spent the last four days trying to get Koha installed on this machine (both 2.2.9 and 3.0-beta) without success. I have been trying on a brand new and clean install. However I have not been able to get all the perl modules to install-in particular some of the XML ones, eg. MARC::File::XML. A number of others I have only been able to install with considerable research and manual installation of "dependencies". They quite often suggest that force install is used, but this also always fails. I was once able to get MARC::File::XML to install by downloading source, but the koha installer refused to accept that it was installed. The install-CPAN. pl installer on version 3.0 keeps telling me i do not have rights to access/install the .tgz file, even though I am working as root. I also had considerable trouble with Zebra but eventually was able to install a rpm from the idzebra site from FC6. I think this was successful, but have been unable to confirm its operation. I have got to the end of my tether on this, and have not been able to find any other suggestions on the Internet. I apologise if there is something under my nose that I have not been able to find, but can any one give guidance or point me to sutable resources. I have looked at all the documentation on the koha.org site as well as doing google searches. Installing this program should *not* be this difficult. I have considerable experience with fedora systems (please do not suggest installing an other distro--it is not an option for me and I dont want a flame war on that subject), but have only had minor experience with perl. I have been able to come to grips with perl -MCPAN -e 'install "xyz::abc"' but have little further experience. Is it a perl thing that I am not understanding? Any help would be greatly appreciated. Regards to all Ken Lomax

2 1

Barcodes...
by Huck 29 Apr '08

29 Apr '08

For those who struggle with bar-code creation... Scribus from scribus.net will actually output barcodes based on what YOU input... atm I haven't figured out how to script scribus into doing more than one at a time(don't know if it's even possible)... but after spending 1hr today trying to get Koha 3.0 to spit out some bar-codes for me(and failing miserably due to my ignorance of HOW that modules is supposed to function)...I went looking for something that would just create a barcode for me... so I made an 11 row by 3 column template and started inserting my barcodes into each cell...which should print off on some Avery labels. btw just an FYI on the Koha 3.0 beta(release as of 1 week ago today), there is no 'help' in the documentation on the barcode generation page. --Huck

6 8

Advanced Search returns no records
by Luis Rivas 29 Apr '08

29 Apr '08

Hi all, We are using Koha v. 2.2.9, and have found that the Opac Advanced Search does not return any record when used. Quick Search works fine. It appear the problem is in the sql created in sub create_request in module SearchMarc.pm: select distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_word as m1,marc_subfield_table as m2 where biblio.biblionumber=marc_biblio.biblionumber and biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and (m1.bibid=m2.bibid) and ((m1.word like 'quantum' and m1.tagsubfield in ('biblio.title')) and (m2.subfieldvalue = 'PI' and concat(m2.tag,m2.subfieldcode) in ('items.holdingbranch'))) order by biblio.title ASC term is quantum PI ../koha/modules/C4/SearchMarc.pm line 274. When I replace 'biblio.title' for its correspondent MARC tag 245a and 'items.holdingbranch' for 952d it all works fine. Is there a fix available? Thanks in advanced for your help. Luis Cabo Senior Software Developer Perimeter Institute for Theoretical Physics <http://www.perimeterinstitute.ca/> (519) 569-7600 x5120

1 0