Koha 3.0 total number of books, cds, dvds, journals and others
Hi, If i want to see total number of inserted books,cds,dvds, journals and others which are inserted into my Koha 3.0 server, what i need to do? I went to: Reports --> Statistics Wizards --> Catalog But, nothing is showing but only 0. But, my inserted items are 5,000 approximately. i want to know the exact figure. -- Best, Zico
I don't mess with the reports, so I can't help with them. For this I would run a few SQL commands. I'll write some here for you. SELECT COUNT(barcode) FROM items WHERE barcode <> '' AND barcode IS NOT NULL SELECT categorycode,COUNT(barcode) FROM items WHERE barcode<> '' AND barcode IS NOT NULL GROUP BY categorycode; SELECT COUNT(biblionumber) FROM biblio These will give you the total number of barcodes, the number of barcodes per item category, and the total number of titles in the database. Good luck. On Tue, 2009-10-06 at 00:59 +0600, Zico wrote:
Hi, If i want to see total number of inserted books,cds,dvds, journals and others which are inserted into my Koha 3.0 server, what i need to do? I went to:
Reports --> Statistics Wizards --> Catalog
But, nothing is showing but only 0. But, my inserted items are 5,000 approximately. i want to know the exact figure.
-- Best, Zico _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel -- Michael Hafen Systems Analyst and Programmer Washington County School District Utah, USA
for Koha checkout http://development.washk12.org/gitweb/ or git://development.washk12.org/koha
Make sure you add these reports to the SQL Reports page on the wiki - and always check there for reports that others have written: http://wiki.koha.org/doku.php?id=sql_library Nicole On Mon, Oct 5, 2009 at 5:19 PM, Michael Hafen <mdhafen@tech.washk12.org> wrote:
I don't mess with the reports, so I can't help with them. For this I would run a few SQL commands. I'll write some here for you.
SELECT COUNT(barcode) FROM items WHERE barcode <> '' AND barcode IS NOT NULL
SELECT categorycode,COUNT(barcode) FROM items WHERE barcode<> '' AND barcode IS NOT NULL GROUP BY categorycode;
SELECT COUNT(biblionumber) FROM biblio
These will give you the total number of barcodes, the number of barcodes per item category, and the total number of titles in the database.
Good luck.
On Tue, 2009-10-06 at 00:59 +0600, Zico wrote:
Hi, If i want to see total number of inserted books,cds,dvds, journals and others which are inserted into my Koha 3.0 server, what i need to do? I went to:
Reports --> Statistics Wizards --> Catalog
But, nothing is showing but only 0. But, my inserted items are 5,000 approximately. i want to know the exact figure.
-- Best, Zico _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel -- Michael Hafen Systems Analyst and Programmer Washington County School District Utah, USA
for Koha checkout http://development.washk12.org/gitweb/ or git://development.washk12.org/koha
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
I added these three to the Wiki. I noticed that I made a mistake in the middle one while I was at it: categorycode should be itype. On Tue, 2009-10-06 at 07:41 -0400, Nicole Engard wrote:
Make sure you add these reports to the SQL Reports page on the wiki - and always check there for reports that others have written: http://wiki.koha.org/doku.php?id=sql_library
Nicole
On Mon, Oct 5, 2009 at 5:19 PM, Michael Hafen <mdhafen@tech.washk12.org> wrote:
I don't mess with the reports, so I can't help with them. For this I would run a few SQL commands. I'll write some here for you.
SELECT COUNT(barcode) FROM items WHERE barcode <> '' AND barcode IS NOT NULL
SELECT categorycode,COUNT(barcode) FROM items WHERE barcode<> '' AND barcode IS NOT NULL GROUP BY categorycode;
SELECT COUNT(biblionumber) FROM biblio
These will give you the total number of barcodes, the number of barcodes per item category, and the total number of titles in the database.
Good luck.
On Tue, 2009-10-06 at 00:59 +0600, Zico wrote:
Hi, If i want to see total number of inserted books,cds,dvds, journals and others which are inserted into my Koha 3.0 server, what i need to do? I went to:
Reports --> Statistics Wizards --> Catalog
But, nothing is showing but only 0. But, my inserted items are 5,000 approximately. i want to know the exact figure.
-- Best, Zico _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel -- Michael Hafen Systems Analyst and Programmer Washington County School District Utah, USA
for Koha checkout http://development.washk12.org/gitweb/ or git://development.washk12.org/koha
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
-- Michael Hafen Systems Analyst and Programmer Washington County School District Utah, USA
for Koha checkout http://development.washk12.org/gitweb/ or git://development.washk12.org/koha
On Tue, Oct 6, 2009 at 3:19 AM, Michael Hafen <mdhafen@tech.washk12.org>wrote:
I don't mess with the reports, so I can't help with them. For this I would run a few SQL commands.
Thanks for the commands. But, is there any GUI way to do that? -- Best, Zico
Kinda there is. In the Reports section you can use the Guided Reports Wizard to create a report from SQL. As Nicole pointed out there is also a Library of SQL commands you can use with the Reports Wizard, including the three I posted: http://wiki.koha.org/doku.php?id=sql_library That's the GUI way which I know about. Maybe others on the list know more. Good luck. On Wed, 2009-10-07 at 01:49 +0600, Zico wrote:
On Tue, Oct 6, 2009 at 3:19 AM, Michael Hafen <mdhafen@tech.washk12.org> wrote: I don't mess with the reports, so I can't help with them. For this I would run a few SQL commands.
Thanks for the commands. But, is there any GUI way to do that?
-- Best, Zico
-- Michael Hafen Systems Analyst and Programmer Washington County School District Utah, USA for Koha checkout http://development.washk12.org/gitweb/ or git://development.washk12.org/koha
More documentation here: http://koha.org/documentation/manual/3.0/reports/custom-reports On Tue, Oct 6, 2009 at 3:58 PM, Michael Hafen <mdhafen@tech.washk12.org> wrote:
Kinda there is. In the Reports section you can use the Guided Reports Wizard to create a report from SQL. As Nicole pointed out there is also a Library of SQL commands you can use with the Reports Wizard, including the three I posted: http://wiki.koha.org/doku.php?id=sql_library
That's the GUI way which I know about.
Maybe others on the list know more.
Good luck.
On Wed, 2009-10-07 at 01:49 +0600, Zico wrote:
On Tue, Oct 6, 2009 at 3:19 AM, Michael Hafen <mdhafen@tech.washk12.org> wrote: I don't mess with the reports, so I can't help with them. For this I would run a few SQL commands.
Thanks for the commands. But, is there any GUI way to do that?
-- Best, Zico
-- Michael Hafen Systems Analyst and Programmer Washington County School District Utah, USA
for Koha checkout http://development.washk12.org/gitweb/ or git://development.washk12.org/koha
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
participants (3)
-
Michael Hafen -
Nicole Engard -
Zico