How can i count the total catalog entry by user wise
We've 4 staff in our library for catalog entry and each of them have koha librarian accounts. We would like analyze their work by counting the total number of books they entered. How can we count / generate report on the total number of books entered by a user? -- Regards Anastes Mp foranastes@gmail.com +91-9744949078 [image: Facebook] <http://www.facebook.com/toanasmp> [image: Google] <https://google.com/+anastes> [image: LinkedIn] [image: Twitter]
Hello Anastes, By *books* you mean biblio records or items? Either way, some available reports my help you, such as: For *items*: https://wiki.koha-community.org/wiki/SQL_Reports_Library#Count_of_items_adde... Or for *biblios*: https://wiki.koha-community.org/wiki/SQL_Reports_Library#Count_of_bibs_modif... GL, Pedro Amorim 2017-05-25 11:48 GMT+00:00 Anastes Mp <foranastes@gmail.com>:
We've 4 staff in our library for catalog entry and each of them have koha librarian accounts. We would like analyze their work by counting the total number of books they entered. How can we count / generate report on the total number of books entered by a user?
--
Regards Anastes Mp foranastes@gmail.com +91-9744949078 [image: Facebook] <http://www.facebook.com/toanasmp> [image: Google] <https://google.com/+anastes> [image: LinkedIn] [image: Twitter] _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Hi, On Thu, May 25, 2017 at 5:18 PM, Anastes Mp <foranastes@gmail.com> wrote:
We've 4 staff in our library for catalog entry and each of them have koha librarian accounts. We would like analyze their work by counting the total number of books they entered. How can we count / generate report on the total number of books entered by a user?
Start looking at the reports from here https://wiki.koha-community.org/wiki/SQL_Reports_Library#Count_of_items_adde... and modify as per your needs. hope this helps Indranil Das Gupta L2C2 Technologies Phone : +91-98300-20971 WWW : http://www.l2c2.co.in Blog : http://blog.l2c2.co.in IRC : indradg on irc://irc.freenode.net Twitter : indradg
Hi Anastes, You can find SQL reports from the Koha SQL Reports wiki here <https://wiki.koha-community.org/wiki/SQL_Reports_Library#Count_of_items_added_by_cataloger_2>. Go to More > Reports > Create from SQL. Give the report a name that will help you remember what it's for (or just copy and paste the details from the SQL Reports wiki). Then copy and paste the following under the SQL tab. SELECT concat(p.firstname, ' ', p.surname) AS staff, concat(a.action, ' ', a.info) AS action, count(a.timestamp) AS count FROM action_logs a LEFT JOIN borrowers p ON (a.user=p.borrowernumber) WHERE a.module='CATALOGUING' AND a.timestamp BETWEEN <<Between (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> AND a.info IN ('item','biblio') GROUP BY p.borrowernumber, concat(a.action, ' ', a.info) Save the report and run it. Oh, you need to turn the CataloguingLog system preference on (More > Administration > Global System Preferences
Logs > CataloguingLog.
Kind regards, Lennon Mazonde On 25/05/2017 13:48, Anastes Mp wrote:
We've 4 staff in our library for catalog entry and each of them have koha librarian accounts. We would like analyze their work by counting the total number of books they entered. How can we count / generate report on the total number of books entered by a user?
Lol...! Worked like a charm. Thanks for your support. On Thu, May 25, 2017 at 5:40 PM, Lennon Mazonde <lmmazonde@gmail.com> wrote:
Hi Anastes,
You can find SQL reports from the Koha SQL Reports wiki here <https://wiki.koha-community.org/wiki/SQL_Reports_Library#Count_of_items_added_by_cataloger_2>. Go to More > Reports > Create from SQL. Give the report a name that will help you remember what it's for (or just copy and paste the details from the SQL Reports wiki).
Then copy and paste the following under the SQL tab.
SELECT concat(p.firstname, ' ', p.surname) AS staff, concat(a.action, ' ', a.info) AS action, count(a.timestamp) AS count FROM action_logs a LEFT JOIN borrowers p ON (a.user=p.borrowernumber) WHERE a.module='CATALOGUING' AND a.timestamp BETWEEN <<Between (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> AND a.info IN ('item','biblio') GROUP BY p.borrowernumber, concat(a.action, ' ', a.info)
Save the report and run it. Oh, you need to turn the CataloguingLog system preference on (More > Administration > Global System Preferences > Logs > CataloguingLog.
Kind regards,
Lennon Mazonde
On 25/05/2017 13:48, Anastes Mp wrote:
We've 4 staff in our library for catalog entry and each of them have koha librarian accounts. We would like analyze their work by counting the total number of books they entered. How can we count / generate report on the total number of books entered by a user?
-- Regards Anastes Mp foranastes@gmail.com +91-9744949078 [image: Facebook] <http://www.facebook.com/toanasmp> [image: Google] <https://google.com/+anastes> [image: LinkedIn] [image: Twitter]
Glad it worked. All credit to the authors of the reports. This particular was written by Nicole Engard. Kind regards, Lennon Mazonde On 25/05/2017 18:43, Anastes Mp wrote:
Lol...! Worked like a charm. Thanks for your support.
On Thu, May 25, 2017 at 5:40 PM, Lennon Mazonde <lmmazonde@gmail.com <mailto:lmmazonde@gmail.com>> wrote:
Hi Anastes,
You can find SQL reports from the Koha SQL Reports wiki here <https://wiki.koha-community.org/wiki/SQL_Reports_Library#Count_of_items_added_by_cataloger_2>. Go to More > Reports > Create from SQL. Give the report a name that will help you remember what it's for (or just copy and paste the details from the SQL Reports wiki).
Then copy and paste the following under the SQL tab.
SELECT concat(p.firstname, ' ', p.surname) AS staff, concat(a.action, ' ', a.info <http://a.info>) AS action, count(a.timestamp) AS count FROM action_logs a LEFT JOIN borrowers p ON (a.user=p.borrowernumber) WHERE a.module='CATALOGUING' AND a.timestamp BETWEEN <<Between (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> AND a.info <http://a.info> IN ('item','biblio') GROUP BY p.borrowernumber, concat(a.action, ' ', a.info <http://a.info>)
Save the report and run it. Oh, you need to turn the CataloguingLog system preference on (More > Administration > Global System Preferences > Logs > CataloguingLog.
Kind regards,
Lennon Mazonde
On 25/05/2017 13:48, Anastes Mp wrote:
We've 4 staff in our library for catalog entry and each of them have koha librarian accounts. We would like analyze their work by counting the total number of books they entered. How can we count / generate report on the total number of books entered by a user?
--
Regards
Anastes Mp
foranastes@gmail.com <mailto:foranastes@gmail.com>
+91-9744949078
Facebook <http://www.facebook.com/toanasmp>Google <https://google.com/+anastes>LinkedInTwitter
participants (4)
-
Anastes Mp -
Indranil Das Gupta -
Lennon Mazonde -
Pedro Amorim