<div dir="ltr"><div class="gmail_default" style="font-family:georgia,serif;font-size:small">Hi Sarit,</div><div class="gmail_default" style="font-family:georgia,serif;font-size:small"><br></div><div class="gmail_default" style="font-family:georgia,serif;font-size:small">Thank you - I hadn't noticed this plugin. This sounds like it might be what we're looking for.<br></div><div class="gmail_default" style="font-family:georgia,serif;font-size:small"><br></div><div class="gmail_default" style="font-family:georgia,serif;font-size:small">Regarding being in the core code, I see a <a href="https://github.com/hudmol/as_spreadsheet_bulk_updater">Github</a> page for it but I can't see it mentioned in any of the release notes recently, or any information in the <a href="https://archivesspace.atlassian.net/wiki/spaces/ArchivesSpaceUserManual/pages/890339531/Importing+and+Exporting+Data">import/export section</a> of the documentation, or in Jira. Can anybody confirm if this is the case or is planned?<br></div><div class="gmail_default" style="font-family:georgia,serif;font-size:small"><br></div><div class="gmail_default" style="font-family:georgia,serif;font-size:small">Best,</div><div class="gmail_default" style="font-family:georgia,serif;font-size:small">Paul<br></div><div class="gmail_default" style="font-family:georgia,serif;font-size:small"><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, May 11, 2023 at 5:46 PM Hand, Sarit <<a href="mailto:shand@ap.org">shand@ap.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="msg1031025406289848188">
<div style="overflow-wrap: break-word;" lang="EN-US">
<div class="m_1031025406289848188WordSection1">
<p class="MsoNormal">Hi Paul,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">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.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Hope that is useful.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Cheers,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<table style="border-collapse:collapse" cellspacing="0" cellpadding="0" border="0">
<tbody>
<tr>
<td style="width:406.45pt;padding:0in" width="542" valign="top">
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Arial",sans-serif"><img style="width: 0.5083in; height: 0.6333in;" id="m_1031025406289848188Picture_x0020_3" src="cid:188249a8fd84cff311" width="49" height="61"><u></u><u></u></span></p>
</td>
</tr>
<tr>
<td style="width:406.45pt;padding:0in" width="542" valign="top">
<p class="MsoNormal"><b><span style="font-family:"Verdana",sans-serif"><u></u> <u></u></span></b></p>
</td>
</tr>
<tr>
<td style="width:406.45pt;padding:0in" width="542" valign="top">
<p class="MsoNormal"><b><span style="font-size:10pt;font-family:"Garamond",serif" lang="FR">Sarit Hand</span></b><b><span style="font-size:10pt;font-family:"Garamond",serif"><u></u><u></u></span></b></p>
<p class="MsoNormal" style="margin-bottom:12pt"><span style="font-size:10pt;font-family:"Garamond",serif" lang="FR">Digital Archivist</span><span style="font-size:10pt;font-family:"Garamond",serif"><br>
</span><span style="font-size:10pt;font-family:"Garamond",serif" lang="FR">AP Corporate Archives</span><span style="font-size:10pt;font-family:"Garamond",serif"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Garamond",serif" lang="FR">200 Liberty Street<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Garamond",serif" lang="FR">New York, NY 10281<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Garamond",serif">T
</span><span style="font-size:10pt;font-family:"Garamond",serif" lang="FR">212.621.7035<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Garamond",serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Arial",sans-serif"><a href="mailto:shand@ap.org" target="_blank">shand@ap.org</a><br>
</span><span style="font-size:12pt"><a href="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=" target="_blank"><span style="font-size:10pt;font-family:"Arial",sans-serif;color:black">ap.org</span></a></span><span style="font-family:"Verdana",sans-serif" lang="FR"><u></u><u></u></span></p>
</td>
</tr>
<tr>
<td style="width:406.45pt;padding:0in" width="542" valign="top">
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Arial",sans-serif" lang="FR"><img style="width: 2.775in; height: 0.7166in;" id="m_1031025406289848188Graphic_x0020_4" src="cid:188249a8fd85b16b22" width="266" height="69" border="0"><u></u><u></u></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div style="border-color:rgb(225,225,225) currentcolor currentcolor;border-style:solid none none;border-width:1pt medium medium;padding:3pt 0in 0in">
<p class="MsoNormal"><b>From:</b> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
<b>On Behalf Of </b>Paul Sutherland<br>
<b>Sent:</b> Thursday, May 11, 2023 5:04 PM<br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> [Archivesspace_Users_Group] Collection CSV export<u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p><span style="font-size:9pt;font-family:"Arial",sans-serif;color:red">[EXTERNAL]<u></u><u></u></span></p>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Georgia",serif">Hi all,<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Georgia",serif"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Georgia",serif">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.<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Georgia",serif"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Georgia",serif">Specific use cases include making folder labels, producing reports on collections' objects, transforming the data for other purposes, running large granular searches, etc.<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Georgia",serif"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Georgia",serif">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.<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Georgia",serif"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Georgia",serif">There are a couple of ways I can see this being implemented:<u></u><u></u></span></p>
</div>
<div>
<ul type="disc">
<li class="MsoNormal">
<span style="font-size:12pt;font-family:"Georgia",serif">a button on the Resource level for Download CSV, under Export<u></u><u></u></span></li></ul>
<div>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Georgia",serif"><img style="width: 4.8666in; height: 1.8416in;" id="m_1031025406289848188Picture_x0020_1" src="cid:188249a8fd9692e333" width="467" height="177" border="0"></span><span style="font-size:12pt;font-family:"Georgia",serif"><u></u><u></u></span></p>
<ul type="disc">
<li class="MsoNormal">
<span style="font-size:12pt;font-family:"Georgia",serif">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.<u></u><u></u></span></li></ul>
</div>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Georgia",serif">Thank you for your help,<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Georgia",serif">Paul<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Georgia",serif"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Georgia",serif">(*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). <u></u><u></u></span></p>
</div>
<p class="MsoNormal"><br>
<span class="m_1031025406289848188gmailsignatureprefix">-- </span><u></u><u></u></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><b>Paul Sutherland</b> (he/his)<br>
Archivist of Indigenous Materials<br>
Center for Native American and Indigenous Research<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Library & Museum<br>
American Philosophical Society<br>
105 S. 5th Street, 2nd Floor<br>
Philadelphia, PA 19406<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Lenapehoking<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">215-440-3408<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><a href="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=" target="_blank">amphilsoc.org/library/CNAIR</a><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><a href="mailto:cnair@amphilsoc.org" target="_blank">cnair@amphilsoc.org</a><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal"><i><span style="font-family:"Arial",sans-serif">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</span></i><i><span style="font-size:10pt;font-family:"Arial",sans-serif">uals who have offered guidance, expertise, and opportunities for collaboration that make my work possible.
</span></i><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Arial",sans-serif">Learn more about ...</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Arial",sans-serif">- The
<a href="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=" target="_blank">Indigenous Subject Guide</a> to our Indigenous collections, updated frequently<br>
- <a href="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=" target="_blank">Blog posts</a> by CNAIR staff & fellows</span><br>
<span style="font-size:10pt;font-family:"Arial",sans-serif">- <a href="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=" target="_blank">
Fellowships</a> (residential and non) for working with our collections and elsewhere</span><br>
<span style="font-size:10pt;font-family:"Arial",sans-serif">- <a href="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=" target="_blank">
Scheduling a visit</a> to our Reading Room to view our collections</span><br>
- Our latest museum exhibit <i><a href="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=" target="_blank">Pursuit & Persistence: 300 Years of Women in Science</a>,
</i>open until December 30, 2023<u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
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.
</div>
_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="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=" rel="noreferrer" target="_blank">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=</a><br>
</div></blockquote></div><br clear="all"><br><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><span><span style="color:rgb(68,68,68)"></span><font size="1"><span style="font-family:verdana,sans-serif"><span style="font-family:georgia,serif"><span style="color:rgb(102,102,102)"><font size="4" face="georgia, serif"><span style="color:rgb(68,68,68)"><font size="2"><i><span style="letter-spacing:0.36px">
<i style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:small"><span style="font-family:Arial,sans-serif;color:black;letter-spacing:0.25pt"></span></i></span></i></font></span></font></span></span></span></font></span></div><div><span style="color:rgb(0,0,0)"><i><span style="font-family:arial,sans-serif"><font size="2"><span><span style="letter-spacing:0.36px"><span style="letter-spacing:0.25pt"></span></span></span></font></span></i></span></div><div><b>Paul Sutherland</b> (he/his)<br>Archivist of Indigenous Materials<br>Center for Native American and Indigenous Research</div><div>Library & Museum<br>American Philosophical Society<br>105 S. 5th Street, 2nd Floor<br>Philadelphia, PA 19406</div><div>Lenapehoking<br></div><div>215-440-3408<br></div><div><a href="http://amphilsoc.org/library/CNAIR" target="_blank">amphilsoc.org/library/CNAIR</a></div><div><a href="mailto:cnair@amphilsoc.org" target="_blank">cnair@amphilsoc.org</a><br></div><div></div><div><br><div dir="ltr"><i><span style="font-family:Arial;background-color:transparent;vertical-align:baseline;white-space:pre-wrap">I respectfully acknowledge that I work and reside in <span>Lenapehoking</span>, the homeland of the <span>Lenape</span> people in past, present, and future generations. I <span>am grateful</span> for the past</span><span style="background-color:transparent;font-family:Arial;white-space:pre-wrap"> and ongoing generosity of numerous Indigenous communities and individ</span><font size="2"><span style="background-color:transparent;white-space:pre-wrap;font-family:arial,sans-serif">uals who have offered guidance, expertise, and opportunities for collaboration that make my work possible. </span></font></i><font style="font-family:arial,sans-serif" size="2"><br></font></div><div dir="ltr"><font style="font-family:arial,sans-serif" size="2"><br></font></div><div><font style="font-family:arial,sans-serif" size="2">Learn more about ...<br></font></div><div><font style="font-family:arial,sans-serif" size="2">- The <a href="https://indigenousguide.amphilsoc.org" target="_blank">Indigenous Subject Guide</a> to our Indigenous collections, updated frequently</font><font size="2"><span style="font-family:arial,sans-serif"><br></span><span style="font-family:arial,sans-serif">- <a href="https://www.amphilsoc.org/blog-category/cnair" target="_blank">Blog posts</a> by CNAIR staff & fellows</span></font><br><font size="2"><span style="font-family:arial,sans-serif">- <a href="https://www.amphilsoc.org/grants/fellowships" target="_blank">Fellowships</a> (residential and non) for working with our collections and elsewhere</span></font><br><font size="2"><span style="font-family:arial,sans-serif">- <a href="https://www.amphilsoc.org/library#paragraph-36" target="_blank">Scheduling a visit</a> to our Reading Room to view our collections</span></font><br><font size="2"><span style="font-family:arial,sans-serif"></span></font>- Our latest museum exhibit <i><a href="https://www.amphilsoc.org/visit-museum" target="_blank">Pursuit & Persistence: 300 Years of Women in Science</a>, </i>open until December 30, 2023</div></div></div></div></div></div></div></div>