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

Fill a koha installation with very partial data...
by Marco Gaiarin 08 May '03

08 May '03

I've collected some data from the books stored in a library of my organization. This data was managed with a simple db (microsoft works), and contain rather minimal data, like: 1) title 2) author 3) publisher 3) the series title (first volume, second volume, ...) 4) a field that can be considered like an item type 5) the ``location'', that i think i can consider like a branches With this simple list of books i can fill the koha database and start using it quickly?! Thanks. -- dott. Marco Gaiarin GNUPG Key ID: 240A3D66 Associazione ``La Nostra Famiglia'' http://www.sv.lnf.it/ Polo FVG - Via della Bontà, 7 - 33078 - San Vito al Tagliamento (PN) gaio(at)sv.lnf.it tel +39-0434-842711 fax +39-0434-842797 Osservatorio sulle sporche menzogne di guerra http://www.peacelink.it/mediawatch/

2 2

koha and museums
by Pat Eyler 01 May '03

01 May '03

I know that there are a couple of museums using Koha (or looking at using Koha). There is a thread of discussion at http://usrlib.info/story/2003/4/16/73130/6689 which might be of interest if you're looking at (or already) doing this. thanks, -pate Pat Eyler Kaitiaki/manager migrant Linux sys admin the Koha project ruby, shell, and perl geek http://www.koha.org http://pate.eylerfamily.org

1 0

Setting up on Mandrake
by Timothy R. Butler 30 Apr '03

30 Apr '03

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, I'm trying to setup Koha 1.9.2b on a Mandrake Linux 9.1 box (Apache 2.0), and I'm having some trouble. I took the httpd.conf adjustments that the auto-installer made and placed them in the vhosts.conf and commonhttpd.conf files that MDK has split httpd conf into, but it doesn't seem to be working quite right. In /etc/httpd/2.0/conf/vhosts/vhosts.conf: - --------------------------------------- Listen 8080 # NameVirtualHost is used by one of the optional configurations detailed below #NameVirtualHost 11.22.33.44 # KOHA's OPAC Configuration <VirtualHost localhost:80> ServerAdmin tbutler(a)uninetsolutions.com DocumentRoot /home/uninet/www-koha/opac/htdocs ServerName localhost ScriptAlias /cgi-bin/koha/ /home/uninet/www-koha/opac/cgi-bin/ ErrorLog logs/opac-error_log TransferLog logs/opac-access_log SetEnv PERL5LIB "/home/uninet/www-koha/intranet/modules" Options +Includes AddHandler server-parsed .html </VirtualHost> # KOHA's INTRANET Configuration <VirtualHost localhost:8080> ServerAdmin tbutler(a)uninetsolutions.com DocumentRoot /home/uninet/www-koha/intranet/htdocs ServerName localhost ScriptAlias /cgi-bin/koha/ "/home/uninet/www-koha/intranet/cgi-bin/" ErrorLog logs/koha-error_log TransferLog logs/koha-access_log SetEnv PERL5LIB "/home/uninet/www-koha/intranet/modules" Options +Includes AddHandler server-parsed .html </VirtualHost> - --------------------------------------- In /etc/httpd/2.0/conf/commonhttpd.conf: - --------------------------------------- <Directory /home/uninet/www-koha/intranet> AuthUserFile /etc/kohaintranet.pass AuthType Basic AuthName "Koha Intranet (for librarians only)" Require valid-user <IfModule mod_access.c> Order allow,deny Allow from all </IfModule> </Directory> - --------------------------------------- The rest is pretty much standard issue Mandrake httpd setup. If I go to localhost:8080, I get a 403 Forbidden error, ditto if I go to localhost:80. Any ideas? Thanks, Tim - -- - --------------------------------------------------------------- Timothy R. Butler Universal Networks www.uninet.info ==================== <tbutler(a)uninet.info> ==================== | Christian Portal: | Have you not learned great lessons | | www.faithtree.com | from those who braced themselves | | GNU/Linux News: | against you and disputed the | | www.ofb.biz | passage with you? --Walt Whitman | -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE+qtzQK37Cns9gJ0gRAoOxAJ9jG1NlN6d6bBKwO6xPegQ+B37LUACaA+6r 5jZJ3sIbgBaHin7MjIo7dqA= =A1uF -----END PGP SIGNATURE-----

