- Koha - lists.katipo.co.nz

query
by Archana Nanda 22 Nov '06

22 Nov '06

can anybody tell me i have to install koha on fedora 4 which is a postgres based dspace server...should i continue...mean can i install koha along with dspace i.e. postgres and mysql both on same machine....?

1 0

how to automate adding of items.
by Alex King 21 Nov '06

21 Nov '06

I'm needing some assistance with adding (biblios & items) into koha automatically. The biblio data is (for the most part) already in the reservoir. I have a list of matched ISBNs and barcodes, and I need to "create" a biblio from data in the reservoir and add an item. I can do this easily enough through the web UI, but there has to be a better way to enter the data automatically, given that I have the list of ISBNs and barcodes already in a text file. I am comfortable enough with scripting and accessing the mysql tables directly. I'm not though familiar enough with the koha database to know what to do there. I know it's not simply a matter of adding records in a single table. Can anyone point me to any scripts I can start from or suggest better ways to achieve what I'm trying to do? My thinking is to look at the cgi scripts and see what they are doing behind the scenes and write non-interactive scripts that do the same thing. My guess is they probably call library routines in the "C4" directory, and I could hook into the same library routines. Cheers, Alex

1 0

Re: Import data from text file or MS-Excel file to MARC
by thandu venkat narayana 19 Nov '06

19 Nov '06

Dear Koha Users, I want to import bibliographic records from text file or MS-Excek file to MARC. How to convert any one can help to me. Regards Venkat ____________________________________________________________________________________ Sponsored Link Mortgage rates near 39yr lows. $310k for $999/mo. Calculate new payment! www.LowerMyBills.com/lre

1 0

Duplicate 300f (Physical Description) field
by T & J Kotula 18 Nov '06

18 Nov '06

Hi, A few days ago I have reported a strange behaviour, where certain MARC fields would get duplicated. I have received one reply from Henri, asking if all the subfields were on the same tab. Well they were not - I split them between two tabs. 1. How can I fix it? Unfortunately the obvious solution of putting all these subfields on one tab makes the problem worse, as then all subfields of that field get duplicated - when I go to edit the biblio. 2. Should this be entered as a bug - if it's not already? Thanking in advance for any hints or suggestions. tomasz.

1 0

installation problem 2.2.6
by robin ros 17 Nov '06

17 Nov '06

hi everyone, (i speak spanish, i am sorry my english) i want to install koha 2.2.6, but the system tellme that i donot have this modules installed: You are missing some Perl modules required by Koha. Please run this again after installing them. They may be installed by finding packages from your operating system supplier, or running (as root) the following commands: perl -MCPAN -e 'install "ZOOM"' perl -MCPAN -e 'install "You will need PDF::API2 for barcode generator"' perl -MCPAN -e 'install "You will need GD::Barcode for the new barcode generator"' perl -MCPAN -e 'install "You will need PDF::Reuse::Barcode for the new barcode generator"' but i have installed all these modules of perl, cpan tellme this for all that modules are up to date, i have a debian sarge system, can anybody helpme, thanks a lot, robin

2 2

a query
by Archana Nanda 17 Nov '06

17 Nov '06

Sir/Mam pl. guide me how to install koha .....i m new to it. I have fedora 4 srever. Already installed dspace and it's running well now need to install koha on same system. pl. tell me the feasibility and step by step guidelines. thanking You in anticipation; -- Archana Nanda, Information Scientist, Central Library, TIET

1 0

plugin_launcher.pl error
by library cdac 17 Nov '06

17 Nov '06

Hi! Can anyone let me know what is this error and how to solve it? When entering a biblio record, in the 008 field an window is displayed stating that 'You have chosen to open plugin_launcher.pl. and what do you want the firefox to do with it?' When a search is made for the same record in the opac, there too it does not retriev the record but gives this error. --trupti

1 0

Re: [Koha] Error 500
by Rob Weir 16 Nov '06

16 Nov '06

