[Koha] Add new serials

Librarian for the Society of Jesus in South Africa SA-RegLibrary at sj.org.za
Thu Jul 24 23:45:36 NZST 2014


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-request at lists.katipo.co.nz wrote:
> Send Koha mailing list submissions to
> 	koha at 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-request at lists.katipo.co.nz
>
> You can reach the person managing the list at
> 	koha-owner at 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 <eb at efdss.org>
> To: Robin Sheat <robin at catalyst.net.nz>
> Cc: koha <koha at lists.katipo.co.nz>
> Subject: Re: [Koha] Report help
> Message-ID:
> 	<CAPdfUuxn+=gBkZxgntAvRAskd8X16afksQHkU7_J_03RkZrnuQ at 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 <robin at 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 at 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-RegLibrary at sj.org.za | Web: 
http://www.sj.org.za/
Post: St Ignatius House, 15 Molesey Avenue Auckland Park, Johannesburg, 
2092, South Africa



More information about the Koha mailing list