- Koha - lists.katipo.co.nz

Re: [Koha] Empty shelves
by Paul A 22 Apr '14

22 Apr '14

At 08:57 AM 4/22/2014 -0400, Katelyn Browne wrote: >Hi Paul, >Not sure if you've solved this yet--we've been on spring break! I got your >report to work by changing the order of the tables joined together. By >pulling from authorised_values first (and joining everything to that), you >get all possible location values rather than just the ones that appear in >biblioitems. Hi Katelyn, Many thanks for your reply. With a little assistance and some refining, we ended up with a good working solution (in fact biblioitems was an unnecessary complication) : SELECT authorised_value AS Auth_Location, COUNT(items.itemnumber) FROM authorised_values LEFT JOIN items ON (authorised_values.authorised_value=items.location) WHERE authorised_values.category LIKE 'loc' GROUP BY authorised_value HAVING COUNT(DISTINCT(items.itemnumber))=0; Best regards and again thanks, Paul >Here's a report that worked for me: > >SELECT authorised_values.authorised_value AS Auth_Location, >COUNT(DISTINCT biblioitems.biblionumber) as Quantity >FROM authorised_values >LEFT JOIN items ON (authorised_values.authorised_value=items.location) >LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) >WHERE authorised_values.category LIKE 'loc' >GROUP BY authorised_values.authorised_value HAVING COUNT(DISTINCT >biblioitems.biblionumber)=0 > >--Katelyn. > > >Katelyn Browne >Middle/High School Librarian >Capital City Public Charter School >100 Peabody Street NW >Washington, DC 20011 >(202) 387-0309 x1745 ><mailto:kbrowne@ccpcs.org>kbrowne(a)ccpcs.org >http://www.ccpcs.org/library/ > > >On Wed, Apr 16, 2014 at 11:40 AM, Paul A ><<mailto:paul.a@navalmarinearchive.com>paul.a(a)navalmarinearchive.com> wrote: >Help requested, please -- the MySQL part of my brain is obviously not at >the right caffeine level. > >Over the years, we have used a lot of "shelves" (authorized values, mostly >temporary boxes) and now I need to identify the "empty" ones as a >cleanup/caretaking excercise. > >The following SQL query works syntactically, and finds any shelf with at >least one item: > >SELECT authorised_values.authorised_value AS Auth_Location, >COUNT(DISTINCT biblioitems.biblionumber) as Quantity >FROM biblioitems >LEFT JOIN items ON (items.biblioitemnumber=biblioitems.biblioitemnumber) >LEFT JOIN authorised_values ON >(authorised_values.authorised_value=items.location) >WHERE authorised_values.category LIKE 'loc' >GROUP BY authorised_values.authorised_value HAVING COUNT(DISTINCT >biblioitems.biblionumber)>0; > >but if I change the final >0 to =0 it fails to find any empty box ;={ > >I'm sort-of convinced that this comes from JOINing the >authorised_values.authorised_value to the items.location (obviously that >location no longer exists in items), but am going in circles looking for >an alternate method. > >Thanks in advance -- Paul > > >_______________________________________________ >Koha mailing list <http://koha-community.org>http://koha-community.org ><mailto:Koha@lists.katipo.co.nz>Koha(a)lists.katipo.co.nz ><http://lists.katipo.co.nz/mailman/listinfo/koha>http://lists.katipo.co.nz/mailman/listinfo/koha > --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://NavalMarineArchive.com> and <http://UltraMarine.ca>

1 0

Empty shelves
by Paul A 22 Apr '14

22 Apr '14

