- Koha - lists.katipo.co.nz

Koha error upgrade -Can't call method "raw" on an undefined value at /usr/share/koha/lib/C4/Search.pm
by Admire Mutsikiwa 12 Feb '15

12 Feb '15

I have upgrade my Koha instance from any earlier version through a series of version. Now if I try to search for books on OPAC or staff catalog, I am getting the following message * You did not specify any search criteria <http://10.12.1.24/cgi-bin/koha/opac-search.pl?idx=ti&q=warfare> No results found! You did not specify any search criteria. Error: Can't call method "raw" on an undefined value at /usr/share/koha/lib/C4/Search.pm line 800. An help on this one. I have re-indexed the browse Kind Regards, Admire Mutsikiwa (Mr) ICT Manager Libraries University of Zimbabwe Tel:+263-4-303276 Mob:+263782476883 "It is easy to dodge our responsibilities, but we cannot dodge the consequences of dodging our responsibilities." Josiah Charles Stamp <http://www.goodreads.com/author/show/4867406.Josiah_Charles_Stamp>

1 0

Huge grant from Ebsco Publishing
by Stefano Bargioni 12 Feb '15

12 Feb '15

Hi, folks, Koha Gruppo Italiano https://www.facebook.com/KohaGruppoItaliano has received a major award by EBSCO Publishing to integrate the ElasticSearch tool into Koha. The press release link is http://www.librarytechnology.org/ltg-displaytext.pl?RC=20347 Last year, the Koha Gruppo Italiano launched the idea of substituting Zebra with Solr or ElasticSearch at the Hackfest in Marseille. We discussed about the best way to replace Zebra, and if and how to fund this enhancement through companies interested in a diffusion of open source software in libraries. During the upcoming Hackest in Marseille there will be a presentation of this grant. Further we hope to obtain an additional grant for a new project. We will also discuss how to manage the development and payment of the implementation of ElasticSearch in Koha. Koha Gruppo Italiano was founded in 2012 by Franziska Wallner (www.aur.edu) Stefano Bargioni and Juan Diego Ramírez (www.pusc.it/bib) and Sebastian Hierl (aarome.org) Best regards. Stefano

1 0

Indexing with dom - uses the DOM XML filter; offers improved
by Admire Mutsikiwa 12 Feb '15

12 Feb '15

I am upgrading my koha instance and I am being given the options grs1 - uses the Zebra GRS-1 filter, available for legacy support dom - uses the DOM XML filter; offers improved functionality. Bibliographic indexing mode (dom, grs1) [dom] Can someone point to me how indexing is done with the dom method, before I leave my familiar zebra method. Kind Regards, Admire Mutsikiwa (Mr) ICT Manager Libraries University of Zimbabwe Tel:+263-4-303276 Mob:+263782476883 "It is easy to dodge our responsibilities, but we cannot dodge the consequences of dodging our responsibilities." Josiah Charles Stamp <http://www.goodreads.com/author/show/4867406.Josiah_Charles_Stamp>

2 1

Re: [Koha] Koha Digest, Vol 112, Issue 22
by Digeswar Mahananda 12 Feb '15

12 Feb '15

