[Archivesspace_Users_Group] [External] Collection CSV export

Wed May 31 09:08:22 EDT 2023

Hi all,

This looks like a very interesting piece of functionality. I'm still intrigued by Paul's question:

Regarding being in the core code, I see a Github<https://github.com/hudmol/as_spreadsheet_bulk_updater> page for it but I can't see it mentioned in any of the release notes recently, or any information in the import/export section<https://archivesspace.atlassian.net/wiki/spaces/ArchivesSpaceUserManual/pages/890339531/Importing+and+Exporting+Data> of the documentation, or in Jira. Can anybody confirm if this is the case or is planned?

When checking the official ArchivesSpace code tree in Github, I don't find any traces of bulk_update files. Does anyone know more about the status or plans?

Best,

Ron

________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Paul Sutherland <psutherland at amphilsoc.org>
Sent: 25 May 2023 23:18
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] [External] Collection CSV export

WAARSCHUWING: DIT IS EEN EXTERNE MAIL

Deze mail komt van buiten onze organisatie. Kijk eerst of je het mailadres en de afzender herkent en/of vertrouwt. Doe dat voor je bijlagen opent of links aanklikt. Zo houden we onze organisatie veiliger voor phishing.

Hi Sarit,
Thank you for pointing me to this. We've got it installed and it looks like it works smoothly for our purposes right now.
Best,
Paul

On Tue, May 16, 2023 at 9:08 AM Paul Sutherland <psutherland at amphilsoc.org<mailto:psutherland at amphilsoc.org>> wrote:
Hi Sarit,

Thank you - I hadn't noticed this plugin. This sounds like it might be what we're looking for.

Regarding being in the core code, I see a Github<https://github.com/hudmol/as_spreadsheet_bulk_updater> page for it but I can't see it mentioned in any of the release notes recently, or any information in the import/export section<https://archivesspace.atlassian.net/wiki/spaces/ArchivesSpaceUserManual/pages/890339531/Importing+and+Exporting+Data> of the documentation, or in Jira. Can anybody confirm if this is the case or is planned?

Best,
Paul

On Thu, May 11, 2023 at 5:46 PM Hand, Sarit <shand at ap.org<mailto:shand at ap.org>> wrote:

Hi Paul,

Right off the cuff I would suggest looking at the bulk updater which is now part of the core code in the newest version (I believe).  It was a plugin. You can granularly select which records to export into a CVS/excel spreadsheet including many of the sub-records.

Hope that is useful.

Cheers,

[cid:188249a8fd84cff311]

Sarit Hand

Digital Archivist
AP Corporate Archives

200 Liberty Street

New York, NY 10281

T 212.621.7035

shand at ap.org<mailto:shand at ap.org>
ap.org<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.ap.org_&d=DwMFAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=70gVc8PkZ8LRd0WR_N4Lh2vwCTUp-4jc9IXouEpQ4Go&m=6UoNjAFDH0YF8OOcVefcFJr87AnD-3CtVIWRN1xXmM8&s=j5mLAr5vMMd5IuZzCT_emHmreskbjS8Rp-p5KYtp9oU&e=>

[cid:188249a8fd85b16b22]

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 Paul Sutherland
Sent: Thursday, May 11, 2023 5:04 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>>
Subject: [Archivesspace_Users_Group] Collection CSV export

[EXTERNAL]

Hi all,

I'm looking for a way to export a CSV of all the Archival Objects under a specific Resource (collection). The goal would be to generate a CSV of every child archival object (through all levels of hierarchy*), including all fields that have been filled for each archival object. Essentially the opposite of the CSV import function.

Specific use cases include making folder labels, producing reports on collections' objects, transforming the data for other purposes, running large granular searches, etc.

I've looked around plugins and custom reports and nothing appears to match this exactly. I wanted to reach out to the community here to see if anyone has created such a tool.

There are a couple of ways I can see this being implemented:

  *   a button on the Resource level for Download CSV, under Export

[cid:188249a8fd9692e333]

  *   a version of Report. Report lets you produce a CSV of every archival object in the repository but it's limited to 50000 results and doesn't let you narrow down by parent, as far as I can see.

Thank you for your help,

Paul

