<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
Thanks, John! That's really useful. (And honestly, shame on me for forgetting that MarcEdit exists.) Are you importing those EAD XML files one at a time?<br>
</div>
<div id="appendonsend"></div>
<p style="FONT-SIZE: 11pt; FONT-FAMILY: Calibri">
<p style="FONT-SIZE: 11pt; FONT-FAMILY: Calibri"><font face="Calibri"><strong>Science History Institute </strong><br style="FONT-SIZE: 11pt; FONT-FAMILY: Calibri">Chemistry • Engineering
• Life Sciences <br style="FONT-SIZE: 11pt; FONT-FAMILY: Calibri">315
Chestnut Street • Philadelphia, PA 19106 • U.S.A. <br style="FONT-SIZE: 11pt; FONT-FAMILY: Calibri">Learn about the scientific
discoveries that changed our world at <a title="" href="https://www.sciencehistory.org/learn">sciencehistory.org/learn</a></font></p>
<font face="Calibri">__________________________________ <br><br style="FONT-SIZE: 11pt; FONT-FAMILY: Calibri">Sarah Newhouse <em>(she, her, hers)</em> <br style="FONT-SIZE: 11pt; FONT-FAMILY: Calibri">Digital Preservation Archivist <br style="FONT-SIZE: 11pt; FONT-FAMILY: Calibri"></font><span style="font-size: 14.6667px;">Othmer Library of Chemical History</span><font face="Calibri"> <br style="FONT-SIZE: 11pt; FONT-FAMILY: Calibri">t. +1.215.873.8249
<br></font></p>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Rees, John
(NIH/NLM) [E] <reesj@mail.nlm.nih.gov><br>
<b>Sent:</b> Tuesday, October 4, 2022 4:33 PM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] MARC XML -->resource record batch import</font>
<div> </div>
</div>
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
p.x_MsoNormal, li.x_MsoNormal, div.x_MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
a:link, span.x_MsoHyperlink
{color:#0563C1;
text-decoration:underline}
p.x_MsoListParagraph, li.x_MsoListParagraph, div.x_MsoListParagraph
{margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
span.x_EmailStyle22
{font-family:"Calibri",sans-serif;
color:windowtext}
.x_MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
div.x_WordSection1
{}
ol
{margin-bottom:0in}
ul
{margin-bottom:0in}
-->
</style>
<div lang="EN-US" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="x_WordSection1">
<p class="x_MsoNormal">Hi Sarah,</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">My path (pre-covid) used MarcEdit</p>
<ol start="1" type="1" style="margin-top:0in">
<li class="x_MsoListParagraph" style="margin-left:0in">grab MARCXML via z39.50</li><li class="x_MsoListParagraph" style="margin-left:0in">use marcedit’s MARC-EAD transform xsl (w/ local edits)</li><li class="x_MsoListParagraph" style="margin-left:0in">import EAD into aspace</li><li class="x_MsoListParagraph" style="margin-left:0in">massage/publish agents, subjects, etc.</li></ol>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">We do this annually for adding accession records as resources (we don’t use the aspace accession module). I had done this same routine for our pre-aspace EAD-centric discovery software.</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">John</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">John P. Rees</p>
<p class="x_MsoNormal">Archivist and Digital Resources Manager</p>
<p class="x_MsoNormal">History of Medicine Division</p>
<p class="x_MsoNormal">National Library of Medicine</p>
<p class="x_MsoNormal">301-827-4510</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"> </p>
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="x_MsoNormal"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org>
<b>On Behalf Of </b>Newhouse, Sarah<br>
<b>Sent:</b> Tuesday, October 4, 2022 12:28 PM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> [EXTERNAL] [Archivesspace_Users_Group] MARC XML -->resource record batch import</p>
</div>
</div>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">Hi all, </p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">We’re trying to figure out the fastest way to generate stub resource records in ASpace from MARC XML for about 300 collections. The MARC XML we get from our Sierra OPAC creates really messy resource records using the MARC import function
baked into ASpace, so while we <i>could</i> do that and spend our time on clean-up after ingest, I feel like there must be a way to convert the MARC XML into clean JSON in bulk (maybe with a CSV intermediary step?) and then import via the API. Before I go
too far down the “I’ll just do it all myself” route, has anyone done this before and could share workflows or scripts? Or gently tell me why this won’t work?</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">I’m aware of this from Smith: <a href="https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fsmith-special-collections%2Fa2c-tools%2Ftree%2Fmaster%2Fmrbc_resources&data=05%7C01%7Creesj%40mail.nlm.nih.gov%7C03a5c3f8d86f4a5fafcc08daa62576b8%7C14b77578977342d58507251ca2dc2b06%7C0%7C0%7C638004977086907720%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=DY8BH%2Feq2Ut1ifqfmhpsdsAxRdR089tLdtRq%2BtKWdq0%3D&reserved=0">
https://github.com/smith-special-collections/a2c-tools/tree/master/mrbc_resources</a>
</p>
<p class="x_MsoNormal">and the <a href="https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fsupport.atlas-sys.com%2Fhc%2Fen-us%2Farticles%2F360052217114-The-ArchivesSpace-API-Playbook&data=05%7C01%7Creesj%40mail.nlm.nih.gov%7C03a5c3f8d86f4a5fafcc08daa62576b8%7C14b77578977342d58507251ca2dc2b06%7C0%7C0%7C638004977086907720%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=G08hfevG8eGYnJvlLthLqf1ehOewF2G2jttjHfdcgo8%3D&reserved=0">
API Playbook</a> from Atlas, <a href="https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchivesspace.github.io%2Farchivesspace%2Fapi%2F&data=05%7C01%7Creesj%40mail.nlm.nih.gov%7C03a5c3f8d86f4a5fafcc08daa62576b8%7C14b77578977342d58507251ca2dc2b06%7C0%7C0%7C638004977087064359%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=R9mNz3BzBw43guZF%2BrQ5axvGopfwgtrja19wKm6WX5s%3D&reserved=0">
the official API wiki</a> and its sample scripts, and various blog posts/guides for ArchivesSnake and PyMARC.</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">Other suggestions?</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">Thank you!</p>
<p>__________________________________ <br>
<br>
Sarah Newhouse <em><span style="font-family:"Calibri",sans-serif">(she, her, hers)</span></em>
<br>
Digital Preservation Archivist <br>
Othmer Library of Chemical History <br>
t. +1.215.873.8249 </p>
<p><strong><span style="font-family:"Calibri",sans-serif">Science History Institute </span></strong><br>
Chemistry • Engineering • Life Sciences <br>
315 Chestnut Street • Philadelphia, PA 19106 • U.S.A. <br>
Learn about the scientific discoveries that changed our world at <a href="https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.sciencehistory.org%2Flearn&data=05%7C01%7Creesj%40mail.nlm.nih.gov%7C03a5c3f8d86f4a5fafcc08daa62576b8%7C14b77578977342d58507251ca2dc2b06%7C0%7C0%7C638004977087064359%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=H1IitZ6WUsya6EROwnGzRCNveMdNxrciEBfPpzh2KmQ%3D&reserved=0">
sciencehistory.org/learn</a></p>
<div style="border:solid #9C6500 1.0pt; padding:2.0pt 2.0pt 2.0pt 2.0pt">
<p class="x_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 from outside of the organization. Do not click links or open
attachments unless you recognize the sender and are confident the content is safe.</span></p>
</div>
<p class="x_MsoNormal"> </p>
</div>
</div>
</body>
</html>