- Koha - lists.katipo.co.nz

OCLC Connexion users on Mac OS
by Eric Phetteplace 26 Jun '16

26 Jun '16

Hello Collective Wisdom, Is anyone an OCLC Connexion user that also happens to use Mac OS X? We're a Mac school and the desktop client only runs on Windows. But we learned today that the website's export function, which worked fine with our prior ILS Millennium, only exports records in MARC8 encoding and not UTF-8, so Koha doesn't work with it. All our work around options look bleak: using something like WINE to run the client on a Mac, asking our staff to dual boot or run a VM, exporting to a file instead & importing that into Koha. They'll work but they're much more inconvenient than the web client. If anyone has a better idea I'd be grateful. Best, Eric Phetteplace Systems Librarian California College of the Arts libraries.cca.edu | vault.cca.edu 510.594.3660 2>/dev/null

1 0

After upgrade to 16.5.00.000 - OPAC/Staff Client not showing results
by SATISH 25 Jun '16

25 Jun '16

Dear All, Previously, Koha 3.16 was installed from packages method on ubuntu 12.4 LTS Desktop and was working very fine and did an uprade to 16.5.00.000 today morning, after that, I am unable to search records either in staff client or in opac. I followed, https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages and after upgrade did run 1) koha-rebuild-zebra -v -f gechlibrary 2) cleared all browsing cache and zebra re-indexing is throwing some warning ( ow) ==================================================== root@gechlibrary:/home/satish# koha-rebuild-zebra -v -f gechlibrary Warning: You passed -x which is already the default and is now deprecatedÂ· Zebra configuration information ================================ Zebra biblio directory = /var/lib/koha/gechlibrary/biblios Zebra authorities directory = /var/lib/koha/gechlibrary/authorities Koha directory = /usr/share/koha/intranet/cgi-bin Lockfile = /var/lock/zebra_koha_gechlibrary/rebuild/rebuild..LCK BIBLIONUMBER in : 999$c BIBLIOITEMNUMBER in : 999$d ================================ skipping authorities ==================== exporting biblio ==================== 1001................................................................................................... Records exported: 1061 ==================== REINDEXING zebra ==================== 15:27:09-16/06 zebraidx(2466) [warn] Couldn't open collection.abs [No such file or directory] 15:27:29-16/06 zebraidx(2466) [warn] Record didn't contain match fields in (bib1,Local-number) ==================== CLEANING ==================== Zebra configuration information ================================ Zebra biblio directory = /var/lib/koha/gechlibrary/biblios Zebra authorities directory = /var/lib/koha/gechlibrary/authorities Koha directory = /usr/share/koha/intranet/cgi-bin Lockfile = /var/lock/zebra_koha_gechlibrary/rebuild/rebuild..LCK BIBLIONUMBER in : 999$c BIBLIOITEMNUMBER in : 999$d ================================ ==================== exporting authority ==================== Records exported: 0 ==================== REINDEXING zebra ==================== skipping biblios ==================== CLEANING ==================== AND when I try to restart apache service, it is throwing following error: (Server version: Apache/2.2.22 (Ubuntu) Server built: Jul 24 2015 17:25:49) APACHE VERSION PROBLEM root@gechlibrary:/# sudo service apache2 restart ERROR: Syntax error on line 5 of /etc/apache2/sites-enabled/gechlibrary.conf: Invalid command '<IfVersion', perhaps misspelled or defined by a module not included in the server configuration Action 'configtest' failed. The Apache error log may have more information. ...fail! Can community, please help me to restore my opac back...?? with thanks Satish MV Librarian Govt. Engineering College, Hassan Karnataka - 573 201 INDIA. --

2 4

Round the World Koha Speaking Tour
by Joann Ransom 25 Jun '16

25 Jun '16

If I say it I have to do it right; I would love to come visit the global Koha community in the next 3 months. Happy to speak and schmooze and whatever else is needed to help make this happen! If you would like to find out more please read more below and get in touch with me. Norway is the first jigsaw piece set for late September and it looks like Kansas is going to be a go. Many thanks Jo. http://library-matters.blogspot.co.nz/2016/06/round-world-koha-speaking-tou… Sent from my Samsung Galaxy smartphone. ##################################################################################### This e-mail message and any attached files may contain confidential information, and may be subject to legal professional privilege. If you are not the intended recipient, please delete. Unless formally stated, this e-mail and any attachments do not necessarily reflect the views of the the The Horowhenua Trust. The Horowhenua Trust takes extensive precautions with the aim of detecting and removing any virus or defects from its e-mail system but accepts no liability for loss or damage should this e-mail not be virus or defect free or should there be any errors in transmission. #####################################################################################

