<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:"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:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.hoenzb
{mso-style-name:hoenzb;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1027" />
</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="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Hi Jane,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks for working on the documentation! I did a fair amount of testing with the MARC batch edit earlier this year so I could have a better understanding of how it works.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I have been working my way through records making some changes on $9 in tag 856 (90% complete!) using the MARC batch edit replace. What I am doing is fairly simple and might not be exactly what you are looking for, but I am using the Advanced
Matching Restriction to specify that when the $u matches http://statelibrarync.org/digitization/request/ then the existing $9 should be completely replaced with the new $9<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><img width="1131" height="523" style="width:11.7812in;height:5.4479in" id="Picture_x0020_1" src="cid:image002.png@01D33386.02728450" alt="cid:image002.png@01D33386.02728450"><b><o:p></o:p></b></p>
<p class="MsoNormal"><b><o:p> </o:p></b></p>
<p class="MsoNormal">This is our first large scale use of the MARC batch edit, but I have not been successful using the advanced matching restriction matching on the same thing that is going to be replaced. For example, in changing the $9, I am not able to
use the $9 as the match.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Adding fields/subfields:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">If you specify a subfield in the Rule Setup, it will add the subfield to the existing tag.<o:p></o:p></p>
<p class="MsoNormal"><img width="1220" height="573" style="width:12.7083in;height:5.9687in" id="_x0000_i1030" src="cid:image009.png@01D33386.E0DF9660" alt="cid:image009.png@01D33386.E0DF9660"><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">If you don’t specify a subfield it will create a new tag, even if the same tag exists<o:p></o:p></p>
<p class="MsoNormal"><img width="1209" height="570" style="width:12.5937in;height:5.9375in" id="Picture_x0020_7" src="cid:image004.png@01D33387.B90E9AE0"><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">My results from the two different add edits<o:p></o:p></p>
<p class="MsoNormal"><img width="798" height="68" style="width:8.3125in;height:.7083in" id="Picture_x0020_8" src="cid:image006.png@01D33387.B90E9AE0"><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I hope this helps!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks,<o:p></o:p></p>
<p class="MsoNormal">Catherine<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><!--[if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f">
<v:stroke joinstyle="miter" />
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0" />
<v:f eqn="sum @0 1 0" />
<v:f eqn="sum 0 0 @1" />
<v:f eqn="prod @2 1 2" />
<v:f eqn="prod @3 21600 pixelWidth" />
<v:f eqn="prod @3 21600 pixelHeight" />
<v:f eqn="sum @0 0 1" />
<v:f eqn="prod @6 1 2" />
<v:f eqn="prod @7 21600 pixelWidth" />
<v:f eqn="sum @8 21600 0" />
<v:f eqn="prod @7 21600 pixelHeight" />
<v:f eqn="sum @10 21600 0" />
</v:formulas>
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect" />
<o:lock v:ext="edit" aspectratio="t" />
</v:shapetype><v:shape id="Picture_x0020_1" o:spid="_x0000_s1026" type="#_x0000_t75" alt="NC_State_Seal PMS 2955" style='position:absolute;margin-left:0;margin-top:0;width:1in;height:1in;z-index:251659264;visibility:visible;mso-wrap-style:square;mso-width-percent:0;mso-height-percent:0;mso-wrap-distance-left:9pt;mso-wrap-distance-top:0;mso-wrap-distance-right:9pt;mso-wrap-distance-bottom:0;mso-position-horizontal:absolute;mso-position-horizontal-relative:text;mso-position-vertical:absolute;mso-position-vertical-relative:text;mso-width-percent:0;mso-height-percent:0;mso-width-relative:margin;mso-height-relative:margin'>
<v:imagedata src="cid:image001.png@01D33384.D0090CB0" o:title="NC_State_Seal PMS 2955" />
<w:wrap type="square"/>
</v:shape><![endif]--><![if !vml]><img width="96" height="96" style="width:1.0in;height:1.0in" src="cid:image010.png@01D33388.D114DA90" align="left" hspace="12" alt="NC_State_Seal PMS 2955" v:shapes="Picture_x0020_1"><![endif]><b>Catherine
M. Prince</b><b><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">NC Cardinal Systems Librarian<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">NC Dept. of Natural and Cultural Resources<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">919 807 7426 office<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">919 733 8748 fax<u><o:p></o:p></u></span></p>
<p class="MsoNormal"><u><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#0070C0">catherine.prince@ncdcr.gov<o:p></o:p></span></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif">109 East Jones Street | 4640 Mail Service Center | Raleigh, NC 27699<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:gray">Email correspondence to and from this address is subject to the<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:gray">North Carolina Public Records Law and may be disclosed to third parties.<o:p></o:p></span></i></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b>From:</b> Willis, Beth [mailto:willis@noblenet.org] <br>
<b>Sent:</b> Friday, September 22, 2017 9:07 AM<br>
<b>To:</b> Evergreen Community Catalogers <evergreen-catalogers@list.evergreen-ils.org><br>
<b>Subject:</b> Re: [Evergreen-catalogers] MARC Batch Edit questions<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">Hi Jane,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I have not used MARC Batch Edit much. When I first tried to work with it I found it confusing, so I have relied upon MARCEdit for editing bib records. However, your e-mail prompted me to go back and look at it again.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">As far as I can tell, you DO have to include a value in the MARC tag when adding a new MARC field to bib records. So, for example, to add a new MARC 650 field, I find that the following does NOT work. Note that the instruction in the
905 field is empty.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><img width="544" height="381" style="width:5.6666in;height:3.9687in" id="Picture_x0020_3" src="cid:image011.png@01D33388.D114DA90" alt="Inline image 1"><o:p></o:p></p>
<div>
<p class="MsoNormal"><br clear="all">
<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">The following DOES add a new MARC field to my bib records.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><img width="544" height="351" style="width:5.6666in;height:3.6562in" id="Picture_x0020_4" src="cid:image012.png@01D33388.D114DA90" alt="Inline image 2"><o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">If you include a value for Subfields I have found that a new MARC field is NOT added. Rather, a new subdivision is added to any existing fields with that same MARC tag. This seems to be the case regardless of what subfield is used.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">So, the following will add the subdivision "United States" to all of the existing 650 fields.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><img width="563" height="267" style="width:5.8645in;height:2.7812in" id="Picture_x0020_5" src="cid:image014.png@01D33388.D114DA90" alt="Inline image 1"><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I must be missing something obvious here because, for the life of me, I cannot figure out how to add a NEW MARC field if a field with the same tag already exists in the record.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I have not used the Replace function at all, so I cannot comment on that right now.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Thanks for working on this!<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On Thu, Sep 21, 2017 at 9:34 AM, Jane Sandberg <<a href="mailto:sandbej@linnbenton.edu" target="_blank">sandbej@linnbenton.edu</a>> wrote:<o:p></o:p></p>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt">
<p class="MsoNormal">Hi all,<br>
<br>
I'm trying to improve my understanding of the MARC Batch Edit tool,<br>
and also get some more details into the official documentation. I'd<br>
appreciate any help you can provide.<br>
<br>
In Add mode:<br>
* Do the MARC Tag and Subfield fields need to be filled out if the<br>
MARC Data field is filled out?<br>
* What happens if the subfields listed in the Subfield field don't<br>
match the subfields listed in the MARC Data field?<br>
* Is there a way to add subfields to existing fields, or can you only<br>
add new fields?<br>
<br>
In Replace mode:<br>
* Is there a way to capture a group of characters from a regular<br>
expression and then use it in the MARC Data field? Or any other way<br>
to replace values based on what values are already there in one fell<br>
swoop?<br>
<br>
Thanks,<br>
<br>
-Jane<br>
<span style="color:#888888"><br>
<span class="hoenzb">--</span><br>
<span class="hoenzb">Jane Sandberg</span><br>
<span class="hoenzb">Electronic Resources Librarian</span><br>
<span class="hoenzb">Linn-Benton Community College</span><br>
</span><a href="mailto:sandbej@linnbenton.edu">sandbej@linnbenton.edu</a><span class="hoenzb"><span style="color:#888888"> /
</span></span><a href="tel:541-917-4655">541-917-4655</a><span style="color:#888888"><br>
<span class="hoenzb">Pronouns: she/her/hers or they/them/theirs</span><br>
<span class="hoenzb">_______________________________________________</span><br>
<span class="hoenzb">Evergreen-catalogers mailing list</span><br>
</span><a href="mailto:Evergreen-catalogers@list.evergreen-ils.org">Evergreen-catalogers@list.evergreen-ils.org</a><span style="color:#888888"><br>
</span><a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-catalogers" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-catalogers</a><o:p></o:p></p>
</blockquote>
</div>
<p class="MsoNormal"><br>
<br clear="all">
<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal">-- <o:p></o:p></p>
<div>
<div>
<p class="MsoNormal">Beth Willis <br>
Digital & Catalog Librarian <br>
NOBLE, Inc. <br>
26 Cherry Hill Drive <br>
Danvers, MA 01923 <o:p></o:p></p>
</div>
</div>
</div>
</div>
</body>
</html>