- Koha - lists.katipo.co.nz

Koha as a journal citation catalog
by Fred King 30 Sep '13

30 Sep '13

Greetings, all, A couple of months ago, I brought up the topic of using Koha as a catalog of journal articles. I've been working on this ever since, and I finally have our system up and running. Unfortunately, it's behind a firewall so I can't give you a link, but I can tell you about it and post screen shots if there's any interest. I work in a teaching hospital, and a lot of our residents and staff publish articles, most of which are indexed in Medline. For years, I've been collecting citations and putting them together on a web page. Several years ago, we started Authors Day, where we recognize the literary efforts of our associates. We also put together a bibliography that includes the Medline citations as well as conference abstracts, poster presentations, books (editor, chapter author, or full book)--basically anything we know about, and not limited to medical literature. Last year we started using Reference Manager to track citations. I wanted to see if I could use Koha to make the publications more accessible within the hospital. My conclusion: yes. It takes a lot of work to set up, and it takes more steps than I'd like to convert Medline records to (my modified version of) MARC, but the end product is a lot more versatile than the bare Medline citations with local authors' names highlighted, which is what we had. A lot of the constraints I faced are specific to our situation and type of library, so YMMV. In particular: Most of the citations are from Medline. Most articles have a lot of co-authors, not all of whom are local. The citations had to be formatted for Koha and Reference Manager. I wanted to make authors' names uniform; Medline citations don't have authority control. I wanted to include the authors' departments. We're using Koha 3.12, running Ubuntu. There are two main parts to setting this up: modifying Koha templates to display the information I wanted, and modifying citations to fit Koha. Modifying citations: I use Ovid to export the Medline citations in RIS format. PubMed and Ebsco will also export tagged citations--anything with field tags will do. RIS is a format used by Reference Manager, EndNote, Zotero, and a few others. The main (hard!) part was coming up with an appropriate MARC tag to match the field tag. Since I envision this being for institution-wide use only, I didn't worry too much about straying slightly from MARC standards. One of my colleagues is entering conference presentations, etc., into Reference Manager; as soon as I can get my head above water, we'll convert those tags to MARC, too. Modifying Koha: I modified the OPACXSLTDetailsDisplay and OPACXSLTResultsDisplay templates to show just the fields I wanted. I didn't need to display item/barcode information, so I took out the item display at the bottom. I put in the PMID (every article in Medline has a unique identifier; I used MARC 099), MeSH (MEdical Subject Heading, 650), department (I used 656), publication type (clinical trial, editorial, randomized controlled trial, etc., 657), abstract (520), and a few others. General Koha Setup: Right now, I have only one hospital's authors in the database, so that's the only branch. If this catches on, we can add others. For Item Types I used Journal Article, Book (Chapter Author), Book (Editor), Book (Author), Poster, and a few others. That's about all I had to do. Adding Citations: As I said, more steps than I'd like. Here's an outline. 1. Determine which citations are local authors. I've already written too much, so I'm going to leave this part out. Let's just assume I end up with a few citations to add, with all the fields I want to include in both Reference Manager and Koha. I've also added links to the full text of the articles, if available. 2. Standardize the authors' names and add their departments. Medline/RIS has two fields for the authors' names: standard AU (Lastname FirstIntitalSecondInitial) and full FA (Lastname, Firstname MiddleInitial). I've already taken out non-local authors from the FA list. I use Replace Text (free from www.ecobyte.com) to search for the name as it appears in the FA field and replace it with the name and department (on a separate line, with a separate tag). If Replace Text doesn't find a match, it puts NOT FOUND by the author's name. I search through the results for NOT FOUND and either add the author and department, or add the variation of the author's name. For example, Dr. William J Rubin of the Department of Hematology might be listed in the Medline FA field as Rubin, William J or Rubin, Wm James or Rubin, Billy and by editing the Replace Text file, all of those names will be converted to Rubin, William J Hematology complete with RIS field tags for name and department ready to upload. Adding new names and variations to the Replace Text file takes a while, but I think it will become faster as I catch all the missing authors and name variations. 3. Import the edited file into Reference Manager. We can use this database to print bibliographies by name, department, etc. It's not necessary if all you need is a catalog. 4. Convert RIS tags to MARC. Replace Text again. 5. Remove duplicate department tags. In step 2 above, I replaced each name with the author's name and department. However, a lot of authors are from the same department. Uploading a MARC record with three instances of Hematology will result in a catalog display with three instances of Hematology as well. I want each department mentioned only once, so I have to go through each citation and take out duplicates. There's probably an easier way to do this. 6. Compile the citations into a .mrc file with MarcEdit. 7. Upload into Koha. A few thoughts: The most important part is to think everything out beforehand. No, this wasn't meant to be surprising news. I thought out most things, but not everything. I discovered that modifing 360 records one-by-one takes a while. No, that's not meant to be surprising either. Was it worth the time and effort to develop? I think it was. We needed a database of local authors anyway, and the steps to convert from RIS to Koha don't add much more to the process. Setting up a separate instance of Koha, modifying it to display what I wanted, and developing the RIS to MARC tags took a lot of time, but once that's done, it's fairly simple. Why modify Koha instead of using some other system? I didn't want our users to have to learn another system. Neither did I. Koha is easy to use, and we're using it for our library catalog already. Will anyone use it? I hope so. :-) If anyone has made it this far and would like to hear more, I'll be glad to provide more information. Thoughts, improvements, etc., are all welcome. Fred King kohauser(a)phred.us