Dear sir, Please help me to update the Koha software. *with regards* *Digeswar Mahananda* *Library Assistant* National Institute of Fashion Technology, Bhubaneswar राष्ट्रीय फैशन टैक्नालाँजी संस्थान, भुवनेश्वर (Ministry of Textiles, Govt. of India) (वस्त्र मन्त्रालय, भारत सरकार) A College of Design, Management and Technology डिज़ाईन, मैनेजमेंट और टैक्नालाँजी का महाविद्यालय *NIFT Campus, Plot No-24,* *Opp. KIIT School of Management,* *Chandaka Industrial Estate,* *Bhubaneswar-751024, Odisha* *Fax-0674-2305710* *Tel-0674-2305713, 2305700* *Mobile no.09778685517* *email id : digeswar.mahananda(a)nift.ac.in <digeswar.mahananda(a)nift.ac.in>* * mdigesh555(a)gmail.com <mdigesh555(a)gmail.com>* * digeswarmahananda(a)gmail.com <digeswarmahananda(a)gmail.com>* On Wed, Feb 11, 2015 at 9:37 PM, <koha-request(a)lists.katipo.co.nz> wrote: > Send Koha mailing list submissions to > koha(a)lists.katipo.co.nz > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.katipo.co.nz/mailman/listinfo/koha > or, via email, send a message with subject or body 'help' to > koha-request(a)lists.katipo.co.nz > > You can reach the person managing the list at > koha-owner(a)lists.katipo.co.nz > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Koha digest..." > > > Today's Topics: > > 1. Re: Search shows nothing (Robin Sheat) > 2. Re: Mixed Materials showing up as (Ian Bays) > 3. Request to add our company name in list of Koha Paid Support > (Pankaj) > 4. Github mirror question (Nicole Engard) > 5. Re: Github mirror question (Galen Charlton) > 6. Koha 3.18 adding T-Prefix to all scanned barcodes (bowmanrt) > 7. Re: Koha 3.18 adding T-Prefix to all scanned barcodes > (ramirouvia .) > 8. Re: Koha 3.18 adding T-Prefix to all scanned barcodes (bowmanrt) > 9. Koha on Ubuntu (Ahmad Amanullah Khan) > 10. Re: Koha on Ubuntu (vikram zadgaonkar) > 11. Re: Koha on Ubuntu (Tomas Cohen Arazi) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 11 Feb 2015 12:12:48 +1300 > From: Robin Sheat <robin(a)catalyst.net.nz> > To: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Search shows nothing > Message-ID: <1423609968.6249.47.camel(a)catalyst.net.nz> > Content-Type: text/plain; charset="UTF-8" > > Jack Morash schreef op di 10-02-2015 om 00:51 [-0800]: > > d. Zebra Service running? If the Zebra service is part of the > > koha-common service, then yes. If not no. > > What does 'ps ax|grep zebra' return? > > -- > Robin Sheat > Catalyst IT Ltd. > ? +64 4 803 2204 > GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF > > > > ------------------------------ > > Message: 2 > Date: Tue, 10 Feb 2015 23:12:49 +0000 > From: Ian Bays <ian.bays(a)ptfs-europe.com> > To: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Mixed Materials showing up as > Message-ID: <54DA9071.4060904(a)ptfs-europe.com> > Content-Type: text/plain; charset=windows-1252; format=flowed > > Hi. > If you mean the icon and text say Books then this is driven by the MARC > leader positions 6 and 7 rather than the contents of the 008. > I hope this helps. > Ian > > On 10/02/2015 21:06, Barton Chittenden wrote: > > Heidi, > > > > Which version of Koha are you using? > > > > There was a bug > > > > http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9093 > > > > The fix is included in 3.16.01 > > > > Thanks, > > > > --Barton > > > > On Fri, Feb 6, 2015 at 10:57 AM, Heidi Addy <generalslibrary(a)ibethel.org > > > > wrote: > > > >> I am creating a number of records that are mixed materials. > >> I select this "type of material" in the 008 > >> field, but often these items are still showing up as 'books' > >> in the OPAC. Any suggestions? Thanks, > >> Heidi > >> > >> _______________________________________________ > >> 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 > > > -- > Ian Bays > Director of Projects, PTFS Europe Limited > Content Management and Library Solutions > +44 (0) 800 756 6803 (phone) > +44 (0) 7774 995297 (mobile) > +44 (0) 800 756 6384 (fax) > skype: ian.bays > email: ian.bays(a)ptfs-europe.com > > > > ------------------------------ > > Message: 3 > Date: Wed, 11 Feb 2015 17:08:42 +0530 > From: Pankaj <pdelnet(a)gmail.com> > To: koha(a)lists.katipo.co.nz > Subject: [Koha] Request to add our company name in list of Koha Paid > Support > Message-ID: > < > CALYPb4DC0K2LgSJ_5FMPkbYM4PmDfZiEh_XRvPdcib2+n1nuyA(a)mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Company Name:* Great Eastern Impex Pvt. Ltd.* > > Contact Person:* Mr.Pankaj Kumar Maurya * > > Contact email: *rfid.suppoort(a)geipl.com <rfid.suppoort(a)geipl.com>* > > Website:* http://www.geipl.com/ <http://www.geipl.com/>* > > Telephone:*+91 ? 124 ? 234 7431/32* > > Address: > > *285 Udyog Vihar, Phase II,* > > *Gurgaon 122016(Haryana)INDIA* > > *Tel: +91 ? 124 ? 234 7431/32* > > *Fax: +91- 124 ? 234 8432* > > *National Service Support: 1-800-200-4015 (Toll Free)* > * S**ales: sales(a)geipl.com <sales(a)geipl.com>* > > *Support: technical.support(a)geipl.com <technical.support(a)geipl.com>* > > > Short description of your services: > > *Great Eastern Impex Pvt. Ltd. * established 1983, is India?s leading > systems integrator & solution provider in Automatic Identification & Data > Capture (AIDC) technologies to help businesses identify & track goods or > information across the supply chain and improve business productivity, and > profits. > Core capabilities > > - Standards driven, custom built solutions (Barcode, RFID & Labeling) > that includes hardware, supplies, software & integration services for > large > & SMB companies. > - RFID & barcode label, tickets (tags) & printing ribbon manufacturer > (converter) with manufacturing operations at Gurgaon (ISO 9001: 2008 > certified facility). > - Nationwide service support with strategically located regional offices > at New Delhi/ NCR, Ludhiana, Mumbai, Pune, Bangalore, Chennai, > Hyderabad & > Kolkata. > - Partnership with industry leaders - Toshiba TEC Corp., Denso Wave > Corp.; ThingMagic Inc.; Alien Technologies Inc., Century Inc., & Avery > Dennison Inc. > - Domain expertise of over 30 years in delivering value to > Manufacturing, Logistics, Retail and Healthcare enterprises. > > > > > > > > > > > > > > > > > > > > > *With Regards, PANKAJ KUMAR MAURYAGreat Eastern Impex Pvt. Ltd.Plot no. : > 285, Udyog Vihar,Phase - II, Gurgaon - 122016(HARYANA), IndiaPhone No. : > +91-124-2347431, 2347432Fax No. : +91-124-2348432Vodafone No. : > 9953938077Toll Free :-18002004015Visit us at www.geipl.com > <http://www.geipl.com> An ISO 9001:2008 Certified Company* > > > ------------------------------ > > Message: 4 > Date: Wed, 11 Feb 2015 08:46:50 -0600 > From: Nicole Engard <nengard(a)gmail.com> > To: Koha <Koha(a)lists.katipo.co.nz> > Subject: [Koha] Github mirror question > Message-ID: > < > CAC0K6VFzDYh5sAZ-nyGMwNogxwb9yAOoke4CWuaQ7JY8unk80A(a)mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Hi all, > > I'm curious about something on Github. Anyone have any ideas why my > patches are all back in 2010: > https://github.com/Koha-Community/Koha/commits?author=nengard > > I've done at least 10 a release because of the help files I edit. > > How is this mirror updated? I'm trying to learn a bit more about > Github just out of professional curiosity. > > Thanks > Nicole > > > ------------------------------ > > Message: 5 > Date: Wed, 11 Feb 2015 10:13:41 -0500 > From: Galen Charlton <gmc(a)esilibrary.com> > To: Nicole Engard <nengard(a)gmail.com> > Cc: Koha <Koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Github mirror question > Message-ID: > < > CAPLnt64T2-5VaPwt8OXa9njq3Zk38izModTvY0J60MekvjQ7xA(a)mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Hi, > > On Wed, Feb 11, 2015 at 9:46 AM, Nicole Engard <nengard(a)gmail.com> wrote: > > I'm curious about something on Github. Anyone have any ideas why my > > patches are all back in 2010: > > https://github.com/Koha-Community/Koha/commits?author=nengard > > > > I've done at least 10 a release because of the help files I edit. > > The mirror itself is up to date; the difference is that you changed > your email address. I believe that if you add your ByWater email > address to your profile on Github, it will recognize more of your > commits as yours. > > Regards, > > Galen > -- > Galen Charlton > Manager of Implementation > Equinox Software, Inc. / The Open Source Experts > email: gmc(a)esilibrary.com > direct: +1 770-709-5581 > cell: +1 404-984-4366 > skype: gmcharlt > web: http://www.esilibrary.com/ > Supporting Koha and Evergreen: http://koha-community.org & > http://evergreen-ils.org > > > ------------------------------ > > Message: 6 > Date: Wed, 11 Feb 2015 08:23:24 -0700 (MST) > From: bowmanrt <bowmanrt(a)lancastermennonite.org> > To: koha(a)lists.katipo.co.nz > Subject: [Koha] Koha 3.18 adding T-Prefix to all scanned barcodes > Message-ID: <1423668204956-5827926.post(a)n5.nabble.com> > Content-Type: text/plain; charset=us-ascii > > We have a library system which we migrated from Follett years ago. We left > all of the old barcodes with the T-prefix, and use the barcode input filter > which removes the T-prefix from our old barcode stickers. Lately, a > different issue is occurring with checkout. Most of our barcode stickers > have no T-prefix, but when scanned into the Checkout field a T-prefix > appears. I'm not sure how Koha is adding the prefix. Is there a setting I'm > missing? > > Thanks! > > Todd > > > > -- > View this message in context: > http://koha.1045719.n5.nabble.com/Koha-3-18-adding-T-Prefix-to-all-scanned-… > Sent from the Koha-general mailing list archive at Nabble.com. > > > ------------------------------ > > Message: 7 > Date: Wed, 11 Feb 2015 12:30:22 -0300 > From: "ramirouvia ." <ramirouvia(a)gmail.com> > To: bowmanrt <bowmanrt(a)lancastermennonite.org> > Cc: "Koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Koha 3.18 adding T-Prefix to all scanned barcodes > Message-ID: > < > CA+QW4LbrM3itwE78axjGhhDyqB8gownSaf-YcTz0Yhy6bmu5PQ(a)mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Todd: > > Did you check "itemBarcodeInputFilter" preference? > > Hope it helps, > Ramiro > > 2015-02-11 12:23 GMT-03:00 bowmanrt <bowmanrt(a)lancastermennonite.org>: > > > We have a library system which we migrated from Follett years ago. We > left > > all of the old barcodes with the T-prefix, and use the barcode input > filter > > which removes the T-prefix from our old barcode stickers. Lately, a > > different issue is occurring with checkout. Most of our barcode stickers > > have no T-prefix, but when scanned into the Checkout field a T-prefix > > appears. I'm not sure how Koha is adding the prefix. Is there a setting > I'm > > missing? > > > > Thanks! > > > > Todd > > > > > > > > -- > > View this message in context: > > > http://koha.1045719.n5.nabble.com/Koha-3-18-adding-T-Prefix-to-all-scanned-… > > Sent from the Koha-general mailing list archive at Nabble.com. > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > ------------------------------ > > Message: 8 > Date: Wed, 11 Feb 2015 08:35:38 -0700 (MST) > From: bowmanrt <bowmanrt(a)lancastermennonite.org> > To: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Koha 3.18 adding T-Prefix to all scanned barcodes > Message-ID: <1423668938352-5827935.post(a)n5.nabble.com> > Content-Type: text/plain; charset=us-ascii > > Thanks for the response! > > I have that checked, but shouldn't that only remove the T-prefix? Instead > it > is adding one to barcodes without a T-prefix. And it only does it in the > checkout field, not when I use the barcode to search the catalog. > > > > -- > View this message in context: > http://koha.1045719.n5.nabble.com/Koha-3-18-adding-T-Prefix-to-all-scanned-… > Sent from the Koha-general mailing list archive at Nabble.com. > > > ------------------------------ > > Message: 9 > Date: Wed, 11 Feb 2015 20:57:43 +0500 > From: Ahmad Amanullah Khan <ahmadamanullahkhan(a)gmail.com> > To: koha(a)lists.katipo.co.nz > Subject: [Koha] Koha on Ubuntu > Message-ID: > <CAGo9-omg0G6_gRn1dCV_Jgzn0271VETO9zc3ErjeNcBus9b1= > w(a)mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Hi > > I wanted to install koha on ubuntu. Can anyone provide me the step by step > guide or any document. > > I will appreciate help on this. > > Thanks > > > ------------------------------ > > Message: 10 > Date: Wed, 11 Feb 2015 21:31:27 +0530 > From: vikram zadgaonkar <vikramczadgaonkar(a)gmail.com> > To: Ahmad Amanullah Khan <ahmadamanullahkhan(a)gmail.com> > Cc: koha list <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Koha on Ubuntu > Message-ID: > <CAGACC3VLDu8VnvBYkYMeO_PxqANkkFjearWVE1vJD= > Cc8JNwMQ(a)mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > You can refer community site. > On 11-Feb-2015 9:30 PM, "Ahmad Amanullah Khan" < > ahmadamanullahkhan(a)gmail.com> > wrote: > > > Hi > > > > I wanted to install koha on ubuntu. Can anyone provide me the step by > step > > guide or any document. > > > > I will appreciate help on this. > > > > Thanks > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > ------------------------------ > > Message: 11 > Date: Wed, 11 Feb 2015 13:06:04 -0300 > From: Tomas Cohen Arazi <tomascohen(a)gmail.com> > To: Ahmad Amanullah Khan <ahmadamanullahkhan(a)gmail.com> > Cc: koha <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Koha on Ubuntu > Message-ID: > <CABZfb=VCNUa4GNRiSsLFBWaDiTYfzojBnC31tNsVvPeF75s= > Dw(a)mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > You should take a look here: > http://wiki.koha-community.org/wiki/Category:Installation > > Probably this one: > http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages > > On Wed, Feb 11, 2015 at 12:57 PM, Ahmad Amanullah Khan < > ahmadamanullahkhan(a)gmail.com> wrote: > > > Hi > > > > I wanted to install koha on ubuntu. Can anyone provide me the step by > step > > guide or any document. > > > > I will appreciate help on this. > > > > Thanks > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > -- > Tom?s Cohen Arazi > Prosecretar?a de Inform?tica > Universidad Nacional de C?rdoba > ? +54 351 5353750 ext 13168 > GPG: B76C 6E7C 2D80 551A C765 E225 0A27 2EA1 B2F3 C15F > > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > > ------------------------------ > > End of Koha Digest, Vol 112, Issue 22 > ************************************* >

