Updated to 6/28/2021
...
Once Government Information has sent the updated Excel spreadsheet showing owned titles, open the spreadsheet, as we will be loading only those that we own (with the exception of bound-with volumes, or already documents already in Sierra).
Open MarcEdit; Tools; Select MARC Records; Extract Selected Records.
Down in Source MARC File, navigate to the File:
In Search, select Field and Field# and in Display Field choose either 245 or 086 if titles are too similar, and click Import File.
Referring to the checked spreadsheet:
click the boxes next to Record Numbers for owned titles:
Click on Export Selected.
Name the file something easily recognizable, such as:
USUL1909-HistoricalFile-Owned
Optional: open the file in the MarcEditor to make sure all is well, and take a look at the titles,
Use Find; Find All: =245 and again, compare to the Excel shelf-checked file:
Add the 909 field:
Click on Files; Add/Delete Fields and add the 909 field
Using this form:
\\$aMelanie Shaw$b2021-11-09$eUNMODIFIED$dCMS STATS$zMarciveGPO
Finally, go to File; Compile into MARC and give it a distinctive name:
...