<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="">
Nathan, that is odd. In the long term, i agree best to fix in refactored migration too, but in short term should be working in archon.
<div class=""><br class="">
</div>
<div class="">I wonder if this is a php version issue? It is working correctly on my development branch, which uses php 5.3.3; which was last supported version of php for archon.</div>
<div class=""><br class="">
</div>
<div class="">I get this output for the collection content:
<div class=""><br class="">
</div>
<div class="">
<div class="">"1": {</div>
<div class=""> "ID": "1",</div>
<div class=""> "CollectionID": "1",</div>
<div class=""> "Title": "CollectionMgr.C01Title-Archon<emph render='bold'>Bold</emph>",</div>
<div class=""> "PrivateTitle": "CollectionMgr.C01InternalTitle-Archon",</div>
<div class=""> "Date": "CollectionMgr.C01Date-Archon",</div>
<div class=""> "Description": "CollectionMgr.C01Description-Archon <emph render='bold'>bold</emph>",</div>
<div class=""> "RootContentID": "1",</div>
<div class=""> "ParentID": "0",</div>
<div class=""> "ContainsContent": "1",</div>
<div class=""> "Enabled": "1",</div>
<div class=""> "SortOrder": "1",</div>
<div class=""> "Subjects": [</div>
<div class=""> "10",</div>
<div class=""> "1",</div>
<div class=""> "2",</div>
<div class=""> "3",</div>
<div class=""> "4",</div>
<div class=""> "5",</div>
<div class=""> "6",</div>
<div class=""> "7",</div>
<div class=""> "8",</div>
<div class=""> "9"</div>
<div class=""> ],</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div>
<blockquote type="cite" class="">
<div class="">On Jul 17, 2015, at 9:26 AM, 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="">I tested the change Chris pushed to github, but that simple removes the bbcode and doesn't replace it with the correct html. As such, I would not recommend applying this fix if you plan on using the Refactored Archon migration tool.
The refactored tool will allow for the bbcode to be removed, or converted valid html tags.</div>
<div class="gmail_extra"><br class="">
<div class="gmail_quote">On Fri, Jul 17, 2015 at 10:20 AM, Nathan Stevens <span dir="ltr" class="">
<<a href="mailto:ns96@nyu.edu" target="_blank" class="">ns96@nyu.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 dir="ltr" class="">The refactored Archon migration tool should automatically handle these conversions, so no need to do manual clean up.</div>
<div class="gmail_extra"><br class="">
<div class="gmail_quote">
<div class="">
<div class="h5">On Fri, Jul 17, 2015 at 9:39 AM, Suda, Phillip J <span dir="ltr" class="">
<<a href="mailto:psuda1@tulane.edu" target="_blank" class="">psuda1@tulane.edu</a>></span> wrote:<br class="">
</div>
</div>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="">
<div class="h5">
<div lang="EN-US" link="blue" vlink="purple" class="">
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="">Thanks Brian. I found it. I am doing quite a bit of cleanup on the Archon DB side of things it seems.
<u class=""></u><u class=""></u></span></p>
<span class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""><u class=""></u> <u class=""></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="">Thanks,
<u class=""></u><u class=""></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""><u class=""></u> <u class=""></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="">Phil
<u class=""></u><u class=""></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""><u class=""></u> <u class=""></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""><u class=""></u> <u class=""></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="">Phillip Suda<u class=""></u><u class=""></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="">Systems Librarian<u class=""></u><u class=""></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="">Howard-Tilton Memorial Library<u class=""></u><u class=""></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="">Tulane University<u class=""></u><u class=""></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""><a href="mailto:psuda1@tulane.edu" target="_blank" class="">psuda1@tulane.edu</a><u class=""></u><u class=""></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""><a href="tel:504-865-5607" value="+15048655607" target="_blank" class="">504-865-5607</a><u class=""></u><u class=""></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""><u class=""></u> <u class=""></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""><u class=""></u> <u class=""></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""><u class=""></u> <u class=""></u></span></p>
</span>
<div class="">
<div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0in 0in 0in" class="">
<p class="MsoNormal"><b class=""><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class="">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class=""> Brian Hoffman [mailto:<a href="mailto:brianjhoffman@gmail.com" target="_blank" class="">brianjhoffman@gmail.com</a>]
<br class="">
<b class="">Sent:</b> Friday, July 17, 2015 8:02 AM<br class="">
<b class="">To:</b> Suda, Phillip J <<a href="mailto:psuda1@tulane.edu" target="_blank" class="">psuda1@tulane.edu</a>><br class="">
<b class="">Cc:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank" class="">archivesspace_users_group@lyralists.lyrasis.org</a>>; Matthew J Gorzalski <<a href="mailto:mGorzalski@lib.siu.edu" target="_blank" class="">mGorzalski@lib.siu.edu</a>></span></p>
<div class="">
<div class=""><br class="">
<b class="">Subject:</b> Re: [Archivesspace_Users_Group] Archon to ArchivesSpace Migration Problems & Questions<u class=""></u><u class=""></u></div>
</div>
<div class=""><br class="webkit-block-placeholder">
</div>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal"><u class=""></u> <u class=""></u></p>
<p class="MsoNormal">Hi Phil,<u class=""></u><u class=""></u></p>
<div class="">
<p class="MsoNormal"><u class=""></u> <u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal">I think the Archon experts could answer this better than I can - I do know that Archon uses a square bracket markup style for things like italics, and I would assume that the markup is stored in the DB. <u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><u class=""></u> <u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal">I don’t think the Archon php files have any bearing on ArchivesSpace - during the migration process all Archon content is served to the migration tool as JSON objects over HTTP.<u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><u class=""></u> <u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal">Brian<u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><u class=""></u> <u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><u class=""></u> <u class=""></u></p>
<div class="">
<div class="">
<p class="MsoNormal">On Jul 6, 2015, at 4:39 PM, Suda, Phillip J <<a href="mailto:psuda1@tulane.edu" target="_blank" class="">psuda1@tulane.edu</a>> wrote:<u class=""></u><u class=""></u></p>
</div>
<p class="MsoNormal"><br class="">
<br class="">
<u class=""></u><u class=""></u></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt" class="">
<div class="">
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="">Brian,</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""> </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""> While I am not a SQL pro, I know my way around well enough to look at the tables, perform queries, and so forth. Where exactly are these [b] and
[i]’s that are showing up in the ArchivesSpace Component Lists & Headers located in the SQL tables? I am not seeing them in the sql data (either the original Archon data or the created ArchivesSpace data post-migration).</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""> </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="">I am seeing a reference to the [b] and [i] in the common.inc.php files on the Archon side, but I am not sure if/how ArchivesSpace is using this file
for the migration.</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""> </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="">Thanks,</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""> </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="">Phil</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""> </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0in 0in 0in" class="">
<div class="">
<p class="MsoNormal"><b class=""><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class="">From:</span></b><span class=""><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class=""> </span></span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class="">brian
[<a href="mailto:brianjhoffman@gmail.com" target="_blank" class="">mailto:brianjhoffman@gmail.com</a>]<span class=""> </span><br class="">
<b class="">Sent:</b><span class=""> </span>Monday, July 06, 2015 1:37 PM<br class="">
<b class="">To:</b><span class=""> </span>Suda, Phillip J; Archivesspace Users Group; Matthew J Gorzalski<br class="">
<b class="">Subject:</b><span class=""> </span>RE: [Archivesspace_Users_Group] Archon to ArchivesSpace Migration Problems & Questions</span><u class=""></u><u class=""></u></p>
</div>
</div>
</div>
<div class="">
<p class="MsoNormal"> <u class=""></u><u class=""></u></p>
</div>
<div class="">
<div class="">
<p class="MsoNormal">Hi Phil,<u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal"> <u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal">That's correct- it can actually only be done in the context of a single resource record and a single sub record type. For example, "replace 'abc' with 'def' in all container summaries of all extent records associated with the g.g. Alin
papers". There isn't currently a way to do a global search and replace, and I'd recommend leaving that to someone facile with sql who can do it at the database level.<u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal"> <u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal">Brian<u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal"> <u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal"> <u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal"><span style="font-size:7.0pt;color:#575757" class="">Sent from my T-Mobile 4G LTE Device</span><u class=""></u><u class=""></u></p>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"> <u class=""></u><u class=""></u></p>
<div class="">
<div class="">
<p class="MsoNormal">-------- Original message --------<u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal">From: "Suda, Phillip J" <<a href="mailto:psuda1@tulane.edu" target="_blank" class=""><span style="color:purple" class="">psuda1@tulane.edu</span></a>><u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal">Date:07/06/2015 2:17 PM (GMT-05:00)<u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal">To: Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank" class=""><span style="color:purple" class="">archivesspace_users_group@lyralists.lyrasis.org</span></a>>, Matthew J Gorzalski
<<a href="mailto:mGorzalski@lib.siu.edu" target="_blank" class=""><span style="color:purple" class="">mGorzalski@lib.siu.edu</span></a>>, Brian Hoffman <<a href="mailto:brianjhoffman@gmail.com" target="_blank" class=""><span style="color:purple" class="">brianjhoffman@gmail.com</span></a>><u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal">Cc:<u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal">Subject: RE: [Archivesspace_Users_Group] Archon to ArchivesSpace Migration Problems & Questions<u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal"> <u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="">Brian,</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""> </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""> From what I can tell, the Batch Find & Replace cannot be done on a “global”/instance-wide scale (i.e. finding all the <i>’s and <b>’s at component
level). It seems like it only works collection by collection. Please let me know what I am missing.</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""> </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""> </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="">Thanks,</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""> </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="">Phil</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""> </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""> </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="">Phillip Suda</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="">Systems Librarian</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="">Howard-Tilton Memorial Library</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="">Tulane University</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><a href="mailto:psuda1@tulane.edu" target="_blank" class=""><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple" class="">psuda1@tulane.edu</span></a><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""><a href="tel:504-865-5607" value="+15048655607" target="_blank" class="">504-865-5607</a></span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""> </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""> </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""> </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0in 0in 0in" class="">
<div class="">
<p class="MsoNormal"><b class=""><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class="">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class=""> </span><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank" class=""><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple" class="">archivesspace_users_group-bounces@lyralists.lyrasis.org</span></a><span class=""><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class=""> </span></span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class="">[</span><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank" class=""><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple" class="">mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org</span></a><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class="">]<span class=""> </span><b class="">On
Behalf Of<span class=""> </span></b>brian<br class="">
<b class="">Sent:</b><span class=""> </span>Monday, July 06, 2015 12:40 PM<br class="">
<b class="">To:</b><span class=""> </span>Matthew J Gorzalski; Archivesspace Users Group<br class="">
<b class="">Subject:</b><span class=""> </span>Re: [Archivesspace_Users_Group] Archon to ArchivesSpace Migration Problems & Questions</span><u class=""></u><u class=""></u></p>
</div>
</div>
</div>
<div class="">
<p class="MsoNormal"> <u class=""></u><u class=""></u></p>
</div>
<div class="">
<div class="">
<p class="MsoNormal">Hi Mathew,<u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal"> <u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal">This will probably be resolved by deleting your solr index and restarting the application, then waiting for the index to rebuild.<u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal"> <u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal">Brian<u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal"> <u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal"> <u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal"><span style="font-size:7.0pt;color:#575757" class="">Sent from my T-Mobile 4G LTE Device</span><u class=""></u><u class=""></u></p>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"> <u class=""></u><u class=""></u></p>
<div class="">
<div class="">
<p class="MsoNormal">-------- Original message --------<u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal">From: Matthew J Gorzalski <<a href="mailto:mGorzalski@lib.siu.edu" target="_blank" class=""><span style="color:purple" class="">mGorzalski@lib.siu.edu</span></a>><u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal">Date:07/06/2015 11:33 AM (GMT-05:00)<u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal">To: Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank" class=""><span style="color:purple" class="">archivesspace_users_group@lyralists.lyrasis.org</span></a>><u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal">Cc:<u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal">Subject: Re: [Archivesspace_Users_Group] Archon to ArchivesSpace Migration Problems & Questions<u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal"> <u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Georgia",serif" class="">I just went in manually in the ASpace admin view, selected one of our repositories, and went into classifications and deleted the empty ones. I found that the name of
the repository and the good classification matched. In other words, the Manuscripts classification under the Manuscripts repository was the only classification within that repository to have collections linked to it. </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Georgia",serif" class=""> </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Georgia",serif" class="">In the process I noticed that the migration produced some weird results, like it was creating false or empty collections that didn’t exist in our Archon. So I would have
Mr. Smith’s Papers, correctly linked to the Manuscripts classification in the Manuscripts repository. But an empty, no data Mr. Smith’s Papers might also appear in the Photographs classification in the Manuscripts Repository. After deleting the bad classifications,
the empty Mr. Smith would still be there. So when I found that record in the resource list and tried to delete it, I couldn’t because it would say “record not found.” So the result is a public view showing two Mr. Smith Papers, one of which has content and
the other is “record not found,” which it seems I am powerless to delete. That is the current issue.</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Georgia",serif" class=""> </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Georgia",serif" class="">Matt</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Georgia",serif" class=""> </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><b class=""><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class="">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class=""> </span><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank" class=""><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple" class="">archivesspace_users_group-bounces@lyralists.lyrasis.org</span></a><span class=""><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class=""> </span></span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class="">[</span><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank" class=""><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple" class="">mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org</span></a><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class="">]<span class=""> </span><b class="">On
Behalf Of<span class=""> </span></b>Nathan Stevens<br class="">
<b class="">Sent:</b><span class=""> </span>Monday, July 06, 2015 10:25 AM<br class="">
<b class="">To:</b><span class=""> </span>Archivesspace Users Group<br class="">
<b class="">Subject:</b><span class=""> </span>Re: [Archivesspace_Users_Group] Archon to ArchivesSpace Migration Problems & Questions</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"> <u class=""></u><u class=""></u></p>
</div>
<div class="">
<div class="">
<p class="MsoNormal">For deleting the bad classifications, use the post data migration tool at the link below, which also performs other clean up operations on the data. Of course, create a backup of the Archivesspace database before running this tool.<br class="">
<br class="">
<a href="https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_archivesspace_aspaceDBUtil&d=AwMFaQ&c=8hUWFZcy2Z-Za5rBPlktOQ&r=jGJMaTc-8I-z6_tkoj_Qyi4UF1KtYBfcz4s2Ly33jmw&m=XbpRrw4gS2Wkua8-vEd4bCwtu1R6QmPnqQDzAE4nzDI&s=kiD_YKCCNsMl5wSvuvHEh0wujySYNBj7me-DtLHJjWU&e=" target="_blank" class=""><span style="color:purple" class="">https://github.com/archivesspace/aspaceDBUtil</span></a><u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal"> <u class=""></u><u class=""></u></p>
</div>
<div class="">
<div class="">
<p class="MsoNormal">On Mon, Jul 6, 2015 at 10:03 AM, Suda, Phillip J <<a href="mailto:psuda1@tulane.edu" target="_blank" class=""><span style="color:purple" class="">psuda1@tulane.edu</span></a>> wrote:<u class=""></u><u class=""></u></p>
</div>
<blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt" class="">
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="">Matt,</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""> </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""> Thanks for your reply. With regard to deleting the “bad” classifications, does it matter which ones are deleted? Will there be any orphaned
data? I am wondering how I could check, via SQL queries? Thanks again for your help. I am glad to know there are others out there facing the same problems.</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""> </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="">Thanks,</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""> </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="">Phil</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""> </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""> </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="">Phillip Suda</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="">Systems Librarian</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="">Howard-Tilton Memorial Library</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class="">Tulane University</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><a href="mailto:psuda1@tulane.edu" target="_blank" class=""><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple" class="">psuda1@tulane.edu</span></a><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><a href="tel:504-865-5607" target="_blank" class=""><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple" class="">504-865-5607</span></a><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""> </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""> </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" class=""> </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0in 0in 0in" class="">
<div class="">
<p class="MsoNormal"><b class=""><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class="">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class=""> </span><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank" class=""><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple" class="">archivesspace_users_group-bounces@lyralists.lyrasis.org</span></a><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class="">[mailto:</span><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank" class=""><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple" class="">archivesspace_users_group-bounces@lyralists.lyrasis.org</span></a><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class="">]<span class=""> </span><b class="">On
Behalf Of<span class=""> </span></b>Matthew J Gorzalski<br class="">
<b class="">Sent:</b><span class=""> </span>Thursday, July 02, 2015 1:04 PM</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<div class="">
<p class="MsoNormal"><br class="">
<b class="">To:</b><span class=""> </span>Archivesspace Users Group<br class="">
<b class="">Subject:</b><span class=""> </span>Re: [Archivesspace_Users_Group] Archon to ArchivesSpace Migration Problems & Questions<u class=""></u><u class=""></u></p>
</div>
</div>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal"> <u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Georgia",serif" class="">We just tried the batch replace and a remigration to see if it worked, but ran into an error that crashed the migration and are waiting for a response to Doug Simmons’
email yesterday afternoon.</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Georgia",serif" class=""> </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Georgia",serif" class="">But Phil, a lot of you’re issues are problems we’re experiencing too (we’re Archon users). I will be talking about our migration adventure at SAA next month and highlight
some of these same issues. The reason classifications are duplicated is because Archon’s classification structure is shared globally throughout Archon, but in ASpace the classifications are replicated per repository. I deleted our “bad” classifications post
migration to knock it back down to 5 from the 30 ArchivesSpace spit out.</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Georgia",serif" class=""> </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Georgia",serif" class=""> </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Georgia",serif" class="">Matt Gorzalski</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Georgia",serif" class="">SIU Carbondale</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Georgia",serif" class=""> </span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"><b class=""><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class="">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class=""> </span><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank" class=""><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple" class="">archivesspace_users_group-bounces@lyralists.lyrasis.org</span></a><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class="">[</span><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank" class=""><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple" class="">mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org</span></a><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" class="">]<span class=""> </span><b class="">On
Behalf Of<span class=""> </span></b>Maura Carbone<br class="">
<b class="">Sent:</b><span class=""> </span>Thursday, July 02, 2015 11:54 AM<br class="">
<b class="">To:</b><span class=""> </span>Archivesspace Users Group<br class="">
<b class="">Subject:</b><span class=""> </span>Re: [Archivesspace_Users_Group] Archon to ArchivesSpace Migration Problems & Questions</span><u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"> <u class=""></u><u class=""></u></p>
</div>
<div class="">
<div class="">
<p class="MsoNormal">Hi Phillip,<u class=""></u><u class=""></u></p>
</div>
<div class="">
<div class="">
<p class="MsoNormal">With regards to number 5, it is a known issue. I have one of the earlier emails about this saved: "<span style="font-size:9.5pt" class="">This is not a bug, but rather has to do with how the information was entered into archon in the first
place. To fix, </span><span style="font-family:"Calibri",sans-serif" class="">a find-replace on all records with will need to done changing [i] into <i> and [/i] into </i>, directly on the backend data."</span><u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal"> <u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif" class="">Brian detailed a bit more: "</span><span style="font-size:9.5pt" class="">You can do this with the Batch <span style="background:white" class="">Find</span> <span style="background:white" class="">and</span> <span style="background:white" class="">Replace</span> feature
(found in the “Background Jobs” section). But you need to test this first in a test environment using a copy of your database. When you are ready to proceed <span style="background:white" class="">and</span> use your production database, make sure to back
it up first."</span><u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal"> <u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal"><span style="font-size:9.5pt" class="">I'm not sure if something like that would need to be done for your other special characters as well.</span><u class=""></u><u class=""></u></p>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal"><span style="font-size:9.5pt" class="">-Maura</span><u class=""></u><u class=""></u></p>
</div>
</div>
</div>
<div class="">
<div class="">
<p class="MsoNormal"> <u class=""></u><u class=""></u></p>
</div>
<div class="">
<div class="">
<p class="MsoNormal">On Thu, Jul 2, 2015 at 12:44 PM, Suda, Phillip J <<a href="mailto:psuda1@tulane.edu" target="_blank" class=""><span style="color:purple" class="">psuda1@tulane.edu</span></a>> wrote:<u class=""></u><u class=""></u></p>
</div>
<blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt" class="">
<div class="">
<p class="MsoNormal">Good morning all,<u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"> <u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"> I have performed migrations from Archon to ArchivesSpace successfully. I have then upgraded to the most recent version of ArchivesSpace (v.1.3.0) for each of my instances. This all works better locally (MacBook for me).
I have a few questions regarding problems we are noticing with the migrations. I do not know who to ask specifically, but here it goes:<u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"> <u class=""></u><u class=""></u></p>
</div>
<p class="">1.<span style="font-size:7.0pt" class=""> <span class=""> </span></span>Public Interface Special Characters & Diacritics:<u class=""></u><u class=""></u></p>
<p style="margin-left:1.0in" class="">a.<span style="font-size:7.0pt" class=""> <span class=""> </span></span>Example: Alcée Fortier papers, 1894-1911 in Archon changes to Alc√©e Fortier papers in ArchivesSpace (v.1.04-v.1.3.0).<u class=""></u><u class=""></u></p>
<p class="">2.<span style="font-size:7.0pt" class=""> <span class=""> </span></span>Public Interface Scope & Content Notes: these are migrated to ArchivesSpace as large text blobs; they were formatted in Archon (indentation, paragraphs, etc.)<u class=""></u><u class=""></u></p>
<p class="">3.<span style="font-size:7.0pt" class=""> <span class=""> </span></span>Public Interface Repositories Odd Behavior:<u class=""></u><u class=""></u></p>
<p style="margin-left:1.0in" class="">a.<span style="font-size:7.0pt" class=""> <span class=""> </span></span>Are all “types” supposed to appear when selecting Repositories? It seems that if you select a repository, it should show you the collections only
OR signify the associated collection for each object/type in question <u class=""></u><u class=""></u></p>
<p style="margin-left:1.0in" class="">b.<span style="font-size:7.0pt" class=""> <span class=""> </span></span>When selecting a repository, the appropriate collections appear but “global” appears with results below the selected repository:<u class=""></u><u class=""></u></p>
<div class="">
<p class="MsoNormal"> <u class=""></u><u class=""></u></p>
</div>
<p style="margin-left:1.0in" class=""> <u class=""></u><u class=""></u></p>
<div class="">
<p class="MsoNormal"> <u class=""></u><u class=""></u></p>
</div>
<p class="">4.<span style="font-size:7.0pt" class=""> <span class=""> </span></span>Classifications appear to be duplicated:<u class=""></u><u class=""></u></p>
<p class="">5.<span style="font-size:7.0pt" class=""> <span class=""> </span></span>Components show [b] and [/b] OR [i] and [/i] in lists and headers:<u class=""></u><u class=""></u></p>
<div class="">
<p class="MsoNormal"> <u class=""></u><u class=""></u></p>
</div>
<div class="">
<p class="MsoNormal"> <u class=""></u><u class=""></u></p>
</div>
<p class="">6.<span style="font-size:7.0pt" class=""> <span class=""> </span></span>Can the Collections be sorted by Collection #/Identifier?<u class=""></u><u class=""></u></p>
</blockquote>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<p class="MsoNormal"><u class=""></u> <u class=""></u></p>
</div>
</div>
</div>
</div>
</div>
<br class="">
</div>
</div>
<span class="">_______________________________________________<br class="">
Archivesspace_Users_Group mailing list<br class="">
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank" 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=8hUWFZcy2Z-Za5rBPlktOQ&r=jGJMaTc-8I-z6_tkoj_Qyi4UF1KtYBfcz4s2Ly33jmw&m=XbpRrw4gS2Wkua8-vEd4bCwtu1R6QmPnqQDzAE4nzDI&s=FNEv1ln2sJNbCJV32TOYKk7Bx_W68rtuK37I7lQkhNM&e=" rel="noreferrer" target="_blank" class="">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br class="">
<br class="">
</span></blockquote>
</div>
<br class="">
<br clear="all" class="">
<span class="">
<div class=""><br class="">
</div>
-- <br class="">
<div class="">Nathan Stevens<br class="">
Programmer/Analyst<br class="">
Digital Library Technology Services<br class="">
New York University<br class="">
<br class="">
<a href="tel:1212-998-2653" value="+12129982653" target="_blank" class="">1212-998-2653</a><br class="">
<a href="mailto:ns96@nyu.edu" target="_blank" class="">ns96@nyu.edu</a></div>
</span></div>
</blockquote>
</div>
<br class="">
<br clear="all" class="">
<div class=""><br class="">
</div>
-- <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="">
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group<br class="">
</div>
</blockquote>
</div>
<br class="">
</div>
</div>
</body>
</html>