1 0

Koha Receives Massive Support from EBSCO for Enhancements to Its Web-Based, Open-Source ILS
by Sandeep Bhavsar 12 Feb '15

12 Feb '15

ROME (PRWEB) February 11, 2015 Koha is an ILS created by librarians for librarians.EBSCO Information Services <http://www.prweb.net/Redirect.aspx?id=aHR0cHM6Ly93d3cuZWJzY28uY29tLw==> is a family-owned company dedicated to solutions that bring real improvements to libraries. Together, the two are working to provide a viable web-based, open source ILS for libraries of all types. Koha libraries reached out to EBSCO for support of some important projects, and EBSCO agreed to partner to accomplish the following for Koha: - Strategic upgrade of of Koha’s core full-text search engine technology to ElasticSearch; ensuring long-term viability - Increased functionality and accuracy of facets - Development of a browse function (author, title, subject, call number) - MARC to RDF crosswalk enhancing capability of linking to online data repositories (linked data) - Greater flexibility in ingesting metadata schemes beyond MARC21 - Improved speed - Enhanced patron functionality API access The financial support from EBSCO will be provided via the Koha Gruppo Italiano founded by the American Academy in Rome, American University of Rome, and the Pontificia Università della Santa Croce which will be assisted in this development and integration by key Koha contributors ByWater Solutions, Catalyst IT, and Cineca. In keeping with open source tradition, these enhancements to Koha are truly open source and will be available for others to use, modify, and re-distribute. The two organizations will also be working to ensure full Koha OPAC functionality within EBSCO Discovery Service™ <http://www.prweb.net/Redirect.aspx?id=aHR0cDovL3d3dy5lYnNjb2hvc3QuY29tL2Rpc…> (EDS) at no additional charge for mutual customers. EBSCO Executive Vice President Sam Brooks says “We very much believe in partnerships with ILS vendors, and we are an active supporter of open source technology for libraries. We are a member of Kuali OLE, and believe that both OLE and Koha are excellent options for libraries worldwide.” Sebastian Hierl, Ph.D., and Drue Heinz Librarian of the American Academy in Rome, which is part of the Koha Gruppo Italiano, commented: “EBSCO is the logical partner for such an endeavor. They are powerful advocates of both open source and open access. The Koha community is excited to have their involvement and strong support.” EBSCO is also a strong supporter of open access, indexing more than 11,000 open access journals in its databases, and supplying substantial traffic to open access publishers. In addition, EBSCO offers free worldwide access to five databases, available at http://www.LibraryResearch.com <http://www.prweb.net/Redirect.aspx?id=aHR0cDovL3d3dy5MaWJyYXJ5UmVzZWFyY2guY…> . Work on the enhancements mentioned above are expected to be completed by the end of 2015. Source : http://www.prweb.com/releases/Koha/EBSCO/prweb12507871.htm -- Warm Regards Sandeep Bhavsar Librarian *Prin. L. N. Welingkar Institute of Management Development & Research* L Napoo Road | Matunga (CR) | Mumbai- 400 019. Tel: 022-2419 8377 | Mob: 9870 18 9999 Library Portal*: http://elearn.welingkar.org/infowe <http://elearn.welingkar.org/infowe>*