1 0

Error 255 make test
by vijay kumar 24 Jun '16

24 Jun '16

Dear all, When I used the koha-3.20.12, the problem was solved. thanks Vijay Kumar le 'kohadata.systempreferences' doesn't exist at /usr/share/koha-3.20.12/blib/PERL_MODULE_DIR/C4/Context.pm line 544. DBD::mysql::db selectrow_array failed: Table 'kohadata.systempreferences' doesn't exist at /usr/share/koha-3.20.12/blib/PERL_MODULE_DIR/C4/Context.pm line 544. DBD::mysql::db selectrow_array failed: Table 'kohadata.systempreferences' doesn't exist at /usr/share/koha-3.20.12/blib/PERL_MODULE_DIR/C4/Context.pm line 544. t/SIPILS.t .......................... ok t/SMS.t ............................. ok t/SocialData.t ...................... ok t/Stats.t ........................... ok t/SuggestionEngine.t ................ ok t/SuggestionEngine_AuthorityFile.t .. ok t/TmplToken.t ....................... ok t/XSLT.t ............................ ok All tests successful. Files=100, Tests=10397, 104 wallclock secs ( 3.03 usr 0.35 sys + 69.78 cusr 5.85 csys = 79.01 CPU) Result: PASS

2 1

Error 255 failed 'make test'
by vijay kumar 23 Jun '16

23 Jun '16

