[Archivesspace_Users_Group] Export resource records to Excel

69 views
Skip to first unread message

Nick Richbell

unread,
Dec 6, 2023, 10:44:49 AM12/6/23
to archivesspac...@lyralists.lyrasis.org
Good morning, List:

I am new to ArchivesSpace and am slowly figuring this out. One thing I need some help with is whether I can export a resource (all of the collection) to Excel? I've tried to find a solution but have had no success. 

Any advice will be gratefully received!

Thanks, Nick



Nick Richbell, MLIS

Head, Special Collections and Archives 

Clemson University Libraries 

Clemson University 

 

Strom Thurmond Institute 

230 Kappa Street 

Clemson, SC  29634 

864-656-3875 

http://libraries.clemson.edu/specialcollections/ 

 

 

Norton, Channing

unread,
Dec 6, 2023, 4:04:33 PM12/6/23
to Archivesspace Users Group

Sarit, Nick,

 

The bulk updater has been added to the core code. I don’t recall the exact patch, perhaps 3.2. For the subrecords issue, I’m actually working on a new utility right now that will be able to help with that in a few weeks. Once I have something capable of doing these exports, I’ll build out the documentation and put it all under a release tag in the following repo where I’m working.

 

https://github.com/C-Norton/Archivesspace_Collections_Manager

 

 

Channing Norton (He/Him/They/Them)

Senior Programmer Analyst

Digital Initiatives

University of Rochester

 

On Campus Tues, Wed

 

From: archivesspace_us...@lyralists.lyrasis.org <archivesspace_us...@lyralists.lyrasis.org> On Behalf Of Hand, Sarit
Sent: Wednesday, December 6, 2023 2:06 PM
To: Archivesspace Users Group <archivesspac...@lyralists.lyrasis.org>
Subject: [EXT] Re: [Archivesspace_Users_Group] Export resource records to Excel

 

Have you tried the bulk updater plug-in? I honestly don’t recall if its been added to the core code yet. But that will allow you to download a spreadsheet of a single resource. However, there are some sub-records you will not get in that. That’s a development issue. Wendy Scheir from New School is behind that plug-in!

 

Cheers,

                                              

Sarit Hand                                                       200 Liberty St.

Digital Archivist                                               New York, NY 10281

Corporate Archives                                         T 212.621.7035

 


sh...@ap.org                                                 

www.ap.org

From: archivesspace_us...@lyralists.lyrasis.org <archivesspace_us...@lyralists.lyrasis.org> On Behalf Of Nick Richbell
Sent: Wednesday, December 6, 2023 10:45 AM
To: archivesspac...@lyralists.lyrasis.org
Subject: [Archivesspace_Users_Group] Export resource records to Excel

 

You don't often get email from nri...@clemson.edu. Learn why this is important

[EXTERNAL]

The information contained in this communication is intended for the use of the designated recipients named above. If the reader of this communication is not the intended recipient, you are hereby notified that you have received this communication in error, and that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify The Associated Press immediately by telephone at +1-212-621-1500 and delete this email. Thank you.

Christine Di Bella

unread,
Dec 6, 2023, 7:33:47 PM12/6/23
to Archivesspace Users Group

Thanks for sharing a link with a sneak preview of the data utility you’re building, Channing. This sounds like a really useful project and it’ll be great to hear more when you’re ready.

 

(Just to limit confusion for people reading this thread, I should point out that the bulk updater plugin is not part of the core code of ArchivesSpace – it is a separate plugin developed by Hudson Molonglo for The New School and shared with the ArchivesSpace community. The ArchivesSpace team is working on plans to incorporate this functionality into an upcoming release of ArchivesSpace.)

 

Christine

 

Christine Di Bella

ArchivesSpace Senior Program Manager

christin...@lyrasis.org

 

Hand, Sarit

unread,
Dec 13, 2023, 8:28:55 AM12/13/23
to Archivesspace Users Group

Have you tried the bulk updater plug-in? I honestly don’t recall if its been added to the core code yet. But that will allow you to download a spreadsheet of a single resource. However, there are some sub-records you will not get in that. That’s a development issue. Wendy Scheir from New School is behind that plug-in!

 

Cheers,

                                              

Sarit Hand                                                       200 Liberty St.

Digital Archivist                                               New York, NY 10281

Corporate Archives                                         T 212.621.7035

 


sh...@ap.org                                                 

www.ap.org

From: archivesspace_us...@lyralists.lyrasis.org <archivesspace_us...@lyralists.lyrasis.org> On Behalf Of Nick Richbell
Sent: Wednesday, December 6, 2023 10:45 AM
To: archivesspac...@lyralists.lyrasis.org
Subject: [Archivesspace_Users_Group] Export resource records to Excel

 

You don't often get email from nri...@clemson.edu. Learn why this is important

[EXTERNAL]

Good morning, List:

The information contained in this communication is intended for the use of the designated recipients named above. If the reader of this communication is not the intended recipient, you are hereby notified that you have received this communication in error, and that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify The Associated Press immediately by telephone at +1-212-621-1500 and delete this email. Thank you.
Reply all
Reply to author
Forward
0 new messages