[Archivesspace_Users_Group] [EXT] Re: Export resource records to Excel

[Christine Di Bella]

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
christine.dibella at lyrasis.org<mailto:christine.dibella at lyrasis.org>

[cid:image004.jpg at 01DA287B.1142A640]



From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> On Behalf Of Norton, Channing
Sent: Wednesday, December 6, 2023 4:04 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] [EXT] Re: Export resource records to Excel

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_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org> <archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org>> On Behalf Of Hand, Sarit
Sent: Wednesday, December 6, 2023 2:06 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at 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,
[cid:image001.png at 01DA287A.9EBBA630]                                              [cid:image002.jpg at 01DA287A.9EBBA630]
Sarit Hand                                                       200 Liberty St.
Digital Archivist                                               New York, NY 10281
Corporate Archives                                         T 212.621.7035


shand at ap.org<mailto:shand at ap.org>
www.ap.org<https://urldefense.com/v3/__http:/www.ap.org/__;!!CGUSO5OYRnA7CQ!acRB8y49X820mRDUJu_MgViQ4TFl2DytPoKNyCKKyhBNBT49Ds9Urrf-24o4UL95sdcU_WeeW3XdT5CwU6aoAw$>
From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org> <archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org>> On Behalf Of Nick Richbell
Sent: Wednesday, December 6, 2023 10:45 AM
To: archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>
Subject: [Archivesspace_Users_Group] Export resource records to Excel

You don't often get email from nrichbe at clemson.edu<mailto:nrichbe at clemson.edu>. Learn why this is important<https://urldefense.com/v3/__https:/aka.ms/LearnAboutSenderIdentification__;!!CGUSO5OYRnA7CQ!acRB8y49X820mRDUJu_MgViQ4TFl2DytPoKNyCKKyhBNBT49Ds9Urrf-24o4UL95sdcU_WeeW3XdT5DJNmZWZA$>

[EXTERNAL]
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/<https://urldefense.com/v3/__http:/libraries.clemson.edu/specialcollections/__;!!CGUSO5OYRnA7CQ!acRB8y49X820mRDUJu_MgViQ4TFl2DytPoKNyCKKyhBNBT49Ds9Urrf-24o4UL95sdcU_WeeW3XdT5AiuvvFSA$>



 [cid:image003.png at 01DA287A.9EBBA630]
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20231207/88ef266a/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 5729 bytes
Desc: image001.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20231207/88ef266a/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 1715 bytes
Desc: image002.jpg
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20231207/88ef266a/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 3417 bytes
Desc: image003.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20231207/88ef266a/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.jpg
Type: image/jpeg
Size: 56099 bytes
Desc: image004.jpg
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20231207/88ef266a/attachment-0001.jpg>