[Archivesspace_Users_Group] Advice for reordering large numbers of records

[Wendy Scheir]

Hi Catie,

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.

All best,
Wendy

____________________________________

WENDY SCHEIR

director
THE NEW SCHOOL ARCHIVES & SPECIAL COLLECTIONS

66 FIFTH AVENUE, NEW YORK, NY 10011

scheirw at newschool.edu
<https://www.newschool.edu/email-signature-generator/robinsa1@newschool.edu>

T 212-229-5942

Explore the Archives <http://archives.newschool.edu> | Digital Collections
from the Archives <http://digitalarchives.library.newschool.edu/> | New
School Histories <http://newschoolhistories.org/> | @tnsarchives
<https://twitter.com/tnsarchives>

[image: THE NEW SCHOOL]



On Wed, Sep 14, 2022 at 9:20 AM Catie Heitz <c.heitz at aarome.org> wrote:

> Thanks Corey,
> This is very helpful. We will try using the API first and we will let you
> know if it works for us.
>
> Best,
>
> Catie Heitz (she/her)
> Archivist
> American Academy in Rome
> 7 East 60th St.
> New York, NY 10022
> 212-751-7200 x347
> 212-751-7220 (fax)
> c.heitz at aarome.org <archives at aarome.org>
> www.aarome.org
>
>
> On Wed, Sep 14, 2022 at 8:54 AM Corey Schmidt <Corey.Schmidt at uga.edu>
> wrote:
>
>> Hey Catie,
>>
>> I haven’t used the bulk_updater plugin (
>> https://github.com/hudmol/as_spreadsheet_bulk_updater), 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:
>> https://www.youtube.com/watch?v=LQW1qB_6VGI).
>>
>>
>> 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 (
>> https://archivesspace.github.io/archivesspace/api/?python#get-the-children-of-an-archival-object)
>> 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 (
>> https://archivesspace.github.io/archivesspace/api/?python#update-an-archival-object)
>> to push the updated archival objects in their new positions to ASpace.
>>
>> 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.
>>
>> Hope this helps,
>>
>> Corey
>>
>> *Corey Schmidt*
>> University of Georgia Special Collections Libraries | *Project
>> Management Librarian/Archivist*
>> Corey.Schmidt at uga.edu
>>
>> *From:* archivesspace_users_group-bounces at lyralists.lyrasis.org <
>> archivesspace_users_group-bounces at lyralists.lyrasis.org> *On Behalf Of *Catie
>> Heitz
>> *Sent:* Tuesday, September 13, 2022 8:24 AM
>> *To:* Archivesspace_Users_Group at lyralists.lyrasis.org
>> *Subject:* [Archivesspace_Users_Group] Advice for reordering large
>> numbers of records
>>
>>
>>
>> [EXTERNAL SENDER - PROCEED CAUTIOUSLY]
>>
>> 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?
>>
>> Thank you.
>>
>>
>>
>> Catie Heitz (she/her)
>>
>> Archivist
>> American Academy in Rome
>> 7 East 60th St.
>> New York, NY 10022
>> 212-751-7200 x347
>> 212-751-7220 (fax)
>> c.heitz at aarome.org <archives at aarome.org>
>> www.aarome.org
>> _______________________________________________
>> Archivesspace_Users_Group mailing list
>> Archivesspace_Users_Group at lyralists.lyrasis.org
>> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20220914/03e3bd66/attachment.html>