We have a custom report that acts on the processing status field to pull a list of "unprocessed accessions." In our case, the report lists those accessions with a processing_status value of "new_unprocessed" or "in_progress."
The custom report is part of a plugin that adds several custom reports to our ASpace instance: https://github.com/duke-libraries/archivesspace-duke-custom-reports You can see the SQL query that forms the basis of this report in this file: https://github.com/duke-libraries/archivesspace-duke-custom-reports/blob/master/backend/model/accession_list_of_unprocessed_accessions.rb#L25 -Noah ================ Noah Huffman Archivist for Metadata, Systems, and Digital Records David M. Rubenstein Rare Book & Manuscript Library Duke University | 919-660-5982 http://library.duke.edu/rubenstein/ Pronouns: he / him / his From: archivesspace_users_group-boun...@lyralists.lyrasis.org <archivesspace_users_group-boun...@lyralists.lyrasis.org> On Behalf Of Custer, Mark Sent: Thursday, October 1, 2020 1:50 PM To: Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org> Subject: Re: [Archivesspace_Users_Group] Unprocessed Accessions Report Linda, all: I'd also say that a new report could/should be created that doesn't rely on event records in this case. Adding reports to ASpace is much easier now than it used to be, and I think that having one that relied on the "Processing Status" field in this case would make a lot of sense. Events are much more difficult to create in the staff interface. Does anyone already have such a report, I wonder? Mark ________________________________ From: archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org> <archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>> on behalf of Brian Harrington <brian.harring...@lyrasis.org<mailto:brian.harring...@lyrasis.org>> Sent: Thursday, October 1, 2020 1:20 PM To: Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org<mailto:archivesspace_users_group@lyralists.lyrasis.org>> Subject: Re: [Archivesspace_Users_Group] Unprocessed Accessions Report Hi Linda, I think adding the event records is the only thing that's going to work with that report. Fortunately, it's not too hard to do with the API. Depending on your familiarity with the API, you might find Bria Parker's wonderful blog post here: https://icantiemyownshoes.wordpress.com/2015/11/20/how-i-learned-to-stop-worrying-and-love-the-api/<https://urldefense.com/v3/__https:/nam05.safelinks.protection.outlook.com/?url=https*3A*2F*2Ficantiemyownshoes.wordpress.com*2F2015*2F11*2F20*2Fhow-i-learned-to-stop-worrying-and-love-the-api*2F&data=02*7C01*7Cmark.custer*40yale.edu*7Cfd6185b76df045f05b7908d8662e4d31*7Cdd8cbebb21394df8b4114e3e87abeb5c*7C0*7C0*7C637371696368581251&sdata=bO4FhHWFpW*2BwT8te5SlD*2FAgL1IGPLiivWGuuJhLHtYM*3D&reserved=0__;JSUlJSUlJSUlJSUlJSUlJSUlJQ!!OToaGQ!6fa3X4bbkn0IgxwxkSiiuCxSSLp5N5QWMwvc9B8diRE4YbyolsFIunZRJ5e-C5EtcKP1$> useful. She describes how she used OpenRefine and a little bit of shell scripting to add processing status events to all of her accessions. I hope this helps, Brian -- Brian Harrington Data Migration Specialist LYRASIS brian.harring...@lyrasis.org<mailto:brian.harring...@lyrasis.org> From: <archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>> on behalf of Linda Hocking <lhock...@litchfieldhistoricalsociety.org<mailto:lhock...@litchfieldhistoricalsociety.org>> Reply-To: Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org<mailto:archivesspace_users_group@lyralists.lyrasis.org>> Date: Thursday, October 1, 2020 at 12:23 PM To: Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org<mailto:archivesspace_users_group@lyralists.lyrasis.org>> Subject: Re: [Archivesspace_Users_Group] Unprocessed Accessions Report Kate, Thank you. We have marked them complete, but they still appear in the report. The total count of collections and the total unprocessed show the same number. I was just hoping someone else might have already figured out a more efficient way to remedy this than to enter 1000 or so event records without having any useful data to put in them. We can sort the report by the Linked Resource Title field to determine which ones have no linked resource records, but of course some of the collections with resource records are unprocessed. Thanks for sharing your modifications to the processing status list. I know we have several partially processed as well, so I may make that one of our options. Linda From: archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org> <archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>> On Behalf Of Bowers, Kate A. Sent: Wednesday, September 30, 2020 4:03 PM To: Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org<mailto:archivesspace_users_group@lyralists.lyrasis.org>> Subject: Re: [Archivesspace_Users_Group] Unprocessed Accessions Report There is "processing status" in accession records. I don't think there is a way to update processing statuses in bulk through the user interface, but it is a good place to indicate whether an accession has been processed or not or something in between. Processing statuses can be the default or can be edited using Controlled Value List and selecting Collection Management Processing Status A selection of ours are as follows: * Completed * In progress * Partially processed * Unknown * Unprocessed (For the very curious: "In progress" means we're working on it. "Partially processed" means it's not completed, but we're not working on it.) Kate Kate Bowers Collections Services Archivist for Metadata, Standards, and Systems Harvard University Archives kate_bow...@harvard.edu<mailto:kate_bow...@harvard.edu> https://archives.harvard.edu<https://urldefense.com/v3/__https:/archives.harvard.edu/__;!!OToaGQ!6fa3X4bbkn0IgxwxkSiiuCxSSLp5N5QWMwvc9B8diRE4YbyolsFIunZRJ5e-Cy8GhqNp$> 617-998-5238 From: archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org> <archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>> On Behalf Of Linda Hocking Sent: Wednesday, September 30, 2020 3:43 PM To: archivesspace_users_group@lyralists.lyrasis.org<mailto:archivesspace_users_group@lyralists.lyrasis.org> Subject: [Archivesspace_Users_Group] Unprocessed Accessions Report Good afternoon, One of our work from home data cleanup projects has been dealing with the accession records that weren't linked to resources. When we finished re-linking, we attempted to find a list of all unprocessed accessions. Unfortunately, the Unprocessed Accessions report shows all of our collections because there aren't events for each accession record noting they have been processed. Many of these were processed quite some time ago and imported from Archon, we don't have dates or really any notes to add that aren't already in the finding aid processing notes fields. I'm sure there's a really good database reason why this can't just be a check box, but I wonder if anyone has had this problem and whether you figured out an quick and easy way to create/import the events rather than adding one at a time. Many thanks in advance for help and advice! Linda Linda M. Hocking, CA Curator of Library & Archives Litchfield Historical Society P.O. Box 385 Litchfield, CT 06759 860-567-4501 https://www.litchfieldhistoricalsociety.org<https://urldefense.com/v3/__https:/nam05.safelinks.protection.outlook.com/?url=https*3A*2F*2Fwww.litchfieldhistoricalsociety.org*2F&data=02*7C01*7Cmark.custer*40yale.edu*7Cfd6185b76df045f05b7908d8662e4d31*7Cdd8cbebb21394df8b4114e3e87abeb5c*7C0*7C0*7C637371696368591208&sdata=BcHNJC5S8TJBazrnvJx06FqB03r*2Bff470nFgePPll44*3D&reserved=0__;JSUlJSUlJSUlJSUlJSU!!OToaGQ!6fa3X4bbkn0IgxwxkSiiuCxSSLp5N5QWMwvc9B8diRE4YbyolsFIunZRJ5e-C6btS4cH$>
_______________________________________________ Archivesspace_Users_Group mailing list Archivesspace_Users_Group@lyralists.lyrasis.org http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group