- Koha - lists.katipo.co.nz

Collection HQ and Koha
by Keener, Nancy 04 Sep '14

04 Sep '14

Is anyone currently using Collection HQ with Koha to provide collection management information? If so, would you mind contacting me off-list to have a conversation about how it is working for you? Nancy Keener Systems Librarian I.T.O.S.C. Chair Washoe County Library System Reno, Nevada 775 327-8347 nkeener(a)washoecounty.us

1 0

Stemming and zebra
by Francois Charbonnier 04 Sep '14

04 Sep '14

Hello, I have tested the QueryStemming system preference on Koha 3.14 (my local installation) and I'm wondering, does zebra just right truncate the words or is there an algorithm to find the stems? I use ICU and I have enabled "QueryWeightFields". I don't have automatic truncation or fuzzy search on. I use these words for my tests: * ski, skiing, skills * fish, fished, fishing, fisher, fishxsdfe Each time, with QueryStemming on, skills and fishxsdfe come out in the search results. Is it what I should expect? "Skills", maybe but "fishxsdfe"? Do you know how it works? or have a good example that would help me to understand? Thanks! -- François Charbonnier, Bibl. prof. / Chef de produits Tél. : (888) 604-2627 francois.charbonnier(a)inLibro.com <mailto:francois.charbonnier@inLibro.com> inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>

2 1

Koha layout in Arabic...
by Layale Bassil 04 Sep '14

04 Sep '14

Hello all, I know that Koha supports Arabic language in terms of searching, but I would like to know if there is a Koha layout in Arabic? Does anyone know how to develop such a layout? Or if there is any developed Arabic layout that I can get help from? Thanks in advance, Regards.

3 2

Koha Community Newsletter: August 2014
by Koha News 03 Sep '14

03 Sep '14

Fellow Koha users: The Koha Community Newsletter for August 2014 is here: http://koha-community.org/koha-community-newsletter-august-2014/ Many thanks to all the folks who submitted articles and news to this month's newsletter. Please feel free to email us with any corrections or suggestions. Thanks! Chad Roseburg Joanne Dillon Editors, Koha Community Newsletter

1 0

Re: [Koha] Report help needed - modification date
by Elaine Bradtke 03 Sep '14

03 Sep '14

Thanks, that helps! Elaine On Wed, Sep 3, 2014 at 12:08 PM, Nick Clemens <nick(a)quecheelibrary.org> wrote: > To get the '005' data, I think you have to pull from the marcxml in > biblioitems: > > ExtractValue(marcxml,'//controlfield[@tag="005"]') > > I don't think it is accessible through any of the table directly > > > On Tue, Sep 2, 2014 at 6:39 PM, Elaine Bradtke <eb(a)efdss.org> wrote: > >> How do I filter records based on the MARC 005? DATE AND TIME OF LATEST >> TRANSACTION >> biblio.timestamp doesn't do it. >> >> This is what I have: >> SELECT >> >> biblio.biblionumber,items.barcode,biblio.author,biblio.title,biblio.timestamp,biblio.datecreated >> FROM items LEFT JOIN biblioitems on >> (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on >> (biblioitems.biblionumber=biblio.biblionumber) WHERE biblio.timestamp >= >> '2014-05-01' AND biblio.timestamp <= '2014-05-30' ORDER BY >> biblio.biblionumber asc >> >> In the guided report the option I chose was Modification date / >> biblio.timestamp >> >> But after testing this I've discovered that it isn't using the date in >> the >> 005. I'm not sure where the Modification date / biblio.timestamp >> information is coming from, it's neither the creation date, nor the >> modification date, but some other date entirely. >> >> I'm trying to hunt down a batch of records modified on a certain date. >> Thanks for any help. >> >> -- >> Elaine Bradtke >> Data Wrangler >> VWML >> English Folk Dance and Song Society | http://www.efdss.org >> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY >> Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance >> and >> Song Society in London, England. If you wish to phone me personally, send >> an e-mail first. I work off site) >> -------------------------------------------------------------------------- >> Registered Company No. 297142 >> Charity Registered in England and Wales No. 305999 >> >> --------------------------------------------------------------------------- >> "Writing about music is like dancing about architecture" >> --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> http://lists.katipo.co.nz/mailman/listinfo/koha >> > > > > -- > Nick Clemens > Quechee & Wilder Libraries > Nick(a)quecheelibrary.org > http://www.QuecheeLibrary.org > Q (802) 295-1232 W (802) 295-6341 > -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)

1 0

OpacNav
by Mildred Amita Odongo 03 Sep '14

03 Sep '14

Good morning On my OPAC page the contents of OPACNav jumped down to the bottom of the screen after being in the right position for a long time (More than 2 years). I have tried to apply using style="width:400px" to reduce the width of the list in the OPACNav since I had thought that it may have been too wide to fit on the right side of the OPAC. There is an active OpacMainUserBlock at the centre which I tried reducing its width but there was not change experienced. I need the content of the OPACNav back in their right position. Could anyone help? Kind Regards Mildred Two forces are succesfully influencing the education of a cultivated man: art and science. Both are united in the book. ________________________________ [http://www.kenyapower.co.ke/logo/Logo.jpg] Note: All emails sent from Kenya Power are subject to the company's Email Terms & Conditions. Please click here<http://kplc.co.ke/content/item/65> to read the policy. Kenya Power Contact Center Number: 95551 OR 0703070707, 0732170170, 020-3201680 Twitter - @Kenyapower OR Facebook - Kenya Power. Email: customercare(a)kplc.co.ke ________________________________

3 4

SQL Report help please
by library 03 Sep '14

03 Sep '14

Ata marie Could someone help please. I am trying to produce reading statistics based on patron additional attributes (classes, year levels, ethnicities). Could anyone give me pointers to how to reference borrower attributes and which field holds the issues statistics. Thanks naku noa Ann Murphy Librarian Katikati College Beach Road, Katikati, 3129 New Zealand 0064 7 5492647 amurphy(a)katikaticollege.school.nz

2 1

Update interval of Koha development (squeeze-dev) release
by Vimal Kumar V. 03 Sep '14

03 Sep '14

Dear Developers, May I know the update interval of Koha development release (Debian package). When last release date of current development version of Koha debian package? When is the next release? Regards, -- Vimal Kumar V. Technical Assistant Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.info Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in http://moovandan.blogspot.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

4 3

Report help needed - modification date
by Elaine Bradtke 02 Sep '14

02 Sep '14

How do I filter records based on the MARC 005? DATE AND TIME OF LATEST TRANSACTION biblio.timestamp doesn't do it. This is what I have: SELECT biblio.biblionumber,items.barcode,biblio.author,biblio.title,biblio.timestamp,biblio.datecreated FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE biblio.timestamp >= '2014-05-01' AND biblio.timestamp <= '2014-05-30' ORDER BY biblio.biblionumber asc In the guided report the option I chose was Modification date / biblio.timestamp But after testing this I've discovered that it isn't using the date in the 005. I'm not sure where the Modification date / biblio.timestamp information is coming from, it's neither the creation date, nor the modification date, but some other date entirely. I'm trying to hunt down a batch of records modified on a certain date. Thanks for any help. -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)

1 0

koha (please help)
by Monisa Aslam 02 Sep '14

02 Sep '14

problem is that while adding items to koha there are multiple fields 952$a 952$c 952$p and 952$y. now when i import into koha it is making 4 items instead of 1. what to do please help, where i am going wrong. Internet connection timed out! Please try again.Tip: Didn't want this definition pop-up? Try setting a trigger key in Extension Options.

3 2