[Pansophy] PTeam Weekly Status Report (10Apr2020)

[E. Anne McEwen]

Thanks Valerie !
I hope you have a great weekend

Anne

From: Valerie Bookwalter <bookwalt at jlab.org>
Sent: Friday, April 10, 2020 3:11 PM
To: E. Anne McEwen <mcewen at jlab.org>
Cc: Tony Reilly <areilly at jlab.org>; Jacob Harris <jharris at jlab.org>; pansophy <pansophy at jlab.org>; Liang Zhao <lzhao at jlab.org>; George DeKerlegand <georged at jlab.org>
Subject: PTeam Weekly Status Report (10Apr2020)

I think we are at 80% complete.

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.

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.

I think most everything else is done with minor exceptions:
email
export to PDF and EXCEL
FileUpload

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.

DataMine Areas (need SQL fix):
Queries -> Cavity Performance
D3 Reports -> D3s (OP/CL)
NCR Reports -> NCRs (OP/CL)
NCR Reports -> NCRs BY ENGR
Traveler Reports -> TRAVELERs (OP/CL)
Traveler Reports -> TRAVELER WEEKLY REPORT
Traveler Reports -> TRAVELER WEEKLY OWNER

We are making good progress, albeit a little slow. Finding resolutions to very old versions of code can be trying.
Thank You for your patience and support.

Valerie

[cid:image001.png at 01D60F4B.A3669060]


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20200410/ab3db050/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 15807 bytes
Desc: image001.png
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20200410/ab3db050/attachment-0001.png>