<html><body><div style="font-family: georgia,serif; font-size: 10pt; color: #000000"><div>Noah,<br></div><div><br>We've done this here at Penn State. I am trying to dig up the SQL script we used to identify the unlinked records. I will send it to you off-list.</div><div><br></div><div>-Ben</div><div><br></div><div><br></div><div><span name="x"></span><span data-mce-style="color: #000000; font-size: small;" style="color: #000000; font-size: small;" size="2"><span style="font-family: georgia,serif; font-weight: bold;">Ben Goldman</span><br style="font-family: georgia,serif;"><span style="font-family: georgia,serif;">Digital Records Archivist</span><br style="font-family: georgia,serif;"><span style="font-family: georgia,serif;">Penn State University Libraries</span><br style="font-family: georgia,serif;"><span style="font-family: georgia,serif;">University Park, PA</span><br style="font-family: georgia,serif;"><span style="font-family: georgia,serif;">814-863-8333<br><a href="http://www.libraries.psu.edu/psul/speccolls.html">http://www.libraries.psu.edu/psul/speccolls.html</a><br></span></span><span name="x"></span><br></div><br><hr id="zwchr"><div style="color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><b>From: </b>"Noah Huffman" <noah.huffman@duke.edu><br><b>To: </b>"Archivesspace Users Group" <Archivesspace_Users_Group@lyralists.lyrasis.org><br><b>Sent: </b>Thursday, January 23, 2014 9:38:42 AM<br><b>Subject: </b>[Archivesspace_Users_Group] AT to AS Migration - batch deleting unlinked name/subject records?<br><div><br></div>
<style><!--
@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;}
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>
<div class="WordSection1">
<p class="MsoNormal">Hello all,</p>
<p class="MsoNormal"> </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?</p>
<p class="MsoNormal"> </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.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Thanks for any advice,</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">-Noah</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">================</p>
<p class="MsoNormal">Noah Huffman</p>
<p class="MsoNormal">Archivist for Metadata and Encoding</p>
<p class="MsoNormal">David M. Rubenstein Rare Book & Manuscript Library</p>
<p class="MsoNormal">Duke University</p>
<p class="MsoNormal"><a href="mailto:noah.huffman@duke.edu" target="_blank"><span style="color:blue">noah.huffman@duke.edu</span></a></p>
<p class="MsoNormal">919-660-5982</p>
<p class="MsoNormal"><a href="http://library.duke.edu/rubenstein/" target="_blank"><span style="color:blue">http://library.duke.edu/rubenstein/</span></a>
</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Visit our blog "The Devil's Tale": <a href="http://blogs.library.duke.edu/rubenstein/" target="_blank">
<span style="color:blue">http://blogs.library.duke.edu/rubenstein/</span></a></p>
<p class="MsoNormal">Be our fan on Facebook: <a href="http://www.facebook.com/rubensteinlibrary" target="_blank">
<span style="color:blue">http://www.facebook.com/rubensteinlibrary</span></a>
</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
</div>
<br>_______________________________________________<br>Archivesspace_Users_Group mailing list<br>Archivesspace_Users_Group@lyralists.lyrasis.org<br>http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group<br></div><div><br></div></div></body></html>