3 2

Database Accessing
by Waylon Robertson 30 Apr '03

30 Apr '03

Okay.. with koha 1.2.2 i can do selects using tables... like biblio, borrowers.. i.e virtually using the structure as shown in koha.mysql - the file that creates the inital structure. With koha 1.9.0+, Will i still be able to access the dbase using the exact same select statements? or will it be more difficult to custom build my sql queries? Waylon Robertson Secretary/Assistant Librarian/Koha developer/inplementor of the Palmerston North Branch of the Theosophical Society in New Zealand, Inc.

4 3

Importing Data
by Timothy R. Butler 27 Apr '03

27 Apr '03

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi again, Mike Hansen mentioned to me that perhaps the best way to import my legacy data would be to use a CSV file. The question I have is, what type of organization should I have the CSV file and how should I import it? The first question, to be a bit more specific, is what data should go in what order in the CSV file? Is there a certain format I should use? The second question being should I somehow try to import the CSV directly into MySQL (IIRC there is a way to do this, although I've always stuck to using SQL format for inputting stuff) or can I some how get Koha to process my file? As I believe I mentioned before, currently I have a script that breaks apart the old library program's proprietary data format and then spews out what it gets into some other format. I can, in other words, order the data in whatever way I need to to import it. Thanks! -Tim - -- - --------------------------------------------------------------- Timothy R. Butler Universal Networks www.uninet.info ==================== <tbutler(a)uninet.info> ==================== | Christian Portal: | Have you not learned great lessons | | www.faithtree.com | from those who braced themselves | | GNU/Linux News: | against you and disputed the | | www.ofb.biz | passage with you? --Walt Whitman | -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE+qxG8K37Cns9gJ0gRAtFwAJ4rerAaJSAZjqyprL1jOrugKBYZtwCfbVLe nh2Y+/BRa/VkJJcUpNsvHAQ= =1cYv -----END PGP SIGNATURE-----

1 0

Importing Legacy Data
by Timothy R. Butler 27 Apr '03

27 Apr '03

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi again, I'd like to import legacy data from an old library program we have used. Here's the problem: we are still using the Dewey Decimal system. Is there any way I can stick to using that system so as not to have to manually update each book's record? Thanks, Tim - -- - --------------------------------------------------------------- Timothy R. Butler Universal Networks www.uninet.info ==================== <tbutler(a)uninet.info> ==================== | Christian Portal: | Have you not learned great lessons | | www.faithtree.com | from those who braced themselves | | GNU/Linux News: | against you and disputed the | | www.ofb.biz | passage with you? --Walt Whitman | -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE+quCSK37Cns9gJ0gRAodcAJ9NKVSyquQ0hPAKfGzhi185NzPPxwCaArv2 35OlUAdfXXqhkXRFRvLNy5U= =GNcj -----END PGP SIGNATURE-----

2 1

Re: [Koha] ( Internal Server Error)
by Mohamed Amin 24 Apr '03

24 Apr '03

>Are any errors reported in the apache error logs? > >Steve. > No Steve , there are no errors reported for the "search.pl" script , since I add the line of code u asked for . Mohamed Amin _________________________________________________________________ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail

2 1

Re: [Koha] ( Internal Server Error)
by Mohamed Amin 24 Apr '03

24 Apr '03

>Can you see the error printed out at the top of the generated web page? >You might need to "View Source" and look for the error message at the top >of that output. It'd be better if we could find the source of the error >instead of modifying all of those web scripts.... > >Steve. I can find no errors even by viewing source . and here is a copy of the html output <!doctype html public "-//w3c//dtd html 4.0 transitional//en">   <html> <head> <title>KOHA: INTRANET: Catalogue</title> <style type="text/css">  </style> <SCRIPT LANGUAGE="JavaScript">  </script> </head> <body text="black" bgcolor="white" link="#0000ff" vlink="#0000ff" "3366cc" Alink="#cc3300" marginheight=0 marginwidth=0 leftmargin=0 topmargin=0 onLoad=focusinput()>   <table cellpadding=0 cellspacing=0 width="100%" border=0> <tr bgcolor=663266 > <td valign=top> <table cellpadding=0 cellspacing=0 border=0 height=29> <tr valign=top bgcolor=663266 > <td background="/images/catalogue-spot-1.gif" width="224" height="29"><font size=1 face="arial"><img src="/images/holder.gif" width=210 height=4 alt=" " hspace=0 vspace=0><br> <img src="/images/holder.gif" width=35 height=21 align=left alt=" " hspace=0 vspace=0><font size="+1">KOHA: <a href="/cgi-bin/koha/mainpage.pl">Main Menu</a></font><br> <img src="/images/holder.gif" width=210 height=1 alt=" " hspace=0 vspace=0></FONT></td> </TR></TABLE> </td> <td valign=bottom align=right> <img src="/images/holder.gif" WIDTH=1 HEIGHT=38 HSPACE=0 vspace=0></td> <td valign=bottom align=right> <table cellpadding=0 cellspacing=0 border=0 height=29><tr><td> <img src=/images/cat-cat.gif border="0" name=menu usemap="#map" HSPACE=0 vspace=0 ></td> </TR></TABLE></TD> </tr> </tr> <TR VALIGN=TOP BGCOLOR="000000"><TD COLSPAN=3><img src="/images/blackdot.gif" WIDTH=1 HEIGHT=2 HSPACE=0 vspace=0></TD></TR> </table> <map name="map"> <area shape="rect" coords="18,8,84,27" href="/cgi-bin/koha/catalogue-home.pl" alt="Catalogue" onMouseOver="if(document.images)document.menu.src='/images/cat-cat.gif'" onMouseOut="if(document.images)document.menu.src='/images/cat-cat.gif'"> <area shape="rect" coords="94,8,149,28" href="/cgi-bin/koha/members-home.pl" alt="Members" onMouseOver="if(document.images)document.menu.src='/images/cat-mem.gif'" onMouseOut="if(document.images)document.menu.src='/images/cat-cat.gif'"> <area shape="rect" coords="154,9,212,29" alt="Acquisitions" href="/cgi-bin/koha/loadmodules.pl?module=acquisitions" onMouseOver="if(document.images)document.menu.src='/images/cat-acq.gif'" onMouseOut="if(document.images)document.menu.src='/images/cat-cat.gif'"> <area shape="rect"alt="Reports" coords="217,7,289,27"href="/cgi-bin/koha/reports-home.pl" onMouseOver="if(document.images)document.menu.src='/images/cat-rep.gif'" onMouseOut="if(document.images)document.menu.src='/images/cat-cat.gif'"> <area shape="rect" coords="306,8,352,27" href="/cgi-bin/koha/circ/circulation.pl" alt="Circulation" onMouseOver="if(document.images)document.menu.src='/images/cat-crc.gif'" onMouseOut="if(document.images)document.menu.src='/images/cat-cat.gif'"> <area shape="rect" alt="Home" coords="374,9,419,29" href="/cgi-bin/koha/mainpage.pl" onMouseOver="if(document.images)document.menu.src='/images/cat-hom.gif'" onMouseOut="if(document.images)document.menu.src='/images/cat-cat.gif'"> <area shape="default" nohref> </map> <BLOCKQUOTE> <center> <p align=left><a href=/cgi-bin/koha/userpage.pl>Log In</a> to Koha</p> You searched on <b>keyword = egypt, </b> 2 results found <p>  <img src=/images/numbers/placeholder.gif border=0> <img src=/images/numbers/placeholder.gif border=0> <p>  <table border=0 cellspacing=0 cellpadding=2 width=90%> <tr background="/images/background-mem.gif"> <th align=left>Title</th><th align=left>Author</th><th>©</th><th>Item Count</th><th>Location</th> <th> </th> </tr>  <tr> <td><a href=/cgi-bin/koha/detail.pl?&bib=488>An Egyptian Pyramid</a></td> <td><a href=/cgi-bin/koha/search.pl?author=Morley,%20Jacqueline&>Morley, Jacqueline</a></td> <td align=center> 1991 </td> <td align=center> 0 </td> <td> </td> <td> <a href=/cgi-bin/koha/request.pl?bib=488>Request</a></td> </tr> <tr> <td><a href=/cgi-bin/koha/detail.pl?&bib=487>Ancient Egypt</a></td> <td><a href=/cgi-bin/koha/search.pl?author=Hart,%20George&>Hart, George</a></td> <td align=center> 1990 </td> <td align=center> 1 </td> <td> Main Library </td> <td> <a href=/cgi-bin/koha/request.pl?bib=487>Request</a></td> </tr> <tr bgcolor=#ccccff background="/images/background-mem.gif"><td colspan=6> <table border=0 cellpadding=0 cellspacing=0 width=100%"> <tr bgcolor=#ccccff background="/images/background-mem.gif"><td align=left>   </td><td align=right>   </td></tr> </table> </td></tr> </table> <br> Results 1 through 2 of 2 records. <hr> Try another <a href=/cgi-bin/koha/catalogue-home.pl>search</a> <br clear=all> <p>   </p> </BLOCKQUOTE> <table cellpadding=0 cellspacing=0 width="100%" border=0> <TR VALIGN=TOP BGCOLOR="000000"><TD COLSPAN=6><img src="/images/blackdot.gif" WIDTH=1 HEIGHT=2 HSPACE=0 vspace=0></TD></TR></TABLE> <CENTER> <FONT SIZE=2 face="arial, helvetica"> <A HREF="/cgi-bin/koha/mainpage.pl">Home</a> || <A HREF="/cgi-bin/koha/circ/circulation.pl">Circulation</a> || <A HREF="/cgi-bin/koha/catalogue-home.pl">Catalogue</a> || <A HREF="/cgi-bin/koha/members-home.pl">Members</a> || <A HREF="/cgi-bin/koha/loadmodules.pl?module=acquisitions">Acquisitions</a> || <A HREF="/cgi-bin/koha/reports-home.pl">Reports</a> || <A HREF="/cgi-bin/koha/admin-home.pl">System Parameters</a> || <A HREF="/help/">Help</a> </FONT> </CENTER> </BODY> </HTML> Mohamed Amin _________________________________________________________________ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail

2 1

Re: [Koha] ( Internal Server Error)
by Mohamed Amin 24 Apr '03

24 Apr '03

> >Try adding the following line near the top of search.pl: > >use CGI::Carp qw(fatalsToBrowser); > >and then doing another search. This will cause the error to print to the >browser window, and might give us some more information. > Steve the script is working now , Thanks a lot. but it did not display any error messages , I think because the error is in the header of the generated output. The other scripts still not working . do u suggest that I add this line in all the scripts ? Thanks Again Mohamed Amin _________________________________________________________________ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

2 1

Re: [Koha] ( Internal Server Error)
by Mohamed Amin 24 Apr '03

24 Apr '03

Hi Steve There somethimg I don't know is it right when I rename the test.out file to test.html the first lines Set-Cookie: sessionID=; path=/; expires=Fri, 23-Apr-2004 08:06:37 GMT Date: Thu, 24 Apr 2003 08:06:37 GMT Content-Type: text/html; charset=ISO-8859-1 appear in the browser at the top of the page does it mean that the broswer does not understand what do these line mean ? Mohamed Amin _________________________________________________________________ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail

2 1