- Koha - lists.katipo.co.nz

SQL Report-Circulation-- Help
by SATISH 23 Feb '17

23 Feb '17

Hi, With Koha 16.5/Package Installation/ Ubuntu 14.04 Desktop / I looking for Borrower's complete transactions report between "date range" and "by patron category" and "by itemtype". I reason for the report is: to keep the record in hard copy for entire semester's transactions. I am trying following report, with date range, am successful but when added patron category and itemtype (last two line in WHERE section), it's failing. Can someone help me to get this report or please correct me, if I am wrong in the query?? ------------------------------------------------------------------------------------------------------ SELECT borrowers.cardnumber, borrowers.surname,borrowers.firstname, borrowers.streetnumber, borrowers.categorycode,items.barcode, DATE_FORMAT(old_issues.issuedate, "%d %b %Y %h:%i %p") As issuedate, DATE_FORMAT(old_issues.date_due, "%d %b %Y %h:%i %p") As date_due, DATE_FORMAT(old_issues.lastreneweddate, "%d %b %Y %h:%i %p") As lastreneweddate, DATE_FORMAT(old_issues.returndate, "%d %b %Y %h:%i %p") As returndate, EXTRACTVALUE( b.marcxml, '//datafield[@tag="245"]/subfield[@code>="a"]' ) AS TITLE, items.itype, items.location, items.ccode,items.itemcallnumber, items.price FROM old_issues LEFT JOIN borrowers ON ( borrowers.borrowernumber = old_issues.borrowernumber ) LEFT JOIN items ON ( items.itemnumber = old_issues.itemnumber ) LEFT JOIN biblioitems AS b ON ( items.biblioitemnumber = b.biblioitemnumber) WHERE p.categorycode=<<categorycode|categorycode>> AND WHERE items.itype=<<itemtypes|itemtypes>> AND WHERE old_issues.issuedate BETWEEN <<Between Date (yyyy-mm-dd)|date>> and <<and (yyyy-mm-dd)|date>> ORDER BY old_issues.issuedate ---------------------------------------------------------------------------------------------------- With Thanks Satish MV Librarian Govt. Engineering College, Hassan Karnataka. www.gechassan.ac.in --

3 4

Difference between 3.22 and 16.11
by Walsh, Daniel (British Council) 23 Feb '17

23 Feb '17

Dear Colleagues, We are currently upgrading KOHA across our libraries. Other than a change in naming convention, are there any technical differences between 3.22 and 16.11? Dan Walsh The British Council is the United Kingdom's international organisation for cultural relations and educational opportunities. A registered charity: 209131 (England and Wales) SC037733 (Scotland). This message is for the use of the intended recipient(s) only and may contain confidential information. If you have received this message in error, please notify the sender and delete it. The British Council accepts no liability for loss or damage caused by viruses and other malware and you are advised to carry out a virus and malware check on any attachments contained in this message.

8 9

Koha MARC Tag - Table of Contents
by Dr. Sandeep Bhavsar 22 Feb '17

22 Feb '17

Dear All Greetings !!! I have gone through the Koha OPAC of INSEAD Library, I notice that they have uploaded the Table of Contents (TOC) of the book which has fulltext indexing search. I would like to know about the exact MARC tag number for uploading TOC, ( I can search the contents of pdf file also) Search for = The Threats to Marketing Research http://librarycatalogue.insead.edu/cgi-bin/koha/opac-detail.pl?biblionumber… -- Warm Regards Dr. Sandeep Bhavsar Librarian *Prin. L. N. Welingkar Institute of Management Development & Research (AUTONOMOUS)* 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>*

6 10

Search not working
by i.pratt＠zigzagee.com 22 Feb '17

22 Feb '17

Vanda, Just out of interest, did you choose UNIMARC when the package installation was performed ? I did and I'm facing the same search problems as you. I note the koha-conf.xml file seems to have a lot of MARC21 references. Not sure if this needs to change to UNIMARC. This was just the template file that was generated through the installation. I tried the koha-rebuild-zebra -f -a -b -v $instance approach recommended but that didn't fix the search problems. if you want to know where it is just use >which koha-rebuild-zebra Regards, Ian -- ________________________________________________ Dr. Ian Pratt B.Eng Ph.D C.Eng MIET MIEEE Director - ZigZagee Ltd. Email: i.pratt(a)zigzagee.com Landline: + 44 (0) 1509 276251 Mobile: + 44 (0) 7796331815 Web: www.zigzagee.com ________________________________________________

