- Koha - lists.katipo.co.nz

import excel file to koha
by regina kivuyo 23 Mar '16

23 Mar '16

hello thanks for assistant to install koha now i want to import excel to database is that possible how to do that -- regina

3 2

koha installation
by regina kivuyo 22 Mar '16

22 Mar '16

whwn i install koha i edited the file as needed /etc/perl/XML/SAX/ParserDetails.ini misc/sax_parser_print.pl Koha wants something like: XML::LibXML::SAX::Parser=HASH(0x81fe220) You have: XML::SAX::Expat=HASH(0x1a94e88) Looks bad, check INSTALL.* documentation. what is wrong with me -- regina

2 1

UNIMARC installation - copydate/pubdate not working for date range and sort by
by Pedro Amorim 22 Mar '16

22 Mar '16

Hello, As the title says, I have Koha installed in UNIMARC and the date range and sort by 'publication date' are not working, at all, as if Koha was using some other field entirely. This is what I'm suspecting, Koha is not using 210$d (Publication date) to sort or limit results. The file record.abs for *marc21* has the following line in it: melm 260$c copydate,copydate:s However, the file record.abs for *unimarc* has: melm 210$d pubdate:n,pubdate:y *and* it does not have the word 'copydate' in it. This is important because I have tested it in the online demo for UNIMARC and this behaviour is present in every UNIMARC installation I know. And every marc21 installation I've seen (including the demo) is working as expected. The 'sort by' works If an author (au) filter is also present for example, but it doesn't work if I simply search for 'Books' sorted asc for example. Has anyone noticed this? Or am I seeing things and it's some problem with my installation?

1 1

HTTP::OAI
by regina kivuyo 22 Mar '16

22 Mar '16

