[Koha] On how to create a report

[catarinafrc]

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.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] On how to create a report

[Chitralekha Chitale]

Hello 


Paste the following program in reports. 

SELECT CONCAT('',biblio.title,'')
 
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 <> 
AND <> 



I hope this will give the results you expect. 

For more reports visit 
http://wiki.koha-community.org/wiki/SQL_Reports_Library#Catalog.2FBibliographic_Reports
 

Mrs. Chitralekha Mahesh Chitale 
Librarian, LTCE, Navi Mumbai. 

- Original Message -

From: "catarinafrc [via Koha]"  
To: "Chitralekha Chitale"  
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+s1045719n3047918...@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-tp5859353p5859364.html
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

Re: [Koha] On how to create a report

[catarinafrc]

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-tp5859353p5859367.html
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

Re: [Koha] On how to create a report

[catarinafrc]

Thank you!



--
View this message in context: 
http://koha.1045719.n5.nabble.com/On-how-to-create-a-report-tp5859353p5859377.html
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

Re: [Koha] On how to create a report

[Chitralekha Chitale]

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]"  
To: "Chitralekha Chitale"  
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-tp5859353p5859367.html
 
To start a new topic under Koha-general, email 
ml-node+s1045719n3047918...@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-tp5859353p5859370.html
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

Re: [Koha] On how to create a report

[Karam Qubsi]

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 
wrote:

> Thank you!
>
>
>
> --
> View this message in context:
> http://koha.1045719.n5.nabble.com/On-how-to-create-a-report-tp5859353p5859377.html
> 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 *

*Shah Alam , Malaysia . *
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha