- Koha - lists.katipo.co.nz

Improving Search Results
by Coehoorn, Joel 26 Sep '14

26 Sep '14

I support a relatively new Koha installation, and the search quality we've experienced has been exceptionally poor. What can I do to improve search quality? Here's an example I received today from a librarian: --------------------------------------- On 4/21/14 I cataloged *The Word of Promise from Jesus: Dramatic Passages from the Gospels*. Jim Caviezel was listed as an author since he wrote the foreword. It was given two barcodes since the book also contained a CD. The barcodes are 212580 for the book and 212581 for the CD. L____ had a request from Interlibrary loan for this title. We searched KOHA every way we could think to pull this title up and continued to get a message that "nothing was found". I went to World Cat and found the title with the indication that it was available at York College. In desperation, I checked the basic LC call number and found BT 306. I had L_____ go search the BT 306 section of the shelves and he found the book! Then after finding the book and having the barcode number, I tried to pull the book up by searching for the barcode number. Again, "nothing found". As a last resort, I went into the Reports area of KOHA and searched for the barcode number. Guess what! The Reports area found it. I clicked on the Biblio number and up came the record. Now the record was in there! Why wouldn't it come up when we searched for it? Another example. Dr. E____ asked me to order the 2014 Award winning books. I found the list and checked KOHA for each title to confirm that we didn't have a copy in the library. A couple of the books seemed familiar, but all I got was "not found". I prepared the requisition and ordered the titles. Well, the books came in last Friday. Tuesday I cataloged them. When I downloaded the cataloging from OCLC into KOHA, two of the titles didn't go in because they were duplicates!! I went back and tried to pull them up in KOHA and guess what! They came up. So this caused us to have 2 copies of these two titles. Fortunately it didn't cost more than $20 to get these titles, but KOHA needs to be working correctly so this doesn't happen again. --------------------------------------------------------------------- The point of this is that, from our librarians perspective, without a better search experience, Koha is "broken". Those are their words, not mine. Here's the thing: when I run a search in Koha, I do get back lots of results from our catalog that are highly relevant to the search terms. But these are exact title matches, and they come back with "Not found". How can I improve this? Joel Coehoorn Director of Information Technology York College, Nebraska 402.363.5603 *jcoehoorn(a)york.edu <jcoehoorn(a)york.edu>* The mission of York College is to transform lives through Christ-centered education and to equip students for lifelong service to God, family, and society

3 2

koha reports
by Monisa Aslam 26 Sep '14

26 Sep '14

datewise list of checkin booksdatewise list of checkout books can anybody help?????? Monisa Aslam

2 1

sql report for bibliographic records with more than one subject
by schnydszch 26 Sep '14

26 Sep '14

Hi all! Im trying to make a report that will have in one column all subjects of the bibliographic record separated by a 'semicolon', so it can be saved as csv file. I'm trying the following: SELECT ExtractValue(marcxml,'//datafield[@tag="245"]/subfield[@code="a"]') AS TITLE, ExtractValue(marcxml,'//datafield[@tag="245"]/subfield[@code="b"]') AS TITLE2, ExtractValue(marcxml,'//datafield[@tag="246"]/subfield[@code="a"]') AS TITLE3,ExtractValue(marcxml,'//datafield[@tag="245"]/subfield[@code="c"]') AS AUTHOR, ExtractValue(marcxml,'//datafield[@tag="581"]/subfield[@code="a"]') AS Source, ExtractValue(marcxml,'//datafield[@tag="590"]/subfield[@code="a"]') AS Date_Approved, ExtractValue(marcxml,'//datafield[@tag="653"]/subfield[@code="a"]') AS Subjects FROM biblioitems LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE biblioitems.itemtype='LAWS' ORDER BY biblio.title asc However, with this query it puts in one column all subjects separated by space. I'm trying out group_concat with separator, but still to no avail. Anybody in the group who had the same query? Thanks in advance and cheers! -- View this message in context: http://koha.1045719.n5.nabble.com/sql-report-for-bibliographic-records-with… Sent from the Koha-general mailing list archive at Nabble.com.

1 1

Re: [Koha] delete bibs
by Arslan Farooq 26 Sep '14

26 Sep '14

Hi, I just Googled and found this: http://lists.katipo.co.nz/public/koha/2012-March/032175.html It may help. Regards, Arslan On Fri, Sep 26, 2014 at 10:25 AM, Monisa Aslam <monisaaslam(a)hotmail.com> wrote: > i want to delete all bibs without item...................... is there any > way > > Monisa Aslam > > -- Electronic Resource Librarian SZABIST Islamabad www.szabist-isb.edu.pk arslan.farooq(a)szabist-isb.edu.pk +92 514 863 363-65

1 0

csv-marc
by Ramprasad S. Joshi 26 Sep '14

26 Sep '14

