- Koha - lists.katipo.co.nz

Re: [Koha] Library Database for Australian Water Environments
by Lenora Oftedahl 10 Jul '08

10 Jul '08

You'll probably get some other answers, but I thought I'd tackle the inhouse reports question. I also have loads of inhouse reports and unpublished materials (about 1/3 of my collection). Yes, I have to use the MARC record to describe these items, but I was able to customise Koha so that only the title, barcode and format are required fields. You are welcome to check out our catalog: http://www.fishlib.org It is a work in progress as the switch from the previous software (InMagic) was not smooth. 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 ************************************** >>> "Frances Sandeman" <Frances.Sandeman(a)austwaterenv.com.au> 7/8/2008 9:02:07 PM >>> Hi, My name is Frances and I am a Library Technician representing Australian Water Environments. We are looking at setting up a Library Database and are in the preliminary stages. We are currently in the process of researching and looking at various library database systems. We have an excel spreadsheet to store information and have over 3,000 entries which include reports, books and journals. We also have a GIS Mapping electronic data and an excel spreadsheet for papers. We have a CD Collection and would like to be able to index and scan photos and integrate all forms of media into one Library database system for AWE. Cost is a factor. My question is can we set up a module or customise a KOHA database so that we can add inhouse reports as this is the bulk of our library collection and provide a link to the job nos. of the reports that have been archived? I know this is a rather obvious question but when I looked at the Acquisitions module it didnÆt seem specific enough for our company and was wondering if we can customise it to suit our needs. We have a separate Administration and Accounting process and most our our reports are created and produced by ourselves, Australian Water Environments. We are the vendor in most cases. Would you send us more information about the KOHA database including costs and licensing agreements. Also with Data Entry, how much data can be stored with ease of entry? IÆm just making enquiries at this stage. Thankyou. Regards Frances Sandeman administrator/accounts Australian Water Environments Unit 1, 198 Greenhill Rd, Eastwood, SA 5063 P: (08) 8378 8000 F: (08) 8357 8988 M: 0405 510 726 E: francessandeman(a)austwaterenv.com.au W: www.austwaterenv.com.au Please consider the environment before printing this email This email and any file transmitted with it are confidential to the sender and the intended recipient and may be privileged or subject to copyright of the sender or a third party. If you are not the intended recipient please notify the sender immediately via return email or by calling 08 8378 8000.

1 0

Koha Problem@www.jlcopac.org/
by Amzari Abu Bakar 10 Jul '08

10 Jul '08

Dear Mr. Yesan, Can you post koha error log and apache error log to us? the files name are intranet-error.log and opac-error.log Message: 4 Date: Thu, 10 Jul 2008 14:36:00 +0530 From: "Librarian, SAIACS" <library(a)saiacs.org> Subject: [Koha] Koha Problem To: <koha(a)lists.katipo.co.nz> Message-ID: <20080710093627.8056AECB77(a)daddy.katipo.co.nz> Content-Type: text/plain; charset="us-ascii" Dear Colleagues, We have installed koha 2.2.9 for Joint Library committee union catalogue, Bangalore. URL: www.jlcopac.org/intranet for librarians interface, www.jlcopac.org/opac for catalogue search. Our problem is that librarians interface does not go beyond first page of welcome note (www.jlcopac.org/intranet) Can any of us give possible support to troubleshoot this? Thanks Mr. Yesan Sellan Chief Librarian South Asia Institute of Advanced Christian Studies, Kothanur PO Bangalore - 560077 INDIA Alternative Email: yesans(a)gmail.com Ph: 91-80-2846 5649/5235/5344 Fax: 91-80-2846 5412 Amzari Abu Bakar amzari79(a)gmail.com

1 0

Koha Problem
by Librarian, SAIACS 10 Jul '08

10 Jul '08

