[Archivesspace_Users_Group] AT to AS Migration - batch deleting unlinked name/subject records?

[Ben Goldman]

Noah, 

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. 

-Ben 


Ben Goldman 
Digital Records Archivist 
Penn State University Libraries 
University Park, PA 
814-863-8333 
http://www.libraries.psu.edu/psul/speccolls.html 


----- Original Message -----

From: "Noah Huffman" <noah.huffman at duke.edu> 
To: "Archivesspace Users Group" <Archivesspace_Users_Group at lyralists.lyrasis.org> 
Sent: Thursday, January 23, 2014 9:38:42 AM 
Subject: [Archivesspace_Users_Group] AT to AS Migration - batch deleting unlinked name/subject records? 



Hello all, 



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? 



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. 



Thanks for any advice, 



-Noah 



================ 

Noah Huffman 

Archivist for Metadata and Encoding 

David M. Rubenstein Rare Book & Manuscript Library 

Duke University 

noah.huffman at duke.edu 

919-660-5982 

http://library.duke.edu/rubenstein/ 



Visit our blog "The Devil's Tale": http://blogs.library.duke.edu/rubenstein/ 

Be our fan on Facebook: http://www.facebook.com/rubensteinlibrary 









_______________________________________________ 
Archivesspace_Users_Group mailing list 
Archivesspace_Users_Group at lyralists.lyrasis.org 
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20140123/21616b32/attachment.html>