[Koha] Report on MARC tags

[Katrin Fischer]

Hi,

please keep in mind that newer versions of Koha don't store the item
information (952) in the marcxml any longer - so none of the records
would have a 952. In order to find out which records have no items,
you'd have to check for missing biblionumbers in the items table.

Hope this helps,

Katrin

Am 22.05.2015 um 04:58 schrieb Steven Nickerson:
> Hi Lisa,
>    I hope this is what you were looking for.....the SQL below will list
> biblionumber and ISBN for all biblioitems without 'tag="952"' in the marcxml
> field:
> 
> select biblionumber from biblioitems where marcxml NOT LIKE '%tag="952"%';
> 
> Hope this helps!
> Steve
> 
> -----Original Message-----
> From: Peel Lisa [mailto:lisa.peel at ritz.edu] 
> Sent: Thursday, May 21, 2015 3:20 AM
> To: koha at lists.katipo.co.nz
> Subject: [Koha] Report on MARC tags
> 
> Hello
> 
> I am hoping someone can help me with a little bit of SQL.
> 
> I need to export my whole catalogue but I have now realised that the 'simple
> framework' some staff have been using to create bib items did not include
> the 952 tag so this information is missing from those MARC records.
> 
> So I now need to locate all bib items which do not have a 952 tag (I am
> assuming I will need to manually edit the marc records to include the 952
> information even if I update the 'simple framework?) - if anyone would be
> kind enough to provide the correct SQL for this report I would be extremely
> grateful:-)
> 
> Regards
> 
> Lisa
> 
> ________________________________
> 
> 
> Mrs Lisa Peel, Head of Learning Resources Services, SEG SEG, Swiss Education
> Group Avenue des Alpes 27bis
> CH-1820 Montreux, Switzerland
> 
> Tel: +41 (0)79 228 0151
> Email: lpeel at swisseducation.com<mailto:aaslan at swisseducation.com>
> Web: www.swisseducation.com<http://www.swisseducation.com/>
> 
> [Facebook]<http://facebook.swisseducation.com/> [Twitter]
> <http://twitter.swisseducation.com/>  [Youtube]
> <http://youtube.swisseducation.com/>  [Google+]
> <http://plus.swisseducation.com/>
> 
> [http://www.swisseducation.com/email-signatures/image?co=SEG&id=1]<http://ww
> w.swisseducation.com/email-signatures/link?co=SEG&id=1>
> [http://www.swisseducation.com/email-signatures/image?co=SEG&id=2]<http://ww
> w.swisseducation.com/email-signatures/link?co=SEG&id=2>
> ________________________________
> 
> 
> Confidentiality and Disclaimer:
> 
> This message contains confidential information and is intended only for the
> individual named. Email messages are provided for informational purposes,
> therefore the sender does not accept liability for any errors or omissions
> in the contents of this message.
> 
> 
> 
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>