Help requested, please -- the MySQL part of my brain is obviously not at the right caffeine level. Over the years, we have used a lot of "shelves" (authorized values, mostly temporary boxes) and now I need to identify the "empty" ones as a cleanup/caretaking excercise. The following SQL query works syntactically, and finds any shelf with at least one item: SELECT authorised_values.authorised_value AS Auth_Location, COUNT(DISTINCT biblioitems.biblionumber) as Quantity FROM biblioitems LEFT JOIN items ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN authorised_values ON (authorised_values.authorised_value=items.location) WHERE authorised_values.category LIKE 'loc' GROUP BY authorised_values.authorised_value HAVING COUNT(DISTINCT biblioitems.biblionumber)>0; but if I change the final >0 to =0 it fails to find any empty box ;={ I'm sort-of convinced that this comes from JOINing the authorised_values.authorised_value to the items.location (obviously that location no longer exists in items), but am going in circles looking for an alternate method. Thanks in advance -- Paul

2 1

SQL Report..
by Jerwyn Fernandez 22 Apr '14

22 Apr '14

Good day! I would like to make an SQL report that can provide me the follow information: Barcode (952$p) Title(245$a) Remainder of the Title(245$b) Author(245$c) Target Audience Note((521$a) Reading Level(526$c) Call Number Prefix(942$k) Is there anyone can help me with my dilemma. I am looking forward regarding with this matter. Thank you, *BE AMAZING. BE SOUTHVILLE.* Jerwyn G. Fernadez, RL Basic Education Librarian Southville International School and Colleges Tel: 825-6374 loc.117/146 *Like us https://www.facebook.com/sisc.monarchs <https://www.facebook.com/sisc.monarchs>* *Follow us https://twitter.com/SISCMonarchs <https://twitter.com/SISCMonarchs>* * www.southville.edu.ph <http://www.southville.edu.ph/>* * https://www.youtube.com/watch?v=CEeXh3JyXRg <https://www.youtube.com/watch?v=CEeXh3JyXRg>* *http://library.southville.edu.ph*<http://library.southville.edu.ph>

1 0

Get Listed Paid Support Request
by Carlos Rodrigo Cordova Sandoval 22 Apr '14

22 Apr '14

*Company Name: Open Geek Service* *Contact Person: Carlos Córdova* *Contact email: ccordova(a)opengeek.cl <ccordova(a)opengeek.cl>* *Website: http://www.opengeekservice.cl <http://www.opengeekservice.cl/>* *Telephone: *+569 6668 32 94 *Address: Don luis manuel de zañartu 567, Puente Alto. Chile* *Short description of your services: We have two strong lines, one of them is the OPAC software, and the other, infraestructure and platform services based on Red Hat portfolio products.* *We work with VuFind and KOHA, and we implemented catalogs and services of these products in Chile, South America.* *http://www.opengeekservice.cl/sitio/bibliotecas/koha.html <http://www.opengeekservice.cl/sitio/bibliotecas/koha.html>* -- -Carlos

2 1

we want alert system for new edition of books
by Ashok Gangurde 21 Apr '14

21 Apr '14

Dear sir, We have a list of books in excel format. we want update or check the latest edition of particular books frequently. There is any software or online website it will give us an alert system that new edition came in the market. kindly do the needful Thanks Ashok Gangurde

2 1

Koha installation on Ubuntu 14.04 LTS
by Vimal Kumar V. 20 Apr '14

20 Apr '14

Dear Friends, I made an attempt to install Koha on Ubuntu 14.04. I got following messages after executing the command apt-get install koha-common. I invite your help to interpret the message. Setting up libapache2-mpm-itk (2.4.6-01-1) ... dpkg: error processing package libapache2-mpm-itk (--configure): subprocess installed post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of apache2-mpm-itk: apache2-mpm-itk depends on libapache2-mpm-itk; however: Package libapache2-mpm-itk is not configured yet. dpkg: error processing package apache2-mpm-itk (--configure): dependency problems - leaving unconfigured dpkg: dependency problems prevent configuration of koha-common: No apport report written because the error message indicates its a followup error from a previous failure. koha-common depends on apache2-mpm-itk; however: Package apache2-mpm-itk is not configured yet. dpkg: error processing package koha-common (--configure): dependency problems - leaving unconfigured No apport report written because the error message indicates its a followup error from a previous failure. Errors were encountered while processing: libapache2-mpm-itk apache2-mpm-itk koha-common E: Sub-process /usr/bin/dpkg returned an error code (1) Regards, -- Vimal Kumar V. Technical Assistant Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.info Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in http://moovandan.blogspot.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

3 2

Koha installation on Ubuntu 14.04 LTS
by Vimal Kumar V. 19 Apr '14

19 Apr '14

Dear Friends, I made an attempt to install Koha on Ubuntu 14.04. I got following messages after executing the command apt-get install koha-common. I invite your help to interpret the message. Setting up libapache2-mpm-itk (2.4.6-01-1) ... dpkg: error processing package libapache2-mpm-itk (--configure): subprocess installed post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of apache2-mpm-itk: apache2-mpm-itk depends on libapache2-mpm-itk; however: Package libapache2-mpm-itk is not configured yet. dpkg: error processing package apache2-mpm-itk (--configure): dependency problems - leaving unconfigured dpkg: dependency problems prevent configuration of koha-common: No apport report written because the error message indicates its a followup error from a previous failure. koha-common depends on apache2-mpm-itk; however: Package apache2-mpm-itk is not configured yet. dpkg: error processing package koha-common (--configure): dependency problems - leaving unconfigured No apport report written because the error message indicates its a followup error from a previous failure. Errors were encountered while processing: libapache2-mpm-itk apache2-mpm-itk koha-common E: Sub-process /usr/bin/dpkg returned an error code (1) Regards, -- Vimal Kumar V. Technical Assistant Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.info Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in http://moovandan.blogspot.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

1 0

Auto zebra update: /etc/cron.d/koha-common
by andrea.furin＠slacky.it 19 Apr '14

19 Apr '14

Hi to all. It seems that /etc/cron.d/koha-common doesn't work: I changed the line in this: */5 * * * * esg-koha esg -x /usr/sbin/koha-rebuild-zebra ETC.. esg-koha: my koha user esh: my database name but nothing happens. Some advices? Thanks in advance Andrea Furin

2 1

Cannot place hold
by Anthony Mao 19 Apr '14

19 Apr '14

Hi, I need your help. I can not place hold from staff interface at 3.14.5 At staff interface, from Home › Catalog find particular item which I try to hold, but Koha reply as: Cannot place hold Too many holds: mao has too many holds. mao is reader name. In fact this is the first hold for mao. I check the Holds Policy at Home › Administration › System preferences. set maxreserves as Patrons can only have 10 holds at once. -- Wishing you all the best. . . . Anthony Mao 毛慶禎＋886 2 29052334 (voice) + 886 2 29017405 (FAX)

2 2

Request to add as KOHA PAID SUPPORT PROVIDER
by vikrant malik 18 Apr '14

18 Apr '14

Dear community, We request you to add our organization in the paid support list,in our State we are providing support and service to KOHA library management system please find the information. *Company Name:* jivesna tech pvt. ltd *Contact Person:* utsav rai, *Contact email:* utsav(a)jivesna.com, info(a)jivesna.com *Website:* http://www.jivesna.com/ *Telephone:* 91-0120-4266526, +91-8860611657,9654093042 *Address:* A/209, Sector -17, Vasundhara, Ghaziabad (u.p) 201012, India *Short description of your services:* Our Koha support includes - Training for all major updates to Koha’s functionality via online training or training in person. - installation and customization for koha - - Technical consulting and Solutions. - User training at 3-levels (User, Librarian and Administrator). - Solutions for Data Migration. - Solutions for Networking of Libraries. -- Best regard's vikrant malik +91-9555927211 Jivesna Tech Pvt.Ltd. www.jivesna.com

2 1