[Archivesspace_Users_Group] Adding Resource ID to CSV Download of Search Results in ASpace

[James Bullen]

Hi Aimee and all,

It seems the fields are hardcoded. It is a trivial change to add the identifier, at this line:
https://github.com/archivesspace/archivesspace/blob/master/frontend/app/controllers/top_containers_controller.rb#L47

Something like this:
	params[:fields].prepend('collection_identifier_stored_u_sstr', 'collection_display_string_u_sstr', 'series_title_u_sstr')

Perhaps one of the AS developers can sneak this in ;)

And while they’re at it, it would be nice if the column headers were human friendly, rather than those solr field names.


Cheers,
James



> On Apr 18, 2023, at 2:23 AM, Leah Tams <leah.tams at duke.edu> wrote:
> 
> 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.)
>  
> Leah
>  
>  
> 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 Aimee Truitt
> Sent: Monday, April 17, 2023 11:52 AM
> To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org <mailto:archivesspace_users_group at lyralists.lyrasis.org>>
> Subject: [Archivesspace_Users_Group] Adding Resource ID to CSV Download of Search Results in ASpace
>  
> Hello Everyone,
> 
> I sent this question out last week, but am sharing again, with some examples, in case that helps my query.
>  
> 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?
>  
> Below is a visual of the problem:
>  
> The fields that show on the screen are:
> <image001.png>
>  
>  
> And the ones I get when I "download CSV" are:
>  
> collection_display_string_u_sstr
> series_title_u_sstr
> container_profile_display_string_u_sstr
> location_display_string_u_sstr
> type_enum_s 
> indicator_u_icusort
> barcode_u_sstr 
>  
> Abstracts of Clothing and Equipment Vol.
> 1 Stacks\, 4\, Track 01\, Range 004 [F04 T01 R004 V01 H10]
> volume 
> BV 02035 
> 34072001270056.00
>  
> 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.
>  
> Best Wishes,
>  
> Aimee
>  
> Aimee Truitt (she/her) | Catalog and Metadata Coordinator
> Ohio History Connection | 800 E. 17th Ave., Columbus, OH 43211
> p. 614.297.2589  | f. 614.297.2546 | atruitt at ohiohistory.org <mailto:atruitt at ohiohistory.org>
>  
> The Ohio History Connection’s mission <https://urldefense.com/v3/__https:/www.ohiohistory.org/about-us__;!!OToaGQ!uC9rWkc3bXzCOFUUi2q8WeVp7WsHw-7ICyfxsZz9U1Xg8xb6GuNWujbuGNrubj5Nao5qbIIH0kYfU4buDgZJtw$> is to spark discovery of Ohio’s stories. Embrace the present, share the past and transform the future. Support the Ohio History Connection: www.ohiohistory.org/give <https://urldefense.com/v3/__http:/www.ohiohistory.org/give__;!!OToaGQ!uC9rWkc3bXzCOFUUi2q8WeVp7WsHw-7ICyfxsZz9U1Xg8xb6GuNWujbuGNrubj5Nao5qbIIH0kYfU4aWBDDjOQ$>.
>  
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org <mailto:Archivesspace_Users_Group at lyralists.lyrasis.org>
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230418/16e1b657/attachment.html>