- Koha - lists.katipo.co.nz

Re: Koha Digest, Vol 8, Issue 19
by Amzari Abu Bakar 19 Jun '06

19 Jun '06

Hi Nitin, I have tried once, migrating from windows to Koha. You can backup your Database using either mysql command or Mysql Administrator if you are not familiar using command line. mysql Administrator is pretty easy. You can download it from mysql.com. You can follow the following step: 1. Check your Koha version. eg: 2.2.4. So, you need to install 2.2.4 version first on Linux. 2. Install Koha on Linux.Make sure it is running well. 3. Backup your Koha database in Windows. it will generate sql script. 4. Restore database (run this script) in Linux. 5. Map database which Koha would read to your new database. You can do this inside /etc/koha.conf After that, if it is work well, you can run upgrade script to upgrade to a newer version (eg: 2.2.5). Hope it can help. Amzari Abu Bakar FingerClick Solutions "Assisting Koha in Malaysia" ----------------------------------------- Message: 1 Date: Sun, 18 Jun 2006 13:30:50 +0530 From: "Nitin Madhavan" <mnitin73(a)gmail.com> Subject: [Koha] Migrating Data from Windows to Linux To: Koha(a)lists.katipo.co.nz Message-ID: <c19020fe0606180100l9ec615cqca651debfb9a1ca0(a)mail.gmail.com> Content-Type: text/plain; charset="iso-8859-1" I installed Koha for windows initially and catalogued my entire collection. I have now successfully installed Koha on Linux and would like to use the same database. I tried copying the database folder onto the linux database folder, but it doesnt seem to work. How do I use my earlier data? Maddy

1 0

Tag 852c Shelving Location
by Nitin Madhavan 18 Jun '06

18 Jun '06

I am aware of tag 852c and this tag is visible in the default MARC framework. However the comment in front of it says that this tag is not being used. How do I make it appear in the form while editing item data? Maddy

1 0

centos dependencies with yaz
by anson＠treebay.org 17 Jun '06

17 Jun '06

Hi All, doing a centos install - good news: most of the missing dependecies on a clean install can be added by enabling centosplus in the /etc/yum.repos.d/CentOS-Base.repo sudo vim CentOS-Base.repo .... name=centosplus ... enabled=1 other news: libssl.so.5, libcrypto.so.5, and libwrap.so.0 are still MIA. I installed the openssl from the dries repository cd /etc/yum.repos.d/ sudo wget http://soundlinuxtraining.com/portal/file.php/1/misc/dries.repo sudo rpm --import http://dries.studentenweb.org/rpm/RPM-GPG-KEY.dries.txt however that didn't seem to finish the job. if anyone has any clues on those three packages it would be great, looking forward to reporting back with a completed effort. Anson ps Gracias to Liblime & Josh for the support on the mIRC channel -- Rock On!

1 0

Annual leave
by howard_dahdah＠idg.com.au 17 Jun '06

17 Jun '06

1 0

Annual leave
by howard_dahdah＠idg.com.au 16 Jun '06

16 Jun '06

1 0

How to setup httpd.conf to use domain/opac instead of opac.domain or domain:port
by Michael Lake 16 Jun '06

16 Jun '06

Hi all I would like to have the opac served from the URL http://nsw.royalsoc.org.au/opac instead of from a port say http://nsw.royalsoc.org.au:8000 The reason is that I have the Intranet being served from 8080 and although I can setup opac at say :8000 it's blocked from my work here and other ports such as 9000 and many others are blocked. I know 80 and 8080 seem OK. Hence I have setup the Intranet from :8080 and it works fine. I'm having problems in working out how to get http://nsw.royalsoc.org.au/opac working. Note: I don't want to use http://opac.royalsoc.org.au/ as I'm using http://www.royalsoc.org.au/ and http://qld.royalsoc.org.au/ and so opac.royalsoc.org.au does not "fit in". I thought that maybe an "Alias /opac /home/koha/koha/opac/htdocs" might work but I'm getting very confused with virtual domains, virt name hosting etc. Some help in the config would be appreciated. # Ports to listen to for Koha Listen 80 Listen 8080 Listen 8000 <--- this is blocked so can't really use it NameVirtualHost 300.200.100.111 ############################## # nsw.royalsoc.org.au ############################## <VirtualHost 300.200.100.111> <-- my real IP addr is here. ServerName nsw.royalsoc.org.au ServerAlias nsw.royalsoc.org.au DocumentRoot /home/rsnsw/web/nsw ErrorLog /var/log/apache/nsw-error.log CustomLog /var/log/apache/nsw-access.log combined </VirtualHost> # Koha OPAC settings # I want to move this to be available from: # http://nsw.royalsoc.org.au/opac <VirtualHost nsw.royalsoc.org.au:8000> ServerName nsw.royalsoc.org.au ServerAlias nsw.royalsoc.org.au DocumentRoot /home/koha/koha/opac/htdocs ScriptAlias /cgi-bin/koha/ /home/koha/koha/opac/cgi-bin/ Redirect permanent index.html http://nsw.royalsoc.org.au:8000/cgi-bin/koha/opac-main.pl ErrorLog /var/log/apache/nsw-error.log CustomLog /var/log/apache/nsw-access.log combined SetEnv PERL5LIB "/home/koha/koha/intranet/modules" SetEnv KOHA_CONF "/home/koha/koha/etc/koha.conf" </VirtualHost> # Koha Intranet settings # This is sworking fine. <VirtualHost nsw.royalsoc.org.au:8080> ServerName nsw.royalsoc.org.au ServerAlias nsw.royalsoc.org.au DocumentRoot /home/koha/koha/intranet/htdocs ScriptAlias /cgi-bin/koha/ "/home/koha/koha/intranet/cgi-bin/" Redirect permanent index.html http://nsw.royalsoc.org.au:8080/cgi-bin/koha/mainpage.pl ErrorLog /var/log/apache/koha-error.log TransferLog /var/log/apache/koha-access.log SetEnv PERL5LIB "/home/koha/koha/intranet/modules" SetEnv KOHA_CONF "/home/koha/koha/etc/koha.conf" </VirtualHost> Mike -- Michael Lake Science Faculty, UTS Ph: 9514 8232 Fx: 9514 1460

