- Koha - lists.katipo.co.nz

Koha - query help needed for bilblioitems.marc
by Linda 22 Aug '12

22 Aug '12

All, I need to find records having a 773 field that are missing either a subfield "9". or a subfield "o".. I'm at a loss of how to accomplish this. Any input would be appreciated. Thanks in advance. -- Linda Culberson lculber(a)mdah.state.ms.us Miss. Dept. of Archives and History Archives& Records Services P.O. Box 571 Jackson, MS 39205-0571 Phone: (601) 576-6873

2 2

Can data from CDISIS transfered to MySQL
by Naveed 22 Aug '12

22 Aug '12

Hi all Presently i am working on CDISIS WINISIS.Now i want to switch over to KOHA.Kindly guide me can i export my data to MySQL as i have thousands of records of my Library. Kind regards Naveed.

2 1

Completeness of records for importing
by franc＠library.iisc.ernet.in 22 Aug '12

22 Aug '12

Dear Members, For the last couple of weeks, I have been experimenting with the Koha's importing feature. I seem to have understood and overcome all the teething problems related to importing of bibliographic records. I have now imported more than 60K records and every thing seems to be working fine. Before I proceed with the other aspects of Koha, I just wanted to ensure that the there isn't something oblivious that is missing in the records that I have imported. Could you please have look at the sample record given below and let me know if it is complete in all aspects or if any of the obvious and essential fields are missing. A Sample Record --------------- =LDR 00000nam 2200000Ia 45e0^M =008 120819s9999\\\\xx\\\\\\\\\\\\000\0\und\d^M =020 \\$a0-87692-514-10^M =082 \\$a005.133$bN884^M =245 \\$aPrinciples of computer programming (Fortran 77 for IBM PC) /by V. Rajaraman.^M =250 \\$a3rd.^M =260 \\$aNew Delhi$bP-H of India$c1988^M =300 \\$a246p^M =653 \\$a<Programming, Electronic digital computers Computer programming languages>^M =700 \\$aRajaraman, V.^M =952 \\$aJRDTML$bJRDTML$yBK$p144621 $o005.133 N884^M Thanks for your attention. - Francis JRDTML, IISc, Bangalore, India -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.

5 8

Bulk Delete of Biblios without items
by Tony Morton 22 Aug '12

22 Aug '12

Hi Can anyone tell me how I can Bulk Delete of Biblios without items in Koha 3.6 Tony Morton Senior Librarian Phone: (03) 6890071 Email: tony(a)waimatedc.govt.nz<mailto:tony@waimatedc.govt.nz> P.O. Box 122 Waimate 7960 ________________________________ ______________________________________________________________________________ This email has been scrubbed for your protection by SMX. For more information visit http://smxemail.com ______________________________________________________________________________

2 1

Koha version 3.6.8 released
by Jared Camins-Esakov 22 Aug '12

22 Aug '12

