[Koha] Report on MARC tags

[Katrin Fischer]

Hi Lisa,

which version of Koha are you using?

For newer versions there should never be a 952 in the marcxml field in
the database. For older versions all records with items should also have
one or mulitple 952 fields. There should be no mix in the database.

But when you export, the item information will be added to the records.

Hope this explains,

Katrin


Am 22.05.2015 um 08:18 schrieb Peel Lisa:
> Hi Katrin
>
> Thanks for that information - that makes some of the records make a
> bit more sense. I have realised that a lot of the records have no
> items (so obviously no 952) but there are other newer records
> (including all our ebooks and ejournals) which also don't have 952 - I
> need to export the whole catalogue including item information so how
> would I do this?
>
> 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/link?co=SEG&id=1>
> <http://www.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.
>
>
>> On 22 May 2015, at 07:40, Katrin Fischer <Katrin.Fischer.83 at web.de
>> <mailto:Katrin.Fischer.83 at web.de>> wrote:
>>
>> 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 <mailto: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:lpeel at swisseducation.com><mailto:aaslan at swisseducation.com>
>>> Web: www.swisseducation.com
>>> <http://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://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
>>> <http://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 <mailto:Koha at lists.katipo.co.nz>
>>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>>
>>
>> _______________________________________________
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz>
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>