2 2

September 2013 Koha Community Newsletter has been published
by Daniel Grobani 30 Sep '13

30 Sep '13

Hi, The September 2013 edition of the Koha Community Newsletter has been posted to http://koha-community.org/koha-community-newsletter-september-2013/. Cheers, Daniel Grobani Koha Community Newsletter Editor

1 0

Error indexing Koha
by Araik Manukyan 30 Sep '13

30 Sep '13

Hi Friends ! Recently I have upgraded Koha version from 3.08.07 to 3.12.04 .It works but we can't find new catologized records. We removed old zebra index and tried indexing with ./rebuild_zebra.pl -b -a - z -v command. It brings such error and show only 226 records 1101........................................................................ ............................ Records exported: 1103 ==================== REINDEXING zebra ==================== 14:45:56-30/09 zebraidx(2582) [warn] Record didn't contain match fields in (bib1,Local-number) ==================== CLEANING How can we solve this problem ? Best regards, Araik

1 0

To build Koha Community in Vietnam
by Lan Vu Duy 28 Sep '13

28 Sep '13

Dear Koha community, First, I would like to send greetings to the Koha community warmest. I would like to introduce, my name is Vu Duy Lan, one of the founding members of the D & L Company in Vietnam http://dlcorp.com.vn/default.aspx. The D&L was founded in 2009, is an active member of the club in Vietnam Free & Open source software Association (VFOSSA http://vfossa.vn/en/) as well as the library associations in Vietnam. Scope of activities of D&L is to provide integrated solutions for libraries in Vietnam. Currently, our customers are the largest library in Vietnam. After a period of research and evaluation of open source software Koha. We realize this is software that Koha is LMS/ILS suitable for the majority of libraries in Vietnam. So, D & L would like to cooperate with community Koha in the World and VFOSSA to build Koha community in Vietnam. Aim to bring Koha to libraries in Vietnam. We would like to join the Koha community in the World, learn experience how to development Koha community in Vietnam. Please give us advice and cooperate with us to build Koha community in Vietnam. Currently, we are working with VFOSS and the library associations in Vietnam to introduce Koha libraries in Vietnam. Sincerely, Vu Duy Lan Sales Director, D&L Technology Integration and Consulting ., JSC

1 0

DBD driver not implementing AutoCommit attribute
by David Munaaba 28 Sep '13

28 Sep '13

Hello my Koha installation collapsed when i updated ubuntu /apache2. so i decided to uninstall the koha and reinstall the latest package. 3.12.04 everything went well but have failed to launch the web installer, i get the message: DBD driver has not implemented the AutoCommit attribute at /usr/lib/perl5/DBI.pm ... now i am stuck, what could be the solution Thanks in advance David Munaaba Librarian National Library of Uganda

2 1

opaclook and feel customization had not been restored same after upgradation from 3.8.4 to 3.10.04 version.
by Shiva Kumara 27 Sep '13

27 Sep '13

Hi All, ****Greeting for the day**** I have upgraded koha from 3.8.4 to 3.10.04 version. The database backup restored successfully.Opac search is working fine, but opaclook and feel customization had not been restored same, it seems to be a plain page. I could tried to customize opac by setting opac parameter in global system preference. Everything comes in plain main single page, there is no navigation bar for left and right. And also, opac search bar looks plain, there is no koha logo and masthed color. How would I make koha as default opac features (koha logo, masthed color in search bar, navigation for left and right, etc) Kindly suggest me useful tips, It would be greatly appriciated. Thanking you, With Regards Shivakumara RM ISEC, Bangalore

2 2

Overdue reminders not being generated after making the libraries independent
by S Anand 26 Sep '13

26 Sep '13

Dear all, We have more than one libraries attached to our Koha System, and to make all the libraries independent of one another, we enable the function * “Prevent*” staff from modifying objects (holds, items, patrons etc.) belonging to other libraries. The Libraries have now become independent, but, *the system has stopped generating overdue reminders*. (*Steps followed are*: Administration – Global system preferences – Administration – under login options –Independent branches – selected “Prevent” staff from from modifying objects (holds, items, patrons etc.) belonging to other libraries). *We are using Koha version: 3.08.03.000 * Can any one let me know as to why the system stopped generating overdue reminders after making the libraries independent? Is there any way to correct it so that the system generates overdue reminders - as was being done until making the libraries independent as above. I would very much appreciate your help in this regard and look forward to your reply. *Note: * Thanks and Regards S Aanand