Hi Ata, What version of Active Perl did you install? Is it the newest one - 5.8.8.819? If you can tell me the exact version, I will test with that version to figure out what is going on. Rob > -------Original Message------- > From: Ata ur Rehman <ata.rehman(a)gmail.com> > Subject: Re: [Koha] Error 500 > Sent: 16 Nov '06 05:41 > > Dear Rob / All > > please review the following information: > > =========================PATH===================== > C:\>path > PATH=C:\MYSQL\BIN\;C:\usr\bin\;c:\program > files\imagemagick-6.2.6-q8;C:\WINDOWS\system32; > C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\QuickTime\QTSystem\; > C:\jdk\bin;C:\jdk\lib;D:\paklag\mysql-4.0.18\bin;C:\Program > Files\Zebra\bin;C:\Program Files\Yaz\bin; > D:\Greenstone271\bin\script;D:\Greenstone271\bin\windows\perl\bin;C:\MySQL\Bin;C:\MYSQL\BIN\;C:\usr\bin\; > c:\program files\imagemagick-6.2.6-q8;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem; > C:\Program Files\QuickTime\QTSystem\;C:\jdk\bin;C:\jdk\lib;D:\paklag\mysql-4.0.18\bin; > C:\Program Files\Zebra\bin;C:\Program Files\Yaz\bin;D:\Greenstone271\bin\script; > D:\Greenstone271\bin\windows\perl\bin;C:\MySQL\Bin; > =========================================================== > > > =========================PERL MODULES===================== > ppm> query * > > Querying target 1 (ActiveP > 1. ActivePerl-Config > 2. ActivePerl-DocTools > 3. ActiveState-Utils > 4. Archive-Tar > 5. Archive-Zip > 6. Compress-Zlib > 7. Data-Dump > 8. DBI > 9. Digest-HMAC > 10. Digest-MD2 > 11. Digest-MD4 > 12. Digest-SHA1 > 13. File-CounterFile > 14. Font-AFM > 15. HTML-Parser > 16. HTML-Tagset > 17. HTML-Tree > 18. IO-String > 19. IO-Zlib > 20. libwin32 > 21. libwww-perl > 22. MARC-Record > 23. MD5 > 24. MIME-Base64-Scripts > 25. PDF-API2 > 26. SOAP-Lite > 27. Term-ReadLine-Perl > 28. TermReadKey > 29. Test-Simple > 30. Text-Autoformat > 31. Text-Reform > 32. Tk > 33. Unicode-String > 34. URI > 35. Win32-AuthenticateU~ > 36. XML-Parser > 37. XML-Simple > ppm> > ================================================ > > > Thanks > > Regards, > > Ata > > On 11/15/06, Rob Weir <robweir(a)alum.drexel.edu> wrote: > > Hi Ata, > > Your install proceedure looks good. The versions you used and the > > install locations you used are fine. To troubleshoot, could you please > > open a command prompt window (Start -> Programs -> Accessories > > -> Command Prompt). > > > > First type "path" and hit enter and verify that C:\usr\bin\ is on your path. > > > > On my system, I get: > > C:\>path > > > > PATH=C:\MYSQL\BIN;C:\usr\bin\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem > > > > Then type "ppm" and hit enter to start the perl package manager. Next > > type "query *" and hit enter and you should get a list of all the perl > > modules that are installed on your system. Verify that the following > > modules are installed: > > Convert-ASN1 > > DateManip > > DBD-Mysql > > DBI > > Digest-MD5 > > File-Spec > > HTML-Template > > Mail-Sendmail > > MARC-Record > > PDF_API2 > > perl-ldap > > Time-HiRes > > > > That is the list of modules that I have for V2.2.4. An install package > > for V2.2.6 is now available, and it requires some additional modules: > > MARC-XML > > Class-Accessor > > Date-Calc > > Date-Random > > GD-Barcode > > PDF-Reuse-Barcode > > > > I think I would troubleshoot v2.2.4 first, but then I suggest you go > > ahead and install V2.2.6 so you have the newer version. > > > > Let me know what you find out, or if you have any questions. > > > > Rob > > > > > -------Original Message------- > > > From: Ata ur Rehman > > > Subject: Re: [Koha] Error 500 > > > Sent: 15 Nov '06 04:09 > > > > > > Dear Robert Lyon / All > > > > > > Thanks for prompt response. > > > I adapted the following method to install Koha > > > > > > 1- Installation of Active Perl 5.8.8 Build 817 at C:\usr > > > 2- Installation of Apache 2.0.58 at C:\Program Files\Apache > > Group\Apache > > > 3- Installation of MySQL 4.0.18 at C:\MySQL > > > 4- Installation of Koha2.2.4-W32-R0 at default location > > > > > > Note: During installation, there is no error. > > > > > > Is this right method to install? > > > > > > > > > Ata > > > > > > On 11/15/06, Robert Lyon wrote: > > > > The error indicates that you do not have the Perl module > > HTML::Template > > > > installed > > > > > > > > This is a common module that (I guess) the setup expects you to have > > > > already installed > > > > You will need to install HTML::Template for the koha system to work > > as > > > > it is the page renderer > > > > > > > > Bob > > > > > > > > > > > > > > > > Ata ur Rehman wrote: > > > > > Dear All > > > > > Assalam O Alaikum > > > > > > > > > > I am new user of Koha. I just installed Koha on windows XP. When i > > > > > open the browser with localhost in address bar, it redirects to > > > > > http://localhost/cgi-bin/koha/opac-main.pl and I find the error > > 500. > > > > > I looked into the error logs of apache. That is: > > > > > > > > > > [Tue Nov 14 17:43:39 2006] [error] [client 127.0.0.1] Premature > > end of > > > > > script headers: opac-main.pl > > > > > [Tue Nov 14 17:43:39 2006] [error] [client 127.0.0.1] Can't locate > > > > > HTML/Template.pm in @INC (@INC contains: > > > > > c:/usr/koha224/intranet/modules C:/usr/lib C:/usr/site/lib .) at > > > > > C:/usr/koha224/opac/cgi-bin/koha/opac-main.pl line 5. > > > > > [Tue Nov 14 17:43:39 2006] [error] [client 127.0.0.1] BEGIN > > > > > failed--compilation aborted at > > > > > C:/usr/koha224/opac/cgi-bin/koha/opac-main.pl line 5. > > > > > > > > > > Please suggest some solution. Also some beginers tutorial if > > possible > > > > > > > > > > Regards, > > > > > > > > > > Ata ur Rehman > > > > > _______________________________________________ > > > > > Koha mailing list > > > > > Koha(a)lists.katipo.co.nz > > > > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > > > > > > > -- > > > > Robert Lyon > > > > Katipo Communications > > > > > > > _______________________________________________ > > > Koha mailing list > > > Koha(a)lists.katipo.co.nz > > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > >

