Hi
I'm new on Koha, i'm struggling to add a new serials subscription ie The
Tablet . I have done the budget part.
*Francis.**
*
*On Thur*sday 24 July 2014 01:21 AM, koha-requ...@lists.katipo.co.nz wrote:
Send Koha mailing list submissions to
koha@lists.katipo.co.nz
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.katipo.co.nz/mailman/listinfo/koha
or, via email, send a message with subject or body 'help' to
koha-requ...@lists.katipo.co.nz
You can reach the person managing the list at
koha-ow...@lists.katipo.co.nz
When replying, please edit your Subject line so it is more specific
than Re: Contents of Koha digest...
Today's Topics:
1. Re: Report help (Elaine Bradtke)
2. Re: Report help (ramirouvia .)
3. Re: Barcode generation in koha 2.2.9 Windows Version (xiaoyuandlg)
4. Re: Report help (Elaine Bradtke)
5. Report to find biblios without dates in 008 - needs work
(Elaine Bradtke)
6. Koha 3.16.2 released (Galen Charlton)
--
Message: 1
Date: Wed, 23 Jul 2014 19:57:26 +0100
From: Elaine Bradtke e...@efdss.org
To: Robin Sheat ro...@catalyst.net.nz
Cc: koha koha@lists.katipo.co.nz
Subject: Re: [Koha] Report help
Message-ID:
CAPdfUuxn+=gbkzxgntavraskd8x16afksqhku7_j_03rkzr...@mail.gmail.com
Content-Type: text/plain; charset=UTF-8
This is the basic report:
SELECT count(biblio.copyrightdate), biblio.copyrightdate,items.itype FROM
items LEFT JOIN biblioitems on
(items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on
(biblioitems.biblionumber=biblio.biblionumber) GROUP BY
biblio.copyrightdate ORDER BY biblio.copyrightdate asc
I also used an expanded version with more fields so I could see what the
numbers really mean.
- It doesn't pick up everything. A lot of our 18th and 19th century
publications have partial or conjectural dates in square brackets. These
seem to be ignored.
- It gives a count of the items. Not the biblios. So this skews the
count further (we have a lot of 18th century pamphlets bound together -
many biblios, but only one item record for the bound volume).
Is there any way we can be more precise?
Would a query on the MARCXML for the 260 c produce a more accurate result?
Can we to force it to count biblios instead of items?
It may be we have to settle for doing the counting in the spreadsheet
rather than via Koha. But it would be nice to have some control over what
is counted.
I know next to nothing about SQL, any help would be greatly appreciated.
Thanks
On Wed, Jul 23, 2014 at 12:31 AM, Robin Sheat ro...@catalyst.net.nz wrote:
Elaine Bradtke schreef op di 22-07-2014 om 17:35 [+0100]:
One of my colleagues was asking if I could give statistics on what we
have
from the 17th, 18th and first half of the 19th century. Preferably by
year.
When my Elasticsearch work is finished, this'll be just a matter of
finding an elasticsearch visualisation tool that lets you explore your
data, and telling it to do what you want.
The way I'd do it currently would be to script something that pulls the
date from the MARC of each entry and exports that. Then you could pop it
into libreoffice calc and make graphs or whatever you need.
--
Robin Sheat
Catalyst IT Ltd.
? +64 4 803 2204
GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
--
Inline image
*Mr Francis Zvigo*
/Librarian/
Regional Library of the Society of Jesus in South Africa
Mobile: +27 (74) 029-8901 | E-mail: sa-reglibr...@sj.org.za | Web:
http://www.sj.org.za/
Post: St Ignatius House, 15 Molesey Avenue Auckland Park, Johannesburg,
2092, South Africa
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
