<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=""><br class=""></div><div class="">This will make it editable and cause the ‘create’ button to appear:</div><div class=""><br class=""></div><div class=""><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">MariaDB [archivesspace]> update enumeration set editable = 1 where name = "subject_term_type" ; </span></div></div><div class=""><br class=""></div>But I’ld still like to understand the reason it was set as not editable as the default. <div class=""><br class=""></div><div class=""><br class=""></div><div class="">— Steve M. </div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><div><br class=""><blockquote type="cite" class=""><div class="">On Jan 17, 2020, at 5:02 PM, Bowers, Kate A. <<a href="mailto:kate_bowers@harvard.edu" class="">kate_bowers@harvard.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: Menlo-Regular; font-size: 16px; 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=""><span style="color: rgb(31, 73, 125);" class="">This needs to either be editable or include all of these controlled vocabularies (405 of them) with the ability to suppress display of them by repository managers:<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=""><a href="https://www.loc.gov/standards/sourcelist/subject.html" style="color: purple; text-decoration: underline;" class="">https://www.loc.gov/standards/sourcelist/subject.html</a><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="">Kate<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=""><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_users_group-bounces@lyralists.lyrasis.org" class="">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" class="">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>><span class="Apple-converted-space"> </span><b class="">On Behalf Of<span class="Apple-converted-space"> </span></b>Majewski, Steven Dennis (sdm7g)<br class=""><b class="">Sent:</b><span class="Apple-converted-space"> </span>Friday, January 17, 2020 4:27 PM<br class=""><b class="">To:</b><span class="Apple-converted-space"> </span><a href="mailto:mcyzyk@jhu.edu" class="">mcyzyk@jhu.edu</a>; Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" class="">archivesspace_users_group@lyralists.lyrasis.org</a>><br class=""><b class="">Subject:</b><span class="Apple-converted-space"> </span>Re: [Archivesspace_Users_Group] Need to add new value to Subject Term Type lookup table<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 class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">subject_term_type enumeration is set as non-editable, which is why no create button appears in the view, and also, I believe, prevents changing it via the API as well:<o:p class=""></o:p></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div></div><div class=""><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><span style="font-size: 11.5pt; color: rgb(205, 190, 151);" class="">./curl_as_osx<span class="Apple-converted-space"> </span><a href="http://localhost:4567/config/enumerations/names/subject_term_type" style="color: purple; text-decoration: underline;" class="">http://localhost:4567/config/enumerations/names/subject_term_type</a><span class="Apple-converted-space"> </span>| jq . <o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class="">{</span></b><span style="font-size: 11.5pt; color: rgb(205, 190, 151);" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class=""> <span class="Apple-converted-space"> </span></span></b><b class=""><span style="font-size: 11.5pt; color: rgb(0, 0, 143);" class="">"lock_version"</span></b><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class="">:<span class="Apple-converted-space"> </span></span></b><span style="font-size: 11.5pt; color: rgb(205, 190, 151);" class="">0</span><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class="">,</span></b><span style="font-size: 11.5pt; color: rgb(0, 0, 143);" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class=""> <span class="Apple-converted-space"> </span></span></b><b class=""><span style="font-size: 11.5pt; color: rgb(0, 0, 143);" class="">"name"</span></b><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class="">:<span class="Apple-converted-space"> </span></span></b><span style="font-size: 11.5pt; color: rgb(80, 219, 57);" class="">"subject_term_type"</span><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class="">,</span></b><span style="font-size: 11.5pt; color: rgb(80, 219, 57);" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class=""> <span class="Apple-converted-space"> </span></span></b><b class=""><span style="font-size: 11.5pt; color: rgb(0, 0, 143);" class="">"editable"</span></b><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class="">:<span class="Apple-converted-space"> </span></span></b><span style="font-size: 11.5pt; color: rgb(205, 190, 151);" class="">false</span><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class="">,</span></b><span style="font-size: 11.5pt; color: rgb(0, 0, 143);" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class=""> <span class="Apple-converted-space"> </span></span></b><b class=""><span style="font-size: 11.5pt; color: rgb(0, 0, 143);" class="">"create_time"</span></b><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class="">:<span class="Apple-converted-space"> </span></span></b><span style="font-size: 11.5pt; color: rgb(80, 219, 57);" class="">"2015-08-11T21:10:13Z"</span><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class="">,</span></b><span style="font-size: 11.5pt; color: rgb(80, 219, 57);" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class=""> <span class="Apple-converted-space"> </span></span></b><b class=""><span style="font-size: 11.5pt; color: rgb(0, 0, 143);" class="">"system_mtime"</span></b><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class="">:<span class="Apple-converted-space"> </span></span></b><span style="font-size: 11.5pt; color: rgb(80, 219, 57);" class="">"2015-08-11T21:10:13Z"</span><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class="">,</span></b><span style="font-size: 11.5pt; color: rgb(80, 219, 57);" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class=""> <span class="Apple-converted-space"> </span></span></b><b class=""><span style="font-size: 11.5pt; color: rgb(0, 0, 143);" class="">"user_mtime"</span></b><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class="">:<span class="Apple-converted-space"> </span></span></b><span style="font-size: 11.5pt; color: rgb(80, 219, 57);" class="">"2015-08-11T21:10:13Z"</span><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class="">,</span></b><span style="font-size: 11.5pt; color: rgb(80, 219, 57);" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class=""> <span class="Apple-converted-space"> </span></span></b><b class=""><span style="font-size: 11.5pt; color: rgb(0, 0, 143);" class="">"jsonmodel_type"</span></b><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class="">:<span class="Apple-converted-space"> </span></span></b><span style="font-size: 11.5pt; color: rgb(80, 219, 57);" class="">"enumeration"</span><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class="">,</span></b><span style="font-size: 11.5pt; color: rgb(0, 0, 143);" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class=""> <span class="Apple-converted-space"> </span></span></b><b class=""><span style="font-size: 11.5pt; color: rgb(0, 0, 143);" class="">"relationships"</span></b><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class="">: [</span></b><span style="font-size: 11.5pt; color: rgb(0, 0, 143);" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class=""> <span class="Apple-converted-space"> </span></span></b><span style="font-size: 11.5pt; color: rgb(80, 219, 57);" class="">"term_type"<o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class=""> ],</span></b><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class=""><o:p class=""></o:p></span></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class=""> <span class="Apple-converted-space"> </span></span></b><b class=""><span style="font-size: 11.5pt; color: rgb(0, 0, 143);" class="">"enumeration_values"</span></b><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class="">: [</span></b><o:p class=""></o:p></div></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class=""> … </span></b><o:p class=""></o:p></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><b class=""><span style="font-size: 11.5pt; color: rgb(223, 189, 34);" class=""><br class=""><br class=""></span></b><o:p class=""></o:p></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><b class=""><span style="color: rgb(223, 189, 34);" class=""><br class=""><br class=""></span></b><o:p class=""></o:p></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">I don’t know where the logic behind what values are editable and what are not is documented. <o:p class=""></o:p></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">I’m thinking you could change this in MySQL, but it would be wise to know why is it set non-editable first. <o:p class=""></o:p></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">— Steve M. <o:p class=""></o:p></div></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></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 class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><br class=""><br class=""><o:p class=""></o:p></div><blockquote style="margin-top: 5pt; margin-bottom: 5pt;" class=""><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">On Jan 17, 2020, at 3:19 PM, Mark Cyzyk <<a href="mailto:mcyzyk@jhu.edu" style="color: purple; text-decoration: underline;" class="">mcyzyk@jhu.edu</a>> wrote:<o:p class=""></o:p></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 class=""><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><br class="">Dear Aspace List,<br class=""><br class="">I've been asked to add two new terms in the following two lookup tables:<br class=""><br class="">Subject Source: lcmptm "Library of Congress Medium of Performance Thesaurus for Music<br class="">Subject Term Type: medium_of_performacne "Medium of performance"<br class=""><br class="">The Subject Source lookup table has a Create button, I click it, add "lcmptm", then go into /aspace/locales/enums/en.yml to add the corresponding "translation".<br class=""><br class="">However, the Subject Term Type lookup table does NOT have a Create button. I added the new value to the proper place in /aspace/locales/enums/en.yml anyway hoping it would show up in the Web GUI. But no joy.<br class=""><br class="">Question: How can I add a new value to the Subject Term Type lookup table without a Create button?<br class=""><br class="">Thanks,<br class=""><br class="">Mark<br class=""><br class="">--<span class="Apple-converted-space"> </span><br class=""><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><br class="">Mark Cyzyk, M.A., M.L.S.<br class="">Library Applications Group<br class="">The Sheridan Libraries<br class="">The Johns Hopkins University<br class=""><a href="mailto:mcyzyk@jhu.edu" style="color: purple; text-decoration: underline;" class="">mcyzyk@jhu.edu</a><br class=""><br class="">Verba volant, scripta manent.<br class=""><br class="">_______________________________________________<br class="">Archivesspace_Users_Group mailing list<br class=""><a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" style="color: purple; text-decoration: underline;" class="">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br class=""><a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" style="color: purple; text-decoration: underline;" class="">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><o:p class=""></o:p></div></div></div></blockquote></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: Menlo-Regular; font-size: 16px; 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: Menlo-Regular; font-size: 16px; 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: Menlo-Regular; font-size: 16px; 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: Menlo-Regular; font-size: 16px; 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: purple; text-decoration: underline; font-family: Menlo-Regular; font-size: 16px; 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: Menlo-Regular; font-size: 16px; 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: purple; text-decoration: underline; font-family: Menlo-Regular; font-size: 16px; 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>