The Koha community is proud to release Koha version 3.06.08.000. This is a bugfix release, and contains a number of important fixes You can obtain Koha 3.06.08.000 from the http://download.koha-community.org site. Debian packages will be available from the http://debian.koha-community.org shortly also. Please read the release notes below for more information RELEASE NOTES FOR KOHA 3.6.8 22 Aug 2012 ======================================================================== Koha is the first free and open source software library automation package (ILS). Development is sponsored by libraries of varying types and sizes, volunteers, and support companies from around the world. The website for the Koha project is http://koha-community.org/ Koha 3.6.8 can be downloaded from: http://download.koha-community.org/koha-3.06.08.tar.gz Installation instructions can be found at: http://wiki.koha-community.org/wiki/Installation_Documentation OR in the INSTALL files that come in the tarball Koha 3.6.8 is a bugfix/maintenance release. Highlights of 3.6.8 ====================== 7329 critical The "undo import into catalog" command deletes items onloan without checking 7834 critical order search at the top of acq does nothing 8289 critical Upgrading from 2.2 does not work anymore 2505 major enable Perl warnings in all modules and scripts 8315 major fix 'C4::Output 3.02' errors in Koha Bugs fixed in 3.6.8 ====================== 4838 normal Repeated authority headings break biblio record data entry form 6634 normal manager_id not populated when paying fines 6720 normal Saved authorities always show as 'Default' 7586 normal Search: Language restriction does NOT show expected results (no items shown) 7807 normal GetSuggestionFromBiblionumber takes only one parameter 7886 normal C4/ShelfBrowser slow SQL performance 7900 normal Link to vendor from subscription details is broken 7952 normal PDF::Reuse under plack writes to console STDOUT instead to browser 8136 normal Changes the expected lenght of 100$a in rebuild_zebra.pl 8171 normal Improper escaping of quotes during z39.50 queries leads to broken html 8197 normal Software error when you have cleaned cookies in your browser and try to past the url to opac-topissues.pl 8226 normal 'OpacFooter' markup/css improvements 8282 normal Bug in modules list in about.pl 5312 minor XHTML correction in authority summary 6141 minor html glitches causing problems to translator 6679 minor Fixing code so it passes basic Perl::Critic tests 7815 minor Order pickup library list by name rather than by code 8009 minor Item descriptive data not populated on pay.pl 8166 minor Adding new currencies & exchange rates if not fill any field it save blank record 8191 minor New value for 8 position in coded data field 100 in unimarc 8232 minor Comments in OPAC contain untranslatable javascript messages 6350 trivial Bug for tracking updates to the history file 7143 trivial Bug for tracking changes to the about page 7367 trivial General OPAC typo omnibus 7368 trivial General staff client typo omnibus 7994 trivial Syntax error in yaml (syspref) files 8222 trivial The zip code field is mandatory by default 8138 enhancement Add 773$t field to xslt 8216 enhancement Enable critic tests on SIP modules New sysprefs in 3.6.8 ====================== * BorrowerMandatoryField System requirements ====================== Important notes: * Perl 5.10 is required * Zebra is required Documentation ====================== As of Koha 3.2, the Koha manual is now maintained in DocBook. The home page for Koha documentation is http://koha-community.org/documentation/ As of the date of these release notes, only the English version of the Koha manual is available: http://manual.koha-community.org/3.6/en/ The Git repository for the Koha manual can be found at http://git.koha-community.org/gitweb/?p=kohadocs.git;a=summary Translations ====================== Complete or near-complete translations of the OPAC and staff interface are available in this release for the following languages: * Arabic (51%) * Chinese (China) (96%) * Chinese (Taiwan) (99%) * Danish (100%) * English (New Zealand) (100%) * English (USA) * English (United Kingdom) (64%) * French (99%) * French (Canada) (95%) * German (100%) * Greek (94%) * Italian (100%) * Norwegian Bokmål (62%) * Portuguese (Brazil) (99%) * Spanish (100%) * Tetun (52%) Partial translations are available for various other languages. The Koha team welcomes additional translations; please see http://wiki.koha-community.org/wiki/Translating_Koha for information about translating Koha, and join the koha-translate list to volunteer: http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-translate The most up-to-date translations can be found at: http://translate.koha-community.org/ Release Team ====================== The release team for Koha 3.6 is Release Manager: Chris Cormack <chrisc(a)catalyst.net.nz> Documentation Manager: Nicole C Engard <nengard(a)gmail.com> Translation Manager: Frédéric Demians <frederic(a)tamil.fr> QA Manager: Ian Walls <ian.walls(a)bywatersolutions.com> Bug Wranglers: MJ Ray, Marcel de Rooy, Paul Poulain, Mason James Past Release Maintainer (3.6.x): Chris Nighswonger <cnighswonger(a)foundations.edu> Release Maintainer (3.6.x): Jared Camins-Esakov <jcamins(a)cpbibliography.com> Credits ====================== We thank the following individuals who contributed patches to Koha 3.6.8. 1 D Ruth Bavousett 5 Jared Camins-Esakov 3 Colin Campbell 4 Chris Cormack 1 Christophe Croullebois 2 Frédéric Demians 1 Jonathan Druart 3 Katrin Fischer 1 Amit Gupta 1 Kyle M Hall 2 Claire Hernandez 2 Mason James 1 Srdjan Jankovic 1 Owen Leonard 1 Julian Maurice 1 Matthias Meusburger 4 Sophie Meynieux 3 Dobrica Pavlinusic 1 Maxime Pelletier 4 Paul Poulain 3 Marcel de Rooy 1 Fridolyn SOMERS 1 Robin Sheat 1 Marc Veron 2 christophe croullebois We also especially thank the following individuals who tested patches for Koha 3.6.8. 51 Jared Camins-Esakov 1 François Charbonnier 41 Chris Cormack 2 Michael Davis 5 Katrin Fischer 1 Marijana Glavica 3 Kyle M Hall 1 Owen Leonard 1 Sophie Meynieux 31 Paul Poulain 2 Martin Renvoize 3 Marcel de Rooy 1 Robin Sheat 2 Marc Veron 1 Stacey Walker We regret any omissions. If a contributor has been inadvertantly missed, please send a patch against these release notes to koha-patches(a)lists.koha-community.org. Revision control notes ====================== The Koha project uses Git for version control. The current development version of Koha can be retrieved by checking out the master branch of git://git.koha-community.org/koha.git The branch for this version of Koha and future bugfixes in this release line is 3.6.x. The last Koha release was 3.8.2, which was released on June 22, 2012. Bugs and feature requests ====================== Bug reports and feature requests can be filed at the Koha bug tracker at http://bugs.koha-community.org/ Ehara taku toa i te toa takitahi, engari he toa takitini