3 4

Summary: Koha Devel Meeting, 22 Februrary 2017
by Nick Clemens 22 Feb '17

22 Feb '17

Hi All, We had a productive dev meeting today, just wanted to highlight some of our discussions for the general list readers. If this seems useful I will try to send these updates after each dev meeting: The Onboarding tool <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17855> still needs more testing (see Jonathan's email here: http://lists.koha-community.org/pipermail/koha-devel/2017-February/043481.h…) This tool will make it easier for those setting up a new instance to enable necessary settings and configuration and generally make Koha setup more friendly. It was proposed as a possibility to roll the tool out in English first, and add other languages as they are tested. Ideally we would have as much testing as possible now. We will discuss and vote on how to move ahead at the next Developers meeting (8 March 2017, 19UTC) The ru-RU and uk-UA languages were discussed for possible removal as there has been no maintenance, if you are using these or interested in helping maintain (or have strong opinion) please let us know. Testing and QA teams can always use more help so let us know if you are interested. Other interesting notes: ElasticSearch dependencies are being packaged by Mirko Jonathan continues work on refactoring and moving things to the Koha namespace (see here <https://bugs.koha-community.org/bugzilla3/showdependencygraph.cgi?id=16846> for Koha::Patron status) OverDrive integration has been pushed to master The next meeting will be 8 March 2017, 19UTC <https://wiki.koha-community.org/wiki/Development_IRC_meeting_8_March_2017>, I hope to see you there.

1 0

Re: [Koha] SQL Report-Circulation-- Help
by Jonathan Druart 22 Feb '17

22 Feb '17

What is the error you get? Please answer to the list. On Wed, 22 Feb 2017 at 12:12 SATISH <lis4satish(a)gmail.com> wrote: > thank you Jonathan for correcting sql syntax. > but after corrections,it is still showing error! > > with thanks > satish > > On 22 February 2017 at 15:57, Jonathan Druart < > jonathan.druart(a)bugs.koha-community.org> wrote: > > Hello Satish, > > To add conditions to a SQL query you just need to separate them with the > "AND" keyword, do not repeat "WHERE". > > So it's: > SELECT fields > FROM TABLE > WHERE condition_a AND condition_b AND condition_c > > Regards, > Jonathan > > On Wed, 22 Feb 2017 at 11:05 SATISH <lis4satish(a)gmail.com> wrote: > > > Hi, > > > > With Koha 16.5/Package Installation/ Ubuntu 14.04 Desktop / > > > > I looking for Borrower's complete transactions report between "date > range" > > and "by patron category" and "by itemtype". > > I reason for the report is: to keep the record in hard copy for entire > > semester's transactions. > > > > I am trying following report, with date range, am successful but when > added > > patron category and itemtype (last two line in WHERE section), it's > > failing. > > > > Can someone help me to get this report or please correct me, if I am > wrong > > in the query?? > > > > > > > ------------------------------------------------------------------------------------------------------ > > SELECT borrowers.cardnumber, borrowers.surname,borrowers.firstname, > > borrowers.streetnumber, borrowers.categorycode,items.barcode, > > DATE_FORMAT(old_issues.issuedate, "%d %b %Y %h:%i %p") As issuedate, > > DATE_FORMAT(old_issues.date_due, "%d %b %Y %h:%i %p") As date_due, > > DATE_FORMAT(old_issues.lastreneweddate, "%d %b %Y %h:%i %p") As > > lastreneweddate, > > DATE_FORMAT(old_issues.returndate, "%d %b %Y %h:%i %p") As returndate, > > EXTRACTVALUE( b.marcxml, '//datafield[@tag="245"]/subfield[@code>="a"]' ) > > AS TITLE, > > items.itype, items.location, items.ccode,items.itemcallnumber, > items.price > > FROM old_issues > > LEFT JOIN borrowers ON ( borrowers.borrowernumber = > > old_issues.borrowernumber ) > > LEFT JOIN items ON ( items.itemnumber = old_issues.itemnumber ) > > LEFT JOIN biblioitems AS b ON ( items.biblioitemnumber = > > b.biblioitemnumber) > > WHERE p.categorycode=<<categorycode|categorycode>> AND > > WHERE items.itype=<<itemtypes|itemtypes>> AND > > WHERE old_issues.issuedate BETWEEN <<Between Date (yyyy-mm-dd)|date>> and > > <<and (yyyy-mm-dd)|date>> ORDER BY old_issues.issuedate > > > > > ---------------------------------------------------------------------------------------------------- > > > > With Thanks > > Satish MV > > Librarian > > Govt. Engineering College, Hassan > > Karnataka. > > www.gechassan.ac.in > > -- > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > > -- > > > >

1 0

Koha 16.11.04 released
by Katrin 22 Feb '17

22 Feb '17

The Koha community is proud to announce the release of Koha 16.11.04. This is a maintenance release of 16.11 and contains 3 enhancements and 41 bugfixes. The full release notes are available at https://koha-community.org/koha-16-11-04-release Packages will be available soon.

2 1

Koha Developers Meeting reminder - Tuesday, February 21, 2017 - 13 UTC
by Nick Clemens 21 Feb '17

21 Feb '17

Hi All, The next Koha Developers IRC meeting is tomorrow, convert into local time using the link below: https://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+Developers+I… The agenda is here: https://wiki.koha-community.org/wiki/Development_IRC_meeting_22_February Please add anything you wish to discuss. For those who cannot attend please add your name in the apologies and take the time survey here https://framadate.org/3dAEB8zqQLzzTptD or leave a suggestion for next meeting time See you all soon! -Nick

1 0

Can Koha be configured for the following variable circulation rules?
by Raymund Delahunty 21 Feb '17

21 Feb '17

Environment: Six libraries at constituent colleges each with identical circulation rules. Maximum loans apply by user category (books and DVDs mainly). Maximum loans by user category apply university wide (so 15 items per undergraduate) and using system preference circcontrol as "the library the member is from" this works fine. Users are free to borrow from multiple libraries, up to the overall maximum loans count of 15. Our "Learning Zone" is a separate library in Koha- it loans only IT kit and is open 24 hours a day, often with only security staff (no library staff). New self-issue laptop loan units have been installed. Requirement: Configure Koha Circulation to allow users to borrow a laptop and other kit from the learning Zone, via self service as an ADDITIONAL entitlement, so users whose account is maxed out with books and audio equipment can still borrow a laptop via self-service kit. Progress to date: Not a lot. I have been unable to get this working, despite extensive testing. Initially I tried separate library circulation rules for Learning Zone and had the other 6 libraries as All Libraries, and my changes to circcontrol to "library the user is logged into" saw the laptops borrowable, but the 15 items became 15 per library, increasing the max-loans from 15 to 90 (6 times the 15 per college).That didn't make me too popular- but it did take some months for the problem to be noticed. I have re-imposed the circcontrol setting to "the library the member is from" to ensure sensible loans maxima, but now maxed out users can't borrow a laptop. There are no users registered at the Learning Zone as all users have a "home college" which is the library they are registered at. With the changes to circcontrol undone in our LIVE system I can continue to test out ideas in our TEST one before rolling them out to the live environment. In October my testing on **one** library plus the Learning Zone in TEST showed the desired functionality was perfect so I rolled it out to LIVE. I did not test multiple libraries and I should have. Any suggestions as to how I can set Koha up to offer what I have been asked to provide would be most appreciated. Ray Delahunty University of the Arts London Koha 16.05 https://libsearch.arts.ac.uk This email and any attachments are intended solely for the addressee and may contain confidential information. If you are not the intended recipient of this email and/or its attachments you must not take any action based upon them and you must not copy or show them to anyone. Please send the email back to us and immediately and permanently delete it and its attachments. Where this email is unrelated to the business of University of the Arts London or of any of its group companies the opinions expressed in it are the opinions of the sender and do not necessarily constitute those of University of the Arts London (or the relevant group company). Where the sender's signature indicates that the email is sent on behalf of UAL Short Courses Limited the following also applies: UAL Short Courses Limited is a company registered in England and Wales under company number 02361261. Registered Office: University of the Arts London, 272 High Holborn, London WC1V 7EY

1 0

Koha 3.22.17 release
by Julian Maurice 20 Feb '17

20 Feb '17

The Koha community is proud to announce the release of Koha 3.22.17. This is a maintenance release and contains several bugfixes. The full release notes are available at https://koha-community.org/koha-3-22-17-release/

4 5