1 0

REport that displays the bib record with items that has been accomplished by each staff
by CHRP Library 12 Feb '15

12 Feb '15

Please help me on how to make a detailed accomplishment report of each staff that displays the bib records, items and the date it was added. Thank you very much. Rochelle Palaña Basto Librarian I Commission on Human Rights of the Philippines Tel. No. 927-87-72

3 2

Koha-NA General Meeting - Thursay, Feburary 12th, 1pm EST
by Nick Clemens 12 Feb '15

12 Feb '15

Hi All, The next meeting of the Koha-NA group is tomorrow, Thursday, Feburary 12th at 1pm EST The link to join (via Blackboard) is: *https://sas.elluminate.com/site/external/jwsdetect/meeting.jnlp?sid=2011591&password=M.F770A6F4D9DD4C6E335EAAFED1332B <https://sas.elluminate.com/site/external/jwsdetect/meeting.jnlp?sid=2011591…>* First time participants on this platform will find this information helpful: http://support.blackboardcollaborate.com/ics/support/default.asp?deptID=833… Meeting info and notes from previous meetings can be found here: http://koha-na.org/index.php/Monthly_online_meetings To sign up for the KohaNA mailing list: http://lists.bywatersolutions.com/mailman/listinfo/kohana -- Nick Clemens Quechee & Wilder Libraries Nick(a)quecheelibrary.org http://www.QuecheeLibrary.org Q (802) 295-1232 W (802) 295-6341