1 0

Note on three suspected bugs
by Manos Petridis 21 Aug '12

21 Aug '12

I'd like to note/report some somewhat irregular behaviour I noticed on my koha installation (3.08.03.000 on Debian). a) Search result pages seem to disregrad settings set in "System preferences". I have set defaultSortField: callnumber defaultSortOrder: ascending OPACdefaultSortField: callnumber OPACdefaultSortOrder: ascending yet, both cgi-bin/koha/opac-search.pl and cgi-bin/koha/catalogue/search.pl default to order by relevance, regardless. b) Local images don't always show on the OPAC search result pages. In some cases the correct local images appear randomly for some books only, while don't appear for others. In other - even more peculiar - cases, local images appear as the page loads and then disappear once the page has completed loading. It doesn't seem to be a browser flaw, as I've tried several browsers on different platforms, with the same results. This is a consistent problem: I have yet to see a full page complete with all the local images I have uploaded so far. I even tried reducing the number of books appearing on each page, from 20 to 10, so that it would put less strainn on apache server and on the browser, but it made no difference. The local images appear correctly in /cgi-bin/koha/opac-detail.pl both in the top portion of tthe page and in the Images tab, however in cgi-bin/koha/catalogue/detail.pl they only appear in the Images tab (this may be by design). Local images don't appear at all in cgi-bin/koha/catalogue/search.pl (administrative interface, with images on the first to the left column), I guess however that this is by design too. c) I had set koha to use the additional Amazon material available, and all went well. Wishing to verify point (b) above, I set AmazonCoverImages back to Don't show, yet it seems to have no influence, as Amazon images continue to appear nevertheless. On all three notes above, am I doing something wrong, have I mis-understood the settings mentioned, or are they bugs? Manos Petridis

4 5

Let's Fix It Together Update
by BWS Johnson 21 Aug '12

21 Aug '12

Salvete! A little while ago, I sent this message to the listserv about improving Koha's search. http://lists.katipo.co.nz/pipermail/koha/2012-July/033634.html There's good news. Mike Rylander and Galen Charlton have encouraged us to use some of the Evergreen community's search code. Adapting their QueryParser from Evergreen 1.6+ results in a big savings since we won't have to reinvent the wheel. Jared will be adapting this code to work with Koha pro bono. Thankfully, a couple of sponsors stepped forward to help make things happen. With their generous support, we have pledges totaling about $6500. The magic number is $9000 to get this off of the ground. At $9000 patrons will actually be able to make use of fielded simple searches, and the new unambiguous query syntax. At $15000 we'll have a new and improved advanced search. At $18000, we'll be looking at faster searches, and after every single component thereafter, life will just get better. For more information on the nuts and bolts, please do check out the wiki at wiki.koha-community.org/wiki/C_%26_P_Search_Rewrite_RFC feel free to leave your feedback since we want this to work right for everyone. To track our funding progress, there's a thermometer up at C&P http://www.cpbibliography.com/services/koha/searchrewrite.html We look forward to fixing this together soon! Cheers, Brooke

1 0

zebra not rebuilding
by sheldon_tappin 21 Aug '12

21 Aug '12

Hi All, I'm getting a error whilst trying to update the zebra index. Therefore I cannot view any updates in my catalogue. ERROR: Can't locate C4/Context.pm in @INC (@INC contains: /etc/perl /usr/local/lib/perl/5.10.0 /usr/local/share/perl/5.10.0 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl .) at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 6. BEGIN failed--compilation aborted at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 6. Thank you in advance. Sheldon -- View this message in context: http://koha.1045719.n5.nabble.com/zebra-not-rebuilding-tp3382983p3382983.ht… Sent from the Koha - Discuss mailing list archive at Nabble.com.

9 19

kohaadmin password change
by Manos Petridis 19 Aug '12

19 Aug '12

