<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><div><br></div>Hi Aimee and all,<div><br></div><div>It seems the fields are hardcoded. It is a trivial change to add the identifier, at this line:</div><div><a href="https://github.com/archivesspace/archivesspace/blob/master/frontend/app/controllers/top_containers_controller.rb#L47">https://github.com/archivesspace/archivesspace/blob/master/frontend/app/controllers/top_containers_controller.rb#L47</a></div><div><div><br></div><div>Something like this:</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>params[:fields].prepend(<b>'collection_identifier_stored_u_sstr',</b> 'collection_display_string_u_sstr', 'series_title_u_sstr')</div><div><br></div><div>Perhaps one of the AS developers can sneak this in ;)</div><div><br></div><div>And while they’re at it, it would be nice if the column headers were human friendly, rather than those solr field names.</div><div><br></div><div><br></div><div>Cheers,</div><div>James</div><div><br></div><div><br></div><div><br><blockquote type="cite"><div>On Apr 18, 2023, at 2:23 AM, Leah Tams <leah.tams@duke.edu> wrote:</div><br class="Apple-interchange-newline"><div><meta charset="UTF-8"><div class="WordSection1" style="page: WordSection1; caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 10pt; font-family: Tahoma, sans-serif;">I wonder if creating a custom report might get around this issue for you and others? (Disclaimer: I’ve never created a custom report before.)<o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 10pt; font-family: Tahoma, sans-serif;"><o:p> </o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 10pt; font-family: Tahoma, sans-serif;">Leah<o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 10pt; font-family: Tahoma, sans-serif;"><o:p> </o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="font-size: 10pt; font-family: Tahoma, sans-serif;"><o:p> </o:p></span></div><div><div style="border-width: 1pt medium medium; border-style: solid none none; border-color: rgb(225, 225, 225) currentcolor currentcolor; border-image: none; padding: 3pt 0in 0in;"><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><b><span>From:</span></b><span><span class="Apple-converted-space"> </span><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" style="color: rgb(5, 99, 193); text-decoration: underline;">archivesspace_users_group-bounces@lyralists.lyrasis.org</a><span class="Apple-converted-space"> </span><<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" style="color: rgb(5, 99, 193); text-decoration: underline;">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>><span class="Apple-converted-space"> </span><b>On Behalf Of<span class="Apple-converted-space"> </span></b>Aimee Truitt<br><b>Sent:</b><span class="Apple-converted-space"> </span>Monday, April 17, 2023 11:52 AM<br><b>To:</b><span class="Apple-converted-space"> </span>Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" style="color: rgb(5, 99, 193); text-decoration: underline;">archivesspace_users_group@lyralists.lyrasis.org</a>><br><b>Subject:</b><span class="Apple-converted-space"> </span>[Archivesspace_Users_Group] Adding Resource ID to CSV Download of Search Results in ASpace<o:p></o:p></span></div></div></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><o:p> </o:p></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">Hello Everyone,<o:p></o:p></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><br><span style="background: white;">I sent this question out last week, but am sharing again, with some examples, in case that helps my query.</span><span style="background: white;"><o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="background: white;"><o:p> </o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="background: white;">When I work in ASpace, I use the "Manage Top Containers" search frequently. Sometimes it's helpful to download the CSV of the search, but it doesn't include the Resource ID in the CSV, even though it does in the search results. Is there a setting somewhere in the backend that dictates which fields get printed for the CSV and has anyone successfully added Resource ID?</span><span style="background: white;"><o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="background: white;"><o:p> </o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><b><span style="background: white;">Below is a visual of the problem:</span><span style="background: white;"><o:p></o:p></span></b></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="background: white;"><o:p> </o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><u><span style="background: white;">The fields that show on the screen are:</span><span style="background: white;"><o:p></o:p></span></u></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="background: white;"><span id="cid:image001.png@01D97127.734E8810"><image001.png></span></span><span style="background: white;"><o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="background: white;"><o:p> </o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="background: white;"><o:p> </o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><u><span style="background: white;">And the ones I get when I "download CSV" are:</span><span style="background: white;"><o:p></o:p></span></u></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="background: white;"><o:p> </o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="background: white;">collection_display_string_u_sstr</span><span style="background: white;"><o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="background: white;">series_title_u_sstr</span><span style="background: white;"><o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="background: white;">container_profile_display_string_u_sstr</span><span style="background: white;"><o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="background: white;">location_display_string_u_sstr</span><span style="background: white;"><o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="background: white;">type_enum_s<span class="Apple-converted-space"> </span></span><span style="background: white;"><o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="background: white;">indicator_u_icusort</span><span style="background: white;"><o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="background: white;">barcode_u_sstr<span class="Apple-converted-space"> </span></span><span style="background: white;"><o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="background: white;"><o:p> </o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="background: white;">Abstracts of Clothing and Equipment Vol.</span><span style="background: white;"><o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="background: white;">1 Stacks\, 4\, Track 01\, Range 004 [F04 T01 R004 V01 H10]</span><span style="background: white;"><o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="background: white;">volume<span class="Apple-converted-space"> </span></span><span style="background: white;"><o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="background: white;">BV 02035<span class="Apple-converted-space"> </span></span><span style="background: white;"><o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="background: white;">34072001270056.00</span><span style="background: white;"><o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="background: white;"><o:p> </o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="background: white;">Having the SAS # (or whatever Resource ID) in the download, would be a big asset. Seems like a there should be a place to be able to specify which fields are showing and which fields download. I would appreciate any tips/tricks/suggestions! Thank you for your time and help.</span><span style="background: white;"><o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="background: white;"><o:p> </o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="background: white;">Best Wishes,</span><span style="background: white;"><o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="background: white;"><o:p> </o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="background: white;">Aimee</span><span style="background: white;"><o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><o:p> </o:p></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><b><span>Aimee Truitt (she/her) | Catalog and Metadata Coordinator</span></b><span><o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span>Ohio History Connection | 800 E. 17<sup>th</sup><span class="Apple-converted-space"> </span>Ave., Columbus, OH 43211<o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span>p. 614.297.2589 | f. 614.297.2546 |<span style=""><span class="Apple-converted-space"> </span></span><a href="mailto:atruitt@ohiohistory.org" style="color: rgb(5, 99, 193); text-decoration: underline;">atruitt@ohiohistory.org</a><span style=""></span><o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><span> <o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><b><span>The Ohio History Connection’s<span class="Apple-converted-space"> </span></span></b><span><a href="https://urldefense.com/v3/__https:/www.ohiohistory.org/about-us__;!!OToaGQ!uC9rWkc3bXzCOFUUi2q8WeVp7WsHw-7ICyfxsZz9U1Xg8xb6GuNWujbuGNrubj5Nao5qbIIH0kYfU4buDgZJtw$" style="color: rgb(5, 99, 193); text-decoration: underline;"><b>mission</b></a><b><span class="Apple-converted-space"> </span>is to spark discovery of Ohio’s stories. Embrace the present, share the past and transform the future.<span class="Apple-converted-space"> </span><span style="background: white;">Support the Ohio History Connection:<span class="Apple-converted-space"> </span></span></b><a href="https://urldefense.com/v3/__http:/www.ohiohistory.org/give__;!!OToaGQ!uC9rWkc3bXzCOFUUi2q8WeVp7WsHw-7ICyfxsZz9U1Xg8xb6GuNWujbuGNrubj5Nao5qbIIH0kYfU4aWBDDjOQ$" style="color: rgb(5, 99, 193); text-decoration: underline;"><b><span style="background: white;">www.ohiohistory.org/give</span></b></a><b><span style="background: white;">.</span></b><o:p></o:p></span></div><div style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;"><o:p> </o:p></div></div><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;">_______________________________________________</span><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;">Archivesspace_Users_Group mailing list</span><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" style="color: rgb(5, 99, 193); text-decoration: underline; font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" style="color: rgb(5, 99, 193); text-decoration: underline; font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a></div></blockquote></div><br></div></body></html>