sorry for disturbance i tried to install HTTP::OAI root@library-HP-Pro-3400-Series-MT:/home/koha-3.10.02# cpan force install HTTP::OAI Reading '/root/.cpan/Metadata' Database was generated on Mon, 21 Mar 2016 16:17:02 GMT Warning: Cannot install force, don't know what it is. Try the command i /force/ to find objects with matching identifiers. install is up to date (0.01). Running install for module 'HTTP::OAI' Checksum for /root/.cpan/sources/authors/id/T/TI/TIMBRODY/HTTP-OAI-4.03.tar.gz ok Configuring T/TI/TIMBRODY/HTTP-OAI-4.03.tar.gz with Makefile.PL Checking if your kit is complete... Warning: the following files are missing in your kit: MYMETA.json MYMETA.yml Please inform the author. Warning: NAME must be a package name Generating a Unix-style Makefile Writing Makefile for HTTP-OAI Writing MYMETA.yml and MYMETA.json TIMBRODY/HTTP-OAI-4.03.tar.gz /usr/bin/perl Makefile.PL INSTALLDIRS=site -- OK Running make for T/TI/TIMBRODY/HTTP-OAI-4.03.tar.gz cp lib/HTTP/OAI/Verb.pm blib/lib/HTTP/OAI/Verb.pm cp lib/HTTP/OAI/UserAgent.pm blib/lib/HTTP/OAI/UserAgent.pm cp lib/HTTP/OAI/Metadata/OAI_Identifier.pm blib/lib/HTTP/OAI/Metadata/OAI_Identifier.pm cp lib/HTTP/OAI/SAXHandler.pm blib/lib/HTTP/OAI/SAXHandler.pm cp lib/HTTP/OAI/Harvester.pm blib/lib/HTTP/OAI/Harvester.pm cp lib/HTTP/OAI/Header.pm blib/lib/HTTP/OAI/Header.pm cp lib/HTTP/OAI/ListRecords.pm blib/lib/HTTP/OAI/ListRecords.pm cp lib/HTTP/OAI/SAX/Driver.pm blib/lib/HTTP/OAI/SAX/Driver.pm cp lib/HTTP/OAI/MemberMixin.pm blib/lib/HTTP/OAI/MemberMixin.pm cp lib/HTTP/OAI/Response.pm blib/lib/HTTP/OAI/Response.pm cp lib/HTTP/OAI/ResumptionToken.pm blib/lib/HTTP/OAI/ResumptionToken.pm cp lib/HTTP/OAI/Metadata/OAI_DC.pm blib/lib/HTTP/OAI/Metadata/OAI_DC.pm cp lib/HTTP/OAI/Metadata/METS.pm blib/lib/HTTP/OAI/Metadata/METS.pm cp lib/HTTP/OAI/SAX/Base.pm blib/lib/HTTP/OAI/SAX/Base.pm cp lib/HTTP/OAI/Repository.pm blib/lib/HTTP/OAI/Repository.pm cp lib/HTTP/OAI/ListIdentifiers.pm blib/lib/HTTP/OAI/ListIdentifiers.pm cp lib/HTTP/OAI/Debug.pm blib/lib/HTTP/OAI/Debug.pm cp lib/HTTP/OAI/PartialList.pm blib/lib/HTTP/OAI/PartialList.pm cp lib/HTTP/OAI/Set.pm blib/lib/HTTP/OAI/Set.pm cp lib/HTTP/OAI/Record.pm blib/lib/HTTP/OAI/Record.pm cp lib/HTTP/OAI/Error.pm blib/lib/HTTP/OAI/Error.pm cp lib/HTTP/OAI/Metadata/OAI_Eprints.pm blib/lib/HTTP/OAI/Metadata/OAI_Eprints.pm cp lib/HTTP/OAI/GetRecord.pm blib/lib/HTTP/OAI/GetRecord.pm cp lib/HTTP/OAI/Metadata.pm blib/lib/HTTP/OAI/Metadata.pm cp lib/HTTP/OAI.pm blib/lib/HTTP/OAI.pm cp lib/HTTP/OAI/ListMetadataFormats.pm blib/lib/HTTP/OAI/ListMetadataFormats.pm cp lib/HTTP/OAI/Encapsulation.pm blib/lib/HTTP/OAI/Encapsulation.pm cp lib/HTTP/OAI/Identify.pm blib/lib/HTTP/OAI/Identify.pm cp lib/HTTP/OAI/SAX/Text.pm blib/lib/HTTP/OAI/SAX/Text.pm cp lib/HTTP/OAI/ListSets.pm blib/lib/HTTP/OAI/ListSets.pm cp lib/HTTP/OAI/MetadataFormat.pm blib/lib/HTTP/OAI/MetadataFormat.pm cp lib/HTTP/OAI/SAX/Trace.pm blib/lib/HTTP/OAI/SAX/Trace.pm cp bin/oai_pmh.pl blib/script/oai_pmh.pl "/usr/bin/perl" -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/ oai_pmh.pl cp bin/oai_browser.pl blib/script/oai_browser.pl "/usr/bin/perl" -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/ oai_browser.pl Manifying 2 pod documents Manifying 25 pod documents TIMBRODY/HTTP-OAI-4.03.tar.gz /usr/bin/make -- OK Running make test PERL_DL_NONLAZY=1 "/usr/bin/perl" "-MExtUtils::Command::MM" "-MTest::Harness" "-e" "undef *Test::Harness::Switches; test_harness(0, 'blib/lib', 'blib/arch')" t/*.t t/000xml_sax.t ........... ok t/00static.t ............. ok t/01parse.t .............. ok t/02token.t .............. ok t/03badbytes.t ........... ok t/50mets.t ............... ok t/80network.t ............ ok t/error.t ................ ok t/getrecord.t ............ 1/8 Can't call method "start_element" on an undefined value at /root/.cpan/build/HTTP-OAI-4.03-UQClDl/blib/lib/HTTP/OAI/Verb.pm line 53. # Looks like you planned 8 tests but ran 7. # Looks like your test exited with 255 just after 7. t/getrecord.t ............ Dubious, test returned 255 (wstat 65280, 0xff00) Failed 1/8 subtests t/identify.t ............. ok t/listidentifiers.t ...... ok t/listmetadataformats.t .. ok Test Summary Report ------------------- t/getrecord.t (Wstat: 65280 Tests: 7 Failed: 0) Non-zero exit status: 255 Parse errors: Bad plan. You planned 8 tests but ran 7. Files=12, Tests=78, 8 wallclock secs ( 0.04 usr 0.02 sys + 1.43 cusr 0.11 csys = 1.60 CPU) Result: FAIL Failed 1/12 test programs. 0/78 subtests failed. make: *** [test_dynamic] Error 255 TIMBRODY/HTTP-OAI-4.03.tar.gz /usr/bin/make test -- NOT OK //hint// to see the cpan-testers results for installing this module, try: reports TIMBRODY/HTTP-OAI-4.03.tar.gz root@library-HP-Pro-3400-Series-MT:/home/koha-3.10.02# help me -- regina

2 1

HTTP::OAI
by regina kivuyo 22 Mar '16

22 Mar '16

what is the function HTTP::OAI , i skip this koha canot work? hel please -- regina

1 0

Net-Z3950-ZOOM
by regina kivuyo 22 Mar '16

22 Mar '16

is it posible to continue with installation without Net-Z3950-ZOOM -- regina

1 0

Net-Z3950-ZOOM
by regina kivuyo 22 Mar '16

22 Mar '16

