- Koha - lists.katipo.co.nz

importing new authorities other than in PERSO_NAME via Tools/Z39.50
by Giuseppe Angilella 10 Jul '16

10 Jul '16

Hi, is it possible to import a new authority other than in PERSO_NAME (say, a new Uniform Title) via Tools ("Stage MARC records for import"), or even by Z39.50? Seemingly, in order to populate any authority table other than the default (i.e. PERSO_NAME) it is only possible to create a new authority in the table of choice. Thanks, Giuseppe.

2 1

Koha Library Enhancements
by Ayrton 10 Jul '16

10 Jul '16

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 -- View this message in context: http://koha.1045719.n5.nabble.com/Koha-Library-Enhancements-tp5894483.html Sent from the Koha-general mailing list archive at Nabble.com.

2 1

Koha 16.05 - Legacy Bibliographic Unique ID numbers mapped to Koha 999c/d?
by Craig Butosi 10 Jul '16

10 Jul '16

Hi all, Koha 16.05 on Ubuntu 14.04, package install. A brief question about bibliographic record unique identifiers and importing records into an empty Koha instance: Is it advisable to map the unique ID numbers from a legacy system's bibliographic records to Koha 999c/d? I am attempting to find a way to connect our items database data to our bibliographics data once the latter has been uploaded to Koha. I imagine the best way to do this is to preserve the unique IDs (i.e., primary key in biblio, foreign key in items) from the legacy system, but I'm not quite sure how I should go about mapping this: should I go for Koha 999c/d, Marc 887, or some other field? The record matching module in Koha gives me much choice, but what does the collective wisdom think? Thank you! C Craig Butosi, MA, MLIS, B Mus (Hons.) LIBRARY SERVICES MANAGER the royal conservatory TELUS Centre for Performance and Learning 273 Bloor Street West Toronto, ON M5S 1W2 416.408.2824 x338 www.rcmusic.ca<http://www.rcmusic.ca/> Note: This email message and any attachments are intended only for the use of the individual to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the recipient of this email is not the intended recipient (or the employee or agent responsible for delivering the email to the intended recipient), you are hereby notified that any review, dissemination, distribution or copying or other use of this message is strictly prohibited. If you have received this communication in error, please notify the sender immediately by return email and delete this message and attachments from your system, thank you.

3 3

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 08 Jul '16

08 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