[Archivesspace_Users_Group] Resource Creation Statistics - Any ideas?

Majewski, Steven Dennis (sdm7g) sdm7g at virginia.edu
Wed Dec 9 12:42:35 EST 2020

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 :

diff --git a/reports/resources/resources_list_report/resources_list_report.rb b/reports/resources/resources_list_report/resources_list_report.rb
index 96f200fed..ad3a96474 100644
--- a/reports/resources/resources_list_report/resources_list_report.rb
+++ b/reports/resources/resources_list_report/resources_list_report.rb
@@ -9,7 +9,8 @@ class ResourcesListReport < AbstractReport
                        level_id as level,
                        resource_type_id as resource_type,
-                       restrictions
+                       restrictions,
+                       created_by, create_time
                from resource
                where repo_id = #{db.literal(repo_id)}"

And add those to the .yml files in that directory, otherwise you will get something like:

translation missing: en.reports.translation_defaults.created_by
translation missing: en.reports.translation_defaults.create_time
2015-08-11 21:43:13 UTC

( And we really should add a translation missing fallback to these reports to make customizing easier! ) 

That doesn’t make it easily sortable however. That would take more work. 
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. 

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. 

— Steve M.

> On Dec 8, 2020, at 6:51 PM, Cornwall, Daniel D (EED) <daniel.cornwall at alaska.gov> wrote:
> Hello,
> 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.
> 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.
> Thanks! - Daneil
> ==============================
> Daniel Cornwall
> Library Technology Consultant / OWL Program Manager
> Alaska State Library
> Ph: 907-465-6332
> https://lam.alaska.gov/daniel <https://lam.alaska.gov/daniel>
> _______________________________________________
> 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 <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/20201209/6a8d5c3d/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 3342 bytes
Desc: not available
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20201209/6a8d5c3d/attachment.bin>

More information about the Archivesspace_Users_Group mailing list