- Koha - lists.katipo.co.nz

Re: [Koha] Koha Library Enhancements
by Stefano Bargioni 08 Jul '16

08 Jul '16

Hy, Ayrton, I tested Elasticsearch in Koha 16.05 and a Debian 8.5 VM. Regarding Elasticsearch, I can say that it is an alpha version. You need to install Elasticsearch, and -see bug 16838 "Elasticsearch - mapping tables are not populated on new installs" - you need to "manually" populate search_* tables. The 16.11 will be a beta version, IMO. Stefano > Hello, > > I'm performing a pro-bono consulting in the Philippines and part of my job > is to help enhancing a library, which currently uses Koha. This Library is > mixed between physical material (circulation in use) and digital material, > which are basically links to Google Drive repository. > > That being said, I would like to ask for some help about the following > requirements: > > - Has anyone implemented Open URL for use of Open URL Referrer? > - Has anyone implemented some kind on Federated Search? > - Has anyone implemented ElasticSearch? > - Has anyone implemented SMS notification with no cost (Email SMS perhaps)? > - Has anyone implemented Facebook messenger to address questions to > Librarians? > > I would really appreciate if anyone could share some details about the > implementations. > > Many thanks in advance, > > Ayrton

1 0

Error on Koha Dev Git install
by auldstampguy 07 Jul '16

07 Jul '16

Scott, The forbidden message that you are getting is saying that you are trying to access the Root directory. Your root directory in your virtual server setup in Apache is pointing at the wrong directory. Hope this helps. Regards, Tim AuldMinnesota Sent from my Galaxy Tab® S2

1 0

Help regarding fine calculation report
by Suresh Kumar Tejomurtula 07 Jul '16

07 Jul '16

Hi, Need help in refining the below query which is based on the query from SQL reports library. I need to add the following also to the query: 1. Using the below report Iam able to generate fine report for only returned items. I need to generate fine even for the items that are renewed and fine is generated. 2. Also in some cases the below query is not including the start date and end date. As far as I read about mysql help regarding BETWEEN function, it includes both start date and END date. *SELECT * * b.cardnumber as Emp_NO,TRIM(CONCAT( b.surname, b.firstname)) as Name, b.address as DEPT,bib.title, i.barcode as Acc_NO,DATE_FORMAT( a.timestamp, "%d %b %Y" ) as FineDate,* * a.amountoutstanding, DATE_FORMAT(ni.issuedate, "%d %b %Y" ) as Issue_date, DATE_FORMAT(ni.date_due, "%d %b %Y" ) as Due_date,* * IF ( ni.returndate IS NULL , " ", ni.returndate ) AS returndate, IF ( ni.lastreneweddate IS NULL , " ", ni.lastreneweddate ) AS lastreneweddate * *FROM accountlines a * * LEFT JOIN borrowers b ON ( b.borrowernumber = a.borrowernumber ) * * LEFT JOIN items i ON ( a.itemnumber = i.itemnumber ) * * LEFT JOIN biblio bib ON ( i.biblionumber = bib.biblionumber ) * * LEFT JOIN ( SELECT * FROM issues UNION SELECT * FROM old_issues ) ni ON ( ni.itemnumber = i.itemnumber AND ni.borrowernumber = a.borrowernumber ) * *WHERE * *DATE_FORMAT( ni.returndate, "%m" )=<<Enter Month MM>> AND DATE_FORMAT( ni.returndate, "%Y" )=<<Enter Year YYYY>>* *and* *((itype='BK' OR itype='REP' ) AND amountoutstanding >'5.00' OR (itype='JNL' OR itype='STD') AND amountoutstanding >'1.50') and returndate is not null* *ORDER BY returndate asc* If there is any other report in the reports library which helps me to generate fines report between two dates for the items that are returned/renewed, please let me know. -- Regards T. Suresh Kumar

2 1

Error on Koha Dev Git install
by Scott Kushner 07 Jul '16

07 Jul '16

Anyone seen this before and have a solution? It's some kind of Apache permissions issue, but I'm not sure where. I gave the directory 755 and www-data permisions.. Forbidden You don't have permission to access / on this server. Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request. ________________________________ Apache/2.4.10 (Debian) Server at xxx.xx.x.xxx Port 8080 I am following these installation instructions... https://wiki.koha-community.org/wiki/Install_and_Setup_Koha_to_use_Git_on_a… thanks, Sincerely, Scott Kushner Systems Librarian Middletown Public Library 55 New Monmouth Rd Middletown, NJ 07748

2 1

Search Sort by Title (A-Z) for non-Latin alphabets?
by Cunningham, Keah M 07 Jul '16

07 Jul '16