@Olawale ILESANMI: CSV to MARC should be easy. Can you post sample data records (100, say) please? Ramprasad Joshi CS-IS Dept BITS, Pilani - K K Birla Goa Campus Zuarinagar, GOA INDIA 403726 Phone +91 832 2580 121 Fax +91 832 2557033

2 1

Download a MARC file of a Saved Report
by Alyssa Enganio Gono 26 Sep '14

26 Sep '14

I have a saved report that shows the list of Books with no Barcodes. I want to download only a MARC file of those bibliographic record of the books with no barcodes.How will I do it? The only option I can download the report is in a form of csv file.e.g. comma separated text; tab separated text and open document spreadsheet. -- View this message in context: http://koha.1045719.n5.nabble.com/Download-a-MARC-file-of-a-Saved-Report-tp… Sent from the Koha-general mailing list archive at Nabble.com.

2 1

Bulk export patrons / borrowers images for batch processing
by Pablo Bianchi 25 Sep '14

25 Sep '14

Hi all, I'm trying to download / export all patrons images into a set of files (something like nnn.png/jpg, where nnn is cardnumber) so I could work with them (ie Imagemagick mogrify) and then import them again <http://manual.koha-community.org/3.16/en/tools.html#uploadpatronimages> into other Koha instance. I'm able to do this one by one with *wget patronimage.pl?borrowernumber= <http://patronimage.pl?borrowernumber=>nnn* or all of them with *SELECT imagefile FROM patronimage INTO OUTFILE '/tmp/PatronsImages.out'* (FIELDS/LINES TERMINATED BY...) but of course all in one file, without considering mimetype column and is not easy for me to use split command in this case. Before trying to write a script to walk *foreach* patrons I invoke list wisdom, might be an easier way... Regards, Pablo

1 1

Export Athena / import Koha
by jrbk 25 Sep '14

25 Sep '14

FYI: I am a total novice at Koha. I had an acquaintance set up a Ubuntu server with Koha on it. The server is running just fine and can only be accessed in-house. We are using it for a small library at a private school. It is replacing the outdated Athena. I created a superuser and have logged in and am starting to set things up... I followed the directions on this wiki in order to export the MARC records from Athena in order to import it into Koha. http://library.bridgton.lib.me.us/BPL_mediawiki/index.php/Exporting_Athena_… I was able to accomplish all of the steps without any errors or issues... I then went into "Manage staged MARC records" from the Tools menu and imported the MARC records into the catalog. I am able to search for each item by title or author, etc. The problem that I am having is that it didn't seem to transfer the Barcode information. All of our books are already labeled so it is advantageous for us to keep the old Barcode system since there are roughly 9000 items. Any help would be much appreciated. Thank you. -- View this message in context: http://koha.1045719.n5.nabble.com/Export-Athena-import-Koha-tp5812752.html Sent from the Koha-general mailing list archive at Nabble.com.

6 7

csv - marc
by Olawale Ilesanmi 25 Sep '14

25 Sep '14

Hello Everyone, Any one in the house who can help with data conversion. I have tried several documentation on data conversion but no luck yet. The biblio is in csv format and we are about migrating to Koha. Thanks -- Olawale ILESANMI Web/System Adminstrator Websites and Online Services Department Tel: (+234)-807-130-5163 [1] Zaccheus Onumba Dibiaezue Memorial Libraries 196 Awolowo Road | Ikoyi | Lagos State| Nigeria Community Library :(+234)-1-463-1787 | Corporate Office:(+234)-1-454-1941 www.zodml.org [1] | info(a)zodml.org Follow Us: [2] [3] [4] [5] [1] CONFIDENTIALITY NOTE: This email may contain confidential and/or private information. If you received this email in error please delete and notify sender. Links: ------ [1] http://www.zodml.org/ [2] http://www.twitter.com/ZODML [3] http://www.facebook.com/ZODML [4] http://pinterest.com/zodml/ [5] http://www.linkedin.com/company/3189484

3 2

borrowers' number
by Olawale Ilesanmi 25 Sep '14

25 Sep '14

Hi Everyone, Please, I need help on how to manually assign borrowers' number. We already have borrowers number assigned to our patrons from CD/ISIS but I noticed koha generates borrowers number by default. I need help on how to resolve the issue. Thanks Olawale ILESANMI Web/System Adminstrator Websites and Online Services Department Tel: (+234)-807-130-5163 [1] Zaccheus Onumba Dibiaezue Memorial Libraries 196 Awolowo Road | Ikoyi | Lagos State| Nigeria Community Library :(+234)-1-463-1787 | Corporate Office:(+234)-1-454-1941 www.zodml.org [1] | info(a)zodml.org Follow Us: [2] [3] [4] [5] [1] CONFIDENTIALITY NOTE: This email may contain confidential and/or private information. If you received this email in error please delete and notify sender. Links: ------ [1] http://www.zodml.org/ [2] http://www.twitter.com/ZODML [3] http://www.facebook.com/ZODML [4] http://pinterest.com/zodml/ [5] http://www.linkedin.com/company/3189484

3 2