[Koha] Github mirror question
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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha 3.18 adding T-Prefix to all scanned barcodes
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-barcodes-tp5827926p5827935.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha on Ubuntu
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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha on Ubuntu
You can refer community site. On 11-Feb-2015 9:30 PM, Ahmad Amanullah Khan ahmadamanullahk...@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@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
[Koha] search returns nothing, yaz-client returns values
We have a koha install that has had some issues (expounded upon below) At the moment, all searches from the webpage return no results. I can do a manual search using yaz-client, and get results. If I go to the item search, I can see everything there. It appears to me that apache is not communicating with zebra. The koha-zebra is running (I can see it when I do a ps). I have done manual index rebuilds, and it looks like the cron re-indexing is happening. And, as I said, I can manually run yaz-client and get responses. The server is Debian Squeeze on a 64-bit system (actual hardware, not a VM). I am a pretty good techie, but I am new to koha. I will give a short version of the history in case something jumps out as something I did wrong. The server and Koha were installed by outside contractors. Koha was installed by git. The data came from an old version of koha that had crashed and was mangled. I was able to dig through 28,000 records and recover most of the data by repairing the sql by hand. The old version of Koha had a different format for some of the mysql tables. I manually added the fields so it is now the same as what the fresh koha install used. Because some of the sql had been mangled, there were a number of biblio records that threw errors during the zebra rebuild. I removed those records, and now zebra reindexes cleanly. I can do a yaz-client unix:/var/run/zebradb/bibliosocket -c /etc/koha/zebradb/ccl.properties base biblio f something and I get lots of responses that I can show I tried using tcp connections instead of sockets. I could connect by yaz-client, but nothing changed with koha. So I went back to sockets. The server is in Africa, and I am helping from the United States, and the Internet is down at the koha site. So I do not have access to the actual running system at the moment. But I am looking for any ideas that might help speed me on my way. I was about to read through the itemsearch.pl code to figure out how itemsearch.pl knows to use the socket or tcp connection, and maybe put in some debugging code to watch it. I saw someone mention that I could increase koha's logging ability and actually capture the queries that were sent to zebra? That would be helpful. - Tim Young ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha on Ubuntu
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 ahmadamanullahk...@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@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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Report help
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
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] search returns nothing, yaz-client returns values
Hi, Il 11/02/2015 18:07, Tim Young ha scritto: We have a koha install that has had some issues (expounded upon below) At the moment, all searches from the webpage return no results. I can do a manual search using yaz-client, and get results. If I go to the item search, I can see everything there. check the system preference 'OpacSuppression' [Opac section] If is on 'Hide', set on 'Don't hide'. And try again. Bye Zeno Tajoli -- Dr. Zeno Tajoli Servizi Innovativi -- Automazione Biblioteche z.taj...@cineca.it fax +39 02 2135520 CINECA - Sede operativa di Segrate ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Github mirror question
Hi, On Wed, Feb 11, 2015 at 9:46 AM, Nicole Engard neng...@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: g...@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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha 3.18 adding T-Prefix to all scanned barcodes
Todd: Did you check itemBarcodeInputFilter preference? Hope it helps, Ramiro 2015-02-11 12:23 GMT-03:00 bowmanrt bowma...@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-barcodes-tp5827926.html Sent from the Koha-general mailing list archive at Nabble.com. ___ 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
[Koha] Koha 3.18 adding T-Prefix to all scanned barcodes
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-barcodes-tp5827926.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha-NA General Meeting - Thursay, Feburary 12th, 1pm EST
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=2011591password=M.F770A6F4D9DD4C6E335EAAFED1332B https://sas.elluminate.com/site/external/jwsdetect/meeting.jnlp?sid=2011591password=M.F770A6F4D9DD4C6E335EAAFED1332B* First time participants on this platform will find this information helpful: http://support.blackboardcollaborate.com/ics/support/default.asp?deptID=8336questionID=1473task=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 n...@quecheelibrary.org http://www.QuecheeLibrary.org Q (802) 295-1232 W (802) 295-6341 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] REport that displays the bib record with items that has been accomplished by each staff
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 (-mm-dd)|date AND and (-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 (-mm-dd)|date AND and (-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 (-mm-dd)|date AND and (-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 (-mm-dd)|date AND and (-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 (-mm-dd)|date AND and (-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-items-that-has-been-accomplished-by-each-staff-tp5827651p5827971.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Indexing with dom - uses the DOM XML filter; offers improved
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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Indexing with dom - uses the DOM XML filter; offers improved
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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Request to add our company name in list of Koha Paid Support
Company Name:* Great Eastern Impex Pvt. Ltd.* Contact Person:* Mr.Pankaj Kumar Maurya * Contact email: *rfid.suppo...@geipl.com rfid.suppo...@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: sa...@geipl.com sa...@geipl.com* *Support: technical.supp...@geipl.com technical.supp...@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* ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha Receives Massive Support from EBSCO for Enhancements to Its Web-Based, Open-Source ILS
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 Library Portal*: http://elearn.welingkar.org/infowe http://elearn.welingkar.org/infowe* ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
