[Koha] Dewey Number does not show up for Items even though available in 082a Tag.
Hello, I am working with Koha 3.14 on Ubuntu ( installed via packages) I have a strange behaviour, reg- class number display. I am updating Dewey Number in 082a field for a record. and after adding multiple items to the same record, items do not show up Dewey Class number in OPAC or in Normal View. I would like to know, why it is happening? For fixing this, I am doing, edit items in batch and updating dewey once again at full call number for all the items. then it displays in opac. How to avoid this ? Do we have any settings koha? with thanks. Satish MV Librarian Govt. Engineering College Hassan, Karnataka. -- ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Dewey Number does not show up for Items even though available in 082a Tag.
Please share screen shot to understand better. On 22-Apr-2014 5:16 PM, SATISH lis4sat...@gmail.com wrote: Hello, I am working with Koha 3.14 on Ubuntu ( installed via packages) I have a strange behaviour, reg- class number display. I am updating Dewey Number in 082a field for a record. and after adding multiple items to the same record, items do not show up Dewey Class number in OPAC or in Normal View. I would like to know, why it is happening? For fixing this, I am doing, edit items in batch and updating dewey once again at full call number for all the items. then it displays in opac. How to avoid this ? Do we have any settings koha? with thanks. Satish MV Librarian Govt. Engineering College Hassan, Karnataka. -- ___ 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] Empty shelves
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.
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
kbro...@ccpcs.org
http://www.ccpcs.org/library/
On Wed, Apr 16, 2014 at 11:40 AM, Paul A pau...@navalmarinearchive.comwrote:
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 mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Possible APP development
Viktor Sarge wrote: Ideas: * Automatically renew loans serverside when possible. Contact the patron through snailmail, e-mail or SMS when renewals are no longer possible and set a few days as grace period. * Create new rules that guarantees a patron a certain loan period but allows them to keep the book for as long as they like as long as no reserves are made. Contact the patron when somebody places a hold on the title with a ”Others have requested the book, and you now have X days to return it”. Our library also wants extended loans, that stop when a hold is placed. Not unlimited though, only up to a maximum loan period. We figured automatic renewals would do the job. I'll start writing a patch for an automatic renewal feature very soon: http://wiki.koha-community.org/wiki/Automatic_renewal_RFC Regards Holger ___ 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
However, as a librarian, cache makes more sense to me than reservoir ... As a practicing librarian 'reservoir' is a term that I am so used to ... I think this is a case where we are not going to find an intuitive single term because there are no broadly-experienced analogues. I think our best bet is to make sure the documentation is good, including improving in-page help if necessary. I don't think changing the term again is going to get us anywhere. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Empty shelves
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:kbro...@ccpcs.orgkbro...@ccpcs.org
http://www.ccpcs.org/library/
On Wed, Apr 16, 2014 at 11:40 AM, Paul A
mailto:pau...@navalmarinearchive.compau...@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.orghttp://koha-community.org
mailto:Koha@lists.katipo.co.nzKoha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/kohahttp://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
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Possible APP development
Hi all. Great to hear Holger! One thing I like about automatic renewals is that you can hook a cronjob into the existing rules and don’t have add any complexity to the circulation rules in the staff interface. I took a quick peek at the RFC and what I have to add is that you might want to ”allow/disallow” that the _patrons_ turn automatic renewals on/off in the opac. I think it in many cases would be more useful to let those that actually need/want the feature use it rather than all issues. At least that’s my view after pondering Tim and Elaines point about people misplacing books :) Another thing to add to the wishlist could be a message to send when an automatic renewal is made (defined in letter.pl). Something like ”Hi! The loan ’Learning Perl’ that was due today was automatically renewed and is now due date X. Kind regards/The Library” could help people remeber to keep track of their loans. I do like Tims idea about using automatic renewals for people with certain zipcodes, but I think it might be better to use it like ”Use rule X with all patrons meeting this criteria”. This could be useful for all sorts of granular permissions but seems (to me) like a quite big RFC in it’s own right. And it would create all sorts of interesting problems. Kind regards/Viktor Viktor Sarge Utvecklingsledare Regionbibliotek Halland Kultur i Halland TFN: 035-17 98 73 E-POST: viktor.sa...@regionhalland.semailto:viktor.sa...@regionhalland.se BESÖKSADRESS: Södra vägen 9, 30180 Halmstad WEBB: www.regionhalland.se/regionbibliotekhttp://www.regionhalland.se/regionbibliotek 22 apr 2014 kl. 15:15 skrev Holger Meissner holger.meiss...@hs-gesundheit.demailto:holger.meiss...@hs-gesundheit.de: Viktor Sarge wrote: Ideas: * Automatically renew loans serverside when possible. Contact the patron through snailmail, e-mail or SMS when renewals are no longer possible and set a few days as grace period. * Create new rules that guarantees a patron a certain loan period but allows them to keep the book for as long as they like as long as no reserves are made. Contact the patron when somebody places a hold on the title with a ”Others have requested the book, and you now have X days to return it”. Our library also wants extended loans, that stop when a hold is placed. Not unlimited though, only up to a maximum loan period. We figured automatic renewals would do the job. I'll start writing a patch for an automatic renewal feature very soon: http://wiki.koha-community.org/wiki/Automatic_renewal_RFC Regards Holger ___ 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] Dewey Number does not show up for Items even though available in 082a Tag.
Dear Sir I also face the same problem when I imported the bulk records. The only solution that time I found was to update the mrc file by editing tag number 082a with 952$o. I hope we can do the same thing from phpmyadmin directly by command, If anyone from the group helps. On Tue, Apr 22, 2014 at 5:19 PM, vikram zadgaonkar vikramczadgaon...@gmail.com wrote: Please share screen shot to understand better. On 22-Apr-2014 5:16 PM, SATISH lis4sat...@gmail.com wrote: Hello, I am working with Koha 3.14 on Ubuntu ( installed via packages) I have a strange behaviour, reg- class number display. I am updating Dewey Number in 082a field for a record. and after adding multiple items to the same record, items do not show up Dewey Class number in OPAC or in Normal View. I would like to know, why it is happening? For fixing this, I am doing, edit items in batch and updating dewey once again at full call number for all the items. then it displays in opac. How to avoid this ? Do we have any settings koha? with thanks. Satish MV Librarian Govt. Engineering College Hassan, Karnataka. -- ___ 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 -- *Regards * *Sandeep Bhavsar* B.com, M.Lib.I.Sc SET, M.Phil, American Library Association - FERA 2011 fellow Librarian Dr. V N Bedekar Institute of Management Studies Thane (W) 400601 Mumbai INDIA Mobile : 9987049099 www.vpmthane.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Dewey Number does not show up for Items even though available in 082a Tag.
Dear Satish, Tag 082a stores content of class number of bibliographic record. Tag 952o stores contens of class numbr of items attached to bibliographic record. At the time of import, it is advisble to import class number data at both tags, 082 and 952. This is a major reason that many times only catalogue record gets imported and item (holding) details such as class number are not imported. Further, all item details should appear in one single line record at the time of import using MARCEDIT. If it appears on separate line, item data on each line will be imported as separate item. -- Mr. Mahesh M. Angadi, Librarian, Model College, Dombivli (E). Contact No. 9869120258, (0251) 2470010. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Dewey Number does not show up for Items even though available in 082a Tag.
Perfect solution from Mahesh. I also think in same way. Vikram Zadgaonkar On Wed, Apr 23, 2014 at 11:19 AM, Mahesh Angadi mcdlibr...@gmail.comwrote: Dear Satish, Tag 082a stores content of class number of bibliographic record. Tag 952o stores contens of class numbr of items attached to bibliographic record. At the time of import, it is advisble to import class number data at both tags, 082 and 952. This is a major reason that many times only catalogue record gets imported and item (holding) details such as class number are not imported. Further, all item details should appear in one single line record at the time of import using MARCEDIT. If it appears on separate line, item data on each line will be imported as separate item. -- Mr. Mahesh M. Angadi, Librarian, Model College, Dombivli (E). Contact No. 9869120258, (0251) 2470010. ___ 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
