<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 14 (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;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 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;}
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="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Hello all,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">We’re doing some scrubbing of our Archivists’ Toolkit data in preparation for migration to ArchivesSpace. Can anyone recommend an efficient way to batch delete all unlinked name and subject records in AT that doesn’t involve opening each
record to determine if it’s linked to an accession or resource?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Many of the names and subjects in AT were created during various batch imports and the linked accession and resource records have since been deleted. I’d prefer not to carry these unlinked records over to AS.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks for any advice,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">-Noah<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">================<o:p></o:p></p>
<p class="MsoNormal">Noah Huffman<o:p></o:p></p>
<p class="MsoNormal">Archivist for Metadata and Encoding<o:p></o:p></p>
<p class="MsoNormal">David M. Rubenstein Rare Book & Manuscript Library<o:p></o:p></p>
<p class="MsoNormal">Duke University<o:p></o:p></p>
<p class="MsoNormal"><a href="mailto:noah.huffman@duke.edu"><span style="color:blue">noah.huffman@duke.edu</span></a><o:p></o:p></p>
<p class="MsoNormal">919-660-5982<o:p></o:p></p>
<p class="MsoNormal"><a href="http://library.duke.edu/rubenstein/"><span style="color:blue">http://library.duke.edu/rubenstein/</span></a>
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Visit our blog "The Devil's Tale": <a href="http://blogs.library.duke.edu/rubenstein/">
<span style="color:blue">http://blogs.library.duke.edu/rubenstein/</span></a><o:p></o:p></p>
<p class="MsoNormal">Be our fan on Facebook: <a href="http://www.facebook.com/rubensteinlibrary">
<span style="color:blue">http://www.facebook.com/rubensteinlibrary</span></a> <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>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>