- Koha - lists.katipo.co.nz

Backing up Koha using AutoMySQLBackup
by ed c 09 Mar '10

09 Mar '10

I am curious if anyone is using AutoMySQLBackup [1] as part of their Koha backup scheme. I saw the script mentioned on a list for a different LAMP project and it looks interesting (and is highly rated). Has anyone else tried this or some other script? Edward [1] http://sourceforge.net/projects/automysqlbackup/

3 2

Changing the OPAC details screen
by Otis, Perry W Civ USAF AETC AUL/LTIA 09 Mar '10

09 Mar '10

Hi, I'm setting up a Koha 3.0 system and I would like to make some changes to what displays on the details screen. First, I would like to remove the 'Search for this title in:' section. I tried editing the opac-details.tmpl template, but that didn't work. What do I need to do to remove this section? Also, I would like to have the MARC 099 field display on the details screen. How would I do that? Thanks. //SIGNED// PERRY OTIS Systems Librarian Muir S. Fairchild Research Information Center DSN 493-6498 Comm 334-953-8081

3 5

Koha 3 Check-out process?
by David M. Bucknell 09 Mar '10

09 Mar '10

Dear Koha Community Members, Is there any connection between the user's cart or list and circulation? That is, should we see a user/patron's requested books when we go to their account and begin to check out items to him or her? I am worried that our installation (koha 3.00.06.008). The manual http://koha.org/documentation/manual/3.0/administration/global-system-prefe… says that "WebBasedSelfCheck" is not yet in the code .... Does that mean that there is no connection between what the user does and what the librarian sees? No communication? I would be very grateful for a pointer to a descriptio from the user/patron's viewpoint of how check-out should work. Suggestions appreciated. David ---- **From the above doc: WebBasedSelfCheck Defines if you wish to enable Koha's web-based Self Checkout Module. Default Value: OFF IMPORTANT: This system preference has not been inserted into the code yet. Eventually it will enable/disable the web-based self-checkout system. IMPORTANT: Available in English only. TIP: To access this module now, visit http://YOURURL/cgi-bin/koha/sco/sco-main.pl My server's specs: Apache Server version: Apache/2.2.9 (Debian) Server built: Nov 14 2009 20:23:49 Koha 3.00.06.008 Koha DB 3.0006008 MySQL mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2 OS Linux li142-70 2.6.18.8 ... i686 Perl 5.010000 -- *http://iteachnet.org *http://flossed.org *http://ischoolnet.org *Web Ideas, Tools and Sites for Teachers, Schools, and You. *Cell: +66(0*)84 329 1183; Office: +66(0*)2 980 9464 (*No "0" if calling from overseas.) ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.

3 3

Recreating entry 952 in marcxml using "sync_items_in_marc_bib.pl"
by Toni Rosa 09 Mar '10

09 Mar '10

Hello, We are using Koha 3.0.5 to migrate data from another privative ILS. We have managed to import the biblios (using the bulkmarcimport.pl script) and we have been able to Insert the items data directly into the items table. The problem is that the marc definition (the marcxml field in biblioitems) doesn't contain the 952 and thus some parts of koha that expect the items information being there don't work properly. Is there a way to recreate the marcxml field or at least the part of the items? I have seen that there's a script called "sync_items_in_marc_bib.pl" and although I wasn't sure that it could do what we need, after launching it I get this error: # perl -I /usr/share/koha/lib/ ./maintenance/sync_items_in_marc_bib.pl --run-update problem with :14 : :26: parser error : Premature end of data in tag subfield line 26 <subfield code="c">23 cm., r ^ :26: parser error : Premature end of data in tag datafield line 23 <subfield code="c">23 cm., r ^ :26: parser error : Premature end of data in tag record line 2 <subfield code="c">23 cm., r ^ at /usr/lib/perl5/XML/LibXML/SAX/Parser.pm line 31 (...and many more errors about the "bib record being corrupt."...) So summarizing, my two questions are: 1. Again, Is there a way to recreate the marcxml field or at least the part of the items? 2. If the solution is using this "sync_items_in_marc_bib.pl" script, how can I make it work? Thanks, Regards P.S: I already posted this message to the [koha-devel] list. I am sorry about crossposting it, but after sending it I realized that it would make more sense sending such a message somewhere else but to the devel list.

1 0

Springer ebook records
by Stacy Pober 09 Mar '10

09 Mar '10

