- Koha - lists.katipo.co.nz

problem Installing koha on ubuntu 12.04
by Subhranil Bhattacharyya 23 Feb '17

23 Feb '17

Dear sir, I have some problem during KOHA installation, i am using Ubuntu 12.04 desktop-i386, when i am writing the terminal, sudo apt-get install koha common, its shows following error messege root@koha-H81M-WW:/home/koha# sudo apt-get install koha-common Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help to resolve the situation: The following packages have unmet dependencies: koha-common : Depends: libarchive-extract-perl but it is not installable Depends: libgd-perl but it is not installable Depends: libsereal-decoder-perl but it is not installable Depends: libsereal-encoder-perl but it is not installable E: Unable to correct problems, you have held broken packages. root@koha-H81M-WW:/home/koha# sudo apt-get install -f Reading package lists... Done Building dependency tree Reading state information... Done 0 upgraded, 0 newly installed, 0 to remove and 2 not upgraded. root@koha-H81M-WW:/home/koha# sudo apt-get install koha common Reading package lists... Done Building dependency tree Reading state information... Done E: Unable to locate package koha E: Unable to locate package common root@koha-H81M-WW:/home/koha# please give my suggesion, what can I do

4 3

Having two servers for Koha - Database and Application server
by Admire Mutsikiwa 23 Feb '17

23 Feb '17

Hi I would like to enquire if it is possible to implement Koha on two servers , with one server as the Database server running Mysql Database and another as the application server running Koha. I will appreciate any pointers on how to have such a setup/ Kind Regards, Admire Mutsikiwa (Mr) ICT Manager Libraries University of Zimbabwe Tel:+263-4-303276 Mob:+263771117777 "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>

2 1

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