[Pansophy] Pansophy query questions [From James Maniscalco at SLAC]

[Jacob Harris]

All,

I have not seen or heard of this person's name in any SLAC HE meetings. It is concerning that he could have been granted a JLab account (which then grants full Pansophy access) from any number of people, regardless of their role in the HE project or in SRF Ops. This situation brings up two issues.

First. Pansophy is fully accessible to anyone with a JLab account. I understand Valarie is working to add an additional layer of Pansophy authorization, but currently there is a very large group of people on site and from other labs that can view, add, modify, and delete Pansophy data. While these changes to data create a record in the system, we are not set up to monitor or be alerted when people make changes. It is a risk that persons untrained in Pansophy might inadvertently modify or delete data without our knowledge.

Second. Full access to Pansophy allows someone to see data before it is fully vetted for an intended audience. Data included in presentations and summary reports can be explained and qualified as needed. Real-time access to raw data does not offer SRF the opportunity to contextualize the data. It is a risk for preliminary data to be distributed and used to make unsupported conclusions.

As an alternative approach, we should only grant full access to people in JLab with a need to edit data. Everyone else should be an 'external user' and should only be granted to a read-only reporting section of Pansophy where they can view limited summary graphs/tables for certain projects. Additional information can be requested and then shared by the appropriate people at SRF, e.g. CMTF test results shared by Mike during regular meetings with SLAC counterparts. This preserves the spirit of cooperation and transparency within the DOE Partner Lab environment, while also allowing SRF to protect our data integrity and contextualize any conclusions drawn from the data.

My 2 or 3 cents.

Jacob

From: Valerie Bookwalter <bookwalt at jlab.org>
Sent: Thursday, November 19, 2020 3:48 PM
To: Tony Reilly <areilly at jlab.org>; E. Anne McEwen <mcewen at jlab.org>; Jacob Harris <jharris at jlab.org>
Cc: SRF Pansophy (pansophy at jlab.org) <pansophy at jlab.org>
Subject: Fw: Pansophy query questions [From James Maniscalco at SLAC]
Importance: High

FYI... SLAC LCLS-II HE is already learning how to datamine and retrieve raw data from Pansophy. Is this okay?

Valerie
Pansophy Team

________________________________
From: Maniscalco, James <jamesm at slac.stanford.edu<mailto:jamesm at slac.stanford.edu>>
Sent: Thursday, November 19, 2020 2:44 PM
To: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>
Cc: Katherine Wilson <kwilson at jlab.org<mailto:kwilson at jlab.org>>; Gonnella, Dan A <gonnella at slac.stanford.edu<mailto:gonnella at slac.stanford.edu>>
Subject: [EXTERNAL] Pansophy query questions


Greetings Valerie,



I work on the LCLS-II-HE project at SLAC and I will be handling SLAC's database of cavity test results. I would like to be able to pull in data from Pansophy in batches. After looking around I am getting familiar with Pansophy, browsing the L2PRD travelers directly and playing with datamine queries, but I do have a few questions:



1)      Is there a way to save queries so that I can come back and quickly generate reports in the same format?

2)      When performing datamine queries, is there a way to automatically retrieve files that have been attached to the travelers? In particular I am thinking of the RF_TEST_RAW_DATA on the L2PRD traveler (or its equivalent on the L2HE travelers once cavity production is underway). Do I need to go into each traveler individually to get these files?

3)      Is there a better way to retrieve the exported report excel files/pdfs than by emailing to myself? Right now I use PuTTY + Windows RDP to connect to jlabts, then use a web browser to access Pansophy and generate the reports, then email the files to myself via my web mail client. I don't know if there is a faster or more direct way from off-site. Can SLAC employees get access through the JLab VPN?



Thanks for your help!



Best wishes,

James



---------------------------------------------------------------

James Maniscalco

SRF Engineer

LCLS-II HE Project

SLAC National Accelerator Laboratory

Bldg. 52, Rm. 233-B

Office: (650) 926-2157

Cell: (973) 518-0393


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20201119/63293ce2/attachment-0001.html>