Dear all, I am getting error during fresh installation of koha-3.22.07 on Ubuntu. I have installed all perl dependencies But during 'make test' command ... getting the following errors Your kind help is needed. These are the snapshot of errors With regards, Vijay Kumar ---------------------------------------------------------------------------------------------------------------- root@vijay-ubuntu:/usr/share/koha-3.22.07# make test PERL_DL_NONLAZY=1 KOHA_CONF=blib/KOHA_CONF_DIR/koha-conf.xml "/usr/bin/perl" "-MExtUtils::Command::MM" "-MTest::Harness" "-e" "undef *Test::Harness::Switches; test_harness(0, 'blib/PERL_MODULE_DIR', 'blib/arch')" t/*.t t/00-checkdatabase-version.t ........ ok t/00-deprecated.t ................... ok t/00-load.t ......................... 1/? Too late to run INIT block at /usr/share/koha-3.22.07/blib/PERL_MODULE_DIR/C4/Barcodes/hbyymmincr.pm line 42. t/00-load.t ......................... 14/? DBIx::Class::Storage::DBI::_warn_undetermined_driver(): This version of DBIC does not yet seem to supply a driver for your particular RDBMS and/or connection method ('Mock'). While we will attempt to continue anyway, the results are likely to be underwhelming. Please upgrade DBIC, and if this message does not go away, file a bugreport including the following info: { DBD => "DBD::Mock", DBD_VER => "1.45", DBIC_DRIVER => "DBIx::Class::Storage::DBI", DBIC_DSN => "DBI:Mock:", DBIC_VER => "0.082821", DBI_VER => "1.636" } DBIx::Class::Storage::DBI::sql_maker(): Your storage class (DBIx::Class::Storage::DBI) does not set sql_limit_dialect and you have not supplied an explicit limit_dialect in your connection_info. DBIC will attempt to use the GenericSubQ dialect, which works on most databases but can be (and often is) painfully slow. Please file an RT ticket against 'DBIx::Class::Storage::DBI' at /usr/share/koha-3.22.07/blib/PERL_MODULE_DIR/Koha/Objects.pm line 83 Too late to run INIT block at /usr/share/koha-3.22.07/blib/PERL_MODULE_DIR/C4/Tags.pm line 75. t/00-load.t ......................... 82/? Too late to run INIT block at /usr/share/koha-3.22.07/blib/PERL_MODULE_DIR/C4/External/BakerTaylor.pm line 42. t/00-load.t ......................... ok t/00-merge-conflict-markers.t ....... ok t/00-testcritic.t ................... skipped: Author test. Set $ENV{TEST_QA} to a true value to run t/00-valid-xml.t .................... ok t/Auth_with_shibboleth.t ............ ok t/AuthoritiesMarc_MARC21.t .......... ok t/AuthoritiesMarc_UNIMARC.t ......... ok t/AuthUtils.t ....................... ok t/Barcodes_annual.t ................. ok t/Barcodes_EAN13.t .................. ok t/Barcodes_hbyymmincr.t ............. ok t/Barcodes_incremental.t ............ ok t/Biblio.t .......................... ok t/Bookseller.t ...................... ok t/Boolean.t ......................... ok t/Borrower.t ........................ ok t/Branch.t .......................... ok t/Breeding.t ........................ ok t/Budgets.t ......................... ok t/Cache.t ........................... ok t/Calendar.t ........................ ok t/Charset.t ......................... ok t/Circulation_barcodedecode.t ....... ok t/ClassSortRoutine.t ................ ok t/ClassSortRoutine_Dewey.t .......... ok t/ClassSortRoutine_Generic.t ........ ok t/ClassSortRoutine_LCC.t ............ ok t/ClassSource.t ..................... ok t/Context.t ......................... ok t/Contract.t ........................ ok t/Creators.t ........................ ok t/DateUtils.t ....................... ok t/Debug.t ........................... ok t/dummy.t ........................... ok t/External_Syndetics.t .............. ok t/Form_MessagingPreferences.t ....... ok t/Heading.t ......................... ok t/Images.t .......................... ok t/ImportBatch.t ..................... ok t/Installer_PerlDependencies.t ...... ok t/Installer_PerlModules.t ........... ok t/Installer_pm.t .................... ok t/ItemCirculationAlertPreference.t .. ok t/ItemType.t ........................ ok t/Koha.t ............................ ok t/Koha_Email.t ...................... ok t/Koha_MetadataRecord.t ............. ok t/Koha_Template_Plugin_Cache.t ...... ok t/Koha_Template_Plugin_Koha.t ....... ok t/Koha_Util_FrameworkPlugin.t ....... ok t/Koha_Util_MARC.t .................. ok t/Labels.t .......................... ok t/Labels_split_ccn.t ................ ok t/Labels_split_ddcn.t ............... ok t/Labels_split_lccn.t ............... ok t/Languages.t ....................... ok t/Letters.t ......................... ok t/Log.t ............................. ok t/Logger.t .......................... # Failed test 'Warnings raised if log file is not writeable' # at t/Logger.t line 64. # didn't find a warning # expected to find warning: Log file not writable for log4perl # expected to find warning: warn: Message 3 # Failed test 'Message 3 returned undef' # at t/Logger.t line 67. # got: '1' # expected: undef # Looks like you failed 2 tests of 8. t/Logger.t .......................... 1/1 # Failed test 'Test01 -- Simple tests for Koha::Logger' # at t/Logger.t line 31. # Looks like you failed 1 test of 1. t/Logger.t .......................... Dubious, test returned 1 (wstat 256, 0x100) Failed 1/1 subtests t/Matcher.t ......................... ok t/Members_Attributes.t .............. ok t/Members_AttributeTypes.t .......... ok t/Members_Messaging.t ............... ok t/Message.t ......................... ok t/NorwegianPatronDB.t ............... ok t/Output.t .......................... ok t/Output_JSONStream.t ............... ok t/Overdues.t ........................ ok t/Patroncards.t ..................... ok t/Patroncards_Batch.t ............... ok t/Patroncards_Layout.t .............. ok t/Patroncards_Lib.t ................. ok t/Patroncards_Patroncard.t .......... ok t/Patroncards_Profile.t ............. ok t/Patroncards_Template.t ............ ok t/Prices.t .......................... ok t/Print.t ........................... ok t/QueryParser.t ..................... 7/? Negative repeat count does nothing at /usr/share/koha-3.22.07/blib/PERL_MODULE_DIR/Koha/QueryParser/Driver/PQF/query_plan/ node.pm line 102. t/QueryParser.t ..................... ok t/RecordProcessor.t ................. ok t/Review.t .......................... ok t/Ris.t ............................. 1/6 Use of uninitialized value $uniout in string eq at /usr/share/koha-3.22.07/blib/PERL_MODULE_DIR/C4/Ris.pm line 1024. Use of uninitialized value $uniout in string eq at /usr/share/koha-3.22.07/blib/PERL_MODULE_DIR/C4/Ris.pm line 1024. t/Ris.t ............................. ok t/RotatingCollections.t ............. ok t/Scheduler.t ....................... ok t/Scrubber.t ........................ ok t/Search.t .......................... ok t/Search_PazPar2.t .................. ok t/SimpleMARC.t ...................... ok t/SIP_Sip.t ......................... ok t/SMS.t ............................. ok t/SocialData.t ...................... ok t/Stats.t ........................... ok t/SuggestionEngine.t ................ ok t/SuggestionEngine_AuthorityFile.t .. ok t/TmplToken.t ....................... ok t/XSLT.t ............................ ok Test Summary Report ------------------- t/Logger.t (Wstat: 256 Tests: 1 Failed: 1) Failed test: 1 Non-zero exit status: 1 Files=97, Tests=10432, 172 wallclock secs ( 3.15 usr 0.33 sys + 128.90 cusr 8.12 csys = 140.50 CPU) Result: FAIL Failed 1/97 test programs. 1/10432 subtests failed. Makefile:21065: recipe for target 'test_dynamic' failed make: *** [test_dynamic] Error 255

