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

[Valerie Bookwalter]

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>
Sent: Thursday, November 19, 2020 2:44 PM
To: Valerie Bookwalter <bookwalt at jlab.org>
Cc: Katherine Wilson <kwilson at jlab.org>; Gonnella, Dan A <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/0eb31250/attachment.html>