(*it could also be all immediate children of a specific archival object rather than only the resource level, though this doesn't interact as apparently neatly with the rest of the interface).

--

Paul Sutherland (he/his)
Archivist of Indigenous Materials
Center for Native American and Indigenous Research

Library & Museum
American Philosophical Society
105 S. 5th Street, 2nd Floor
Philadelphia, PA 19406

Lenapehoking

215-440-3408

amphilsoc.org/library/CNAIR<https://urldefense.proofpoint.com/v2/url?u=http-3A__amphilsoc.org_library_CNAIR&d=DwMFAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=70gVc8PkZ8LRd0WR_N4Lh2vwCTUp-4jc9IXouEpQ4Go&m=6UoNjAFDH0YF8OOcVefcFJr87AnD-3CtVIWRN1xXmM8&s=stOBF_CZQ3pqYn7ZSgR3x_xgv-7xCIEJg7aztHQB6l8&e=>

cnair at amphilsoc.org<mailto:cnair at amphilsoc.org>

I respectfully acknowledge that I work and reside in Lenapehoking, the homeland of the Lenape people in past, present, and future generations. I am grateful for the past and ongoing generosity of numerous Indigenous communities and individuals who have offered guidance, expertise, and opportunities for collaboration that make my work possible.

Learn more about ...

- The Indigenous Subject Guide<https://urldefense.proofpoint.com/v2/url?u=https-3A__indigenousguide.amphilsoc.org_&d=DwMFAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=70gVc8PkZ8LRd0WR_N4Lh2vwCTUp-4jc9IXouEpQ4Go&m=6UoNjAFDH0YF8OOcVefcFJr87AnD-3CtVIWRN1xXmM8&s=zcM3_aIE1ZhgNZUMv_V5lBceZk7vZNxi24V7nGigqqo&e=> to our Indigenous collections, updated frequently
- Blog posts<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.amphilsoc.org_blog-2Dcategory_cnair&d=DwMFAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=70gVc8PkZ8LRd0WR_N4Lh2vwCTUp-4jc9IXouEpQ4Go&m=6UoNjAFDH0YF8OOcVefcFJr87AnD-3CtVIWRN1xXmM8&s=-ZB0ESwkYMoWMOoK-ao98OjR87Vti8uPd7rP-MthWxs&e=> by CNAIR staff & fellows
- Fellowships<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.amphilsoc.org_grants_fellowships&d=DwMFAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=70gVc8PkZ8LRd0WR_N4Lh2vwCTUp-4jc9IXouEpQ4Go&m=6UoNjAFDH0YF8OOcVefcFJr87AnD-3CtVIWRN1xXmM8&s=-2ZoEFJ4yNfCM6TMppnn9o4LnFycTtkw6DJu86y71m4&e=> (residential and non) for working with our collections and elsewhere
- Scheduling a visit<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.amphilsoc.org_library-23paragraph-2D36&d=DwMFAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=70gVc8PkZ8LRd0WR_N4Lh2vwCTUp-4jc9IXouEpQ4Go&m=6UoNjAFDH0YF8OOcVefcFJr87AnD-3CtVIWRN1xXmM8&s=IK9UtHuZmNlk-S8IVICRpETIDcAo2sqn6bbaVagbQUY&e=> to our Reading Room to view our collections
- Our latest museum exhibit Pursuit & Persistence: 300 Years of Women in Science<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.amphilsoc.org_visit-2Dmuseum&d=DwMFAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=70gVc8PkZ8LRd0WR_N4Lh2vwCTUp-4jc9IXouEpQ4Go&m=6UoNjAFDH0YF8OOcVefcFJr87AnD-3CtVIWRN1xXmM8&s=I8O9dwp3BMWa-QrG8Ajd-EhPKAVr6HpW0u4Gj78Xmo4&e=>, open until December 30, 2023

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.
_______________________________________________
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:Archivesspace_Users_Group at lyralists.lyrasis.org>
https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=70gVc8PkZ8LRd0WR_N4Lh2vwCTUp-4jc9IXouEpQ4Go&m=6UoNjAFDH0YF8OOcVefcFJr87AnD-3CtVIWRN1xXmM8&s=YLqDhODbddugw1oq0EbjaC798-pCvL8xXBkILdRs_Kc&e=

--
Paul Sutherland (he/his)
Archivist of Indigenous Materials
Center for Native American and Indigenous Research
Library & Museum
American Philosophical Society
105 S. 5th Street, 2nd Floor
Philadelphia, PA 19406
Lenapehoking
215-440-3408
amphilsoc.org/library/CNAIR<http://amphilsoc.org/library/CNAIR>
cnair at amphilsoc.org<mailto:cnair at amphilsoc.org>

I respectfully acknowledge that I work and reside in Lenapehoking, the homeland of the Lenape people in past, present, and future generations. I am grateful for the past and ongoing generosity of numerous Indigenous communities and individuals who have offered guidance, expertise, and opportunities for collaboration that make my work possible.

Learn more about ...
- The Indigenous Subject Guide<https://indigenousguide.amphilsoc.org> to our Indigenous collections, updated frequently
- Blog posts<https://www.amphilsoc.org/blog-category/cnair> by CNAIR staff & fellows
- Fellowships<https://www.amphilsoc.org/grants/fellowships> (residential and non) for working with our collections and elsewhere
- Scheduling a visit<https://www.amphilsoc.org/library#paragraph-36> to our Reading Room to view our collections
- Our latest museum exhibit Pursuit & Persistence: 300 Years of Women in Science<https://www.amphilsoc.org/visit-museum>, open until December 30, 2023

--
Paul Sutherland (he/his)
Archivist of Indigenous Materials
Center for Native American and Indigenous Research
Library & Museum
American Philosophical Society
105 S. 5th Street, 2nd Floor
Philadelphia, PA 19406
Lenapehoking
215-440-3408
amphilsoc.org/library/CNAIR<http://amphilsoc.org/library/CNAIR>
cnair at amphilsoc.org<mailto:cnair at amphilsoc.org>

I respectfully acknowledge that I work and reside in Lenapehoking, the homeland of the Lenape people in past, present, and future generations. I am grateful for the past and ongoing generosity of numerous Indigenous communities and individuals who have offered guidance, expertise, and opportunities for collaboration that make my work possible.

Learn more about ...
- The Indigenous Subject Guide<https://indigenousguide.amphilsoc.org> to our Indigenous collections, updated frequently
- Blog posts<https://www.amphilsoc.org/blog-category/cnair> by CNAIR staff & fellows
- Fellowships<https://www.amphilsoc.org/grants/fellowships> (residential and non) for working with our collections and elsewhere
- Scheduling a visit<https://www.amphilsoc.org/library#paragraph-36> to our Reading Room to view our collections
- Our latest museum exhibit Pursuit & Persistence: 300 Years of Women in Science<https://www.amphilsoc.org/visit-museum>, open until December 30, 2023
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230531/b0b8f1dc/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 1094 bytes
Desc: image001.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230531/b0b8f1dc/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 5548 bytes
Desc: image002.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230531/b0b8f1dc/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 14034 bytes
Desc: image003.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230531/b0b8f1dc/attachment-0002.png>