<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<span>I think we are at 80% complete. <br>
</span>
<div><br>
</div>
<div>Mostly it is the SQL changes for the datamining and primes areas. Mike is working on a solution that is almost ready. At that time we will be able to apply the solution to the remaining datamining pages and complete the PRIMeS area.<br>
</div>
<div><br>
</div>
<div>The problem is the new ColdFusion server is translating our use of the Oracle notation of (+) for INNER/OUTER JOINS of tables. This is used for many of our complicated database queries. He reached out to the ColdFusion community but no one has been able
to offer advice on how to correct or why ColdFusion is interpretting the notation incorrectly.<br>
</div>
<div><br>
</div>
<div>I think most everything else is done with minor exceptions:<br>
</div>
<div>email<br>
</div>
<div>export to PDF and EXCEL<br>
</div>
<div>FileUpload<br>
</div>
<div><br>
</div>
<div>One Note: The export feature we utilize is outdated and we are looking for a resolution. This would not stop us going to the new server but would render exports to PDF and Excel unusable until we do find a solution.<br>
</div>
<div><br>
</div>
<div>DataMine Areas (need SQL fix):<br>
</div>
<div>Queries -> Cavity Performance<br>
</div>
<div>D3 Reports -> D3s (OP/CL)<br>
</div>
<div>NCR Reports -> NCRs (OP/CL)<br>
</div>
<div>NCR Reports -> NCRs BY ENGR<br>
</div>
<div>Traveler Reports -> TRAVELERs (OP/CL)<br>
</div>
<div>Traveler Reports -> TRAVELER WEEKLY REPORT<br>
</div>
<div>Traveler Reports -> TRAVELER WEEKLY OWNER<br>
</div>
<div><br>
</div>
<div>
<div style="box-sizing: border-box; font-family: "Segoe UI", system-ui, "Apple Color Emoji", "Segoe UI Emoji", sans-serif; font-size: 14px; orphans: 2; widows: 2">
<div>We are making good progress, albeit a little slow. Finding resolutions to very old versions of code can be trying.</div>
<div>Thank You for your patience and support.</div>
<div> </div>
<div>Valerie</div>
</div>
</div>
<div><br>
</div>
<div><span></span><img size="15807" contenttype="image/png" style="max-width: 100%; -moz-user-select: none;" unselectable="on" tabindex="-1" data-outlook-trace="F:1|T:1" src="cid:0eba9a31-76f2-48bd-a503-502efa913c02"></div>
<div><br>
</div>
<div><br>
</div>
</body>
</html>