<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Times New Roman",serif;
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Times New Roman",serif;
color:#2E74B5;}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle23
{mso-style-type:personal;
font-family:"Times New Roman",serif;
color:#2E74B5;}
span.EmailStyle24
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle25
{mso-style-type:personal-reply;
font-family:"Times New Roman",serif;
color:#2E74B5;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:290869660;
mso-list-type:hybrid;
mso-list-template-ids:535231070 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l1
{mso-list-id:767624876;
mso-list-template-ids:699983962;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#2E74B5">Wade, you are a genius and I hope they pay you ALL the money
</span><span style="font-size:12.0pt;font-family:Wingdings;color:#2E74B5">J</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#2E74B5">
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#2E74B5"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#2E74B5">It worked like a charm! I replicated the rule and tweaked it for the TE collection, and cleaned that up as well.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#2E74B5"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#2E74B5">I cannot thank you enough and when you come to the lovely town of Longview, the beverage of your choice awaits.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#2E74B5"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#2E74B5">Best,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#2E74B5">Maryanne<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#2E74B5"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Wactclc-alma <wactclc-alma-bounces@lists.ctc.edu>
<b>On Behalf Of </b>Guidry, Wade<br>
<b>Sent:</b> Tuesday, August 13, 2019 12:30 PM<br>
<b>To:</b> WACTCLC Alma Discussion <wactclc-alma@lists.ctc.edu><br>
<b>Subject:</b> Re: [Wactclc-alma] Changing 852 line in holding records<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Maryanne (and sharing on list, as it should be of interest),<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I created a normalization rule that can fix your OVS 852 fields (I tested it already using the ‘preview’ trick I demo’ed today):<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:.5in">rule "Fix 852 errors for OVS titles"<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:1.0in">when<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:1.5in">(TRUE)<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:1.0in">Then<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:1.5in"><b>#the following line fixes the fixed field, 18<sup>th</sup> position<o:p></o:p></b></p>
<p class="MsoNormal" style="margin-left:1.5in">replaceControlContents "LDR.{18,1}.#" with "i"<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:1.5in"><b>#the following line fixes the indicator to indicate Dewey<o:p></o:p></b></p>
<p class="MsoNormal" style="margin-left:1.5in">changeFirstIndicator "852" to "1"<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:1.5in"><b>#the following line removes any OVS prefix from the h subfield<o:p></o:p></b></p>
<p class="MsoNormal" style="margin-left:1.5in">replaceContents "852.h.OVS" with ""<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:1.5in"><b>#the following line adds the k subfield value<o:p></o:p></b></p>
<p class="MsoNormal" style="margin-left:1.5in">addSubfield "852.k.OVS"<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:1.0in">end<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">You can use the information “update / change holding” job against a set of the OVS physical items.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Select “correct the data using normalization rules”, and use the “Fix 852 for OVS titles” rule.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">That should do the trick.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Wade Guidry<o:p></o:p></p>
<p class="MsoNormal">Library Consortium Services Manager, WACTCLC<o:p></o:p></p>
<p class="MsoNormal"><a href="mailto:wadeg@bigbend.edu">wadeg@bigbend.edu</a><o:p></o:p></p>
<p class="MsoNormal">(509) 760-4474<o:p></o:p></p>
<p class="MsoNormal"><a href="http://www.wactclc.org">http://www.wactclc.org</a><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Wactclc-alma <<a href="mailto:wactclc-alma-bounces@lists.ctc.edu">wactclc-alma-bounces@lists.ctc.edu</a>>
<b>On Behalf Of </b>Hirning, Maryanne<br>
<b>Sent:</b> Monday, August 12, 2019 5:37 PM<br>
<b>To:</b> 'WACTCLC Alma Discussion' <<a href="mailto:wactclc-alma@lists.ctc.edu">wactclc-alma@lists.ctc.edu</a>><br>
<b>Subject:</b> Re: [Wactclc-alma] Changing 852 line in holding records<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">ATTENTION: This email contains links. Please follow best practices before clicking on links
<o:p></o:p></p>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#2E74B5">That would be great! I have fixed three hundred manually- I try to get 100 done in my first hour at work each day, but that would be fabulous
</span><span style="font-size:12.0pt;font-family:Wingdings;color:#2E74B5">J</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#2E74B5">
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#2E74B5"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Wactclc-alma <<a href="mailto:wactclc-alma-bounces@lists.ctc.edu">wactclc-alma-bounces@lists.ctc.edu</a>>
<b>On Behalf Of </b>Guidry, Wade<br>
<b>Sent:</b> Monday, August 12, 2019 4:30 PM<br>
<b>To:</b> WACTCLC Alma Discussion <<a href="mailto:wactclc-alma@lists.ctc.edu">wactclc-alma@lists.ctc.edu</a>><br>
<b>Subject:</b> Re: [Wactclc-alma] Changing 852 line in holding records<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Looks like you can use normalization rules to update holdings records as follows:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<ol style="margin-top:0in" start="1" type="1">
<li class="MsoNormal" style="mso-list:l0 level1 lfo3">Create a set of associated physical items (in LCC’s case, maybe physical items in the OVS shelf location)<o:p></o:p></li><li class="MsoNormal" style="mso-list:l0 level1 lfo3">Create a normalization rule to make the desired changes to the 852 in the holdings record<o:p></o:p></li><li class="MsoNormal" style="mso-list:l0 level1 lfo3">Use the ‘Information Update / Change holdings information’ job to run the physical items set through the normalization rule<o:p></o:p></li></ol>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The hardest step in this scenario is #2.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I will look at your desired outcome, Maryanne, and see if I can come up with an appropriate norm rule to get it done.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Wade Guidry<o:p></o:p></p>
<p class="MsoNormal">Library Consortium Services Manager, WACTCLC<o:p></o:p></p>
<p class="MsoNormal"><a href="mailto:wadeg@bigbend.edu">wadeg@bigbend.edu</a><o:p></o:p></p>
<p class="MsoNormal">(509) 760-4474<o:p></o:p></p>
<p class="MsoNormal"><a href="http://www.wactclc.org">http://www.wactclc.org</a><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Wactclc-alma <<a href="mailto:wactclc-alma-bounces@lists.ctc.edu">wactclc-alma-bounces@lists.ctc.edu</a>>
<b>On Behalf Of </b>Hirning, Maryanne<br>
<b>Sent:</b> Wednesday, August 7, 2019 5:50 PM<br>
<b>To:</b> 'WACTCLC Alma Discussion' <<a href="mailto:wactclc-alma@lists.ctc.edu">wactclc-alma@lists.ctc.edu</a>><br>
<b>Subject:</b> Re: [Wactclc-alma] Changing 852 line in holding records<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#2E74B5">Thanks, Kirsti. I will check out that presentation.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#2E74B5"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#2E74B5">Maryanne<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#2E74B5"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Wactclc-alma <<a href="mailto:wactclc-alma-bounces@lists.ctc.edu">wactclc-alma-bounces@lists.ctc.edu</a>>
<b>On Behalf Of </b>Thomas, Kirsti<br>
<b>Sent:</b> Wednesday, August 07, 2019 5:29 PM<br>
<b>To:</b> WACTCLC Alma Discussion <<a href="mailto:wactclc-alma@lists.ctc.edu">wactclc-alma@lists.ctc.edu</a>><br>
<b>Subject:</b> Re: [Wactclc-alma] Changing 852 line in holding records<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:#1F497D">I know that you can use indication rules to create sets of titles based on MARC field and subfield criteria in bib and holdings records. You can use normalization rules to make changes is batch to bib records,
but I keep hearing that editing MARC holdings records with norm rules isn't really possible. I haven't tried it myself.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">There was a presentation at ELUNA 2019 where someone used MARCEdit to run batch changes to MARC fields in holdings records. I think the presentation was by TJ Kao who's at one of the big DC private university
libraries. Check the ELUNA repository.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Kirsti S. Thomas<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Library Technical Services Manager<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Seattle Colleges<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><a href="mailto:kirsti.thomas@seattlecolleges.edu">kirsti.thomas@seattlecolleges.edu</a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">206-934-4106<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Wactclc-alma [<a href="mailto:wactclc-alma-bounces@lists.ctc.edu">mailto:wactclc-alma-bounces@lists.ctc.edu</a>]
<b>On Behalf Of </b>Hirning, Maryanne<br>
<b>Sent:</b> Wednesday, 7 August, 2019 16:35<br>
<b>To:</b> 'WACTCLC Alma Discussion' <<a href="mailto:wactclc-alma@lists.ctc.edu">wactclc-alma@lists.ctc.edu</a>><br>
<b>Subject:</b> [Wactclc-alma] Changing 852 line in holding records<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="border:solid #9C6500 1.0pt;padding:2.0pt 2.0pt 2.0pt 2.0pt">
<p class="MsoNormal" style="line-height:12.0pt;background:#FFEB9C"><span style="font-size:10.0pt;color:#9C6500">CAUTION:</span><span style="font-size:10.0pt;color:black"> This email originated outside of the Seattle Colleges’ email system. Do not click links
or open attachments unless you recognize the sender and know the content is safe. Questions? Contact IT Services at x6333 (Central), x3630 (North), x5844 (South) or email
<a href="mailto:ITHelp@seattlecolleges.edu">ITHelp@seattlecolleges.edu</a>.<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal">I apologize in advance is this is a super dumb question. I have about 800 titles in our Oversized collection that have 852 8 lines instead of 852 1. I guess they imported weird from the previous system. I want to add the “OVS” prefix to
the $$h call number and I would really like to avoid doing that manually! Is there a way to run a set? Looks like this:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><img border="0" width="819" height="227" style="width:8.5312in;height:2.3645in" id="Picture_x0020_1" src="cid:image001.png@01D55282.F9240090"><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Should be this:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><img border="0" width="888" height="245" style="width:9.25in;height:2.552in" id="Picture_x0020_2" src="cid:image002.png@01D55282.F9240090"><span style="font-size:12.0pt;font-family:"Times New Roman",serif"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif">Thanks in advance
</span><span style="font-size:12.0pt;font-family:Wingdings">J</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif">
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif">Maryanne E. Hirning<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif">Library Circulation Services Manager<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif">Lower Columbia College<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif">1600 Maple Street<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif">Longview, WA 98632<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif">360-442-2668<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
</body>
</html>