Dear Colleagues, We have installed koha 2.2.9 for Joint Library committee union catalogue, Bangalore. URL: www.jlcopac.org/intranet for librarians interface, www.jlcopac.org/opac for catalogue search. Our problem is that librarians interface does not go beyond first page of welcome note (www.jlcopac.org/intranet) Can any of us give possible support to troubleshoot this? Thanks Mr. Yesan Sellan Chief Librarian South Asia Institute of Advanced Christian Studies, Kothanur PO Bangalore - 560077 INDIA Alternative Email: yesans(a)gmail.com Ph: 91-80-2846 5649/5235/5344 Fax: 91-80-2846 5412 IMPORTANT : This message is intended only for the addressee. It may contain confidential information. Any unauthorized disclosure is strictly prohibited. If you have received this message in error, please notify us immediately so that we may correct our internal records. Please then delete the original message. Thank you.

2 1

Library Database for Australian Water Environments
by Frances Sandeman 10 Jul '08

10 Jul '08

Hi, My name is Frances and I am a Library Technician representing Australian Water Environments. We are looking at setting up a Library Database and are in the preliminary stages. We are currently in the process of researching and looking at various library database systems. We have an excel spreadsheet to store information and have over 3,000 entries which include reports, books and journals. We also have a GIS Mapping electronic data and an excel spreadsheet for papers. We have a CD Collection and would like to be able to index and scan photos and integrate all forms of media into one Library database system for AWE. Cost is a factor. My question is can we set up a module or customise a KOHA database so that we can add inhouse reports as this is the bulk of our library collection and provide a link to the job nos. of the reports that have been archived? I know this is a rather obvious question but when I looked at the Acquisitions module it didnt seem specific enough for our company and was wondering if we can customise it to suit our needs. We have a separate Administration and Accounting process and most our our reports are created and produced by ourselves, Australian Water Environments. We are the vendor in most cases. Would you send us more information about the KOHA database including costs and licensing agreements. Also with Data Entry, how much data can be stored with ease of entry? Im just making enquiries at this stage. Thankyou. Regards Frances Sandeman administrator/accounts Australian Water Environments Unit 1, 198 Greenhill Rd, Eastwood, SA 5063 P: (08) 8378 8000 F: (08) 8357 8988 M: 0405 510 726 E: francessandeman(a)austwaterenv.com.au W: www.austwaterenv.com.au Please consider the environment before printing this email This email and any file transmitted with it are confidential to the sender and the intended recipient and may be privileged or subject to copyright of the sender or a third party. If you are not the intended recipient please notify the sender immediately via return email or by calling 08 8378 8000.

2 1

problem opening in browser
by vijay kumar 10 Jul '08

10 Jul '08

Dear Member, I am not getting the opac and intranet in browser when type localhost:80 automatically goes to maintenance.pl http://localhost/cgi-bin/koha/maintenance.pl and when type localhost:8080 it shows production mode - trapped fatal error My zebraserver and yaz client is running properly and installed all perl model properly........... So please guide me.................. Thanks VIJAY KUMAR

1 0

General Question from Newbie
by gayle prentice wood 10 Jul '08

10 Jul '08

Please forgive me if this is an incorrect use of this forum, but I am looking to install Koha for use as the ILS at my small, alternative school and I am a bit overwhelmed. I have an IT guy who is well-versed in the programming side of things, but I want to make sure that I communicate with him best about how to set things up to fit my needs. Has anyone created a "Koha for Dummies" tutorial? Or is anyone out there in a similar situation with a small collection (>500 titles) who is using the basic features (cataloging, Z39.50 for acquisition, circulation and OPAC) and can give me some tips? We have no budget to contract with anyone (i.e. LibLime) for training or tech support in the initial stages. I appreciate your help! Gayle Prentice Wood Mt. Scott Learning Centers

3 2

libxslt runtime problem
by vijay kumar 10 Jul '08

10 Jul '08

