Re: [Koha] Report Help
Manojji, Your one book has one biblio record say biblionumber 1234. For this record in 942c tag (Koha [default] item type) you have entered / selected item type as BTECHBKS. If all 12 items are attached to this biblionumber the report will show 12 copies to BTECHBKS. Changing 952y item type for 4 attached items to BCABKS is not getting reflected in this report. I am sorry even I am not sure how to make entry of one biblio-record having different itemtypes. I will explore and let you know as soon as I get solution. Thanks and regards. Chitralekha Mahesh Chitale Librarian, Lokmanya Tilak College of Engineering, Navi Mumbai. On Fri, Apr 11, 2014 at 1:17 PM, manoj382093 [via Koha] ml-node+s1045719n5793704...@n5.nabble.com wrote: Dear Chitralekha, Take this example: I have one book with 12 copies, 8copies with item type BTECHBKS and 4 copies with item type BCABKS. When i generate report it shows 12 copies for itemtype BTECHBKS and none for BCABKS. Is there any way of reporting so that i can get the correct report or i would have to remove 4 copies and save it as different bib record. *Regards!* *Manoj Kumar Misra* M.Phil., M.L.I.Sc., B.L.I.Sc., M.Sc.(Phy), B.Sc. (P.C.M.) Deputy Librarian SRMGPC Lucknow Mob. No.: 09415422579 Alternate E-mail: [hidden email]http://user/SendEmail.jtp?type=nodenode=5793704i=0 -- View this message in context: http://koha.1045719.n5.nabble.com/Report-Help-tp5793161p5794300.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
[Koha] What is a reservoir
Greetings, What is a reservoir and the name of reservoir's file ? (Koha 3.14.) Gennady ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] What is a reservoir
zolot wrote: What is a reservoir and the name of reservoir's file ? (Koha 3.14.) I think it's a pool of records previously downloaded from z39.50 partners or uploaded from a MARC file. It's not controlled or kept in any one file. Other koha users: should this been in the manual? I didn't spot it there. -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op http://koha-community.org supporter, web and library systems developer. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire (including development) at http://www.software.coop/ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] What is a reservoir
There is a small reference on http://manual.koha-community.org/3.14/en/managestaged.html -- Bernardo Gonzalez Kriegel bgkrie...@gmail.com On Wed, Apr 16, 2014 at 7:43 AM, MJ Ray m...@phonecoop.coop wrote: zolot wrote: What is a reservoir and the name of reservoir's file ? (Koha 3.14.) I think it's a pool of records previously downloaded from z39.50 partners or uploaded from a MARC file. It's not controlled or kept in any one file. Other koha users: should this been in the manual? I didn't spot it there. -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op http://koha-community.org supporter, web and library systems developer. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire (including development) at http://www.software.coop/ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] What is a reservoir
I remember ~years~ ago in the early days of Koha, we had a discussion about what to call this pool of records. I think reservoir may have been my suggestion, but I've never been happy with that term. There must be a better, more descriptive term. Stephen On Wed, Apr 16, 2014 at 7:09 AM, Bernardo Gonzalez Kriegel bgkrie...@gmail.com wrote: There is a small reference on http://manual.koha-community.org/3.14/en/managestaged.html -- Bernardo Gonzalez Kriegel bgkrie...@gmail.com On Wed, Apr 16, 2014 at 7:43 AM, MJ Ray m...@phonecoop.coop wrote: zolot wrote: What is a reservoir and the name of reservoir's file ? (Koha 3.14.) I think it's a pool of records previously downloaded from z39.50 partners or uploaded from a MARC file. It's not controlled or kept in any one file. Other koha users: should this been in the manual? I didn't spot it there. -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op http://koha-community.org supporter, web and library systems developer. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire (including development) at http://www.software.coop/ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] What is a reservoir
I remember this being very cryptical in the beginning, fleshing out this section of the manual seems like a good idea. The thing that was really weird to me was that Koha keeps records from earlier Z39.50 searches. It took me a while to figure out why I sometimes saw records for books I knew I didn't have (but had shown up in Z39.50 searches). Kind regards/Viktor -Ursprungligt meddelande- Från: Koha [mailto:koha-boun...@lists.katipo.co.nz] För Bernardo Gonzalez Kriegel Skickat: den 16 april 2014 13:10 Till: MJ Ray Kopia: koha Ämne: Re: [Koha] What is a reservoir There is a small reference on http://manual.koha-community.org/3.14/en/managestaged.html -- Bernardo Gonzalez Kriegel bgkrie...@gmail.com On Wed, Apr 16, 2014 at 7:43 AM, MJ Ray m...@phonecoop.coop wrote: zolot wrote: What is a reservoir and the name of reservoir's file ? (Koha 3.14.) I think it's a pool of records previously downloaded from z39.50 partners or uploaded from a MARC file. It's not controlled or kept in any one file. Other koha users: should this been in the manual? I didn't spot it there. -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op http://koha-community.org supporter, web and library systems developer. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire (including development) at http://www.software.coop/ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Empty shelves
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
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Call for news for April Newsletter
Fellow Koha users ~ We're collecting news for the April newsletter. Send anything noteworthy to: k o h a news AT gmail dot com News criteria: --- * News items can be of any length. * Anything and everything Koha. * Submit by the 26th. If you are working on an interesting project or development related to Koha, please let us know and we'll include in the gossip/society section. -- Chad Roseburg Joanne Dillon Editors, Koha Newsletter ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] possible error at ACQ module
Hi, Is it a bug? I am using Koha 3.14.5 under Ubuntu 12.04. Create New order, from Home › Acquisitions › vendorname(碩陽數位科技有限公司) › Basket 1 › New order Quantity is required. But I could not move cursor to Quantity field box. Koha reply as: - Quantity must be greater than '0' Do I make something wrong? -- Wishing you all the best. . . . Anthony Mao 毛慶禎 ＋886 2 29052334 (voice) + 886 2 29017405 (FAX) ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] possible error at ACQ module
Hi Anthony, Chances are good that you need to add item information and click the add button to add an item to your order. Cheers, Liz Rea Catalyst IT. On 17/04/14 14:43, Anthony Mao wrote: Hi, Is it a bug? I am using Koha 3.14.5 under Ubuntu 12.04. Create New order, from Home › Acquisitions › vendorname(碩陽數位科技有限公司) › Basket 1 › New order Quantity is required. But I could not move cursor to Quantity field box. Koha reply as: - Quantity must be greater than '0' Do I make something wrong? ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] possible error at ACQ module
Hi Liz, I got it. 2014-04-17 10:48 GMT+08:00 Liz Rea l...@catalyst.net.nz: Hi Anthony, Chances are good that you need to add item information and click the add button to add an item to your order. Cheers, Liz Rea Catalyst IT. On 17/04/14 14:43, Anthony Mao wrote: Hi, Is it a bug? I am using Koha 3.14.5 under Ubuntu 12.04. Create New order, from Home › Acquisitions › vendorname(碩陽數位科技有限公司) › Basket 1 › New order Quantity is required. But I could not move cursor to Quantity field box. Koha reply as: - Quantity must be greater than '0' Do I make something wrong? ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Wishing you all the best. . . . Anthony Mao 毛慶禎 ＋886 2 29052334 (voice) + 886 2 29017405 (FAX) ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