1 0

Re: [Koha] Error 500
by Rob Weir 16 Nov '06

16 Nov '06

Hi Ata, Your install proceedure looks good. The versions you used and the install locations you used are fine. To troubleshoot, could you please open a command prompt window (Start -> Programs -> Accessories -> Command Prompt). First type "path" and hit enter and verify that C:\usr\bin\ is on your path. On my system, I get: C:\>path PATH=C:\MYSQL\BIN;C:\usr\bin\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem Then type "ppm" and hit enter to start the perl package manager. Next type "query *" and hit enter and you should get a list of all the perl modules that are installed on your system. Verify that the following modules are installed: Convert-ASN1 DateManip DBD-Mysql DBI Digest-MD5 File-Spec HTML-Template Mail-Sendmail MARC-Record PDF_API2 perl-ldap Time-HiRes That is the list of modules that I have for V2.2.4. An install package for V2.2.6 is now available, and it requires some additional modules: MARC-XML Class-Accessor Date-Calc Date-Random GD-Barcode PDF-Reuse-Barcode I think I would troubleshoot v2.2.4 first, but then I suggest you go ahead and install V2.2.6 so you have the newer version. Let me know what you find out, or if you have any questions. Rob > -------Original Message------- > From: Ata ur Rehman > Subject: Re: [Koha] Error 500 > Sent: 15 Nov '06 04:09 > > Dear Robert Lyon / All > > Thanks for prompt response. > I adapted the following method to install Koha > > 1- Installation of Active Perl 5.8.8 Build 817 at C:\usr > 2- Installation of Apache 2.0.58 at C:\Program Files\Apache Group\Apache > 3- Installation of MySQL 4.0.18 at C:\MySQL > 4- Installation of Koha2.2.4-W32-R0 at default location > > Note: During installation, there is no error. > > Is this right method to install? > > > Ata > > On 11/15/06, Robert Lyon wrote: > > The error indicates that you do not have the Perl module HTML::Template > > installed > > > > This is a common module that (I guess) the setup expects you to have > > already installed > > You will need to install HTML::Template for the koha system to work as > > it is the page renderer > > > > Bob > > > > > > > > Ata ur Rehman wrote: > > > Dear All > > > Assalam O Alaikum > > > > > > I am new user of Koha. I just installed Koha on windows XP. When i > > > open the browser with localhost in address bar, it redirects to > > > http://localhost/cgi-bin/koha/opac-main.pl and I find the error 500. > > > I looked into the error logs of apache. That is: > > > > > > [Tue Nov 14 17:43:39 2006] [error] [client 127.0.0.1] Premature end of > > > script headers: opac-main.pl > > > [Tue Nov 14 17:43:39 2006] [error] [client 127.0.0.1] Can't locate > > > HTML/Template.pm in @INC (@INC contains: > > > c:/usr/koha224/intranet/modules C:/usr/lib C:/usr/site/lib .) at > > > C:/usr/koha224/opac/cgi-bin/koha/opac-main.pl line 5. > > > [Tue Nov 14 17:43:39 2006] [error] [client 127.0.0.1] BEGIN > > > failed--compilation aborted at > > > C:/usr/koha224/opac/cgi-bin/koha/opac-main.pl line 5. > > > > > > Please suggest some solution. Also some beginers tutorial if possible > > > > > > Regards, > > > > > > Ata ur Rehman > > > _______________________________________________ > > > Koha mailing list > > > Koha(a)lists.katipo.co.nz > > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > -- > > Robert Lyon > > Katipo Communications > > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha >

