<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div class="">In most cases, the info displayed in the staff webapp comes from the database but info displayed in the public view usually comes from the SOLR index. When you edit and save records in the staff interface, the update triggers a SOLR reindex of that record. If you make “back door” changes thru MySQL or the API, the SOLR reindex may not get triggered. So probably not unexpected (although I don’t see it noted in the readme for that script).</div><div class=""><br class=""></div><div class="">Editing and saving the record triggers the reindex, but rather than doing that manually for all of the updated records, you can trigger a SOLR reindex by deleting the files in data/indexer_state/ and data/indexer_pui_state/ on the server. </div><div class="">( Or you can be more specific, if you know exactly what needs to be reindexed. ) </div><div class=""><br class=""></div>— Steve M. <div class=""><br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On Jan 8, 2020, at 1:19 PM, Walton, Donnelly <<a href="mailto:dfwalton@ua.edu" class="">dfwalton@ua.edu</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class="WordSection1" style="page: WordSection1; caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span style="color: rgb(31, 73, 125);" class="">We are upgrading to 2.7.0 (on a test server first). We noticed that in the PUI, our Finding Aid data showed Language of Description as “Undetermined” and Script of Description as “Code for Undetermined Script” in every record. I used the<span class="Apple-converted-space"> </span></span><a href="https://github.com/archivesspace-plugins/batch_update_lang_and_script" style="color: rgb(149, 79, 114); text-decoration: underline;" class="">https://github.com/archivesspace-plugins/batch_update_lang_and_script</a><span class="Apple-converted-space"> </span>plugin to fix this problem. This corrected the problem in the staff side, but when I look at the public side, the data still shows<span class="Apple-converted-space"> </span><span style="color: rgb(31, 73, 125);" class="">“Undetermined” and “Code for Undetermined Script” in the PUI. I noticed that if I go to the record in the staff interface in edit mode, then save, the change will show up in the PUI. Is this what is expected in the cleanup process, or did something go wrong?<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span style="color: rgb(31, 73, 125);" class=""><o:p class=""> </o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span style="color: rgb(31, 73, 125);" class="">I accidentally sent this to the Member Reps group first. Sorry for any duplication.<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span style="color: rgb(31, 73, 125);" class=""><o:p class=""> </o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span style="color: rgb(31, 73, 125);" class="">Thanks,<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span style="color: rgb(31, 73, 125);" class=""><o:p class=""> </o:p></span></div><div class=""><p class="MsoNormal" style="margin: 7.5pt 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; background-color: white; background-position: initial initial; background-repeat: initial initial;"><b class=""><span style="font-size: 12pt; font-family: Helvetica, sans-serif; color: rgb(153, 0, 0);" class="">Donnelly Lancaster Walton<o:p class=""></o:p></span></b></p><p class="MsoNormal" style="margin: 0in 0in 7.5pt; font-size: 11pt; font-family: Calibri, sans-serif; background-color: white; background-position: initial initial; background-repeat: initial initial;"><span style="font-size: 11.5pt; font-family: Helvetica, sans-serif; color: rgb(81, 87, 91);" class="">Archival Access Coordinator, Special Collections<o:p class=""></o:p></span></p><p class="MsoNormal" style="margin: 0in 0in 7.5pt; font-size: 11pt; font-family: Calibri, sans-serif; background-color: white; background-position: initial initial; background-repeat: initial initial;"><span style="font-size: 10.5pt; font-family: Helvetica, sans-serif;" class="">University Libraries <br class=""><a href="https://www.ua.edu/" style="color: rgb(149, 79, 114); text-decoration: underline;" class=""><span style="color: maroon; text-decoration: none;" class="">The University of Alabama</span></a><br class="">W. S. Hoole Library, Mary Harmon Bryant Hall<br class="">Box 870266 <br class="">Tuscaloosa, AL 35487 <br class="">Office <a href="tel:205-348-0505" style="color: rgb(149, 79, 114); text-decoration: underline;" class=""><span style="text-decoration: none;" class="">205-348-0505</span></a> <br class=""><a href="mailto:dfwalton@ua.edu" style="color: rgb(149, 79, 114); text-decoration: underline;" class=""><span style="text-decoration: none;" class="">dfwalton@ua.edu</span></a> </span><span style="font-size: 10.5pt; font-family: Helvetica, sans-serif; color: rgb(153, 0, 0);" class="">| </span><span style="font-size: 10.5pt; font-family: Helvetica, sans-serif;" class=""><a href="https://www.lib.ua.edu/libraries/hoole/" style="color: rgb(149, 79, 114); text-decoration: underline;" class=""><span style="text-decoration: none;" class="">https://www.lib.ua.edu/libraries/hoole/</span></a><o:p class=""></o:p></span></p><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><a href="https://www.ua.edu/" style="color: rgb(149, 79, 114); text-decoration: underline;" class=""><span style="font-size: 11.5pt; font-family: Helvetica, sans-serif; color: rgb(153, 0, 0); background-color: white; text-decoration: none; background-position: initial initial; background-repeat: initial initial;" class=""><span id="cid:image001.gif@01D5C612.031582B0"><image001.gif></span></span></a><span style="color: rgb(31, 73, 125);" class=""><o:p class=""></o:p></span></div></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span style="color: rgb(31, 73, 125);" class=""><o:p class=""> </o:p></span></div><div class=""><div style="border-style: solid none none; border-top-width: 1pt; border-top-color: rgb(225, 225, 225); padding: 3pt 0in 0in;" class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><b class="">From:</b><span class="Apple-converted-space"> </span><a href="mailto:archivesspace_member_reps-bounces@lyralists.lyrasis.org" style="color: rgb(149, 79, 114); text-decoration: underline;" class="">archivesspace_member_reps-bounces@lyralists.lyrasis.org</a><span class="Apple-converted-space"> </span><<a href="mailto:archivesspace_member_reps-bounces@lyralists.lyrasis.org" style="color: rgb(149, 79, 114); text-decoration: underline;" class="">archivesspace_member_reps-bounces@lyralists.lyrasis.org</a>><span class="Apple-converted-space"> </span><b class="">On Behalf Of<span class="Apple-converted-space"> </span></b>Christine Di Bella<br class=""><b class="">Sent:</b><span class="Apple-converted-space"> </span>Wednesday, November 6, 2019 11:31 AM<br class=""><b class="">To:</b><span class="Apple-converted-space"> </span>Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" style="color: rgb(149, 79, 114); text-decoration: underline;" class="">archivesspace_users_group@lyralists.lyrasis.org</a>>; Archivesspace Member Reps <<a href="mailto:archivesspace_member_reps@lyralists.lyrasis.org" style="color: rgb(149, 79, 114); text-decoration: underline;" class="">archivesspace_member_reps@lyralists.lyrasis.org</a>>;<span class="Apple-converted-space"> </span><a href="mailto:archivesspace_tac@lyralists.lyrasis.org" style="color: rgb(149, 79, 114); text-decoration: underline;" class="">archivesspace_tac@lyralists.lyrasis.org</a>;<span class="Apple-converted-space"> </span><a href="mailto:archivesspace_uac@lyralists.lyrasis.org" style="color: rgb(149, 79, 114); text-decoration: underline;" class="">archivesspace_uac@lyralists.lyrasis.org</a><br class=""><b class="">Subject:</b><span class="Apple-converted-space"> </span>[Archivesspace_member_reps] plugins available for bulk data cleanup of language information/RDE template issue<o:p class=""></o:p></div></div></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">As mentioned in the release announcement for ArchivesSpace v2.7.0, the changes in the languages area will require data cleanup to existing records for some people. Upon upgrade, existing language information is migrated to the new or newly structured fields. While some ways of recording information could be easily accommodated in this migration, because there are so many different ways language information could have been recorded previously, some situations will require data cleanup.<o:p class=""></o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">We’ve put together three plugins that you can use, or use as examples, to handle some common situations. These only run on resource records. They are:<o:p class=""></o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><ul type="disc" style="margin-bottom: 0in; margin-top: 0in;" class=""><li class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">Batch update language and script of description in resource records to one language and/or script of description value:<a href="https://github.com/archivesspace-plugins/batch_update_lang_and_script" style="color: rgb(149, 79, 114); text-decoration: underline;" class="">https://github.com/archivesspace-plugins/batch_update_lang_and_script</a><span class="Apple-converted-space"> </span>- for cases where all or most of your description is done in one language and script, this will help you do a global or repository-specific update.<o:p class=""></o:p></li></ul><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><ul type="disc" style="margin-bottom: 0in; margin-top: 0in;" class=""><li class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">Batch update language of materials in resource records currently lacking a controlled value language:<a href="https://github.com/archivesspace-plugins/batch_update_langmaterials" style="color: rgb(149, 79, 114); text-decoration: underline;" class="">https://github.com/archivesspace-plugins/batch_update_langmaterials</a><span class="Apple-converted-space"> </span>- for situations where all or most of your materials that do not currently have a language value are in one language, this will help you do a global or repository-specific update.<o:p class=""></o:p></li></ul><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><ul type="disc" style="margin-bottom: 0in; margin-top: 0in;" class=""><li class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">Batch update language of materials records for resource records currently lacking a controlled value language by matching a text string in a note:<span class="Apple-converted-space"> </span><a href="https://github.com/archivesspace-plugins/batch_update_langmaterials_from_note" style="color: rgb(149, 79, 114); text-decoration: underline;" class="">https://github.com/archivesspace-plugins/batch_update_langmaterials_from_note</a><span class="Apple-converted-space"> </span>- for situations where specific note text can be easily parsed into a controlled value language, this will help you do a targeted update. You will be able to choose whether to keep or delete the notes after running this job.<o:p class=""></o:p></li></ul><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">As with any plugins that change information in records, we strongly recommend you backup your data before running them and review the results in records afterwards before moving on to do more work in your ArchivesSpace. These plugins make changes to your records that cannot be undone, though you can edit individual records or run the plugins again at any point. Once you’ve run the plugin(s) and are satisfied with the results, you can disable the plugins at any time.<o:p class=""></o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">Also, we have been alerted to an issue where previously created RDE templates do not display correctly in v2.7.0 due to the language changes. This will be corrected in the next release, but we are working on a plugin that can provide a fix for people who need it quicker than that. In the interim, feel free to reach out to us if you need guidance on fixing this locally.<o:p class=""></o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">We hope these resources are helpful. Please let us know if you need help with them or have other languages-related questions.<o:p class=""></o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">Christine<o:p class=""></o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span style="font-family: Arial, sans-serif; color: rgb(31, 73, 125);" class="">Christine Di Bella<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span style="font-family: Arial, sans-serif; color: rgb(31, 73, 125);" class="">ArchivesSpace Program Manager<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><a href="mailto:christine.dibella@lyrasis.org" style="color: rgb(149, 79, 114); text-decoration: underline;" class=""><span style="font-family: Arial, sans-serif;" class="">christine.dibella@lyrasis.org</span></a><span style="font-family: Arial, sans-serif; color: rgb(31, 73, 125);" class=""><o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span style="font-family: Arial, sans-serif; color: rgb(31, 73, 125);" class="">800.999.8558 x2905<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span style="font-family: Arial, sans-serif; color: rgb(31, 73, 125);" class="">678-235-2905<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span style="font-family: Arial, sans-serif; color: rgb(31, 73, 125);" class="">cdibella13 (Skype)</span><span style="color: rgb(31, 73, 125);" class=""><o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span id="cid:image003.jpg@01D5C61D.0A2D4D70"><image003.jpg></span><o:p class=""></o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div></div><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">_______________________________________________</span><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">Archivesspace_member_reps mailing list</span><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><a href="mailto:Archivesspace_member_reps@lyralists.lyrasis.org" style="color: rgb(149, 79, 114); text-decoration: underline; font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">Archivesspace_member_reps@lyralists.lyrasis.org</a><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_member_reps" style="color: rgb(149, 79, 114); text-decoration: underline; font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_member_reps</a><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">_______________________________________________</span><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">Archivesspace_Users_Group mailing list</span><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" style="color: rgb(149, 79, 114); text-decoration: underline; font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" style="color: rgb(149, 79, 114); text-decoration: underline; font-family: Helvetica; font-size: 14px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a></div></blockquote></div><br class=""></div></body></html>