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

[Nathan Stevens]

Hi,

Since it seems that many users would like to do this, we will add an option
in the migration plugin to ignore names and/or subjects which are not
linked during the migration process.  We hope the have the updated plugin
ready for testing next week.


On Thu, Jan 23, 2014 at 9:45 AM, Ben Goldman <bmg17 at psu.edu> wrote:

> 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
>
>
> ------------------------------
> *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
>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>
>


-- 
Nathan Stevens
Programmer/Analyst
Digital Library Technology Services
New York University

1212-998-2653
ns96 at nyu.edu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20140123/bc4ea0be/attachment.html>