- Koha - lists.katipo.co.nz

Koha Database,
by ahtshun83 02 Jul '09

02 Jul '09

Hi all, if u add a new patron, may i know which table will hold the information? i would like to import student info into koha rather than manually input. I'm using Microsoft SQL Server (Navision) to store my student info.... how can i import into MYSQL which uses by Koha? -- View this message in context: http://www.nabble.com/Koha-Database%2C-tp24284288p24284288.html Sent from the Koha - Discuss mailing list archive at Nabble.com.

3 2

Access to mysql
by João Verissimo - Câmara Municipal de Ferreira do Zêzere 02 Jul '09

02 Jul '09

Hello. I'm attempting to remote access mysql on "Koha 3.01 Release VMWare Virtual Appliance Image created by Kyle M. Hall <kyle.m.hall(a)gmail.com> http://kylehall.info" from a windows xp machine throw "mysql administrator" and it always fails with network problems, but ping, and web access is ok. Any one can help me to access the mysql database. Thank you. __________________________________ João Veríssimo - Área de Informática Município de Ferreira do Zêzere Praça Dias Ferreira 2240-341 Ferreira do Zêzere 249 360 150 "Esta mensagem pode conter informação considerada confidencial. Se o receptor não for o destinatário indicado, não deverá copiar ou endereçar a mensagem a terceiros. Nesta situação, o receptor deverá destruir a mensagem e por gentileza informar o emissor do sucedido. O conteúdo desta mensagem, bem como dos respectivos anexos é da responsabilidade exclusiva do emissor, não podendo o Município de Ferreira do Zêzere ser responsabilizado por eventuais consequências. This message may contain confidential information. If you are not the addressee indicated in this message you should not copy or address this message to anyone. In this event we ask you to kindly delete the message and notify the sender. The contents of this message and attachments are the responsibility of the individual sender and under no circumstances can Ferreira do Zêzere City Council be liable for any resulting consequences."

1 0

Re: [Koha] Problems installing ZOOM
by Stefano Bargioni 02 Jul '09

02 Jul '09

The solution proposed by Zeno worked well. Thanks a lot. Anyway, the INSTALL.debian-lenny document file doesn't speak about it at all, if I am not wrong. The only info comes from the perl Makefile.PL that lists warnings for not found Perl modules. So I installed a lot of them using perl -MCPAN -e shell but ZOOM. gonzalez(a)famaf.unc.edu.ar wrote: > I install that module using cpan. > > try running > cpan -i Net::Z3950::ZOOM > > or > perl -MCPAN -e shell > cpan> force install Net::Z3950::ZOOM > > There are tests that fail because the connection attempt to > z3950.indexdata fails. This was my first choice. It fails with the message '/usr/bin/perl Makefile.PL INSTALLDIRS=site' returned status 512, won't make Maybe a better cpan configuration could avoid this. Bye. Stefano On Jul 1, 2009, at 18:44 , Zeno Tajoli wrote: > Hi to all, > > At 17.14 01/07/2009, Stefano Bargioni wrote: >> I'm trying to install Koha 3.0.3 in a Debian Lenny. >> The prerequisite Perl module Net::Z3950::ZOOM has become a problem. >> The tarball from CPAN has a README that suggests to enter the command >> dh-make-perl --build >> See the result below (runs as root). >> Is this the best way? Where is my mistake? > > why do you try cpan tarball ? > The debian-lenny INSTALL doesn't speak about install Net::Z3950::ZOOM > from CPAN. > In lenny there is a specific deb, libnet-z3950-zoom-perl. > > Bye > Zeno Tajoli > CILEA - Segrate (MI) > tajoliAT_SPAM_no_prendiATcilea.it > (Indirizzo mascherato anti-spam; sostituisci quanto tra AT con @)

1 0

July #koha IRC meeting transcript
by Galen Charlton 01 Jul '09

01 Jul '09

