<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 16pt; color: rgb(0, 0, 0);">
FYI... SLAC LCLS-II HE is already learning how to datamine and retrieve raw data from Pansophy. Is this okay?</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 16pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 16pt; color: rgb(0, 0, 0);">
Valerie </div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 16pt; color: rgb(0, 0, 0);">
Pansophy Team</div>
<div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 16pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="appendonsend"></div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> Maniscalco, James <jamesm@slac.stanford.edu><br>
<b>Sent:</b> Thursday, November 19, 2020 2:44 PM<br>
<b>To:</b> Valerie Bookwalter <bookwalt@jlab.org><br>
<b>Cc:</b> Katherine Wilson <kwilson@jlab.org>; Gonnella, Dan A <gonnella@slac.stanford.edu><br>
<b>Subject:</b> [EXTERNAL] Pansophy query questions</font>
<div> </div>
</div>
<div lang="EN-US">
<div class="x_WordSection1">
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
Greetings Valerie,</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
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:</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
</p>
<p class="x_MsoListParagraph" style="margin: 0in 0in 0.0001pt 0.5in; font-size: 11pt; font-family: Calibri, sans-serif;text-indent:-.25in; mso-list:l0 level1 lfo1">
<span style="mso-list:Ignore">1)<span style="font:7.0pt "Times New Roman""> </span>
</span>Is there a way to save queries so that I can come back and quickly generate reports in the same format?</p>
<p class="x_MsoListParagraph" style="margin: 0in 0in 0.0001pt 0.5in; font-size: 11pt; font-family: Calibri, sans-serif;text-indent:-.25in; mso-list:l0 level1 lfo1">
<span style="mso-list:Ignore">2)<span style="font:7.0pt "Times New Roman""> </span>
</span>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?</p>
<p class="x_MsoListParagraph" style="margin: 0in 0in 0.0001pt 0.5in; font-size: 11pt; font-family: Calibri, sans-serif;text-indent:-.25in; mso-list:l0 level1 lfo1">
<span style="mso-list:Ignore">3)<span style="font:7.0pt "Times New Roman""> </span>
</span>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?</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
Thanks for your help!</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
Best wishes,</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
James</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
---------------------------------------------------------------</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
James Maniscalco</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
SRF Engineer</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
LCLS-II HE Project</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
SLAC National Accelerator Laboratory</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
Bldg. 52, Rm. 233-B</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
Office: (650) 926-2157</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
Cell: (973) 518-0393</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
</p>
</div>
</div>
</div>
</body>
</html>