1 0

Report help
by Nicole Engard 11 Feb '15

11 Feb '15

Hi all, I'm looking for a report to give the average age of the collection in a few item types. This report runs but isn't right: SELECT i.itype, avg(b.pubdate REGEXP '^[0-9]+$') as average FROM items i left join (select biblionumber, ExtractValue(marcxml, '//datafield[@tag="264"]/subfield[@code="c"]') as pubdate from biblioitems where ExtractValue(marcxml, '//datafield[@tag="264"]/subfield[@code="c"]') is not null and ExtractValue(marcxml, '//datafield[@tag="264"]/subfield[@code="c"]') != '' union all select biblionumber, copyrightdate as pubdate from biblio where copyrightdate is not null) b using (biblionumber) where i.itype in ('JBK','JPLUS') group by i.itype Also on large collections it takes too long to run so any more efficient suggestions are welcome - I am terrible at math :) Nicole

1 0

Koha 3.18 adding T-Prefix to all scanned barcodes
by bowmanrt 11 Feb '15

11 Feb '15

We have a library system which we migrated from Follett years ago. We left all of the old barcodes with the T-prefix, and use the barcode input filter which removes the T-prefix from our old barcode stickers. Lately, a different issue is occurring with checkout. Most of our barcode stickers have no T-prefix, but when scanned into the Checkout field a T-prefix appears. I'm not sure how Koha is adding the prefix. Is there a setting I'm missing? Thanks! Todd -- View this message in context: http://koha.1045719.n5.nabble.com/Koha-3-18-adding-T-Prefix-to-all-scanned-… Sent from the Koha-general mailing list archive at Nabble.com.

2 2

Mixed Materials showing up as
by Heidi Addy 11 Feb '15

11 Feb '15

I am creating a number of records that are mixed materials. I select this "type of material" in the 008 field, but often these items are still showing up as 'books' in the OPAC. Any suggestions? Thanks, Heidi

3 2