Hi, I was wondering if anyone has the Sort by Title (A-Z) working properly in Koha. Currently, any foreign language materials that have titles in languages that use non-Latin alphabets do not sort by title correctly. Here is an example OPAC search for Russian films: http://catalog.egarc.ku.edu/cgi-bin/koha/opac-search.pl?idx=kw&idx=kw&idx=k…. Koha seems to sort the results by character count ... but there is no alphabetizing at all. Two records with Вий as the title are listed as #3 and #6; with identical titles, they should be next to each other. I found this post (http://article.gmane.org/gmane.comp.misc.koha/19912/match=cyrillic+title) and I think it will do what we want. However, I am curious about other languages that are script-based (e.g., Mandarin, Korean, etc.) or that read Left-to-Right (e.g., Hebrew, Arabic, etc.). Is there some sort of catch-all to make this work? Or how are others addressing the issue? Creating Reports in Koha that sort by title do in fact alphabetize correctly, so it seems to be a limitation of the search/Zebra rather than Koha as a whole. Thanks in advance, Keah -- Keah Cunningham Assistant Director Ermal Garinger Academic Resource Center University of Kansas 1445 Jayhawk Boulevard 4073 Wescoe Hall Lawrence, KS 66045-7590 keah(a)ku.edu<mailto:keah@ku.edu>

2 1

Re: [Koha] [Koha-devel] Error on Koha Dev Git install
by Paul A 07 Jul '16

07 Jul '16

At 03:55 PM 7/7/2016 +0000, Scott Kushner wrote: >Anyone seen this before and have a solution? >Its some kind of Apache permissions issue, but Im not sure where. >I gave the directory 755 and www-data permisions.. > >Forbidden >You don't have permission to access / on this server. Yup, Apache (out of the box, all versions that I can remember over the last two decades) denies access to root (" / ") -- anything else would be a huge security risk. So you don't have an Apache problem. And FYI, (you don't say what "directory" you're referring to), *most* (certainly all static) webpages should be 644. >Additionally, a 404 Not Found error was encountered while trying to use an >ErrorDocument to handle the request. Normal: if you can't get the request|page, it's "404" -- what do your error logs say??? Best -- Paul

1 0

Z39.50 search window is not showing
by Mubassir Ahsan 07 Jul '16

07 Jul '16

When we click on the link add record under z39.50 from the following link http://koha.library.daffodilvarsity.edu.bd/cgi-bin/koha/cataloguing/addbibl… is not working. To reproduce the error: 1. Search for any title 2. Go to its bibliography 3. Click on new>New Record 4. Click on " Z39.50/SRU search <http://koha.library.daffodilvarsity.edu.bd/cgi-bin/koha/cataloguing/addbibl…>" is not showing searching window. -- *Best wishes.--------------------Md. Mubassir Ahsan* *-----------------------------* *Mobile+Viber+IMO: 01916303060* *Facebook:* mmahsan <http://facebook.com/mmahsan> *Skype+Twitter*: mahsandu *"Proud to be a LIS Professional*" *Tag: Web Developer, CMS (Drupal, Joomla), ILS (Koha), IR (DSpace, Greenstone), N/W Admin, DBA.*

4 3

Re: [Koha] [Koha-devel] Error on Koha Dev Git install
by Eric Bégin 07 Jul '16

07 Jul '16

Scott, There is a slight difference the way the permissions are given in Apache 2.4. Take a look at this : https://httpd.apache.org/docs/current/en/upgrading.html#run-time Cheers, Eric BéginSolutions inLibro inc. -------- Message d'origine -------- De : Scott Kushner <skushner(a)mplmain.mtpl.org> Date : 07/07/2016 11:55 (GMT-05:00) À : "Koha Devel (koha-devel(a)lists.koha-community.org)" <koha-devel(a)lists.koha-community.org>, koha(a)lists.katipo.co.nz Objet : [Koha-devel] Error on Koha Dev Git install Anyone seen this before and have a solution? It’s some kind of Apache permissions issue, but I’m not sure where. I gave the directory 755 and www-data permisions.. ForbiddenYou don't have permission to access / on this server.Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.Apache/2.4.10 (Debian) Server at xxx.xx.x.xxx Port 8080 I am following these installation instructions… https://wiki.koha-community.org/wiki/Install_and_Setup_Koha_to_use_Git_on_a… thanks, Sincerely, Scott KushnerSystems LibrarianMiddletown Public Library55 New Monmouth RdMiddletown, NJ 07748

1 0

Kohacon 2017 proposals: deadline 10 August 2016, 10 UTC
by Mirko Tietgen 06 Jul '16

06 Jul '16

Hello everyone (again), the deadline to submit your proposals to host Kohacon 2017 is 10 August 2016, 10 UTC. Please add your proposals to the wiki[1] and feel free to make an announcement to the main Koha mailing list. Cheers, Mirko [1] https://wiki.koha-community.org/wiki/KohaCon17_Proposals -- Mirko Tietgen mirko(a)abunchofthings.net http://koha.abunchofthings.net http://meinkoha.de

1 0

Next general IRC meeting: 3 August 2016
by Mirko Tietgen 06 Jul '16

06 Jul '16

Hello everyone, today's general IRC meeting was postponed due to lack of attendence and urgent agenda items. The next general Koha IRC meeting will be held on 3 August 2016, 10 UTC. Please add important items to the agenda in the wiki.[1] Cheers, Mirko [1] https://wiki.koha-community.org/wiki/General_IRC_meeting_3_August_2016 -- Mirko Tietgen mirko(a)abunchofthings.net http://koha.abunchofthings.net http://meinkoha.de

1 0