im install koha but the problem in install Net-Z3950-ZOOM i got the error cpan Net::Z3950 Going to read '/root/.cpan/Metadata' Database was generated on Mon, 21 Mar 2016 16:17:02 GMT Running install for module 'Net::Z3950' Running make for M/MI/MIRK/Net-Z3950-ZOOM-1.30.tar.gz Checksum for /root/.cpan/sources/authors/id/M/MI/MIRK/Net-Z3950-ZOOM-1.30.tar.gz ok CPAN.pm: Going to build M/MI/MIRK/Net-Z3950-ZOOM-1.30.tar.gz Checking if your kit is complete... Looks good Generating a Unix-style Makefile Writing Makefile for Net::Z3950::ZOOM Writing MYMETA.yml and MYMETA.json cp lib/Net/Z3950/ZOOM.pm blib/lib/Net/Z3950/ZOOM.pm cp lib/ZOOM.pod blib/lib/ZOOM.pod cp lib/ZOOM.pm blib/lib/ZOOM.pm cp lib/Net/Z3950.pm blib/lib/Net/Z3950.pm Running Mkbootstrap for Net::Z3950::ZOOM () chmod 644 "ZOOM.bs" "/usr/bin/perl" "/usr/share/perl/5.14/ExtUtils/xsubpp" -typemap "/usr/share/perl/5.14/ExtUtils/typemap" -typemap "typemap" ZOOM.xs > ZOOM.xsc && mv ZOOM.xsc ZOOM.c cc -c -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 -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -g -DVERSION=\"1.30\" -DXS_VERSION=\"1.30\" -fPIC "-I/usr/lib/perl/5.14/CORE" ZOOM.c rm -f blib/arch/auto/Net/Z3950/ZOOM/ZOOM.so LD_RUN_PATH="/usr/lib/../lib:/usr/lib/i386-linux-gnu" cc -shared -O2 -g -L/usr/local/lib -fstack-protector ZOOM.o -o blib/arch/auto/Net/Z3950/ZOOM/ZOOM.so \ -lyaz -lexslt -lxslt -lxml2 -lpthread \ chmod 755 blib/arch/auto/Net/Z3950/ZOOM/ZOOM.so "/usr/bin/perl" -MExtUtils::Command::MM -e 'cp_nonempty' -- ZOOM.bs blib/arch/auto/Net/Z3950/ZOOM/ZOOM.bs 644 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 cp samples/zoom/zoom-delete-records blib/script/zoom-delete-records "/usr/bin/perl" -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/zoom-delete-records Manifying 2 pod documents MIRK/Net-Z3950-ZOOM-1.30.tar.gz /usr/bin/make -- OK Running make test Running Mkbootstrap for Net::Z3950::ZOOM () chmod 644 "ZOOM.bs" PERL_DL_NONLAZY=1 "/usr/bin/perl" "-MExtUtils::Command::MM" "-MTest::Harness" "-e" "undef *Test::Harness::Switches; 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 ......... ok t/17-logging.t .......... ok t/18-charset.t .......... 2/9 # Failed test 'connection to 'z3950.loc.gov:7090/voyager'' # at t/18-charset.t line 15. # Failed test 'found 0 records (expected 1)' # at t/18-charset.t line 26. # Failed test 'got first record' # at t/18-charset.t line 29. Net::Z3950::ZOOM::record_get_binary: rec is not of type ZOOM_record at /root/.cpan/build/Net-Z3950-ZOOM-1.30-5dQ0MB/blib/lib/Net/Z3950/ZOOM.pm line 159. # Looks like you planned 9 tests but ran 5. # Looks like you failed 3 tests of 5 run. # Looks like your test exited with 115 just after 5. t/18-charset.t .......... Dubious, test returned 115 (wstat 29440, 0x7300) Failed 7/9 subtests 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 ......... 5/39 ^Cmake: *** [test_dynamic] Interrupt MIRK/Net-Z3950-ZOOM-1.30.tar.gz /usr/bin/make test -- NOT OK //hint// to see the cpan-testers results for installing this module, try: reports MIRK/Net-Z3950-ZOOM-1.30.tar.gz Running make install make test had returned bad status, won't install without force i i force the install but it give me the same message help me please -- regina

2 1

Reminder: Global Bug Squashing Day - this week on March 24!
by Katrin Fischer 21 Mar '16

21 Mar '16

Hi all, just a quick reminder about the Global Bug Squashing Day (GBSD) this week - March 24th 2016! Please feel free to add your ideas for the day to the wiki page, things you want to learn about and bugs you'd like to test or see tested: https://wiki.koha-community.org/wiki/2016-03-24_Global_bug_squashing_day Hope to see you there! Katrin

2 1

22nd March - Dev meeting in IRC at 19 UTC
by Brendan Gallagher 21 Mar '16

21 Mar '16

https://wiki.koha-community.org/wiki/Development_IRC_meeting_22_March Please see the agenda for action and discussion items. - 22 March 2016, 19 UTC Time and Date.com converter for various local times <http://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+Developers+IR…> Thanks Brendan.

1 0

koha reports
by Monisa Aslam 20 Mar '16

20 Mar '16

help needed I need a complete patron list with item.barcodes (items still with that patron). this report should also include the patrons which don't have any item with them. what i made isSELECT borrowernumber,borrowers.cardnumber,borrowers.surname,borrowers.firstname,borrowers.address,borrowers.address2,borrowers.branchcode,borrowers.categorycode,borrowers.dateenrolled,borrowers.dateexpiry,borrowers.debarredcomment,borrowers.borrowernotes,items.barcodeFROM borrowers LEFT JOIN items but there is a syntax error, i don't know where?Monisa Aslam

2 1