1 0

Koha 3.22 authorities linking and hierarchy not working properly
by Andreas Roussos 23 Jun '16

23 Jun '16

Hello, We plan to use authorities linking and hierarchy in production to display thesaurus based topical subject authorities. On a clean install of Koha 3.22 on Ubuntu using UNIMARC, we created 1 biblio with 2 topical subject authorities (biblio unimarc 607), the one being broader than the other and linked them. Issue #1: authority link relations had to be entered manually (in 550$5 'g' and 550$5 'h') as they would not be entered using the authority finder plugin. Issue #2: only broader to narrower terms show correctly when viewing the broader term's details with a collapsible + sign to display the narrower term, while in the narrower term's details view no broader term is displayed as linked. Any guidance will be greatly appreciated, Andreas

2 1

Koha 3.20.12 released
by Chris Cormack 23 Jun '16

23 Jun '16

Hi All The Koha community is proud to announce the release of Koha 3.20.12. This a bugfix and security release. Packages should be available soon. You can read the release notes here https://koha-community.org/koha-3-20-12-released/ Chris

1 0

Batch Creation of Bibliographic Records based on ISBN numbers
by Admire Mutsikiwa 22 Jun '16

22 Jun '16

Hi I have a list of ISBN numbers of the books that are in one of our library. I would like to automatically import the records based on the ISBN numbers into the reservoir to streamline cataloguing. Is this possible? Kind Regards, Admire Mutsikiwa (Mr) ICT Manager Libraries University of Zimbabwe Tel:+263-4-303276 Mob:+263771117777 "It is easy to dodge our responsibilities, but we cannot dodge the consequences of dodging our responsibilities." Josiah Charles Stamp <http://www.goodreads.com/author/show/4867406.Josiah_Charles_Stamp>

1 0

Updating 856 Field
by Graham, Stephen 22 Jun '16

22 Jun '16

Hi All - we want to change the 856 field in over 18,000 records. The actual change itself is easy - simply URL encoding the existing URL, and then prefixing it with another value. I am thinking of scripting this job. 1. Identity and retrieve the biblio IDs from a SQL query 2. Iterate over the IDs and use C4::Biblio:: GetMarcBiblio to retrieve the MARC record 3. Grab the 856, subfield u value and make the change 4. Use C4::Biblio:: ModBiblio to update the record in Koha The actual relevant code would look something like (this is inside a loop which is iterating over the array of BIB IDs): my $marc_record = GetMarcBiblio($id); if ($marc_record) { my $url = $marc_record->field('856')->subfield('u'); my $field_856 = $marc_record->field('856'); my $encodedURL = &encodeURL($url); my $wURL = $eblPrefix . $encodedURL; $field_856->update( u => $wURL); my $updated = ModBiblio($marc_record,$id,''); } I've test this on 10 records and it seems to work OK. My main question is, are there any "gotchas" doing it this way - anything I need to look out for/anything I've missed? I'm not explicitly indicating any encoding format - I'm assuming that what goes back into Koha , will be the same as what I took out (apart from the URL) - with all the encoding the same. Is that assumption correct? Is it OK to make this change to 18K in one go? Before I run the script I'm make a dump of the biblioitems table (which I think is the only table effected by this update), and the script dumps out the BIB IDs and the MARC records to file for reference. How does this sound/look? Cheers, Stephen Stephen Graham Library Technology Consultant Academic Resources Library and Computing Services University of Hertfordshire Hatfield AL10 9AB UK Tel. 01707 286111 Ext: 77751 Email s.graham4(a)herts.ac.uk

1 0

Re: [Koha] Upgraded to 16.05 and can't retrieve Patrons by Surname (Liz Rea)
by Tim Auld 21 Jun '16

21 Jun '16

Thank you Liz, you were quite correct. It was just a matter of clearing the browser cache. Much appreciated. Regards, Tim Auld Northern Philatelic Library Minnesota.

1 0