<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Menlo-Regular;
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Hi Kevin,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks for this. I’ll take a closer look. Take care and be well, Daniel<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org>
<b>On Behalf Of </b>Kevin W. Schlottmann<br>
<b>Sent:</b> Wednesday, December 9, 2020 11:08 AM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Resource Creation Statistics - Any ideas?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<div>
<p class="MsoNormal">Hi Daniel,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">We built a report that includes, among other things, created/modified date/user for all resources. We also include some other info that's useful for us, such as external links, user defined fields, and collection management data. Post-lockdown,
we also added scopenote and bionote information to aid in targeting remediation efforts. The data retrieved from the AS API and written to a Google sheet by a script on a nightly basis. The Python code is here:
<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><a href="https://urldefense.com/v3/__https:/github.com/cul/rbml-archivesspace/blob/master/reporting/resource_reporter.py__;!!J2_8gdp6gZQ!5H7NTB7ucGUW9p8F3e4_s8HbL5w7nAYlyeH6j1XUYVQ8QDHbpOEkmcXKeTxvJ74sAAIPVtQ$">https://github.com/cul/rbml-archivesspace/blob/master/reporting/resource_reporter.py</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">You would need API access and possibly some developer support, but this is an alternative to modifying any AS code.
<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">We took this approach both because these were the tools we knew (Python, Google sheets, scripts), and also because we are hosted -- this keeps our AS instance clean and easy to upgrade.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Kevin<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal">On Wed, Dec 9, 2020 at 1:48 PM Majewski, Steven Dennis (sdm7g) <<a href="mailto:sdm7g@virginia.edu">sdm7g@virginia.edu</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<p class="MsoNormal">On second thought, if you’re not adept with JSON tools, then exporting as CSV and loading in EXCEL to sort and group by created_by might be an easier solution. <o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">And the missing translation errors don’t show up in the CSV: <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">repository,Albert and Shirley Small Special Collections Library<br>
<br>
record_title,identifier,level,resource_type,publish,restrictions,created_by,create_time,date,extent<br>
Jack R. Levien papers,MSS 15241,Collection,,Yes,No,admin,2015-08-11 21:43:13 UTC,"[{""_date"":""Creation: 1960 - 1999, 1960-1999""}]","[{""portion"":""Whole"",""container_summary"":""2 document boxes"",""physical_details"":null,""dimensions"":null,""extent"":""0.80
Cubic Feet""}]"<br>
George family papers,MSS 13543,Collection,Papers,Yes,No,admin,2015-08-11 21:43:17 UTC,"[{""_date"":""Creation: 1816 - 1963, 1816-1963""}]","[{""portion"":""Whole"",""container_summary"":""1 document box"",""physical_details"":null,""dimensions"":null,""extent"":""0.50
Cubic Feet""}]"<br>
Francis Burton Harrison papers,MSS 14969,Collection,Papers,Yes,No,admin,2015-08-11 21:43:21 UTC,"[{""_date"":""Creation: 1921 - 1945, 1921-1945""}]","[{""portion"":""Whole"",""container_summary"":""1 document box"",""physical_details"":null,""dimensions"":null,""extent"":""0.50
Cubic Feet""}]"<br>
Holmes family papers,MSS15167,Collection,,Yes,No,admin,2015-08-11 21:43:24 UTC,"[{""_date"":""Creation: 1766 - 1928, 1908-1975; 1766-1928""}]","[{""portion"":""Whole"",""container_summary"":""4 Hollinger boxes"",""physical_details"":null,""dimensions"":null,""extent"":""934.00
items""}]"<br>
Theron H. Rice papers,MSS15247,Collection,,Yes,No,admin,2015-08-11 21:43:28 UTC,"[{""_date"":""Creation: 1877 - 1923, 1877-1923""}]","[{""portion"":""Whole"",""container_summary"":""1 Hollinger box"",""physical_details"":null,""dimensions"":null,""extent"":""70.00
items""}]"<br>
Benjamin C. Howland papers,MSS 13748,Collection,,Yes,No,admin,2015-08-11 21:43:31 UTC,"[{""_date"":""Creation: 1941 - 1983, 1941-1983""}]","[{""portion"":""Whole"",""container_summary"":""6 Hollinger boxes"",""physical_details"":null,""dimensions"":null,""extent"":""757.00
items""}]"<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><br>
<br>
<o:p></o:p></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal">On Dec 9, 2020, at 12:42 PM, Majewski, Steven Dennis (sdm7g) <<a href="mailto:sdm7g@virginia.edu" target="_blank">sdm7g@virginia.edu</a>> wrote:<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal">You can just add created_by and create_time ( and perhaps other fields like: last_modified_by, finding_aid_author ) to the resource_list_report.rb :<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-size:13.0pt;color:#DFBD22">diff --git a/reports/resources/resources_list_report/resources_list_report.rb b/reports/resources/resources_list_report/resources_list_report.rb</span></b><span style="font-size:13.0pt;color:#DFBD22"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-size:13.0pt;color:#DFBD22">index 96f200fed..ad3a96474 100644</span></b><span style="font-size:13.0pt;color:#DFBD22"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-size:13.0pt;color:#DFBD22">--- a/reports/resources/resources_list_report/resources_list_report.rb</span></b><span style="font-size:13.0pt;color:#DFBD22"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-size:13.0pt;color:#DFBD22">+++ b/reports/resources/resources_list_report/resources_list_report.rb</span></b><span style="font-size:13.0pt;color:#DFBD22"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:13.0pt;color:#4ED2E0">@@ -9,7 +9,8 @@</span><span style="font-size:13.0pt;color:#CDBE97"> class ResourcesListReport < AbstractReport<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:13.0pt;color:#CDBE97"> level_id as level,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:13.0pt;color:#CDBE97"> resource_type_id as resource_type,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:13.0pt;color:#CDBE97"> publish,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:13.0pt;color:#560001">- restrictions<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:13.0pt;color:#50DB39">+</span><span style="font-size:13.0pt;color:#CDBE97">
</span><span style="font-size:13.0pt;color:#50DB39">restrictions,</span><span style="font-size:13.0pt;color:#CDBE97"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:13.0pt;color:#50DB39">+ created_by, create_time<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:13.0pt;color:#CDBE97"> from resource<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:13.0pt;color:#CDBE97"> where repo_id = #{db.literal(repo_id)}"<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:13.0pt;color:#CDBE97"> end<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">And add those to the .yml files in that directory, otherwise you will get something like:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-right:7.5pt"><b><span style="font-family:"Helvetica",sans-serif">translation missing: en.reports.translation_defaults.created_by<o:p></o:p></span></b></p>
<p class="MsoNormal" style="mso-margin-top-alt:1.5pt;margin-right:1.5pt;margin-bottom:1.5pt;margin-left:.5in">
<span style="font-family:"Helvetica",sans-serif">admin<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:0in;margin-right:7.5pt;margin-bottom:0in;margin-left:1.5pt;margin-bottom:.0001pt">
<b><span style="font-family:"Helvetica",sans-serif">translation missing: en.reports.translation_defaults.create_time<o:p></o:p></span></b></p>
<p class="MsoNormal" style="mso-margin-top-alt:1.5pt;margin-right:1.5pt;margin-bottom:1.5pt;margin-left:.5in">
<span style="font-family:"Helvetica",sans-serif">2015-08-11 21:43:13 UTC<o:p></o:p></span></p>
<div>
<p class="MsoNormal" style="margin-left:3.0pt"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:3.0pt">( And we really should add a translation missing fallback to these reports to make customizing easier! ) <o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal" style="margin-left:3.0pt"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:3.0pt">That doesn’t make it easily sortable however. That would take more work. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:3.0pt">Alternatively, once you have added those fields, you can use the json output format, and write a script, or use ‘jq’ to sort, group, and format the report before printing. However, if you need to group by author,
it might just be simpler to run the report outside of archivesspace as a mysql query. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:3.0pt"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:3.0pt">If you wanted that sort of grouping as an ArchivesSpace report, you would need to write a new report, restructuring it as a subreport on resources created by each user. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:3.0pt"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:3.0pt"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:3.0pt">— Steve M.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:3.0pt"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:3.0pt"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:3.0pt"><br>
<br>
<o:p></o:p></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal" style="margin-left:3.0pt">On Dec 8, 2020, at 6:51 PM, Cornwall, Daniel D (EED) <<a href="mailto:daniel.cornwall@alaska.gov" target="_blank">daniel.cornwall@alaska.gov</a>> wrote:<o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-left:3.0pt"><o:p> </o:p></p>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-left:3.0pt"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:3.0pt">Hello,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:3.0pt"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:3.0pt">After fiddling with the reports module in 2.8 and looking at the documentation in ArchivesSpace help center I want to ask you if your institution keeps track of the number of finding aids that someone enters into
ArchivesSpace and if so, how you track that. The Resources List Report ALMOST fits my purposes but doesn’t list the audit information I’d need to filter when resource records were created or modified.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:3.0pt"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:3.0pt">If you’re aware of this kind of functionality, or ideally a report that would produced a list of resource records with creation date by users, please let me know. Otherwise I’ll think about other ways to track.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:3.0pt"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:3.0pt">Thanks! - Daneil<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:3.0pt"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:3.0pt">==============================<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:3.0pt">Daniel Cornwall<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:3.0pt">Library Technology Consultant / OWL Program Manager<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:3.0pt">Alaska State Library<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:3.0pt">Ph: 907-465-6332<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:3.0pt"><a href="https://lam.alaska.gov/daniel" target="_blank">https://lam.alaska.gov/daniel</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:3.0pt"> <o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="margin-left:3.0pt"><span style="font-size:12.0pt;font-family:"Menlo-Regular",serif">_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
</span><a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank"><span style="font-size:12.0pt;font-family:"Menlo-Regular",serif">Archivesspace_Users_Group@lyralists.lyrasis.org</span></a><span style="font-size:12.0pt;font-family:"Menlo-Regular",serif"><br>
</span><a href="https://urldefense.com/v3/__http:/lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group__;!!J2_8gdp6gZQ!5H7NTB7ucGUW9p8F3e4_s8HbL5w7nAYlyeH6j1XUYVQ8QDHbpOEkmcXKeTxvJ74sotOPO9o$" target="_blank"><span style="font-size:12.0pt;font-family:"Menlo-Regular",serif">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</span></a><o:p></o:p></p>
</div>
</blockquote>
</div>
<p class="MsoNormal" style="margin-left:3.0pt"><o:p> </o:p></p>
</div>
</div>
<p class="MsoNormal" style="margin-left:3.0pt">_______________________________________________<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.com/v3/__http:/lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group__;!!J2_8gdp6gZQ!5H7NTB7ucGUW9p8F3e4_s8HbL5w7nAYlyeH6j1XUYVQ8QDHbpOEkmcXKeTxvJ74sotOPO9o$" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><o:p></o:p></p>
</div>
</blockquote>
</div>
<p class="MsoNormal" style="margin-left:3.0pt"><o:p> </o:p></p>
</div>
</div>
<p class="MsoNormal" style="margin-left:3.0pt">_______________________________________________<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.com/v3/__http:/lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group__;!!J2_8gdp6gZQ!5H7NTB7ucGUW9p8F3e4_s8HbL5w7nAYlyeH6j1XUYVQ8QDHbpOEkmcXKeTxvJ74sotOPO9o$" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><o:p></o:p></p>
</blockquote>
</div>
<p class="MsoNormal" style="margin-left:3.0pt"><br clear="all">
<br>
-- <o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="margin-left:3.0pt">Kevin Schlottmann<br>
Interim Director and Head of Archives Processing<br>
Rare Book & Manuscript Library<br>
Butler Library, Room 801<br>
Columbia University<br>
535 W. 114th St., New York, NY 10027<br>
(212) 854-8483<o:p></o:p></p>
</div>
</div>
</div>
</div>
</body>
</html>