<div dir="ltr">Hi Catie,<div><br></div><div>Unfortunately, the bulk editor is not useful for a big reordering job like that (nor for adding or deleting components). It sounds like the API might be the right route for you. What I had been thinking to suggest--since for us using the API means enlisting help from another over-worked department--was a longer process, where you'd export the spreadsheet, re-sort in Excel or Open Refine, import this as though a new series, deleting the other one.</div><div><br></div><div>All best,</div><div>Wendy<br clear="all"><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><p style="color:rgb(0,0,0);font-family:arial;font-size:10px;padding:5px 0px 0px 5px;margin:0px"><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px">____________________________________</span><span style="color:rgb(232,46,33)"><br></span></p><p style="font-family:arial;padding:5px 0px 0px 5px;margin:0px"><span style="font-size:10px;color:rgb(172,147,110);font-weight:bold">WENDY SCHEIR</span><br></p><p style="color:rgb(34,34,34);background:none 0% 0% repeat scroll transparent;margin:0px;padding:5px 0px 0px 5px;border:0px none;font-stretch:inherit;line-height:15px;font-family:arial;font-size:10px;vertical-align:baseline;outline:currentcolor none 0px"><span style="color:rgb(0,0,0);margin:0px;padding:0px;border:0px none;background:none 0% 0% repeat scroll transparent;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;outline:currentcolor none 0px;text-transform:uppercase">director</span><br><span style="color:rgb(232,46,33);margin:0px;padding:0px;border:0px none;background:none 0% 0% repeat scroll transparent;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;outline:currentcolor none 0px;text-transform:uppercase">THE NEW SCHOOL </span><span style="color:rgb(102,102,102);margin:0px;padding:0px;border:0px none;background:none 0% 0% repeat scroll transparent;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;outline:currentcolor none 0px;text-transform:uppercase">ARCHIVES & SPECIAL COLLECTIONS</span></p><p style="color:rgb(34,34,34);background:none 0% 0% repeat scroll transparent;margin:0px;padding:5px 0px 0px 5px;border:0px none;font-stretch:inherit;line-height:15px;font-family:arial;font-size:10px;vertical-align:baseline;outline:currentcolor none 0px"><span style="background-color:transparent;font-family:inherit;font-style:inherit;font-weight:inherit;color:rgb(102,102,102);text-transform:uppercase">66 FIFTH AVENUE, NEW YORK, NY 10011</span></p><p style="color:rgb(34,34,34);background:none 0% 0% repeat scroll transparent;margin:0px;padding:5px 0px 0px 5px;border:0px none;font-stretch:inherit;line-height:15px;font-family:arial;font-size:10px;vertical-align:baseline;outline:currentcolor none 0px"><a href="https://www.newschool.edu/email-signature-generator/robinsa1@newschool.edu" style="background-color:transparent;color:rgb(102,102,102);text-transform:lowercase" target="_blank">scheirw@newschool.edu</a></p><p style="background:none 0% 0% repeat scroll transparent;margin:0px;padding:10px 0px 0px 5px;border:0px none;font-stretch:inherit;line-height:15px;font-family:arial;font-size:10px;vertical-align:baseline;outline:currentcolor none 0px;color:rgb(102,102,102);text-transform:uppercase"><span style="margin:0px;padding:0px;border:0px none;background:none 0% 0% repeat scroll transparent;font-style:inherit;font-variant:inherit;font-weight:bold;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;outline:currentcolor none 0px;color:rgb(0,0,0)">T</span> 212-229-5942</p><p style="background:none 0% 0% repeat scroll transparent;margin:0px;padding:10px 0px 0px 5px;border:0px none;font-stretch:inherit;line-height:16.5px;font-family:arial;font-size:11px;vertical-align:baseline;outline:currentcolor none 0px;color:rgb(0,0,0);text-transform:uppercase"><a href="http://archives.newschool.edu" style="text-transform:none;color:rgb(172,147,110)" target="_blank">Explore the Archives</a><span style="color:rgb(32,33,36);text-transform:none;font-size:10px"> </span><span style="text-transform:none;font-size:10px">| </span><a href="http://digitalarchives.library.newschool.edu/" style="text-transform:none;color:rgb(172,147,110)" target="_blank">Digital Collections from the Archives</a><span style="color:rgb(32,33,36);text-transform:none;font-size:10px"> </span><span style="text-transform:none;font-size:10px">| </span><a href="http://newschoolhistories.org/" style="text-transform:none;color:rgb(172,147,110)" target="_blank">New School Histories</a><span style="color:rgb(32,33,36);text-transform:none;font-size:10px"> </span><font color="#000000" style="text-transform:none;font-size:10px">|</font><span style="color:rgb(32,33,36);text-transform:none;font-size:10px"> </span><a href="https://twitter.com/tnsarchives" style="text-transform:none;color:rgb(172,147,110)" target="_blank">@tnsarchives</a><br></p><p style="font-family:arial;padding:5px 0px 0px 5px;margin:0px"><img src="https://www.newschool.edu/edu-assets/marketing-communication/signature-tns.jpg" alt="THE NEW SCHOOL" style="background:none 0% 0% repeat scroll transparent;margin:0px;padding:15px 0px 0px 3px;border:0px none;font-stretch:inherit;line-height:inherit;font-family:neue,"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:17px;vertical-align:baseline;outline:currentcolor none 0px;color:rgb(25,25,25);width:262px"></p><div><div><p style="vertical-align:baseline;outline-width:0px;margin:0in 0in 0.0001pt"><font color="#999999" face="Arial, sans-serif" size="1"><span style="line-height:18px"></span></font></p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Sep 14, 2022 at 9:20 AM Catie Heitz <<a href="mailto:c.heitz@aarome.org">c.heitz@aarome.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Thanks Corey, <div>This is very helpful. We will try using the API first and we will let you know if it works for us. <br></div><div><br></div><div>Best,</div><div><br></div><div><div><div dir="ltr"><div dir="ltr">Catie Heitz (she/her)<div><div>Archivist<br>American Academy in Rome<br>7 East 60th St.<br>New York, NY 10022<br>212-751-7200 x347<br>212-751-7220 (fax)<br><a href="mailto:archives@aarome.org" target="_blank">c.heitz@aarome.org</a><br><a href="http://www.aarome.org/" target="_blank">www.aarome.org</a><br></div></div></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Sep 14, 2022 at 8:54 AM Corey Schmidt <<a href="mailto:Corey.Schmidt@uga.edu" target="_blank">Corey.Schmidt@uga.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div>
<div lang="EN-US">
<div>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:black">Hey Catie,<br>
<br>
I haven’t used the bulk_updater plugin (<a href="https://github.com/hudmol/as_spreadsheet_bulk_updater" target="_blank">https://github.com/hudmol/as_spreadsheet_bulk_updater</a>), but if the spreadsheet you re-upload to ASpace maintains any changes to the re-ordering of archival
objects, I think that’s the easiest way to go. Anna Robinson-Sweet at UCLA, Wendy Scheir at the New School, and James Bullen at Hudson Molonglo would be able to provide more details about the plugin and what it can do (presentation link for anyone interested:
<a href="https://www.youtube.com/watch?v=LQW1qB_6VGI" target="_blank">https://www.youtube.com/watch?v=LQW1qB_6VGI</a>).<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:black"><br>
Another option would be to write a script to use the ASpace API to reposition the archival objects in alphabetical order. You could use the Get the children of an Archival Object endpoint (<a href="https://archivesspace.github.io/archivesspace/api/?python#get-the-children-of-an-archival-object" target="_blank">https://archivesspace.github.io/archivesspace/api/?python#get-the-children-of-an-archival-object</a>)
to get a list of all the archival objects in the series, then use the script to alphabetize that list and change the "position":### field to match the order of the alphabetized list. Then use the Update an Archival Object endpoint (<a href="https://archivesspace.github.io/archivesspace/api/?python#update-an-archival-object" target="_blank">https://archivesspace.github.io/archivesspace/api/?python#update-an-archival-object</a>)
to push the updated archival objects in their new positions to ASpace.<br>
<br>
If there are no follow-ups in a week, I’ll try to spin up my local ASpace instance and test that plugin to see if it does what you’re asking.<br>
<br>
Hope this helps,<br>
<br>
Corey<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-bottom:12pt"><b><span style="font-size:9pt;font-family:Georgia,serif;color:black">Corey Schmidt</span></b><span style="font-size:9pt;font-family:Georgia,serif;color:black">
<br>
University of Georgia Special Collections Libraries | <i>Project Management Librarian/Archivist</i>
<br>
</span><a href="mailto:Corey.Schmidt@uga.edu" target="_blank"><span style="font-size:9pt;font-family:Georgia,serif">Corey.Schmidt@uga.edu</span></a><span style="font-size:9pt;font-family:Georgia,serif;color:black">
<u></u><u></u></span></p>
<div>
<div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(225,225,225);padding:3pt 0in 0in">
<p class="MsoNormal"><b><span style="font-size:11pt;font-family:Calibri,sans-serif">From:</span></b><span style="font-size:11pt;font-family:Calibri,sans-serif"> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
<b>On Behalf Of </b>Catie Heitz<br>
<b>Sent:</b> Tuesday, September 13, 2022 8:24 AM<br>
<b>To:</b> <a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<b>Subject:</b> [Archivesspace_Users_Group] Advice for reordering large numbers of records<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal" style="margin-bottom:12pt"><span style="color:rgb(186,12,47)">[EXTERNAL SENDER - PROCEED CAUTIOUSLY]</span><u></u><u></u></p>
<div>
<div>
<p class="MsoNormal">I'm looking for advice on how to reorder records efficiently. I have a series with a couple thousand records that need to be alphabetized. This is slow work in reorder mode. Is there a better way to do this? Is this something I can do with
the bulk updater plug-in? <u></u><u></u></p>
<div>
<p class="MsoNormal">Thank you. <u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<div>
<div>
<div>
<p class="MsoNormal">Catie Heitz (she/her) <u></u><u></u></p>
<div>
<div>
<p class="MsoNormal">Archivist<br>
American Academy in Rome<br>
7 East 60th St.<br>
New York, NY 10022<br>
212-751-7200 x347<br>
212-751-7220 (fax)<br>
<a href="mailto:archives@aarome.org" target="_blank">c.heitz@aarome.org</a><br>
<a href="http://www.aarome.org/" target="_blank">www.aarome.org</a><u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" rel="noreferrer" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br>
</div></blockquote></div>
_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" rel="noreferrer" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br>
</blockquote></div>