<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif;" dir="ltr">
<p style="margin-top:0;margin-bottom:0">I'm seeing this as well when I make a new event but leave the outcome blank.</p>
</div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of James R Griffin
 III <jrg5@princeton.edu><br>
<b>Sent:</b> Tuesday, September 25, 2018 2:36:25 PM<br>
<b>To:</b> archivesspace_users_group@lyralists.lyrasis.org<br>
<b>Subject:</b> [Archivesspace_Users_Group] Event Outcome Problems</font>
<div> </div>
</div>
<meta content="text/html; charset=utf-8">
<meta name="x_Title" content="">
<meta name="x_Keywords" content="">
<meta name="x_Generator" content="Microsoft Word 15 (filtered medium)">
<style>
<!--
@font-face
        {font-family:"Cambria Math"}
@font-face
        {font-family:Calibri}
@font-face
        {font-family:Consolas}
p.x_MsoNormal, li.x_MsoNormal, div.x_MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Calibri",sans-serif}
a:x_link, span.x_MsoHyperlink
        {color:#0563C1;
        text-decoration:underline}
a:x_visited, span.x_MsoHyperlinkFollowed
        {color:#954F72;
        text-decoration:underline}
span.x_EmailStyle17
        {font-family:"Calibri",sans-serif;
        color:windowtext}
span.x_msoIns
        {text-decoration:underline;
        color:teal}
.x_MsoChpDefault
        {font-family:"Calibri",sans-serif}
@page WordSection1
        {margin:1.0in 1.0in 1.0in 1.0in}
div.x_WordSection1
        {}
-->
</style>
<div lang="EN-US" link="#0563C1" vlink="#954F72" style="background-color:white">
<div class="x_WordSection1">
<p class="x_MsoNormal"><span style="font-size:11.0pt">Hello Everyone,</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt"> </span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt">Please forgive any misunderstandings on my part, as I'm relatively new to this software and the project.</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt"> </span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt">I'm currently working with an installation of ArchivesSpace which has been updated to 2.5.0, and I've encountered a problem in which Event "Outcome" values can be persisted into the database with NULL foreign
 keys:</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt"> </span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt; font-family:"Consolas",sans-serif">[archivesspace]> select count(<a href="http://e.id/" target="_blank">e.id</a>) from event as e where e.outcome_id IS NULL;</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt; font-family:"Consolas",sans-serif">+-------------+</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt; font-family:"Consolas",sans-serif">| count(<a href="http://e.id/" target="_blank">e.id</a>) |</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt; font-family:"Consolas",sans-serif">+-------------+</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt; font-family:"Consolas",sans-serif">|       14324 |</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt; font-family:"Consolas",sans-serif">+-------------+</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt"> </span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt">Is this expected? When these are set as NULL, the corresponding enumeration_value cannot be retrieved for translation in the locale, leading to the following errors:</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt"> </span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt; font-family:"Consolas",sans-serif">translation missing: enumerations.event_outcome.<br>
</span><span style="font-size:11.0pt"><br>
...where the tag following enumerations.event_outcome (normally some value like pass or fail, as found in <a href="https://github.com/archivesspace/archivesspace/blob/v2.5.0/common/locales/enums/en.yml#L442" target="_blank">https://github.com/archivesspace/archivesspace/blob/v2.5.0/common/locales/enums/en.yml#L442</a>)
 is simply blank.<br>
<br>
Is this something which others have encountered before? Might this be an issue which must be addressed with database record cleaning for these NULL foreign keys? Thank you for your time and support.<br>
<br>
Sincerely,<br>
James Griffin</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt"> </span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt">-- </span></p>
<div>
<p class="x_MsoNormal"><span style="font-size:11.0pt">Digital Infrastructure Developer</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt"><a href="https://library.princeton.edu/"><span style="color:#0563C1">Princeton University Library</span></a></span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt">Princeton, NJ 08544</span></p>
</div>
<p class="x_MsoNormal"> </p>
</div>
</div>
</body>
</html>