Hi, Thanks to everybody who participated today. A transcript of the meeting can be found at http://koha.org/cgi-bin/logs.pl?user=&startdate=2009070112%3A00%3A00&enddat… Regards, Galen -- Galen Charlton VP, Research & Development, LibLime galen.charlton(a)liblime.com p: 1-888-564-2457 x709 skype: gmcharlt

1 0

New to KOHA. Trying to start indexing. Can anyone assist?
by Goatley, Todd 01 Jul '09

01 Jul '09

Trying to start indexing in KOHA 3.0 on Debian Sarge. Zebra is installed. I run this (sugggested from online: zebrasrv -f /koha/etc/koha.xml but I get this error msg: koha@lnxkoha:/var/lib$ zebrasrv -f /koha/etc/koha.xml I/O warning : failed to load external entity "/koha/etc/koha.xml" 12:58:50-01/07 [fatal] Could not parse /koha/etc/koha.xml Can anyone assist? Thank you, Todd Goatley

2 1

Re: [Koha] Hide bibliographic records
by Kathy Rippel 01 Jul '09

01 Jul '09

I, too, think it would be nice to be able to suppress at the item level, too. We have duplicate records in our catalog only because one site needs to suppress and the other doesn't. It would be nice to combine them on to one bib record, with some suppressed in the OPAC and one not. Kathy OS-- Oh, yeah, and it would REALLY be great if there was a flag in the staff module to alert staff that a certain record is suppressed! That would save staff telling patrons, "It's right there in the catalog, I'm looking at the record right here." (While they are using the staff module!) Kathy At 08:45 AM 7/1/2009, Galen Charlton wrote: >Hi, > >On Wed, Jul 1, 2009 at 5:04 AM, MJ Ray<mjr(a)phonecoop.coop> wrote: > > "Michael Leung (SIL)" <ykleung7(a)msn.com> wrote: > >> Is it possible to set a bibliographic record(s) that only show to the user > >> who has login to the OPAC. That means this bibliographic record > would not be > >> shown in OPAC for general user or guest who is not the patron of the > >> library. > > > > As I understand it, OpacSupression does this for the whole catalogue, > > but it isn't yet possible for individual records. I am interested in > > adding such a feature, as well as restricting records to particular > > patron categories. Would many people be interested in this? > >To clarify, turning on the OpacSupression syspref enables the >capability to suppress OPAC display of individual records. To >actually suppress a particular bib record, it's still necessary to set >the 942$n subfield to 1 (if you're using the MARC21 frameworks). > >Enhancing the OPAC suppression feature so that you can specify that >certain records are to be visible only if the user is logged on to the >OPAC belongs to particular patron category would be useful >developments. > >Regards, > >Galen >-- >Galen Charlton >VP, Research & Development, LibLime >galen.charlton(a)liblime.com >p: 1-888-564-2457 x709 >skype: gmcharlt >_______________________________________________ >Koha mailing list >Koha(a)lists.katipo.co.nz >http://lists.katipo.co.nz/mailman/listinfo/koha Kathleen D. Rippel Dept. Head/Consultant--Resource Sharing and Access ; Pathfinder Central (Manager) Central Kansas Library System 1409 Williams Great Bend, KS 67530 (620-792-4865) phone (800-362-2642) toll-free, KS (620-792-5495) fax kdr(a)ckls.org ******************************************************************************************** I'm currently reading: The Myriad: Tour of the Merrimack #1, by R. M. Meluch. I'm currently listening to: Eclipse, by Stephenie Meyer.

1 0

bulkmarcimport.pl warning messages
by Bob Ewart 01 Jul '09

01 Jul '09