I loaded about 17,000 Springer ebooks into our catalog. I did not directly upload them into Koha, though. First, I edited them in the free MarcEdit program to add some fields. We use EZproxy to allow our users to access IP-restricted resources from off-campus. If you use something similar, you would use the Edit Subfield Data function to alter the 856$u data. You would replace "http: with something like "http:ezproxy.yourlibrary.edu:2048/login?url=http:" Additionally, the Springer ebook MARC records do not come with any custom link text. We added custom link text by adding an 856$y field. with the text "Available for our library via Springer eBooks. Click here for access". The custom link text is often provided in an 856$w field rather than the $y field, and the $w and $y but they seem to display exactly the same in our catalog, so if you get other vendor-supplied records with 845$w fields, you don't need to change them unless you want to customize the link text. We also add a 952 field to specify the branchcode, ITYPE, shelving location and CCODE: \\$aMAN$bMAN$cEBOOKS$oELECTRONIC BOOKS$yEBOOKS$8EBOOKS The branch code needed to be added because without it, each ebook appeared in Koha with messages about availability that we did not want to see. Adding the ITYPE allowed us to add a "View this eBook" link to each summary record which is a nice convenience for end-users. We also add a 500$a field which lists the ebook service name (Springer eBooks) because that's the standard way we've been listing all other ebook packages (not all of the vendors have the package name anywhere in the record) and a 099$a field for Local Call Number of ELECTRONIC BOOKS because that's the way our other ebooks have always been listed. You may not need or want this level of customization, but it's nice to know it's available. When I first tried to upload the Springer records, I could not upload them in one step. Our catalog is hosted by LibLime and at the time I processed these records (a couple of months ago), the server response time was very slow and it would time out for large uploads. This was the only batch of MARC records I had that was quite so large, and I had to split the 17,000 records into batches of about 1500 records. I don't know if there is any effective limit on file size for uploads in the official version of Koha. The processing of the initial file of the large Springer ebook record set was tedious but routine. However, Springer issues updated record sets for books they add to your subscription each month, and I am currently trying to work through some problems in the December update file. The monthly updates come in separate files for each publication year. We get five years of books, and rather than having to process them separately, I used MarcJoin in MarcEdit to concatenate them into one large file. This did not work, because it turned out there were some invalid characters in two of the records that caused errors in the joined file. I'm still working through that. The individual files validate correctly using the validator in MarcEdit, so I need to find a 'pickier' MARC validator to find the invalid characters. One more thing about ebook MARC records generally: I find that the quality of publisher-supplied MARC records is very variable. One problem we ran into with the MARC record sets for netLibrary and a couple of other vendors is that some of the records included multiple $856$u fields with URL's leading to other subscription-based online services to which we have no access. I had to find those bad URLs and strip them out of our records, and that was a little tedious. -- Stacy Pober Information Alchemist Riverdale, NY 10471 stacy.pober(a)manhattan.edu

2 1

Re: [Koha] Inquiry: Batch download e-books from Springer Databaseto KOHA with Marc-Records
by Susan Mustafa 09 Mar '10

09 Mar '10

That is exactly what I was looking for. Thank you all :D On Sun, Mar 7, 2010 at 9:06 PM, Indranil Das Gupta <indradg(a)gmail.com>wrote: > Susan, > > 2010/3/7 Susan Mustafa <susan.mustafa(a)gmail.com>: > > Hi, > > > > Does this mean I have to request a MARC records file from Springer > > themselves?? Is this normal to ask for? Would they know what I am talking > > about? > > Was away from comp, so couldn't answer you sooner. Springer freely > provides MARC records for all their e-books. Perhaps what you need to > get started would be this : > > > http://www.springer.com/librarians/e-content/springer+marc+records?SGWID=0-… > > hope that helps :) > > -- > Indranil Das Gupta > > Phone : +91-98300-20971 > Blog : http://indradg.randomink.org/blog > IRC : indradg on irc://irc.freenode.net > Twitter : indradg > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- > Please exchange editable Office documents only in ODF Format. No other > format is acceptable. Support Open Standards. > > To get a free editor supporting ODF, please visit > http://www.openoffice.org/ >

2 2

How to make smaller version of Koha?
by Vimal Kumar 08 Mar '10

08 Mar '10

I submitted a query to find a solution to reduce the size of Koha package. I didn't received a proper solution. I succeeded in find a solution at last. Here is the solution. Template files of various languages make Koha big size. Template files of intranet and OPAC resides in "koha-tmpl" folder. We can reduce the size of Koha package by deleting unwanted lanuage files. Follow the steps here, 1. Extract the koha package. 2. Enter into koha-3.00.05/koha-tmpl/intranet-tmpl/prog 3. Delete all folders except "en" and "img" 4. Enter into koha-3.00.05/koha-tmpl/opac-tmpl/prog 5. Delete all folders except en, famfamfam, images, itemtypeimg. Here "en" is the language folder name for English. If your language is different, you can retain your language instead of English. It will reduce the koha package to 20 MB. Then you can start the installation using the small size koha. It take less time for Koha installation. Smaller size Koha is useful for save your time in training programmes and installation for others. -- Vimal Kumar V. Asst. Librarian Asian School of Business Technopark, Trivandrum-695 581 Web: www.vimalkumar.co.nr Blog: http://vimalkumar.oksociety.in OK Society Volunteer. http://oksociety.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

3 2

Call for Koha Newsletter Articles
by Nicole Engard 08 Mar '10

08 Mar '10

It's that time again! The newsletter will be released on the 15th of this month and that means I need some submissions from users and developers alike! Articles can be as short as 2 sentences - so send along any news/tips/guides/ideas you want to share with the community. Thanks Nicole C. Engard

1 1

Advanced Search Question
by Nicole Engard 08 Mar '10

08 Mar '10

In the Advanced Search tab in the staff client, what does “scan indexes” mean? Thanks Nicole

2 2

Serials Question
by Nicole Engard 08 Mar '10

08 Mar '10

On the advanced patters, what is inner counter? I seemed to have documented all but this in the 3.0 manual ... Thanks Nicole

3 3