Re: [Koha] SQL Report-Circulation-- Help
Dear All, Currently i am using Koha version 3.12.10.000. and i am having two branch libraries. I am looking in SQL report to generate the books details with the following details. 1. Title of the book 2. Author 3. Publisher 4. Place of Publication and year 5. Name of the vendor 6. Invoice No and Date 7. Price 8. Withdrawn status Kindly guide to get the report. Thanks Pandu. +91-8978002982 On Wed, Feb 22, 2017 at 3:35 PM, SATISH <lis4sat...@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 <> and > <> 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@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > -- M.Pandu Rangaswamy H.T.Parekh Library Institute For Financial Management and Research (IFMR) 24, Kothari Road, Chennai - 600 034 INDIA Tel - 91-44-2830 3498 Mobile: 08978002982 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha 3.14.0 released
Dear All, Congratulations friends. Pandu On Thu, Nov 21, 2013 at 6:30 PM, Tomas Cohen Arazi tomasco...@gmail.comwrote: Congratulations for such a great release Galen! To+ On Thu, Nov 21, 2013 at 1:48 AM, Galen Charlton g...@esilibrary.com wrote: Hi, The Koha community is pleased to announce the release of version 3.14.0 of the Koha library automation system. Koha 3.14.0 is a major functionality release that includes various new features, including: * A new default theme, “Bootstrap”, for the public catalog interface. The Bootstrap theme provides a reponsive design that works well both for desktop web browsers and mobile devices. * A new course reserves module. * A new offline circulation module that is entirely browser-based. * A revamp of the serials predication system which allows for significantly more flexibility in managing patterns. * The ability to create lists of patrons. * The ability to search for items to check out by keyword rather than barcode. * The ability to overlay item records during batch imports. * The ability to define rules (called MARC modification templates) for batch-modifying MARC records during import. * Numerous acquisitions workflow improvements, including the ability to move orders from one vendor to another, search acquisitions history, merge duplicate invoices, and get warnings if a new order would over-commit a fund. * Cataloging improvements including the ability to import authority record via Z39.50, the ability to merge authority records, and the ability to save and continue editing bib records. * Support for schema.org microdata in the OPAC to increase the visibility of your catalog to search engines. There are also a number of under-the-hood improvements, including * Zebra DOM filter support for UNIMARC bib and authority records. * The introduction of an ORM, DBIx::Class. * Significantly improved unit test coverage. And, as always, there are numerous bugfixes and minor improvements. Koha can be downloaded from http://download.koha-community.org. Debian packages of Koha 3.14.0 will be available shortly. As release manager for Koha 3.14, I would like to thank everybody who contributed patches, documentation, testing, moral support, money, and time to the effort. Koha users both old and new should find 3.14 a tasty piece of π indeed. Additional details, including the release notes, can be found at http://koha-community.org/koha-3-14-0-released/ 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 -- Tomás Cohen Arazi Prosecretaría de Informática Universidad Nacional de Córdoba ✆ +54 351 4333190 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 -- M.Pandu Rangaswamy H.T.Parekh Library Institute For Financial Management and Research (IFMR) 24, Kothari Road, Chennai - 600 034 INDIA Tel - 91-44-2830 3498 Mobile: 08807679789 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha error
Dear All, I tried to import the data(Books) from the existing koha 3.0 version to Koha version 3.10 in ubuntu 12.4. When i searched it shows only Books Biblios data only, its not showing the item details. Then i did undo the imported data, after that if i search again it shows 116 books. if i tried to edit record it shows the following error. Software error: Can't call method title on an undefined value at /usr/share/koha/intranet/cgi-bin/cataloguing/addbiblio.pl line 815. For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error. Kindly guide me to slow the error. With records M.Pandu Rangaswamy ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Fwd:
http://www.tassinionline.it/r4viz7.php?s=lf ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha Upgrade
Dear All, We are using Koha version: 3.00.05.003 Acquisitions Module, ILL Suggestions/ Pending suggestions we are getting nearly 1000-1500 blogs Please someone guide us. Advance thanks Pandu On Fri, Jan 18, 2013 at 4:24 PM, mifantrax mihai.bojo...@tcmi.edu wrote: HI all, i need your help. I am very new to koha. I have inherited a koha installation version 2.~ with many problems on the server, old version of ubuntu, full disk, and other issues. I have installed a new vm vith koha 3.8 on proxmox and seems to work perfect, however i would like to migrate the old database to the new instalation, is there a beginners way to do that ? Will exporting and importing the marcs work ? Are there any other config files that need to be migrated ? Is there a guide somewhere ? I have been searching the wiki and i was not able to find it. Please someone guide us in the right direction. Thanks -- View this message in context: http://koha.1045719.n5.nabble.com/Koha-Upgrade-tp5739511.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 -- M.Pandu Rangaswamy H.T.Parekh Library Institute For Financial Management and Research (IFMR) 24, Kothari Road, Chennai - 600 034 INDIA Tel - 91-44-2830 3498 Mobile: 08807679789 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha upgrade version
Dear all, I am running Koha 3.00.05.003 on Linux, Perl interpreter: /usr/local/bin/perl Pear Version 5.010001, Pearl @ INC /usr/share/koha/lib /usr/local/lib/perl5/5.10.1/i686-linux /usr/local/lib/perl5/5.10.1 /usr/local/lib/perl5/site_perl/5.10.1/i686-linux /usr/local/lib/perl5/site_perl/5.10.1 My SQL Version: mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (i686) using readline 5.0 Apache Version: Server version: Apache/2.2.3 Server built: Jan 21 2009 22:01:41 and would like to upgrade to the latest version 3.8. Can someone provide me a guide to complete this task? Thank you Pandu. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha error
Sir Iam using Koha (V.3.00.05.003) software in our library, present we are using only one ID PW for all the modules(Like Acquision, Calalogue, Circulation etc), some times it creates problems, please guide me 1. How can we creat seperate ID PW for each module. 2. How can we creat the ID PW for Patrons, it helps themself can check their record and renew the borrowed documents. regards Pandu. -- View this message in context: http://koha.1045719.n5.nabble.com/Koha-error-tp5720900.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