I'm getting a slew of warnings on every book imported: use of uninitialized value in pattern match ... C4/Biblio.pm line 2645 use of uninitialized vlaue in addition... C4/Biblio.pm line 2656 An example marc record =LDR 00589nam 22002051a 4500 =001 23749 =003 flflsla =010 \\$a82045600 =020 \\$a0806527544 =040 \\$aLibrary of Congress =050 \4$aML 420 .G253 M5 1983 =100 1\$aMeyer, John =245 00$aHeartbreaker$cJohn Meyer. =250 \\$a1st ed. =260 3\$aNew York$bCitadel Press Books$c1983 =300 \\$a322 p.$c22 cm. =500 \\$aIncludes index. =650 \4$aGarland, Judy. =650 \4$aSingers - United States - Biography. =952 \\$aSLA$cNonFiction$x17654$d2007-01-04$oML 420 .G253 M5 1983$r2009-06-12$yBOOK$p08065275441$t1 The problem seems to have occured in 3.00.01 and is still present in 3.00.02 running on openSUSE 11.0 and Kubuntu 9.04 I have zebra installed but am not using it. The warnings don't seem to matter, because the biblios and items are imported. Has anyone else seen this? -- Bob

3 7

Problems installing ZOOM
by Stefano Bargioni 01 Jul '09

01 Jul '09