1 0

Re: [Koha] cataloging books in other languages
by mh_zalabany 26 Sep '13

26 Sep '13

-------- Original message -------- From: mh_zalabany <mh_zalabany(a)hotmail.com> Date: 26/09/2013 3:46 PM (GMT+02:00) To: "Morsy, Amal" <amorsy(a)mei.edu>,koha list <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] cataloging books in other languages Sorry for writing you name wrong mrs. amal You can use the 880 field for writing the vernicular of any field you want in arabic and use the subfield 6 to link the to fields you can take a look on any arabic record in the library of congress to under stand what i mean After that we can add new search index In zebra with 880 field All best Mohamed zalabany EGPV For library systems and information technology Sent from Samsung tablet -------- Original message -------- From: "Morsy, Amal" <amorsy(a)mei.edu> Date: 26/09/2013 3:29 PM (GMT+02:00) To: koha(a)lists.katipo.co.nz Subject: [Koha] cataloging books in other languages Hallo, We have several books in Arabic and other languages that we like it to be displayed in its original language in the catalog. We want to enter the author name in English and display it in the other language as well and make it searchable My question is how we can display the title and other information in its original language and it will be searchable. Thank you in advance for your help Amal *Amal Morsy * *Library Director * 202-785-1141 ext. 222 <http://www.mei.edu/> Providing non-partisan, expert information and analysis on the Middle East. For additional information please visit www.mei.edu | 1761 N STREET NW, WASHINGTON, D.C. 20036-2882 <https://twitter.com/MiddleEastInst>@MiddleEastInst<https://twitter.com/MiddleEastInst> | <https://www.facebook.com/middleeastinstitute> Middle East Institute<https://www.facebook.com/middleeastinstitute> | <http://www.mei.edu/feeds/analysis> MEI Analysis & Opinion<http://www.mei.edu/feeds/analysis> ** _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Re: [Koha] cataloging books in other languages
by mh_zalabany 26 Sep '13

26 Sep '13

Hi iman You can use the 880 field for writing the vernicular of any field you want in arabic and use the subfield 6 to link the to fields you can take a look on any arabic record in the library of congress to under stand what i mean After that we can add new search index In zebra with 880 field All best Mohamed zalabany EGPV For library systems and information technology Sent from Samsung tablet -------- Original message -------- From: "Morsy, Amal" <amorsy(a)mei.edu> Date: 26/09/2013 3:29 PM (GMT+02:00) To: koha(a)lists.katipo.co.nz Subject: [Koha] cataloging books in other languages Hallo, We have several books in Arabic and other languages that we like it to be displayed in its original language in the catalog. We want to enter the author name in English and display it in the other language as well and make it searchable My question is how we can display the title and other information in its original language and it will be searchable. Thank you in advance for your help Amal *Amal Morsy * *Library Director * 202-785-1141 ext. 222 <http://www.mei.edu/> Providing non-partisan, expert information and analysis on the Middle East. For additional information please visit www.mei.edu | 1761 N STREET NW, WASHINGTON, D.C. 20036-2882 <https://twitter.com/MiddleEastInst>@MiddleEastInst<https://twitter.com/MiddleEastInst> | <https://www.facebook.com/middleeastinstitute> Middle East Institute<https://www.facebook.com/middleeastinstitute> | <http://www.mei.edu/feeds/analysis> MEI Analysis & Opinion<http://www.mei.edu/feeds/analysis> ** _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

cataloging books in other languages
by Morsy, Amal 26 Sep '13

26 Sep '13

Hallo, We have several books in Arabic and other languages that we like it to be displayed in its original language in the catalog. We want to enter the author name in English and display it in the other language as well and make it searchable My question is how we can display the title and other information in its original language and it will be searchable. Thank you in advance for your help Amal *Amal Morsy * *Library Director * 202-785-1141 ext. 222 <http://www.mei.edu/> Providing non-partisan, expert information and analysis on the Middle East. For additional information please visit www.mei.edu | 1761 N STREET NW, WASHINGTON, D.C. 20036-2882 <https://twitter.com/MiddleEastInst>@MiddleEastInst<https://twitter.com/MiddleEastInst> | <https://www.facebook.com/middleeastinstitute> Middle East Institute<https://www.facebook.com/middleeastinstitute> | <http://www.mei.edu/feeds/analysis> MEI Analysis & Opinion<http://www.mei.edu/feeds/analysis> **

1 0