Re: [Koha] Report Help
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: manojmisrasrm...@gmail.com On Thu, Apr 10, 2014 at 2:06 AM, Chitralekha [via Koha] ml-node+s1045719n5793620...@n5.nabble.com wrote: Please try this SQL report. This is sorted by count. SELECT CONCAT('a href=\/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\',biblio.biblionumber,'/a') AS biblionumbers, biblio.author, biblio.title, COUNT(items.itemnumber) AS ItemCount, ccode, itype FROM items LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber) GROUP BY items.biblionumber HAVING (COUNT(*)=1) ORDER BY ItemCount DESC On Sat, Apr 5, 2014 at 2:01 PM, manoj382093 [via Koha] [hidden email]http://user/SendEmail.jtp?type=nodenode=5793620i=0 wrote: Dear Friends, I am looking for a report which has list of titles(biblio) their number of copies(items) by item type and collection code. -- If you reply to this email, your message will be added to the discussion below: http://koha.1045719.n5.nabble.com/Report-Help-tp5793161.html To unsubscribe from Koha-general, click here. NAMLhttp://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml -- If you reply to this email, your message will be added to the discussion below: http://koha.1045719.n5.nabble.com/Report-Help-tp5793161p5793620.html To unsubscribe from Report Help, click herehttp://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=5793161code=bWFub2prdW1hcm1pc3JhQGdtYWlsLmNvbXw1NzkzMTYxfC0xMDkzNzg1MDg0 . NAMLhttp://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml -- View this message in context: http://koha.1045719.n5.nabble.com/Report-Help-tp5793161p5793704.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
Re: [Koha] Report Help
Thank you very much Katelyn, it worked. *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: manojmisrasrm...@gmail.com On Fri, Apr 11, 2014 at 4:48 AM, Katelyn Browne [via Koha] ml-node+s1045719n5793778...@n5.nabble.com wrote: Liz's report should do what you want if you change the GROUP BY to say GROUP BY biblionumber, i.itype. (That will list, say, the 14 copies of Book A that are type x, then the 3 copies that are type y. If you'd rather have all the type x's list together, then all the type y's, just change the order: GROUP BY i.itype, biblionumber). --Katelyn. Katelyn Browne Middle/High School Librarian Capital City Public Charter School 100 Peabody Street NW Washington, DC 20011 (202) 387-0309 x1745 [hidden email] http://user/SendEmail.jtp?type=nodenode=5793778i=0 http://www.ccpcs.org/library/ On Fri, Apr 11, 2014 at 3:47 AM, manoj382093 [hidden email]http://user/SendEmail.jtp?type=nodenode=5793778i=1wrote: 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=5793778i=2 On Thu, Apr 10, 2014 at 2:06 AM, Chitralekha [via Koha] [hidden email] http://user/SendEmail.jtp?type=nodenode=5793778i=3 wrote: Please try this SQL report. This is sorted by count. SELECT CONCAT('a href=\/cgi-bin/koha/catalogue/ detail.pl?biblionumber= ',biblio.biblionumber,'\',biblio.biblionumber,'/a') AS biblionumbers, biblio.author, biblio.title, COUNT(items.itemnumber) AS ItemCount, ccode, itype FROM items LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber) GROUP BY items.biblionumber HAVING (COUNT(*)=1) ORDER BY ItemCount DESC On Sat, Apr 5, 2014 at 2:01 PM, manoj382093 [via Koha] [hidden email] http://user/SendEmail.jtp?type=nodenode=5793620i=0 wrote: Dear Friends, I am looking for a report which has list of titles(biblio) their number of copies(items) by item type and collection code. -- If you reply to this email, your message will be added to the discussion below: http://koha.1045719.n5.nabble.com/Report-Help-tp5793161.html To unsubscribe from Koha-general, click here. NAML http://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml -- If you reply to this email, your message will be added to the discussion below: http://koha.1045719.n5.nabble.com/Report-Help-tp5793161p5793620.html To unsubscribe from Report Help, click here . NAML http://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml -- View this message in context: http://koha.1045719.n5.nabble.com/Report-Help-tp5793161p5793704.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org [hidden email] http://user/SendEmail.jtp?type=nodenode=5793778i=4 http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org [hidden email] http://user/SendEmail.jtp?type=nodenode=5793778i=5 http://lists.katipo.co.nz/mailman/listinfo/koha -- If you reply to this email, your message will be added to the discussion below: http://koha.1045719.n5.nabble.com/Report-Help-tp5793161p5793778.html To unsubscribe from Report Help, click herehttp://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=5793161code=bWFub2prdW1hcm1pc3JhQGdtYWlsLmNvbXw1NzkzMTYxfC0xMDkzNzg1MDg0 . NAMLhttp://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase
Re: [Koha] Report Help
Thanks Liz, it is working but i want list with specific item type and collection code. As the bib record may be attached to more than 1 item type so it should be distinct. *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: manojmisrasrm...@gmail.com On Sun, Apr 6, 2014 at 5:09 PM, Liz Rea-3 [via Koha] ml-node+s1045719n579322...@n5.nabble.com wrote: Give this a try: SELECT b.title, count(i.itemnumber) AS number of items, i.itype, i.ccode FROM biblio b JOIN items i USING(biblionumber) GROUP BY b.biblionumber If it works you can add it to the report library. ;) Cheers, Liz Rea Catalyst IT On 05/04/14 21:31, manoj382093 wrote: Dear Friends, I am looking for a report which has list of titles(biblio) their number of copies(items) by item type and collection code. -- View this message in context: http://koha.1045719.n5.nabble.com/Report-Help-tp5793161.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org [hidden email] http://user/SendEmail.jtp?type=nodenode=5793227i=0 http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org [hidden email] http://user/SendEmail.jtp?type=nodenode=5793227i=1 http://lists.katipo.co.nz/mailman/listinfo/koha -- If you reply to this email, your message will be added to the discussion below: http://koha.1045719.n5.nabble.com/Report-Help-tp5793161p5793227.html To unsubscribe from Report Help, click herehttp://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=5793161code=bWFub2prdW1hcm1pc3JhQGdtYWlsLmNvbXw1NzkzMTYxfC0xMDkzNzg1MDg0 . NAMLhttp://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml -- View this message in context: http://koha.1045719.n5.nabble.com/Report-Help-tp5793161p5793244.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] Report Help
Dear Friends, I am looking for a report which has list of titles(biblio) their number of copies(items) by item type and collection code. -- View this message in context: http://koha.1045719.n5.nabble.com/Report-Help-tp5793161.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
Re: [Koha] Report Help
Dear Arslan, I could not find it there *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: manojmisrasrm...@gmail.com On Sat, Apr 5, 2014 at 12:39 AM, arslan [via Koha] ml-node+s1045719n5793162...@n5.nabble.com wrote: Hi, Did you have a look in 5 Catalog/Bibliographic Reports here?: http://wiki.koha-community.org/wiki/SQL_Reports_Library Arslan ___ Koha mailing list http://koha-community.org [hidden email] http://user/SendEmail.jtp?type=nodenode=5793162i=0 http://lists.katipo.co.nz/mailman/listinfo/koha -- If you reply to this email, your message will be added to the discussion below: http://koha.1045719.n5.nabble.com/Report-Help-tp5793161p5793162.html To unsubscribe from Report Help, click herehttp://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=5793161code=bWFub2prdW1hcm1pc3JhQGdtYWlsLmNvbXw1NzkzMTYxfC0xMDkzNzg1MDg0 . NAMLhttp://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml -- View this message in context: http://koha.1045719.n5.nabble.com/Report-Help-tp5793161p5793169.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
Re: [Koha] Sorting of accession numbers
Dear Friends, Is there no way we can do it by SQL Command in report writing. *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: manojmisrasrm...@gmail.com On Sat, Mar 29, 2014 at 4:34 AM, Jerwyn Fernandez [via Koha] ml-node+s1045719n5792600...@n5.nabble.com wrote: Hi Manoj, Maybe what you are try to say, you want to export your generated report arranged by barcode? Am I right? In that case you may edit your data through excel. *Steps* Step 1 Highlight the whole column of the barcode Step 2 click cnrt+H Step 3 Find what = A Replace with = *note leave it blank click Replace All (so that you can remove the A symbol) Step 4 Go to *Data* and sort your column to A - Z Step 5 Make a new column beside the barcode column then type =A(the column with the number 1) then press enter and then drag the formula to put A back Regards, - Jerwyn On Sat, Mar 29, 2014 at 12:20 PM, manoj382093 [hidden email]http://user/SendEmail.jtp?type=nodenode=5792600i=0wrote: Dear Friends, I have used alphabets in barcode numerbers for different item types, now when i have generated the accession register sorted by barcode it sort like A1, A11, A12, A21.. etc instead of A1,A2,A3,A4. Please help! Manoj Kumar Misra -- View this message in context: http://koha.1045719.n5.nabble.com/Sorting-of-accession-numbers-tp5792591.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org [hidden email] http://user/SendEmail.jtp?type=nodenode=5792600i=1 http://lists.katipo.co.nz/mailman/listinfo/koha -- Jerwyn G. Fernadez Basic Education Librarian Southville International School and Colleges ___ Koha mailing list http://koha-community.org [hidden email] http://user/SendEmail.jtp?type=nodenode=5792600i=2 http://lists.katipo.co.nz/mailman/listinfo/koha -- If you reply to this email, your message will be added to the discussion below: http://koha.1045719.n5.nabble.com/Sorting-of-accession-numbers-tp5792591p5792600.html To unsubscribe from Sorting of accession numbers, click herehttp://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=5792591code=bWFub2prdW1hcm1pc3JhQGdtYWlsLmNvbXw1NzkyNTkxfC0xMDkzNzg1MDg0 . NAMLhttp://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml -- View this message in context: http://koha.1045719.n5.nabble.com/Sorting-of-accession-numbers-tp5792591p5792647.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
Re: [Koha] Circulation and Fine Rules
Thank you friends *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: manojmisrasrm...@gmail.com On Tue, Mar 11, 2014 at 2:35 PM, vikram zadgaonkar-2 [via Koha] ml-node+s1045719n5790215...@n5.nabble.com wrote: Holger Meissne is correct. You need to define different circulation rules. Vikram Zadgaonkar On Tue, Mar 11, 2014 at 2:21 PM, Holger Meissner [hidden email] http://user/SendEmail.jtp?type=nodenode=5790215i=0 wrote: manoj382093 wrote: Dear Friends, I am testing latest version of koha for my library, I have set five item types for different courses and five different patron categories of these courses. I have set same course patron category with item type so that patrons cannot get books of other courses. but it is not working and patrons are getting issued all item types. Please help! Manoj Kumar Misra So you set a total of five issuing rules? Not defining rules does not prevent checkout. Instead the default issuing rules are applied. You could define five issuing rules for each course. One for the item type they are supposed to be able to borrow and four for the other item types, where you set Current checkouts allowed to zero. This still won't make checkout impossible, but you will get a warning asking you to confirm the checkout. Regards Holger ___ Koha mailing list http://koha-community.org [hidden email] http://user/SendEmail.jtp?type=nodenode=5790215i=1 http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org [hidden email] http://user/SendEmail.jtp?type=nodenode=5790215i=2 http://lists.katipo.co.nz/mailman/listinfo/koha -- If you reply to this email, your message will be added to the discussion below: http://koha.1045719.n5.nabble.com/Circulation-and-Fine-Rules-tp5789921p5790215.html To unsubscribe from Circulation and Fine Rules, click herehttp://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=5789921code=bWFub2prdW1hcm1pc3JhQGdtYWlsLmNvbXw1Nzg5OTIxfC0xMDkzNzg1MDg0 . NAMLhttp://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml -- View this message in context: http://koha.1045719.n5.nabble.com/Circulation-and-Fine-Rules-tp5789921p5790393.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] Circulation and Fine Rules
Dear Friends, I am testing latest version of koha for my library, I have set five item types for different courses and five different patron categories of these courses. I have set same course patron category with item type so that patrons cannot get books of other courses. but it is not working and patrons are getting issued all item types. Please help! Manoj Kumar Misra -- View this message in context: http://koha.1045719.n5.nabble.com/Circulation-and-Fine-Rules-tp5789921.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