Re: [Archivesspace_Users_Group] [External] Collection CSV export

2023-05-31 Thread Ron Van den Branden 
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-boun...@lyralists.lyrasis.org 
 on behalf of Paul 
Sutherland 
Sent: 25 May 2023 23:18
To: Archivesspace Users Group 
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 
mailto:psutherl...@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 mailto:sh...@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



sh...@ap.org<mailto:sh...@ap.org>
ap.org<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.ap.org_=DwMFAg=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM=70gVc8PkZ8LRd0WR_N4Lh2vwCTUp-4jc9IXouEpQ4Go=6UoNjAFDH0YF8OOcVefcFJr87AnD-3CtVIWRN1xXmM8=j5mLAr5vMMd5IuZzCT_emHmreskbjS8Rp-p5KYtp9oU=>

[cid:188249a8fd85b16b22]





From: 
archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>
 
mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>>
 On Behalf Of Paul Sutherland
Sent: Thursday, May 11, 2023 5:04 PM
To: Archivesspace Users Group 
mailto:archivesspace_users_group@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 5 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://urlde

Re: [Archivesspace_Users_Group] [External] Collection CSV export

2023-05-25 Thread Paul Sutherland 
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 
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
>  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
> 
> 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  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
>>
>>
>>
>> sh...@ap.org
>> ap.org
>> 
>>
>>
>>
>>
>>
>> *From:* archivesspace_users_group-boun...@lyralists.lyrasis.org <
>> archivesspace_users_group-boun...@lyralists.lyrasis.org> *On Behalf Of *Paul
>> Sutherland
>> *Sent:* Thursday, May 11, 2023 5:04 PM
>> *To:* Archivesspace Users Group <
>> archivesspace_users_group@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 5 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
>> 
>>
>> cn...@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
>> 
>> to our Indigenous collections, updated frequently
>> - Blog posts
>>

Re: [Archivesspace_Users_Group] [External] Collection CSV export

2023-05-16 Thread Paul Sutherland 
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
 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

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  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
>
>
>
> sh...@ap.org
> ap.org
> 
>
>
>
>
>
> *From:* archivesspace_users_group-boun...@lyralists.lyrasis.org <
> archivesspace_users_group-boun...@lyralists.lyrasis.org> *On Behalf Of *Paul
> Sutherland
> *Sent:* Thursday, May 11, 2023 5:04 PM
> *To:* Archivesspace Users Group <
> archivesspace_users_group@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 5 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
> 
>
> cn...@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
> 
> to our Indigenous collections, updated frequently
> - Blog posts
> 
> by CNAIR staff & fellows
> - Fellowships
>