<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
On 10/10/10 2:54 PM, Chris Cormack wrote:
<blockquote
cite="mid:AANLkTi=s9JHqfa8GupxfxKJGoLJYO=L5FFyuFc5kzQ-g@mail.gmail.com"
type="cite">
<pre wrap="">2010/10/9 Chris Hobbs <a class="moz-txt-link-rfc2396E" href="mailto:CHobbs@nhusd.k12.ca.us"><CHobbs@nhusd.k12.ca.us></a>:
</pre>
<blockquote type="cite">
<pre wrap="">Is there a way for me to fix the Default item types for our biblios en
masse? Our biblioitems records have the correct item type from our
conversion, but every time we add a new item type it defaults to our '0'
type (Art Print).</pre>
</blockquote>
<pre wrap="">There are 2 places where itemtype is set, either at
biblioitems.itemype or items.itype
There is a systempreference which controls which one is used.
I would recommend using the item level itemtypes.
</pre>
</blockquote>
That is our setting, but I think I did a poor job of explaining our
problem. The real issue is that I didn't populate the 942c (or 942n)
sub-fields when I imported our MARC records, so those are unset. If
somebody edits an existing MARC record, 942c is defaulting to our
itemtype 0, which is Art Print, unless the cataloger is paying
attention and edits 942c in addition to whatever else she went in to
edit. Later, when they go to add a new item of that biblio, the
item-level itype becomes Art Print unless they notice and change it.
<br>
<br>
Since we have no biblios with multiple item types associated with
them (we create a different biblio for each media type of a title),
I'd like to set the 942c sub-field based on an example item attached
to that biblio. *If* there were an itemtype in the biblio table, the
pseudo-SQL might look something like this:<br>
<br>
update biblio set itemtype=(select top 1 itype from items where
items.biblionumber=biblio.biblionumber)<br>
<br>
Hopefully that helps explain what I'm after. Thanks for the help!<br>
<br>
Chris<br>
<br>
<div class="moz-signature">-- <br>
<font color="blue">Chris Hobbs</font><br>
Director, Technology<br>
New Haven Unified School District</div>
--
This message has been checked by ESVA and is believed to be clean.
</body>
</html>