<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="">
<div class=""><br class="">
</div>
<div class="">We had this problem as well. See previous thread in mailing list:</div>
<div class=""><br class="">
</div>
<div class=""><a href="http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/2016-November/004238.html" class="">http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/2016-November/004238.html</a></div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">I believe it’s a lot easier to fix the problem in 1.4.2 before migration, where it can be done in MySQL, than to try to fix it afterwards when top_container become independent linked objects: a lot simpler to just change a couple values in a table
than to deal with deleting and creating top_containers. </div>
<div class=""><br class="">
</div>
<div class="">In our case it was a bit more complicated because some of the container type enums had already been merged and changed, so it required pulling info from a previous mysqldump and creating a view over several tables. </div>
<div class="">In your case, I think you can just lookup the container type ids for “box”, “folder” and “box/folder” and update the container values where type_1_id = [box/folder id] AND type_2_id IS NULL and indicator_1 LIKE “%/%” and indicator_2 is NULL. </div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">You might want to first do some exploring of table values in MySQL to check that there aren’t any false positives. I also tested everything out on a local test server with a database cloned from mysqldump of production database, before trying
the procedure on production data. </div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">— Steve. </div>
<div class=""><br class="">
</div>
<br class="">
<div>
<blockquote type="cite" class="">
<div class="">On Mar 6, 2017, at 12:53 PM, Tony Kurtz <<a href="mailto:Tony.Kurtz@wwu.edu" class="">Tony.Kurtz@wwu.edu</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div class="WordSection1" style="page: WordSection1; font-family: Menlo-Regular; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;">
<div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
Greetings,<o:p class=""></o:p></div>
<div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
I’ve searched around but I don’t think I’ve been able to find an answer to an issue we’re having. If I’m mistaken I’ll happily endure the embarrassment along with the solution!<o:p class=""></o:p></div>
<div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<o:p class=""> </o:p></div>
<div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
We are planning an upgrade from AS 1.4.2 to 1.5 and we are doing an assessment of how our top containers will look post-upgrade. One of our repositories expresses almost all containers with a type indicator of “box-folder” and a value expressed as a box/folder
pair, e.g. “1/1”, “1/2”, etc. (and all box/folder expressions are unique within a collection—i.e., each “b/f” value is not repeated). From what we can tell, it looks like the 1.5 upgrade process will result in top containers being created at the<span class="Apple-converted-space"> </span><b class="">folder</b><span class="Apple-converted-space"> </span>level.
However, we want top containers to be at the<span class="Apple-converted-space"> </span><b class="">box</b><span class="Apple-converted-space"> </span>level. Is our assumption correct that top containers will be created as folders? Does anyone have advice
on how best to navigate this so that we can ensure that boxes are our top containers—e.g. is there anything we can do prior to the upgrade to make this work out as we wish, or will we just need to do the work post-ugrade?<o:p class=""></o:p></div>
<div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<o:p class=""> </o:p></div>
<div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
Thanks<o:p class=""></o:p></div>
<div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<o:p class=""> </o:p></div>
<div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<span style="font-size: 9pt; font-family: Verdana, sans-serif;" class="">Tony Kurtz<o:p class=""></o:p></span></div>
<div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">
<span style="font-size: 8pt; font-family: Verdana, sans-serif;" class="">Western Washington University</span><o:p class=""></o:p></div>
</div>
<span style="font-family: Menlo-Regular; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">_______________________________________________</span><br style="font-family: Menlo-Regular; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<span style="font-family: Menlo-Regular; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">Archivesspace_Users_Group
mailing list</span><br style="font-family: Menlo-Regular; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" style="color: rgb(149, 79, 114); text-decoration: underline; font-family: Menlo-Regular; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br style="font-family: Menlo-Regular; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" style="color: rgb(149, 79, 114); text-decoration: underline; font-family: Menlo-Regular; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a></div>
</blockquote>
</div>
<br class="">
</body>
</html>