4 5

FW: Internet Explorer and Admin Interface
by Phill Hardstaff 16 Nov '06

16 Nov '06

Hi All, posting this again as I seemed not to stir anything much up last time and I just installed 2.2.6 and the same "bugs" in Koha remain :) OK, if I am posting this to the wrong place let me know, is there a developers list or something ? These are very minor changes below that do not affect Firefox at all and make Internet Explorer pretty much 100% compatible with the admin interface using the default template. We have been testing for around 2 months with these changes and only using IE in our library, in fact because of the "bug" with Firefox that does not show the cursor on the search page which IE does, IE actually works better than FF for us. To fix all the pages under /koha/intranet/cgi-bin/value_builder I used sarep, a really cool Perl command line search and replace tool. freebsd# cd /usr/local/koha/intranet/cgi-bin/value_builder/ freebsd# /usr/local/bin/sarep -v "unimarc field " "unimarc_field_" * Cheers Phill -----Original Message----- From: Phill Hardstaff Sent: Friday, 11 August 2006 11:33 To: 'koha(a)lists.katipo.co.nz' Subject: Internet Explorer and Admin Interface Hi all, we hit a few snags with Firefox not displaying form fields properly, see this post : >On Wed, Aug 09, 2006 at 03:43:15PM +1100, Eleanor Kleiber said: > Hello everyone, > I am new to the list as I have inherited Koha from my predecessor, so please bear with me. >This will be the first of >> several posts! > We are working with Koha >2.2.5. >Our biggest problem here at the SPC is that the cursor does not show up >on the right side of the screen. This is on the Admin pages, default theme, English, Catalogue - Catalogue Search - then the 4 fields under Other Options (ie Item Barcode) on the right hand side, in Firefox click in any of them and you will not be able to see the cursor, this won't happen if you are running say 800x600 screen resolution and these boxes are bunched over to the left hand side, you then have a cursor, however these work fine in Internet Explorer, so ... I did a little digging, and I am aware that for the admin Interface that Mozilla is the only approved browser, why I am not sure but anyway, that's how it is. The one big problem with IE and Koha is that is does not work on these pages. Catalogue - Add Biblio - Create Empty Biblio Then anywhere where you have the three little dots that normally open a popup (in Firefox this works) nothing happens in IE, you get a script error saying "invalid argument". So, I am really interested in getting Koha Admin to work with IE here so I took a look at the code. What IE is choking on is the following. This does not work function Dopop(link,i) { defaultvalue=document.forms['f'].field_value[i].value; newin=window.open(link+"&result="+defaultvalue,"value builder",'width=550,height=550,toolbar=false,scrollbars=yes'); This does work function Dopop(link,i) { defaultvalue=document.forms['f'].field_value[i].value; newin=window.open(link+"&result="+defaultvalue,"value_builder",'width=55 0,height=550,toolbar=false,scrollbars=yes'); When "value builder" is "value_builder" IE works fine ? I changed this in the default template files addbiblio.tmpl line 599, additem.tmpl line 121, authorities.tmpl line 162 and things started working in Internet Explorer, I start to get pop-ups on addbiblio etc where it calls javascript:Dopop() Then found I also needed to change the files under /koha/intranet/cgi-bin/value_builder, This is for all the Clic() functions. Take marc21_field_008.pl as an example (as this was one I had to change) before function Clic$function_name(i) { defaultvalue=document.forms['f'].field_value[i].value; newin=window.open(\"../plugin_launcher.pl?plugin_name=marc21_field_008.p l&index=\"+i+\"&result=\"+defaultvalue,\"unimarc field 100\",'width=1000,height=600,toolbar=false,scrollbars=yes'); after function Clic$function_name(i) { defaultvalue=document.forms['f'].field_value[i].value; newin=window.open(\"../plugin_launcher.pl?plugin_name=marc21_field_008.p l&index=\"+i+\"&result=\"+defaultvalue,\"unimarc_field_100\",'width=1000 ,height=600,toolbar=false,scrollbars=yes'); ie if I change \"unimarc field 100\" to \"unimarc_field_100\" it then works fine in IE, why is this ? Is this something that can easily be changed to accommodate IE as most everything else except this works ? It seems most of the admin interface now works for us in IE, and we can see the cursor that we cannot see in Firefox :) Cheers Phill -- Phill Hardstaff MCSA 2003_A+_Network+_Inet+_Server+ Senior Support Engineer Secretariat of the Pacific Community B.P. D5 Noumea Cedex 98848 New Caledonia

2 1