Hi, I'm trying to install Koha 3.0.3 in a Debian Lenny. The prerequisite Perl module Net::Z3950::ZOOM has become a problem. The tarball from CPAN has a README that suggests to enter the command dh-make-perl --build See the result below (runs as root). Is this the best way? Where is my mistake? Thanks a lot. Stefano astronomic:/home/sb/Net-Z3950-ZOOM-1.25# dh-make-perl --build Found: Net-Z3950-ZOOM 1.25 (libnet-z3950-zoom-perl arch=any) Searching for package containing MARC::Record using apt-file. Needs the following modules for which there are no debian packages available - MARC::Record Using maintainer: root <root(a)astronomic.pusc.it> Found changelog: Changes Found docs: README samples/README Found examples: samples/* Using rules: /usr/share/dh-make-perl/rules.MakeMaker.xs ********** Copyright information incomplete! Upstream copyright information could not be automatically determined. If you are building this package for your personal use, you might disregard this information; however, if you intend to upload this package to Debian (or in general, if you plan on distributing it), you must look into the complete copyright information. The causes for this warning are: No licensing information make: Entering directory `/home/sb/Net-Z3950-ZOOM-1.25' dh_testdir dh_testroot dh_clean build-stamp install-stamp # Add commands to clean up after the build process here [ ! -f Makefile ] || make realclean make: Leaving directory `/home/sb/Net-Z3950-ZOOM-1.25' make: Entering directory `/home/sb/Net-Z3950-ZOOM-1.25' dh_testdir # Add commands to compile the package here /usr/bin/perl Makefile.PL INSTALLDIRS=vendor Checking if your kit is complete... Looks good Writing Makefile for Net::Z3950::ZOOM make OPTIMIZE="-Wall -g -O2" LD_RUN_PATH="" make[1]: Entering directory `/home/sb/Net-Z3950-ZOOM-1.25' cp lib/Net/Z3950/ZOOM.pm blib/lib/Net/Z3950/ZOOM.pm cp lib/ZOOM.pm blib/lib/ZOOM.pm cp lib/ZOOM.pod blib/lib/ZOOM.pod cp lib/Net/Z3950.pm blib/lib/Net/Z3950.pm /usr/bin/perl /usr/share/perl/5.10/ExtUtils/xsubpp -typemap /usr/ share/perl/5.10/ExtUtils/typemap -typemap typemap ZOOM.xs > ZOOM.xsc && mv ZOOM.xsc ZOOM.c cc -c -pthread -DYAZ_POSIX_THREADS=1 -DYAZ_HAVE_XML2=1 - DYAZ_HAVE_XSLT=1 -DYAZ_HAVE_EXSLT=1 -I/usr/include/libxml2 - D_REENTRANT -D_GNU_SOURCE -DDEBIAN -fno-strict-aliasing -pipe -I/usr/ local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -Wall -g - O2 -DVERSION=\"1.25\" -DXS_VERSION=\"1.25\" -fPIC "-I/usr/lib/perl/ 5.10/CORE" ZOOM.c ZOOM.xs: In function ‘XS_Net__Z3950__ZOOM_options_set_callback’: ZOOM.xs:469: warning: statement with no effect ZOOM.xs:470: warning: statement with no effect Running Mkbootstrap for Net::Z3950::ZOOM () chmod 644 ZOOM.bs rm -f blib/arch/auto/Net/Z3950/ZOOM/ZOOM.so LD_RUN_PATH="" cc -shared -O2 -g -L/usr/local/lib ZOOM.o -o blib/ arch/auto/Net/Z3950/ZOOM/ZOOM.so \ -lyaz -lexslt -lxslt -lxml2 -lpthread -lssl -lcrypto -lwrap -lnsl \ chmod 755 blib/arch/auto/Net/Z3950/ZOOM/ZOOM.so cp ZOOM.bs blib/arch/auto/Net/Z3950/ZOOM/ZOOM.bs chmod 644 blib/arch/auto/Net/Z3950/ZOOM/ZOOM.bs cp samples/zoom/zoomdump blib/script/zoomdump /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/ zoomdump cp samples/zoom/zselect blib/script/zselect /usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/ zselect Manifying blib/man3/Net::Z3950::ZOOM.3pm Manifying blib/man3/ZOOM.3pm make[1]: Leaving directory `/home/sb/Net-Z3950-ZOOM-1.25' make test make[1]: Entering directory `/home/sb/Net-Z3950-ZOOM-1.25' PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t t/1-Net-Z3950-ZOOM.t .... ok t/10-options.t .......... ok t/11-option-callback.t .. ok t/12-query.t ............ ok t/13-resultset.t ........ ok t/14-sorting.t .......... ok t/15-scan.t ............. ok t/16-packages.t ......... 3/39 # Failed test 'connection to 'z3950.indexdata.com:2100' refused (10007)' # at t/16-packages.t line 88. t/16-packages.t ......... 5/39 # Failed test 'connection to 'z3950.indexdata.com:2100' refused (10007)' # at t/16-packages.t line 88. t/16-packages.t ......... 7/39 # Failed test 'connection to 'z3950.indexdata.com:2100' refused (10007)' # at t/16-packages.t line 88. # Failed test 'database creation 'utmijxcaea'' # at t/16-packages.t line 110. t/16-packages.t ......... 13/39 # Failed test 'connection to 'z3950.indexdata.com:2100' refused (10007)' # at t/16-packages.t line 88. # Failed test 'database 'utmijxcaea' can be searched' # at t/16-packages.t line 175. Use of uninitialized value $expected_count in numeric eq (==) at t/16- packages.t line 179. Use of uninitialized value $expected_count in concatenation (.) or string at t/16-packages.t line 179. # Failed test 'database 'utmijxcaea' can be searched' # at t/16-packages.t line 175. Use of uninitialized value $expected_count in numeric eq (==) at t/16- packages.t line 179. Use of uninitialized value $expected_count in concatenation (.) or string at t/16-packages.t line 179. # Failed test 'database creation 'utmijxcaea'' # at t/16-packages.t line 110. # Failed test 'database 'utmijxcaea' has 0 records (expected 1)' # at t/16-packages.t line 179. # Failed test 'database 'utmijxcaea' has 0 records (expected 1)' # at t/16-packages.t line 179. # Failed test 'database 'utmijxcaea' has 0 records (expected 2)' # at t/16-packages.t line 179. # Failed test 'database drop 'utmijxcaea' expected 235 but succeeded' # at t/16-packages.t line 136. # Looks like you planned 39 tests but ran 41. # Looks like you failed 12 tests of 41 run. t/16-packages.t ......... Dubious, test returned 12 (wstat 3072, 0xc00) Failed 11/39 subtests t/17-logging.t .......... ok t/18-charset.t .......... ok t/19-events.t ........... ok t/2-ZOOM.t .............. ok t/20-options.t .......... ok t/21-option-callback.t .. ok t/22-query.t ............ ok t/23-resultset.t ........ ok t/24-sorting.t .......... ok t/25-scan.t ............. ok t/26-packages.t ......... 3/39 # Failed test 'connection to 'z3950.indexdata.com:2100' refused (10007)' # at t/26-packages.t line 79. t/26-packages.t ......... 5/39 # Failed test 'connection to 'z3950.indexdata.com:2100' refused (10007)' # at t/26-packages.t line 79. t/26-packages.t ......... 7/39 # Failed test 'connection to 'z3950.indexdata.com:2100' refused (10007)' # at t/26-packages.t line 79. # Failed test 'database creation 'szdunzqdra'' # at t/26-packages.t line 99. t/26-packages.t ......... 13/39 # Failed test 'connection to 'z3950.indexdata.com:2100' refused (10007)' # at t/26-packages.t line 79. # Failed test 'database 'szdunzqdra' can be searched' # at t/26-packages.t line 159. Use of uninitialized value $expected_count in numeric eq (==) at t/26- packages.t line 164. Use of uninitialized value $expected_count in concatenation (.) or string at t/26-packages.t line 164. # Failed test 'database 'szdunzqdra' can be searched' # at t/26-packages.t line 159. Use of uninitialized value $expected_count in numeric eq (==) at t/26- packages.t line 164. Use of uninitialized value $expected_count in concatenation (.) or string at t/26-packages.t line 164. # Failed test 'database creation 'szdunzqdra'' # at t/26-packages.t line 99. # Failed test 'database 'szdunzqdra' has 0 records (expected 1)' # at t/26-packages.t line 164. # Failed test 'database 'szdunzqdra' has 0 records (expected 1)' # at t/26-packages.t line 164. # Failed test 'database 'szdunzqdra' has 0 records (expected 2)' # at t/26-packages.t line 164. # Failed test 'database drop 'szdunzqdra'' # at t/26-packages.t line 123. # Looks like you planned 39 tests but ran 41. # Looks like you failed 12 tests of 41 run. t/26-packages.t ......... Dubious, test returned 12 (wstat 3072, 0xc00) Failed 11/39 subtests t/27-logging.t .......... ok t/28-charset.t .......... ok t/29-events.t ........... ok Test Summary Report ------------------- t/16-packages.t (Wstat: 3072 Tests: 41 Failed: 13) Failed tests: 3, 5, 7, 10, 13-14, 20, 24, 29, 33, 37 40-41 Non-zero exit status: 12 Parse errors: Bad plan. You planned 39 tests but ran 41. t/26-packages.t (Wstat: 3072 Tests: 41 Failed: 13) Failed tests: 3, 5, 7, 10, 13-14, 20, 24, 29, 33, 37 40-41 Non-zero exit status: 12 Parse errors: Bad plan. You planned 39 tests but ran 41. Files=22, Tests=716, 262 wallclock secs ( 0.29 usr 0.06 sys + 1.61 cusr 0.17 csys = 2.13 CPU) Result: FAIL Failed 2/22 test programs. 26/716 subtests failed. make[1]: *** [test_dynamic] Error 255 make[1]: Leaving directory `/home/sb/Net-Z3950-ZOOM-1.25' make: *** [build-stamp] Error 2 make: Leaving directory `/home/sb/Net-Z3950-ZOOM-1.25' Cannot create deb package

2 1

Reimporting Updated info
by Roche III, Edward 01 Jul '09

01 Jul '09

Is it possible to re-import our data through with updated info? I found a field that I forgot to add to the 952 field and I want to reimport our data with the correction but each time I do it doesn't update the field. Any thoughts? Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?"

1 0

losing folder var/run/koha/...
by Mono Lib 01 Jul '09

01 Jul '09

hi to all thank's to every one tried to helped me that's was so kind , when i turn on server i didn't found :/var/run/koha/zebradb in pass and running mkdir -p /var/lock/koha/zebradb/... to restore the folder and contains and rebuild zebra and running sudo zebrasrv -f/etc/koha/koha-conf.xml to starting zebra and making search it's okay , when i close the terminal and making search no result onther thing when i running /usr/share/koha/bin/koha-zebraqueue-ctl.sh start i got Starting Zebraqueue Daemon /usr/share/koha/bin/koha-zebraqueue-ctl.sh: line 26: daemon: command not found that is all my problem with koha , i'm using ubuntu 9 ... thanks

2 1