<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=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<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:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
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="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">Hi everyone,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">We’re running our fourth of four migrations at Yale this week (WOOHOO), and right now I’m doing some data integrity checking between AT and ArchivesSpace to get slightly more detailed information than what the migrator provides.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Almost everything looks pretty good, except for one problem – we have 2603 fewer archival_objects in ArchivesSpace than we had components in Archivists’ Toolkit. This wasn’t a problem for migrations for other repositories. I am almost positive
that this was the result of irresponsible SQL delete statements many moons ago, and that the components in AT are orphans, but I’d like to figure out a way to check. Does anyone have any ideas? Maybe comparing refids and call numbers? All ideas are welcome.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Maureen<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Maureen Callahan<o:p></o:p></p>
<p class="MsoNormal"><span style="color:#404040">Archivist, Metadata Specialist<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#404040">Manuscripts & Archives<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#404040">Yale University Library<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#8496B0"><a href="mailto:maureen.callahan@yale.edu"><span style="color:#8496B0">maureen.callahan@yale.edu</span></a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#404040">203.432.3627<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#7F7F7F"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#404040">Webpage:</span><span style="color:#7F7F7F">
</span><span style="color:#8496B0"><a href="web.library.yale.edu/mssa"><span style="color:#8496B0">web.library.yale.edu/mssa</span></a></span><span style="color:#7F7F7F"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#404040">Collections:</span><span style="color:#7F7F7F">
</span><span style="color:#8496B0"><a href="drs.library.yale.edu"><span style="color:#8496B0">drs.library.yale.edu</span></a></span><span style="color:#7F7F7F"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>