[Archivesspace_Users_Group] [External] Collection CSV export

Tue May 16 09:08:43 EDT 2023

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> 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,
>
>
>
>
>
> *Sarit Hand*
>
> Digital Archivist
> AP Corporate Archives
>
> 200 Liberty Street
>
> New York, NY 10281
>
> T 212.621.7035
>
>
>
> 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=>
>
>
>
>
>
> *From:* archivesspace_users_group-bounces at lyralists.lyrasis.org <
> 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>
> *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
>
>
>    - 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
>
>
>
> *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 individ**uals 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
>
> 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
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/20230516/87a9ab71/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 1094 bytes
Desc: not available
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230516/87a9ab71/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 5548 bytes
Desc: not available
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230516/87a9ab71/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 14034 bytes
Desc: not available
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230516/87a9ab71/attachment-0002.png>