One further question: I recently changed the kohaadmin password, using the koha admin interface (i.e. for patron #1). This change was necessary in order to be able to perform catalogue-ing off-site, connecting to port 8080 from any Internet-connected browser. I did not change the operating system user password, nor the MySQL user password. One would expect that patrons and their passwords were stored in the MySQL koha database itself, so koha functionality would remain as before. To my surprise, I can't connect to koha, even from the same LAN. From the server I get the following errors: Software error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /home/koha/kohaclone/C4/Context.pm line 758. Compilation failed in require at /home/koha/kohaclone/C4/Auth.pm line 31. BEGIN failed--compilation aborted at /home/koha/kohaclone/C4/Auth.pm line 31. Compilation failed in require at /home/koha/kohaclone/mainpage.pl line 25. BEGIN failed--compilation aborted at /home/koha/kohaclone/mainpage.pl line 25. For help, please send mail to the webmaster (webmaster@koha), giving this error message and the time and date of the error. when I try the admin interface, and Software error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /home/koha/kohaclone/C4/Context.pm line 758. Compilation failed in require at /home/koha/kohaclone/C4/Auth.pm line 31. BEGIN failed--compilation aborted at /home/koha/kohaclone/C4/Auth.pm line 31. Compilation failed in require at /home/koha/kohaclone/opac/opac-main.pl line 22. BEGIN failed--compilation aborted at /home/koha/kohaclone/opac/opac-main.pl line 22. For help, please send mail to the webmaster (webmaster@koha), giving this error message and the time and date of the error. when I try the OPAC interface. Have the errors above anything to do with the password change? I repeat, I haven't changed (yet) the operating system user password, nor the MySQL user password, or thet of the MySQL root. ΤΙΑ Manos Petridis

4 7

Re: [Koha] Importing Catalogue Records
by franc＠library.iisc.ernet.in 17 Aug '12

17 Aug '12

Dear Moderator, Could you please circulate the above message if it has not been done so already. The message (reply) was sent last Monday, but it bounced because of some technical issues with our email server. Thanks, Francis ---------- Forwarded message ---------- Date: Mon, 13 Aug 2012 14:01:35 +0530 (IST) From: franc(a)library.iisc.ernet.in To: Marc Véron <veron(a)veron.ch> Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Importing Catalogue Records On Mon, 13 Aug 2012, Marc Véron wrote: > Francis, > > Nicole Engard made a great video tutorial for this: > > http://bywatersolutions.com/2012/01/18/using-marcedit-to-add-koha-items/ > > Marc Marc, Thanks very much for the link. It surely is a great video! I was thinking in terms of using a Perl script to add the 952 sub-fields for each of the records that I need to import. That's not needed at all. It can be easily done using the MarcEdit tool. Thanks to Terry Reese for the MarcEdit tool and to Nocole for the video. - Francis > > > > Am 13.08.2012 07:22, schrieb clint.deckard: > > Francis, > > I think I can help here as I have just been going through this process. I > > am not a Koha expert and if I have made a mistake I invite anyone to > > correct me please. > > Item Type is stored at 952$y, current location is stored at 952$b, Home > > library is stored at 952$a and call number at 952$o > > These fields do not appear in your records. > > > > You could use a tool such as MarcEdit to add these fields with the > > appropriate data for your library. Call number is a bit more difficult if > > it is stored in a variety of sub fields in the original record. > > > > I hope this helps. > > Clint Deckard. > > > > franc(a)library.iisc.ernet.in wrote: > > > Dear Members, > > > > > > I'm trying to import a few sample records using the 'Stage MARC records > > > for import' feature of KOHA-3.08.03. A sample ,mrk record is given > > > below > > > for your reference: > > > > > > =LDR 00000nam 2200000Ia 45e0^M > > > =008 120810s9999\\\\xx\\\\\\\\\\\\000\0\und\d^M > > > =020 \\$a001^M > > > =082 \\$a541.39$bN37^M > > > =100 \\$aBailey, K.C.^M > > > =245 \\$aGalactose regulation of yeast: From genetics to systms^M > > > =260 \\$c1937$bEdward Arnold$aBANGALORE^M > > > =300 \\$a100P^M > > > =952 \\$p2^M > > > > > > After converting the .mrk file to .mrc file, records are successfully > > > imported. While staging the records for importing, I have ensured that > > > the > > > 'check for embedded item data record' is set to 'yes'. > > > > > > Indexing through Zebra goes through without any issues. However, in the > > > search results, the Holding Details for 'item type', 'current > > > location', > > > 'home library' and 'call number' are all blank. I have looked up the > > > Koha > > > documentation and also the Koha list's archived content, but not been > > > able > > > to find a solution for my problem. Could I request for some guidance > > > from > > > the fellow members? > > > > > > In the Administrative cataloging preferences, NewItemsDefaultLocation > > > is > > > set to JRDTML, the only library that exists as of now. > > > > > > Thanks for your attention. > > > > > > - Francis > > > > > > JRDTML, IISc, Bangalore, India > > > > > > > > > > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.

1 0