Generate Report for Linked Agents for CFCH

[crugas]

Cecilia Peterson requested a report of all linked agents to their resources and their sources for the CFCH repository. See below for details.

I just had a meeting with Rachel Menyuk and Amanda Sorensen regarding the AWHI URI project they are managing. To get started on generating a list of local agents we use in ASpace that can be included in the project, they suggested I reach out to see if it would be possible for you to export a list/spreadsheet of the agents we (Rinzler Archives/CFCH user group) link to in our finding aids and their sources (NACO, local, etc.). Would that be possible?

[crugas]

Lora and Corey met and decided on the following plan for getting this data to Ceci:

1. Run a Solr Query filtering by primary_type:agents*, CFCH (21) and used_within_repository fields to filter by how many agents are linked.
2. Run the same query within the staff interface, browsing by agents and using the used_within_repository field to filter the results.
3. Export the results to a CSV file, which should contain the agent title, ID, type, source, and relator.
4. If Ceci wants what these agents are linked to (resources and archival objects), we'll need to export the CSV with the URI field of the agent. Using the URI field, we can then use SQL to grab what resources or archival objects link to the agent and add that data to the CSV.

[crugas]

Got clarification from Ceci that they want just agent persons and the following data:

• Agent name
• Agent ID
• Agent Role (Creator, Subject, Source)
• Agent Source

I'll upload the SQL query I used and attach it to this issue as a PR. But the query has 1104 NULL values for sources, because they can have multiple sources listed, which can get a bit tricky to handle in the database. Some persons have the same source listed multiple times in the Record IDs (NACO or naf for instance), while others might have different sources listed for different Record IDs for the same person. I asked Ceci if they want me to include that info as well, which may result in me having to create a python script with the API to get that data, as it might be very complicated to do it in the database (some sort of concatenation with the agent_record_identifier fields?).

[crugas]

From Ceci: "Thanks so much for this! Wow, there are more than I ever expected, this is all stuff that we link to?? Our work is definitely cut out for us!"

[fordmadox]

For ASpace (h/t to Lora for the 'used_within_repository' field in Solr), this link returns all of the "Person" agents linked in AAG (i.e., repo 32):

https://aspace.si.edu/search?facets%5B%5D=primary_type&facets%5B%5D=source&facets%5B%5D=rules&filter_term%5B%5D=%7B%22primary_type%22%3A%22agent_person%22%7D&q=used_within_repository%3A%22%2Frepositories%2F32%22&sort=title_sort+asc