Dear Member, I am getting an error during final step of koha installation using fc7 Warning: is -------XML::LibXSLT compiled against libxslt 10122, but runtime libxslt is older 10117 I have installed XML::LibXSLT 1.66 libxml2-2.6.27 But it shows compilation problem so how can I replace new with old one and from where I will get. Please help These are some screenshot of my problem..............In the last line it shows problem.... OPAC_TMPL_DIR /usr/share/koha/opac/htdocs/opac-tmpl OPAC_WWW_DIR /usr/share/koha/opac/htdocs PAZPAR2_CONF_DIR /etc/koha/pazpar2 PERL_MODULE_DIR /usr/share/koha/lib SCRIPT_DIR /usr/share/koha/bin SCRIPT_NONDEV_DIR /usr/share/koha/bin ZEBRA_CONF_DIR /etc/koha/zebradb ZEBRA_DATA_DIR /var/lib/koha/zebradb ZEBRA_LOCK_DIR /var/lock/koha/zebradb ZEBRA_RUN_DIR /var/run/koha/zebradb To change any configuration setting, please run perl Makefile.PL again. To override one of the target directories, you can do so on the command line like this: perl Makefile.PL PERL_MODULE_DIR=/usr/share/perl/5.8 You can also set different default values for parameters or override directory locations by using environment variables. For example: export DB_USER=my_koha perl Makefile.PL or DB_USER=my_koha DOC_DIR=/usr/local/info perl Makefile.PL If installing on a Win32 platform, be sure to use: 'dmake -x MAXLINELENGTH=300000' [Thu Jul 10 14:57:22 2008] Makefile.PL: Warning: XML::LibXSLT compiled against libxslt 10122, but runtime libxslt is older 10117 Writing Makefile for koha Thanks Vijay Kumar NCSI,IISc Bangalore INDIA

1 0

Installation instructions for Koha 2.2.9 on OpenSolaris 2008.05
by "Thommy M. Malmström" 09 Jul '08

09 Jul '08

I've made rather detailed installation instructions for Koha 2.2.9 on OpenSolaris 2008.05 available at http://www.at-hardeberga.com/Koha-2.2.9-on-OpenSolaris-2008-05-v0.95.odt Please feel free to try it out and give feedback. Next I will give Koha 3 a spin on OpenSolaris 2008.05. Stay tuned.

2 1

Installation of koha-3
by vijay kumar 09 Jul '08

09 Jul '08

