On how to create a report
Hey guys, My question is how can I create a report to know how many books were cataloged from Jan till now (or any other time period)? I have tried, but I find that the manual is not clear enough on this. all the reports I created were not able to give me this info.... Thanks [I still have 3.10 version, and NO I can't changed it now, so any help will be much appreciated] Thank you, -- View this message in context: http://koha.1045719.n5.nabble.com/On-how-to-create-a-report-tp5859353.html Sent from the Koha-general mailing list archive at Nabble.com.
Hello Paste the following program in reports. SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',items.biblionumber,'\">',biblio.title,'</a>') AS Title, biblio.author AS Author, items.barcode AS Barcode FROM items LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber) WHERE DATE(items.dateaccessioned) BETWEEN <<Accessioned BETWEEN (yyyy-mm-dd)>> AND <<and (yyyy-mm-dd)>> I hope this will give the results you expect. For more reports visit http://wiki.koha-community.org/wiki/SQL_Reports_Library#Catalog.2FBibliograp... Mrs. Chitralekha Mahesh Chitale Librarian, LTCE, Navi Mumbai. ----- Original Message ----- From: "catarinafrc [via Koha]" <ml-node+s1045719n5859353h45@n5.nabble.com> To: "Chitralekha Chitale" <library.ltce@ltjss.net> Sent: Friday, October 30, 2015 1:44:43 PM Subject: On how to create a report Hey guys, My question is how can I create a report to know how many books were cataloged from Jan till now (or any other time period)? I have tried, but I find that the manual is not clear enough on this. all the reports I created were not able to give me this info.... Thanks [I still have 3.10 version, and NO I can't changed it now, so any help will be much appreciated] Thank you, If you reply to this email, your message will be added to the discussion below: http://koha.1045719.n5.nabble.com/On-how-to-create-a-report-tp5859353.html To start a new topic under Koha-general, email ml-node+s1045719n3047918h60@n5.nabble.com To unsubscribe from Koha-general, click here . NAML -- View this message in context: http://koha.1045719.n5.nabble.com/On-how-to-create-a-report-tp5859353p585936... Sent from the Koha-general mailing list archive at Nabble.com.
Thank you it worked!!!!!! You saved me!! p.s. is there anything I can add so it gives me the information of how many books each librarian cataloged? Thank you so much!!!! -- View this message in context: http://koha.1045719.n5.nabble.com/On-how-to-create-a-report-tp5859353p585936... Sent from the Koha-general mailing list archive at Nabble.com.
You are most welcome Catarina. Please visit the link I sent. It gives many reports that we normally require. If you check the list item 6.86 and 6.87 are the reports you required. I hope either one will help you provided CataloguingLog to be on (setting in global system preferences, under log tab) Mrs. Chitralekha Mahesh Chitale Librarian, LTCE, Navi Mumbai. ----- Original Message ----- From: "catarinafrc [via Koha]" <ml-node+s1045719n5859367h79@n5.nabble.com> To: "Chitralekha Chitale" <library.ltce@ltjss.net> Sent: Friday, October 30, 2015 2:23:42 PM Subject: Re: On how to create a report Thank you it worked!!!!!! You saved me!! p.s. is there anything I can add so it gives me the information of how many books each librarian cataloged? Thank you so much!!!! If you reply to this email, your message will be added to the discussion below: http://koha.1045719.n5.nabble.com/On-how-to-create-a-report-tp5859353p585936... To start a new topic under Koha-general, email ml-node+s1045719n3047918h60@n5.nabble.com To unsubscribe from Koha-general, click here . NAML -- View this message in context: http://koha.1045719.n5.nabble.com/On-how-to-create-a-report-tp5859353p585937... Sent from the Koha-general mailing list archive at Nabble.com.
Thank you!!!!! -- View this message in context: http://koha.1045719.n5.nabble.com/On-how-to-create-a-report-tp5859353p585937... Sent from the Koha-general mailing list archive at Nabble.com.
Hi, You may visit this wiki page : http://wiki.koha-community.org/wiki/SQL_Reports_Library and you can see all reports related to what you want , we use the following 2 reports in our library : they will give you the name of the cataloger as well but you must active action log in your syspref first : Statistic for daily catalogers achievement in date range for bib records - *Developer:* Karam Qubsi - *Module:* Cataloging - *Purpose:* Statistic for daily catalogers achievement in date range for bib records (you can change the date range I make it for the whole 2014 year in this example ) - *Status:* Complete SELECT DATE_FORMAT(I.timestamp, '%d-%c-%Y') AS Date, B.userid AS Staff, count(I.timestamp) AS CountFROM action_logs ILEFT JOIN borrowers BON I.user=B.borrowernumberWHERE I.module='CATALOGUING' AND I.action='ADD' AND date(I.timestamp) BETWEEN '2014-01-01' AND '2014-12-31' AND I.info='biblio'GROUP BY Date,B.useridORDER BY DATE(timestamp) DESC change dates to the correct range you want . for items added you may try this report : Statistic for daily catalogers achievement in date range for Item records - *Developer:* Karam Qubsi - *Module:* Cataloging - *Purpose:* Statistic for daily catalogers achievement in date range for item records (you can change the date range I make it for the whole 2014 year in this example ) - *Status:* Complete SELECT DATE_FORMAT(I.timestamp, '%d-%c-%Y') AS Date, B.userid AS Staff, count(I.timestamp) AS CountFROM action_logs ILEFT JOIN borrowers BON I.user=B.borrowernumberWHERE I.module='CATALOGUING' AND I.action='ADD' AND date(I.timestamp) BETWEEN '2014-01-01' AND '2014-12-31' AND I.info='item'GROUP BY Date,B.useridORDER BY DATE(timestamp) DESC *Best regards . * On Fri, Oct 30, 2015 at 5:15 PM, catarinafrc <catarina@fundacao-rc.org> wrote:
Thank you!!!!!
-- View this message in context: http://koha.1045719.n5.nabble.com/On-how-to-create-a-report-tp5859353p585937... Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- *Karam Qubsi <https://www.linkedin.com/in/kqubsi>* *Shah Alam , Malaysia . *
participants (3)
-
catarinafrc -
Chitralekha Chitale -
Karam Qubsi