Re: [Koha] Koha Digest, Vol 112, Issue 24
Greeting to all I want to add column in ADD authority LOC options . how to do this? On 2/12/15, koha-request@lists.katipo.co.nz <koha-request@lists.katipo.co.nz> wrote:
Send Koha mailing list submissions to koha@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@lists.katipo.co.nz
You can reach the person managing the list at koha-owner@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. Koha-NA General Meeting - Thursay, Feburary 12th, 1pm EST (Nick Clemens) 2. Re: REport that displays the bib record with items that has been accomplished by each staff (schnydszch) 3. Koha Receives Massive Support from EBSCO for Enhancements to Its Web-Based, Open-Source ILS (Sandeep Bhavsar) 4. Indexing with dom - uses the DOM XML filter; offers improved (Admire Mutsikiwa) 5. Re: Indexing with dom - uses the DOM XML filter; offers improved (Bob Birchall) 6. Huge grant from Ebsco Publishing (Stefano Bargioni) 7. Koha error upgrade -Can't call method "raw" on an undefined value at /usr/share/koha/lib/C4/Search.pm (Admire Mutsikiwa) 8. Re: Huge grant from Ebsco Publishing (Eric B?gin) 9. Re: Huge grant from Ebsco Publishing (Mike D.)
----------------------------------------------------------------------
Message: 1 Date: Wed, 11 Feb 2015 18:15:02 -0500 From: Nick Clemens <nick@quecheelibrary.org> To: Koha <Koha@lists.katipo.co.nz>, kohana@bywatersolutions.com, partners@bywatersolutions.com Subject: [Koha] Koha-NA General Meeting - Thursay, Feburary 12th, 1pm EST Message-ID: <CAJZuzM-J5gDzYr8MFq1P+W_EAD_yHn=XgpvaCJ-ZyOQdV9OptA@mail.gmail.com> Content-Type: text/plain; charset=UTF-8
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&password=M.F770A6F4D9DD4C6E335EAAFED1332B>*
First time participants on this platform will find this information helpful: http://support.blackboardcollaborate.com/ics/support/default.asp?deptID=8336&questionID=1473&task=knowledge
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@quecheelibrary.org http://www.QuecheeLibrary.org Q (802) 295-1232 W (802) 295-6341
------------------------------
Message: 2 Date: Wed, 11 Feb 2015 18:45:17 -0700 (MST) From: schnydszch <eugenegf@yahoo.com> To: koha@lists.katipo.co.nz Subject: Re: [Koha] REport that displays the bib record with items that has been accomplished by each staff Message-ID: <1423705517041-5827971.post@n5.nabble.com> Content-Type: text/plain; charset=us-ascii
Hi! Manny emailed you and I've also emailed you regarding this report. However, it will be better if the report is shared here (at least on my part):
Reports of All Catalog Actions
SELECT b.title , b.author , i.itemnumber, i.itemcallnumber , i.barcode , l.action_id, l.user, l.module, l.action, l.object, l.info , br.borrowernumber FROM items i LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) LEFT JOIN action_logs l ON (b.biblionumber=l.object) LEFT JOIN borrowers br on (l.user=br.borrowernumber) WHERE br.surname = <<Enter Surname>> AND br.firstname = <<Enter Firstname>> AND date(i.timestamp) BETWEEN <<Between (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>>
Reports of Added Catalog
SELECT b.title , b.author , i.itemnumber, i.itemcallnumber , i.barcode , l.action_id, l.user, l.module, l.action, l.object, l.info , br.borrowernumber FROM items i LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) LEFT JOIN action_logs l ON (b.biblionumber=l.object) LEFT JOIN borrowers br on (l.user=br.borrowernumber) WHERE br.surname = <<Enter Surname>> AND br.firstname = <<Enter Firstname>> AND date(i.timestamp) BETWEEN <<Between (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> AND action='ADD'
Reports of Modified Catalog
SELECT b.title , b.author , i.itemnumber, i.itemcallnumber , i.barcode , l.action_id, l.user, l.module, l.action, l.object, l.info , br.borrowernumber FROM items i LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) LEFT JOIN action_logs l ON (b.biblionumber=l.object) LEFT JOIN borrowers br on (l.user=br.borrowernumber) WHERE br.surname = <<Enter Surname>> AND br.firstname = <<Enter Firstname>> AND date(i.timestamp) BETWEEN <<Between (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> AND action='MODIFY'
Reports of All Catalog Actions (ID number)
SELECT b.title , b.author , i.itemnumber, i.itemcallnumber , i.barcode , l.action_id, l.user, l.module, l.action, l.object, l.info , br.borrowernumber, br.cardnumber FROM items i LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) LEFT JOIN action_logs l ON (b.biblionumber=l.object) LEFT JOIN borrowers br on (l.user=br.borrowernumber) WHERE br.cardnumber = <<Enter ID number>> AND date(i.timestamp) BETWEEN <<Between (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>>
Reports of All Added Catalog Actions (ID number)
SELECT b.title , b.author , i.itemnumber, i.itemcallnumber , i.barcode , l.action_id, l.user, l.module, l.action, l.object, l.info , br.borrowernumber, br.cardnumber FROM items i LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) LEFT JOIN action_logs l ON (b.biblionumber=l.object) LEFT JOIN borrowers br on (l.user=br.borrowernumber) WHERE br.cardnumber = <<Enter ID number>> AND date(i.timestamp) BETWEEN <<Between (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> AND action='ADD'
You see here the reports for showing added items by catalogers filtered by either their surname, firstname, date . Please take note that I did not show the timestamp in these reports, you can replace "l.action_id, l.user, l.module, l.action, l.object, l.info" with "l.*" instead to show the timestamp. I did not include timestamps because you know it can incriminate some persons on their performance based on the report. You could just filter it by date or add in SELECT query the date without the hours, minutes and seconds but I haven't done that, maybe others can share how to do that.
-- View this message in context: http://koha.1045719.n5.nabble.com/REport-that-displays-the-bib-record-with-i... Sent from the Koha-general mailing list archive at Nabble.com.
------------------------------
Message: 3 Date: Thu, 12 Feb 2015 10:46:06 +0530 From: Sandeep Bhavsar <sandeep.bhavsar@gmail.com> To: koha <koha@lists.katipo.co.nz> Subject: [Koha] Koha Receives Massive Support from EBSCO for Enhancements to Its Web-Based, Open-Source ILS Message-ID: <CA+3iuR4r4GNk0o4NW9JzWXVho=8z2_rUS8x_jHRAV+mvNLyh9w@mail.gmail.com> Content-Type: text/plain; charset=UTF-8
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=aHR0cDovL3d3dy5lYnNjb2hvc3QuY29tL2Rpc2NvdmVyeQ==> (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=aHR0cDovL3d3dy5MaWJyYXJ5UmVzZWFyY2guY29t> .
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>*
------------------------------
Message: 4 Date: Thu, 12 Feb 2015 08:56:57 +0200 From: "Admire Mutsikiwa" <amutsikiwa@uzlib.uz.ac.zw> To: <koha@lists.katipo.co.nz> Subject: [Koha] Indexing with dom - uses the DOM XML filter; offers improved Message-ID: <003301d04691$17f922f0$47eb68d0$@uzlib.uz.ac.zw> Content-Type: text/plain; charset="us-ascii"
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>
------------------------------
Message: 5 Date: Thu, 12 Feb 2015 18:51:35 +1100 From: Bob Birchall <bob@calyx.net.au> To: koha@lists.katipo.co.nz Subject: Re: [Koha] Indexing with dom - uses the DOM XML filter; offers improved Message-ID: <54DC5B87.2060405@calyx.net.au> Content-Type: text/plain; charset=windows-1252; format=flowed
Hi Admire, I am not our expert on Zebra but hope I can help.
This is all within Zebra, that is, its grs1 v DOM, not Zebra v DOM. They are different ways of filtering within Zebra.
This information is on the wiki, but may be out of date, I'm not sure: http://wiki.koha-community.org/wiki/Switching_to_dom_indexing
Perhaps you could do your upgrade and then use that to check your settings? You've taken a good back-up?
Bob Birchall Calyx
On 12/02/15 17:56, Admire Mutsikiwa wrote:
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
------------------------------
Message: 6 Date: Thu, 12 Feb 2015 12:42:36 +0100 From: Stefano Bargioni <bargioni@pusc.it> To: Koha List <koha@lists.katipo.co.nz> Subject: [Koha] Huge grant from Ebsco Publishing Message-ID: <A0D63801-DD67-4B14-B34D-E151FF0C5A57@pusc.it> Content-Type: text/plain; charset=iso-8859-1
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
------------------------------
Message: 7 Date: Thu, 12 Feb 2015 14:51:42 +0200 From: "Admire Mutsikiwa" <amutsikiwa@uzlib.uz.ac.zw> To: <koha@lists.katipo.co.nz> Subject: [Koha] Koha error upgrade -Can't call method "raw" on an undefined value at /usr/share/koha/lib/C4/Search.pm Message-ID: <00e101d046c2$a67bb7f0$f37327d0$@uzlib.uz.ac.zw> Content-Type: text/plain; charset="us-ascii"
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>
------------------------------
Message: 8 Date: Thu, 12 Feb 2015 07:59:46 -0500 From: Eric B?gin <eric.begin@inLibro.com> To: Stefano Bargioni <bargioni@pusc.it>, Koha List <koha@lists.katipo.co.nz> Subject: Re: [Koha] Huge grant from Ebsco Publishing Message-ID: <cc3w48wk77yte28f1m067600.1423745986044@email.android.com> Content-Type: text/plain; charset=utf-8
Congratulation Stephano (and your team)
This is a great news.
Eric B?gin Solutions inLibro inc.
<div>-------- Message d'origine --------</div><div>De : Stefano Bargioni <bargioni@pusc.it> </div><div>Date :12/02/2015 06:42 (GMT-05:00) </div><div>? : Koha List <koha@lists.katipo.co.nz> </div><div>Objet : [Koha] Huge grant from Ebsco Publishing </div><div> </div>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 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------
Message: 9 Date: Thu, 12 Feb 2015 14:07:53 +0100 From: "Mike D." <black23@gmail.com> Cc: Koha List <koha@lists.katipo.co.nz> Subject: Re: [Koha] Huge grant from Ebsco Publishing Message-ID: <CAHO46vNYsmPRnvqqHu-jivSVKVCQYiNZYZmeXirkMQy3_9rx8A@mail.gmail.com> Content-Type: text/plain; charset=UTF-8
Hello Spephano, This is great message to whole Koha community. How do You plan to improve speed of Koha? Do you boost development of Plack?
Thanks
Mike
2015-02-12 13:59 GMT+01:00 Eric B?gin <eric.begin@inlibro.com>:
Congratulation Stephano (and your team)
This is a great news.
Eric B?gin Solutions inLibro inc.
<div>-------- Message d'origine --------</div><div>De : Stefano Bargioni < bargioni@pusc.it> </div><div>Date :12/02/2015 06:42 (GMT-05:00) </div><div>? : Koha List <koha@lists.katipo.co.nz> </div><div>Objet : [Koha] Huge grant from Ebsco Publishing </div><div> </div>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 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------
Subject: Digest Footer
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------
End of Koha Digest, Vol 112, Issue 24 *************************************
participants (1)
-
Arshad Iqbal