<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<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;font-family:Calibri,Helvetica,sans-serif;" dir="ltr">
<p style="margin-top:0;margin-bottom:0">I am questioning whether a query given in the documentation may lead to misleading results. I am following the troubleshooting steps in the Archon migration documentation fro:
<br>
</p>
<p style="margin-top:0;margin-bottom:0"><a href="https://archivesspace.org/wp-content/uploads/2017/12/Archon-to-ArchivesSpace-Migration-Tool-Instructions.pdf" class="OWAAutoLink" id="LPlnk778426" previewremoved="true">https://archivesspace.org/wp-content/uploads/2017/12/Archon-to-ArchivesSpace-Migration-Tool-Instructions.pdf</a></p>
<p style="margin-top:0;margin-bottom:0"><br>
</p>
<p style="margin-top:0;margin-bottom:0">I understand why multiple collection records cannot share the same CollectionID, ParentID and SortOrder.<br>
</p>
<p style="margin-top:0;margin-bottom:0">You can't have two items in a list both occupying position 2, for example.
<br>
</p>
<p style="margin-top:0;margin-bottom:0"><br>
</p>
<p style="margin-top:0;margin-bottom:0">However, I don't think there is anything contradictory about having multiple records with ParentID of 0 all sharing the same sort order, as long as their CollectionID's are different.
<br>
</p>
<p style="margin-top:0;margin-bottom:0"><br>
</p>
<p style="margin-top:0;margin-bottom:0">Page 5, sections c/d of the documentations says:<br>
</p>
<p style="margin-top:0;margin-bottom:0"><br>
</p>
<p style="margin-top:0;margin-bottom:0"></p>
<div>"c. <br>
Optionally, if the migration fails, check for ‘duplicate’ collection content records. <br>
‘Duplicate’ records are those that occupy the same node in the collection/content
<br>
hiearchy. To check for these records, run the following query in mysql or sql server.
<br>
SELECT ParentID, SortOrder, count (*) from tblCollections_Content Group by <br>
ParentID, SortOrder HAVING count(*) > 1; </div>
<div><br>
d. <br>
The query above checks for records that occupy the same branch and same position in
<br>
the content hierarchy. If you discover such records, the sort order value of one of the
<br>
records must be changed, so that both records occupy a unique position. "<br>
</div>
<div><br>
</div>
<div>As an aside, the first instance of Count(*) has an extraneous space which will prevent the query from running.
<br>
</div>
<div><br>
</div>
<div>An example result row from running this query on our Archon database yields:</div>
<div>
<div>ParentID SortOrder count(*)</div>
<div>0 30 3</div>
<div><br>
</div>
<div>When I examine these three records, they all have unique CollectionID's. I believe this is only telling me that there are three top-level collections which each possess a child record occupying SortOrder 30. Since these records would never appear in the
same finding aid listing, I don't see this as problematic.<br>
</div>
</div>
<div><br>
</div>
<div>Should the query include CollectionID in order to find those records which really do share the same SortOrder position within the same collection? Or,
<span>do I misunderstand the results I am getting? </span></div>
<div><br>
</div>
<div>thanks,<br>
</div>
<p></p>
<p style="margin-top:0;margin-bottom:0"><br>
</p>
<div id="Signature">
<div id="divtagdefaultwrapper" dir="ltr" style="font-size: 12pt; color: rgb(0, 0, 0); font-family: Calibri, Arial, Helvetica, sans-serif, "EmojiFont", "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols;">
<p><span style="font-size:9pt">DOUG SIMMONS</span></p>
<p><span style="font-size:9pt">Assistant Manager, Morris Library Systems</span></p>
<p><span style="font-size:9pt"><br>
</span></p>
<p><span style="font-size:9pt">MORRIS LIBRARY</span></p>
<p><span style="font-size:9pt">MAIL CODE 6632</span></p>
<p><span style="font-size:9pt">SOUTHERN ILLINOIS UNIVERSITY</span></p>
<p><span style="font-size:9pt">605 AGRICULTURE DRIVE</span></p>
<p><span style="font-size:9pt">CARBONDALE, ILLINOIS 62901<span style="font-family:"Trebuchet MS",sans-serif"></span></span></p>
<p><span style="font-size:9pt"><span style="font-family:"Trebuchet MS",sans-serif"><br>
</span></span></p>
<p><span style="font-size:9pt"><span style="font-family:"Trebuchet MS",sans-serif">dsimmons@siu.edu</span></span></p>
<p><span style="font-size:9pt"><span style="font-family:"Trebuchet MS",sans-serif">P: 618-453-1026</span></span></p>
</div>
</div>
</div>
</body>
</html>