Dear Members, I am trying to install KOHA 3 on Fedora 7 and I did all procedure step by step provided in manuals .But during installation of KOHA 3 (koha-3.00.00-stableRC1) getting some error.............. Shall I proceed with this error further.......... Or how can I overcome from this problem........... Anyone please suggest me...................................... This is one screenshot of my problem 1/4DBD::mysql::db selectrow_array failed: Table 'koha.systempreferences' doesn't exist at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Context.pm line 456. Use of uninitialized value in string eq at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Date.pm line 49. Use of uninitialized value in string eq at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Date.pm line 49. Use of uninitialized value in string eq at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Date.pm line 49. Use of uninitialized value in concatenation (.) or string at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Date.pm line 63. # Failed test 'format_date_in_iso' # at t/Date.t line 29. # got: '' # expected: '1973-05-21' # Looks like you planned 4 tests but only ran 3. # Looks like you failed 1 test of 3 run. t/Date......................dubious Test returned status 1 (wstat 256, 0x100) DIED. FAILED tests 2, 4 Failed 2/4 tests, 50.00% okay t/Dates.....................ok 1/126# # Testing Legacy Functions: format_date and format_date_in_iso DBD::mysql::db selectrow_array failed: Table 'koha.systempreferences' doesn't exist at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Context.pm line 456. Use of uninitialized value in hash element at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Dates.pm line 127. Use of uninitialized value in concatenation (.) or string at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Dates.pm line 127. Invalid date format '' from system preferences at t/Dates.t line 31 # Looks like you planned 126 tests but only ran 1. # Looks like your test died just after 1. t/Dates.....................dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 2-126 Failed 125/126 tests, 0.79% okay t/Debug.....................# BEFORE use: $debug is not defined # BEFORE use: $cgi_debug is not defined t/Debug.....................ok 1/3# AFTER use: $debug is 0 # AFTER use: $cgi_debug is 0 # Done. t/Debug.....................ok t/dummy.....................ok t/icondirectories...........Use of uninitialized value in string eq at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Koha.pm line 460. DBD::mysql::db selectrow_array failed: Table 'koha.systempreferences' doesn't exist at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Context.pm line 456. Use of uninitialized value in concatenation (.) or string at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Koha.pm line 464. DBD::mysql::db selectrow_array failed: Table 'koha.systempreferences' doesn't exist at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Context.pm line 456. Use of uninitialized value in concatenation (.) or string at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Koha.pm line 461. Can't stat /usr/share/koha/opac/htdocs/opac-tmpl//itemtypeimg: No such file or directory at t/icondirectories.t line 37 Can't stat /usr/share/koha/intranet/htdocs/intranet-tmpl//img/itemtypeimg: No such file or directory at t/icondirectories.t line 45 t/icondirectories...........ok t/Input.....................ok t/Items.....................DBD::mysql::db selectrow_array failed: Table 'koha.systempreferences' doesn't exist at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Context.pm line 456. t/Items.....................ok 1/28DBD::mysql::db selectrow_array failed: Table 'koha.systempreferences' doesn't exist at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Context.pm line 456. Use of uninitialized value in hash element at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Dates.pm line 127. Use of uninitialized value in concatenation (.) or string at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Dates.pm line 127. Invalid date format '' from system preferences at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Items.pm line 1728 # Looks like you planned 28 tests but only ran 13. # Looks like your test died just after 13. t/Items.....................dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 14-28 Failed 15/28 tests, 46.43% okay t/Koha......................ok t/Labels....................DBD::mysql::db selectrow_array failed: Table 'koha.systempreferences' doesn't exist at /usr/share/koha-3.00.00-stableRC1/blib/PERL_MODULE_DIR/C4/Context.pm line 456. t/Labels....................ok t/Languages.................ok t/Maintainance..............ok t/Output....................ok t/Record....................ok t/Review....................ok t/Scrubber..................ok 1/10# Note: scrubber test output will have whitespace collapsed for readability # done. t/Scrubber..................ok t/Stats.....................ok Failed Test Stat Wstat Total Fail Failed List of Failed ------------------------------------------------------------------------------- t/Date.t 1 256 4 3 75.00% 2 4 t/Dates.t 255 65280 126 250 198.41% 2-126 t/Items.t 255 65280 28 30 107.14% 14-28 Failed 3/24 test scripts, 87.50% okay. 142/207 subtests failed, 31.40% okay. make: *** [test_dynamic] Error 255 Thanks, Vijay Kumar NCSI,IISc Bangalore

2 2

Re: [Koha] Bulkmarcimport.pl: importing new batch of records
by Tomasz Holdowanski 09 Jul '08

09 Jul '08

Irma wrote: > Hello Tomasz, > > We are working with the same kind of issues at the moment. > > 1) I can send you some files with very good full MARC records, if that were > to help you. But do you use MARC21? Thanks, but that`s not the case. I have my own records in the other ILS (ALEPH to be specific). I extracted the raw data from it in order to figure out the best way of importing it into KOHA and to develop a procedure that would give best results with least effort. After success, I allowed my colleagues to test KOHA, however the biblio and items databases were already outdated. New biblios and items are in Aleph, I can extract them and make them KOHA-importable. The problem would not exist if there were ONLY new biblios with items, however there are items that should be attached to biblio records already existing in KOHA. > 3) Are you using as Koha test the 2.2.9 version or 3.0? I use a Polish fork developed by Wojciech Zatorski. He is developing an "university library" version, I work in a public library, so it`s not the best fit, but still better than "mainstream" KOHA. The fork is heavily modified 2.4 with additions from later versions. Full compatibility is long gone, I guess. > 4) There is a script already written for merging brief and full records in > the Koha reservoir. I just need to ask for it. Not my case again :) I have biblios with items with Koha, just need to attach more items to those biblios: read record from file -> look at ISBN in subfield 020a, search biblioitems for matching isbn -> if found, import field 952 only with biblionumber and biblioitemnumber of the found record. If not found, import all fields as a new biblio/biblioitem/item. I know it would create duplicate biblios, but less than importing everything as complete records. Or maybe someone has a better idea?... Regards, Tomasz.

2 1