<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p><br>
</p>
<p>Hi Valerie,</p>
<p><br>
</p>
<p>Yeah, the approach I started down for this turned out to not be very consistent in identifying all the issues. I had to turn my attention to a couple of plugins that were needed and haven't been able to get back to restart this.</p>
<p><br>
</p>
<p>The best bet is to do the conversion on a backup and run the container_checker report, which will generate a CSV of pre- and post- conversion containers and show a diff.</p>
<p><br>
</p>
<p>If you want, I can run this report for you if you send me a dump of your mysql db.
<br>
</p>
<p><br>
</p>
<p>b,chris. <br>
</p>
<p><br>
</p>
<div id="Signature">
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:; margin:0">
<div class="BodyFragment"><font size="2">
<div class="PlainText">Chris Fitzpatrick | <font size="2">Developer, ArchivesSpace</font><br>
Skype: chrisfitzpat  | Phone: 918.236.6048<br>
http://archivesspace.org/<br>
</div>
</font></div>
</div>
</div>
<br>
<br>
<div style="color: rgb(0, 0, 0);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Valerie Addonizio
 <vaddoniz@jhu.edu><br>
<b>Sent:</b> Tuesday, April 26, 2016 4:53 PM<br>
<b>To:</b> Archivesspace Users Group<br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Container Checker</font>
<div> </div>
</div>
<div>
<div style="">
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif";">
<span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">Greetings. I’m picking this thread back up to ask about the pre-flight checker mentioned below:</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif";">
<span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"> </span></p>
<p style="margin-left:.5in; background:white"><span style="font-family:"Calibri","sans-serif"; color:black">I'm also working on something to do a pre-flight conversion check that will try and call out some potential issues with conversion, which I should have
 done in the next 24 hours or so. </span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif";">
<span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"> </span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif";">
<span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D">Thanks!</span></p>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif";">
<span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"> </span></p>
<div>
<div style="border:none; border-top:solid #B5C4DF 1.0pt; padding:3.0pt 0in 0in 0in">
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif";">
<b><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif""> archivesspace_users_group-bounces@lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org]
<b>On Behalf Of </b>Chris Fitzpatrick<br>
<b>Sent:</b> Monday, April 18, 2016 7:39 AM<br>
<b>To:</b> Archivesspace Users Group<br>
<b>Subject:</b> [Archivesspace_Users_Group] Container Checker</span></p>
</div>
</div>
<p style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif";">
 </p>
<div id="divtagdefaultwrapper">
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black">Hi,</span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black">I put together some SQL queries that might help some people verify their data post-container conversion.
</span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black">Have a look at :<a style="color: blue; text-decoration: underline;" href="https://github.com/archivesspace/container_checker" title="Cmd+Click or tap to follow the link" id="LPlnk184619">
 https://github.com/archivesspace/container_checker</a></span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black">There's a few things here:
</span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black"><a style="color: blue; text-decoration: underline;" href="https://github.com/archivesspace/container_checker/blob/master/container.sql">A SQL script</a> to dump out a
 CSV file of all your containers and their associated resources/accessions/archival objects and locations.
</span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black"><a style="color: blue; text-decoration: underline;" href="https://github.com/archivesspace/container_checker/blob/master/top_container.sql" title="Cmd+Click or tap to follow the link">Another
 SQL scrip</a>t to pull out a CSV file of all you top_containers and their associated resources/accessions/archival objects and locations </span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black">A <a style="color: blue; text-decoration: underline;" href="https://github.com/archivesspace/container_checker/blob/master/cc.sh">shell script</a> to run both the container
 and top_container SQL queries and diff them using the excellent <a style="color: blue; text-decoration: underline;" href="https://github.com/paulfitz/daff" title="Cmd+Click or tap to follow the link">
Daff </a>library and make a HTML table that shows the changes. ( script is linux only...sorry
<img style="-moz-user-select: none;" tabindex="0" id="_x0000_i1025" alt="&#X02639" height="19" border="0" width="19" src="cid:image001.png@01D19FA9.CC6A8F40">)
</span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black">In theory, the CSV files should be identical after conversion. In reality, this won't be the case since the data can change for a variety of reasons ( most of them beneficial
 ). However, you can get an overview of what's going on with this and look at it in the comfort of Excel or your preferred Excel alternative.
</span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black">Please give a go and let us know what you think. If you don't feel capable, or are too busy, or your IT guy is too busy, you can email me an MySQL dump of your database
 ( zipped up, please ) and I can send you back csv files and html output. </span>
</p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black">I'm also working on something to do a pre-flight conversion check that will try and call out some potential issues with conversion, which I should have done in the next
 24 hours or so. </span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black">Thanks and let us know what you think. 
</span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black">best, Chris.
</span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<p style="background:white"><span style="font-family:"Calibri","sans-serif"; color:black"> </span></p>
<div id="Signature">
<div name="divtagdefaultwrapper">
<div>
<div>
<p style="background: white none repeat scroll 0% 0%; margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif";">
<span style="font-size:10.0pt; font-family:"Calibri","sans-serif"; color:black">Chris Fitzpatrick | Developer, ArchivesSpace<br>
Skype: chrisfitzpat  | Phone: 918.236.6048<br>
<a style="color: blue; text-decoration: underline;" href="http://archivesspace.org/">http://archivesspace.org/</a></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>