<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
Hi Nathan,
<div class=""><br class="">
</div>
<div class="">Yeah, that’s what I just suggested in my email. There are two problems with this idea. One, refids are only unique to the resource. This is fine if my query can also pull down the resource identifier that a component belongs to, but here’s where
we get to our next problem… The resourcescomponents table in AT doesn’t reference the related resource unless it’s a top-level component. My colleague Steelsen Smith wrote <a href="https://github.com/SteelsenS/ATK_Tools/tree/master/databaseTools" class="">some
SQL procedures</a> to recursively find the parent of a component until it gets to a component that has a resource record ID, but this obviously won’t find anything if I have an orphan component (in fact, the procedures don’t envision this, so mysql hangs and
then barfs). I think my best bet will probably be to modify Steelsen’s procedures to manage error handling, so it can tell me explicitly that a component doesn’t have a parent resource.</div>
<div class=""><br class="">
</div>
<div class="">Obviously, I’m open to more straightforward approaches! It would probably be good to know, as part of the migrator, not just that resources migrated but that all parts of all resources are accounted for.</div>
<div class=""><br class="">
</div>
<div class="">Maureen</div>
<div class=""><br class="">
<div>
<blockquote type="cite" class="">
<div class="">On Jun 2, 2015, at 2:22 PM, Nathan Stevens <<a href="mailto:ns96@nyu.edu" class="">ns96@nyu.edu</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div dir="ltr" class="">Try a combination of ref_ids and call numbers (I am assuming call numbers get placed into the component unique id field in AT). A combination of those two fields should result in uniquely identifying the resource components as long
as call numbers were always field out.<br class="">
</div>
<div class="gmail_extra"><br class="">
<div class="gmail_quote">On Tue, Jun 2, 2015 at 1:59 PM, Callahan, Maureen <span dir="ltr" class="">
<<a href="mailto:maureen.callahan@yale.edu" target="_blank" class="">maureen.callahan@yale.edu</a>></span> wrote:<br class="">
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="#0563C1" vlink="#954F72" lang="EN-US" class="">
<div class="">
<p class="MsoNormal">Hi everyone,<u class=""></u><u class=""></u></p>
<p class="MsoNormal"><u class=""></u> <u class=""></u></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.<u class=""></u><u class=""></u></p>
<p class="MsoNormal"><u class=""></u> <u class=""></u></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.<u class=""></u><u class=""></u></p>
<p class="MsoNormal"><u class=""></u> <u class=""></u></p>
<p class="MsoNormal">Maureen<u class=""></u><u class=""></u></p>
<p class="MsoNormal"><u class=""></u> <u class=""></u></p>
<p class="MsoNormal">Maureen Callahan<u class=""></u><u class=""></u></p>
<p class="MsoNormal"><span style="color:#404040" class="">Archivist, Metadata Specialist<u class=""></u><u class=""></u></span></p>
<p class="MsoNormal"><span style="color:#404040" class="">Manuscripts & Archives<u class=""></u><u class=""></u></span></p>
<p class="MsoNormal"><span style="color:#404040" class="">Yale University Library<u class=""></u><u class=""></u></span></p>
<p class="MsoNormal"><span style="color:#8496b0" class=""><a href="mailto:maureen.callahan@yale.edu" target="_blank" class=""><span style="color:#8496b0" class="">maureen.callahan@yale.edu</span></a><u class=""></u><u class=""></u></span></p>
<p class="MsoNormal"><span style="color:#404040" class=""><a href="tel:203.432.3627" value="+12034323627" target="_blank" class="">203.432.3627</a><u class=""></u><u class=""></u></span></p>
<p class="MsoNormal"><span style="color:#7f7f7f" class=""><u class=""></u> <u class=""></u></span></p>
<p class="MsoNormal"><span style="color:#404040" class="">Webpage:</span><span style="color:#7f7f7f" class="">
</span><span style="color:#8496b0" class=""><a href="http://web.library.yale.edu/mssa" target="_blank" class=""><span style="color:#8496b0" class="">web.library.yale.edu/mssa</span></a></span><span style="color:#7f7f7f" class=""><u class=""></u><u class=""></u></span></p>
<p class="MsoNormal"><span style="color:#404040" class="">Collections:</span><span style="color:#7f7f7f" class="">
</span><span style="color:#8496b0" class=""><a href="http://drs.library.yale.edu/" target="_blank" class=""><span style="color:#8496b0" class="">drs.library.yale.edu</span></a></span><span style="color:#7f7f7f" class=""><u class=""></u><u class=""></u></span></p>
<p class="MsoNormal"><u class=""></u> <u class=""></u></p>
</div>
</div>
<br class="">
_______________________________________________<br class="">
Archivesspace_Users_Group mailing list<br class="">
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" class="">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br class="">
<a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=AwMFaQ&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=JgH2YCQ8D3P9-Lm_x4bv3d2CZBYlbx6hxnLFHtfovi8&m=otb3yGWWepY7M7b-n4tvhCmEzIZlkl6wasO7MBVZxjg&s=OwtX6HnAHQ6c2aV7-Z5tvs2AMVYLUHf1_DZHusciiFY&e=" target="_blank" class="">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br class="">
<br class="">
</blockquote>
</div>
<br class="">
<br clear="all" class="">
<br class="">
-- <br class="">
<div class="gmail_signature">Nathan Stevens<br class="">
Programmer/Analyst<br class="">
Digital Library Technology Services<br class="">
New York University<br class="">
<br class="">
1212-998-2653<br class="">
<a href="mailto:ns96@nyu.edu" target="_blank" class="">ns96@nyu.edu</a></div>
</div>
_______________________________________________<br class="">
Archivesspace_Users_Group mailing list<br class="">
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" class="">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br class="">
https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=AwICAg&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=JgH2YCQ8D3P9-Lm_x4bv3d2CZBYlbx6hxnLFHtfovi8&m=otb3yGWWepY7M7b-n4tvhCmEzIZlkl6wasO7MBVZxjg&s=OwtX6HnAHQ6c2aV7-Z5tvs2AMVYLUHf1_DZHusciiFY&e=
<br class="">
</div>
</blockquote>
</div>
<br class="">
</div>
</body>
</html>