2 2

Re: [Koha] How to format a register to be successful into Koha?
by Steven F.Baljkas 15 Jun '06

15 Jun '06

Wednesday, June 14, 2006 22:47 CDT Hi, José, I'll have to try to answer quicker this time, as my computer crashed again before the last quick answer was finished. Why would you want to edit the register as you call it (usually referred to as the Directory)? What is the source of the "analysis"? Normally, one wouldn't want to edit the Directory because it provides the structure to the long string of alphanumeric characters that compose a MARC record, allowing Koha and other library programs the ability to take the data and fill in a table (the Directory allows a line to become a matrix). Were you having some problem importing MARC data? Exporting? If you want/need to edit MARC data prior to importing into Koha there are free tools available such as the very useful MARCEdit. You can download it gratis off the MARC Specialized Tools page at the Library of Congress site at: URL <http://www.loc.gov/marc/marctools.html> . This tool will decompile the Directory properly into a tagged format that will allow you to edit the field data. When done editing, you can re-convert records into true MARC and MARCEdit will make all the necessary changes to the Directory. I hope that this information has helped. Write back to the listserv with more detail on your reasons for changing the Directory if you need specific help with it as a MARC issue. Cheers, Steven F. Baljkas library tech at large Koha neophyte Winnipeg, MB, Canada ============================================================ From: "José Lagoas" <jlagoas(a)lnec.pt> Date: 2006/06/14 Wed AM 09:31:08 CDT To: koha(a)lists.katipo.co.nz Subject: [Koha] How to format a register to be successful into Koha? KOHA Using this options Parameters-->MARC biblio export it makes this content for one book (an example): 00227 2200109 4500020001500000090000900015245002000024600001800044600001800062610002900080942000800109 a0672226510 c3d3 aC: Step-by-Step aMitchel Waite aStephen Prata aHoward W. Sams & Company cLIV Analysing the register (all character): Decimal-Octal-ASCII 048-060-0 048-060-0 050-062-2 050-062-2 055-067-7 032-040- 032-040- 032-040- 032-040- 032-040- 050-062-2 050-062-2 048-060-0 048-060-0 049-061-1 048-060-0 057-071-9 032-040- 032-040- 032-040- 052-064-4 053-065-5 048-060-0 048-060-0 048-060-0 050-062-2 048-060-0 048-060-0 048-060-0 049-061-1 053-065-5 048-060-0 048-060-0 048-060-0 048-060-0 048-060-0 048-060-0 057-071-9 048-060-0 048-060-0 048-060-0 048-060-0 057-071-9 048-060-0 048-060-0 048-060-0 049-061-1 053-065-5 050-062-2 052-064-4 053-065-5 048-060-0 048-060-0 050-062-2 048-060-0 048-060-0 048-060-0 048-060-0 050-062-2 052-064-4 054-066-6 048-060-0 048-060-0 048-060-0 048-060-0 049-061-1 056-070-8 048-060-0 048-060-0 048-060-0 052-064-4 052-064-4 054-066-6 048-060-0 048-060-0 048-060-0 048-060-0 049-061-1 056-070-8 048-060-0 048-060-0 048-060-0 054-066-6 050-062-2 054-066-6 049-061-1 048-060-0 048-060-0 048-060-0 050-062-2 057-071-9 048-060-0 048-060-0 048-060-0 056-070-8 048-060-0 057-071-9 052-064-4 050-062-2 048-060-0 048-060-0 048-060-0 056-070-8 048-060-0 048-060-0 049-061-1 048-060-0 057-071-9 030-036- - end field character - 109 caracteres 032-040- 032-040- 031-037- - start field character 097-141-a 048-060-0 054-066-6 055-067-7 050-062-2 050-062-2 050-062-2 054-066-6 053-065-5 049-061-1 048-060-0 030-036- - end field character 032-040- 032-040- 031-037- - start field character 099-143-c 051-063-3 031-037- - start field character (it's a separator character) 100-144-d 051-063-3 030-036- - end field character 032-040- 032-040- 031-037- - start field character 097-141-a 067-103-C 058-072-: 032-040- 083-123-S 116-164-t 101-145-e 112-160-p 045-055-- 098-142-b 121-171-y 045-055-- 083-123-S 116-164-t 101-145-e 112-160-p 030-036- - end field character 032-040- 032-040- 031-037- - start field character 097-141-a 077-115-M 105-151-i 116-164-t 099-143-c 104-150-h 101-145-e 108-154-l 032-040- 087-127-W 097-141-a 105-151-i 116-164-t 101-145-e 030-036- - end field character 032-040- 032-040- 031-037- - start field character 097-141-a 083-123-S 116-164-t 101-145-e 112-160-p 104-150-h 101-145-e 110-156-n 032-040- 080-120-P 114-162-r 097-141-a 116-164-t 097-141-a 030-036- - end field character 032-040- 032-040- 031-037- - start field character 097-141-a 072-110-H 111-157-o 119-167-w 097-141-a 114-162-r 100-144-d 032-040- 087-127-W 046-056-. 032-040- 083-123-S 097-141-a 109-155-m 115-163-s 032-040- 038-046-& 032-040- 067-103-C 111-157-o 109-155-m 112-160-p 097-141-a 110-156-n 121-171-y 030-036- - end field character 032-040- 032-040- 031-037- - start field character 099-143-c 076-114-L 073-111-I 086-126-V 030-036- - end field character 029-035- - end register character - 227 characters Decomposition 00254 2200121 4500 020 0015 00000 - starts at position 0 - ISBN ( a0672226510) - 15 characters length 090 0009 00015 - starts at position 15 - internal order ( c3d3) - 9 characters length 245 0020 00024 - starts at position 24 - TITLE ( aC: Step-by-Step) - 20 characters length 600 0018 00044 - starts at position 44 - Personal name ( aMitchel Waite) - 18 characters length 600 0018 00062 - starts at position 62 - Personal name ( aStephen Prata) - 18 characters length 610 0029 00080 - starts at position 80 - Corporate name ( aHoward W. Sams & Company) - 29 characters length 942 0008 00109 - starts at position 109 - item type ( cLIV) - 8 characters length If I delete the register from Koha and use Parameters --> Upload MARC records in reservoir option, I don't see the book inside koha. How to format the register to be successful? I need help. Thanks José Lagoas (Lisboa, Portugal) ============================================================

1 0

How to format a register to be successful into Koha?
by José Lagoas 14 Jun '06

14 Jun '06

KOHA Using this options Parameters-->MARC biblio export it makes this content for one book (an example): 00227 2200109 4500020001500000090000900015245002000024600001800044600001800062610002900080942000800109 a0672226510 c3d3 aC: Step-by-Step aMitchel Waite aStephen Prata aHoward W. Sams & Company cLIV Analysing the register (all character): Decimal-Octal-ASCII 048-060-0 048-060-0 050-062-2 050-062-2 055-067-7 032-040- 032-040- 032-040- 032-040- 032-040- 050-062-2 050-062-2 048-060-0 048-060-0 049-061-1 048-060-0 057-071-9 032-040- 032-040- 032-040- 052-064-4 053-065-5 048-060-0 048-060-0 048-060-0 050-062-2 048-060-0 048-060-0 048-060-0 049-061-1 053-065-5 048-060-0 048-060-0 048-060-0 048-060-0 048-060-0 048-060-0 057-071-9 048-060-0 048-060-0 048-060-0 048-060-0 057-071-9 048-060-0 048-060-0 048-060-0 049-061-1 053-065-5 050-062-2 052-064-4 053-065-5 048-060-0 048-060-0 050-062-2 048-060-0 048-060-0 048-060-0 048-060-0 050-062-2 052-064-4 054-066-6 048-060-0 048-060-0 048-060-0 048-060-0 049-061-1 056-070-8 048-060-0 048-060-0 048-060-0 052-064-4 052-064-4 054-066-6 048-060-0 048-060-0 048-060-0 048-060-0 049-061-1 056-070-8 048-060-0 048-060-0 048-060-0 054-066-6 050-062-2 054-066-6 049-061-1 048-060-0 048-060-0 048-060-0 050-062-2 057-071-9 048-060-0 048-060-0 048-060-0 056-070-8 048-060-0 057-071-9 052-064-4 050-062-2 048-060-0 048-060-0 048-060-0 056-070-8 048-060-0 048-060-0 049-061-1 048-060-0 057-071-9 030-036- - end field character - 109 caracteres 032-040- 032-040- 031-037- - start field character 097-141-a 048-060-0 054-066-6 055-067-7 050-062-2 050-062-2 050-062-2 054-066-6 053-065-5 049-061-1 048-060-0 030-036- - end field character 032-040- 032-040- 031-037- - start field character 099-143-c 051-063-3 031-037- - start field character (it's a separator character) 100-144-d 051-063-3 030-036- - end field character 032-040- 032-040- 031-037- - start field character 097-141-a 067-103-C 058-072-: 032-040- 083-123-S 116-164-t 101-145-e 112-160-p 045-055-- 098-142-b 121-171-y 045-055-- 083-123-S 116-164-t 101-145-e 112-160-p 030-036- - end field character 032-040- 032-040- 031-037- - start field character 097-141-a 077-115-M 105-151-i 116-164-t 099-143-c 104-150-h 101-145-e 108-154-l 032-040- 087-127-W 097-141-a 105-151-i 116-164-t 101-145-e 030-036- - end field character 032-040- 032-040- 031-037- - start field character 097-141-a 083-123-S 116-164-t 101-145-e 112-160-p 104-150-h 101-145-e 110-156-n 032-040- 080-120-P 114-162-r 097-141-a 116-164-t 097-141-a 030-036- - end field character 032-040- 032-040- 031-037- - start field character 097-141-a 072-110-H 111-157-o 119-167-w 097-141-a 114-162-r 100-144-d 032-040- 087-127-W 046-056-. 032-040- 083-123-S 097-141-a 109-155-m 115-163-s 032-040- 038-046-& 032-040- 067-103-C 111-157-o 109-155-m 112-160-p 097-141-a 110-156-n 121-171-y 030-036- - end field character 032-040- 032-040- 031-037- - start field character 099-143-c 076-114-L 073-111-I 086-126-V 030-036- - end field character 029-035- - end register character - 227 characters Decomposition 00254 2200121 4500 020 0015 00000 - starts at position 0 - ISBN ( a0672226510) - 15 characters length 090 0009 00015 - starts at position 15 - internal order ( c3d3) - 9 characters length 245 0020 00024 - starts at position 24 - TITLE ( aC: Step-by-Step) - 20 characters length 600 0018 00044 - starts at position 44 - Personal name ( aMitchel Waite) - 18 characters length 600 0018 00062 - starts at position 62 - Personal name ( aStephen Prata) - 18 characters length 610 0029 00080 - starts at position 80 - Corporate name ( aHoward W. Sams & Company) - 29 characters length 942 0008 00109 - starts at position 109 - item type ( cLIV) - 8 characters length If I delete the register from Koha and use Parameters --> Upload MARC records in reservoir option, I don't see the book inside koha. How to format the register to be successful? I need help. Thanks José Lagoas (Lisboa, Portugal)

1 0

Re: [Koha] installation on ubuntu dapper 6.06
by Kyle Hall 14 Jun '06

14 Jun '06

Errors are reported in the log files, by default they will be in koha(a)lists.katipo.co.nz. Also, when you reply, use they "reply to all" button, that way the e-mail still gets sent to the koha mailing list as well. That way if anyone else has some wisdom to impart, they can also e-mail you. ; ) Kyle On 6/13/06, Krsnendu Dasa <krsnendu108(a)gmail.com> wrote: > > I can log into intranet:8080, but when go to the main opac page :80 it > says "Welcome to Koha" then it says "500 internal server error." Any tips? > > > -- > Please use my new email address- > krsnendu108(a)gmail.com > -- IT Tech Crawford County Federated Library System

1 0

Branch code v. branch name
by Lenora Oftedahl 09 Jun '06

09 Jun '06

Hi. In the public access catalog, the software is still showing the code rather than the name of the branch. Where do I change that? Thanx. Lenora -- *************************************** Lenora A. Oftedahl, MLS MEPM StreamNet Regional Librarian Columbia River Inter-Tribal Fish Commission 729 NE Oregon St, Ste 190 Portland, OR 97232 503-736-3581 / ARIEL: 207.173.155.8 503-731-1260 FAX OFTL(a)critfc.org http://www.fishlib.org ************************************* "One by one, the penguins are stealing my sanity" ************************************** "Don't worry about the world coming to an end today. It's already tomorrow in Australia." --(Charles Schultz) ************************************** "The problem with adults is that they are contaminated by experience." --Kumi Naidoo, General Secretary and CEO of CIVICUS **************************************

1 0