[Pansophy] Missing sequence number in Excel export

[Valerie Bookwalter]

Not part of User Define Queries.
It sounds like you need a specific report...
Sorry, 2 different areas of data mining.

Valerie

From: Jacob Harris
Sent: Thursday, October 7, 2021 4:25 PM
To: Valerie Bookwalter <bookwalt at jlab.org>; pansophy at jlab.org
Subject: RE: Missing sequence number in Excel export

Related question. What do I select in the user defined query to get the date the traveler was closed?

From: Valerie Bookwalter
Sent: Thursday, October 7, 2021 4:19 PM
To: Jacob Harris <jharris at jlab.org<mailto:jharris at jlab.org>>; pansophy at jlab.org<mailto:pansophy at jlab.org>
Subject: RE: Missing sequence number in Excel export

Yes Jacob, a know core software problem. The Traveler Sequence Number does not get sent to the excel file.
I'm sorry. We are working on getting that fixed.

Thanks for your patience


Valerie Bookwalter
Jefferson Lab, SRF Department
Pansophy Team
1-757-813-6716 (CELL)
1-757-269-5802 (OFFICE - currently working offsite)


From: Pansophy <pansophy-bounces at mailman.jlab.org<mailto:pansophy-bounces at mailman.jlab.org>> On Behalf Of Jacob Harris
Sent: Thursday, October 7, 2021 4:11 PM
To: pansophy at jlab.org<mailto:pansophy at jlab.org>
Subject: [Pansophy] Missing sequence number in Excel export

When I do a user defined query on the HE NCR traveler, it shows the image below. When I select Excel, it creates the files without the first column. What is the field I need to select in the selection screen to get the NCR seq number? Can you make the Seq number automatic in the display and the excel export? Seems like that is essential info for any traveler based query.

[cid:image001.png at 01D7BB98.668BCCA0]

_______________________________________________________________________________
Jacob Harris
SRF Operations Quality Engineer
Jefferson Lab
Newport News, VA 23606
Office: +1 (757) 269-7193
Cell: +1 (334) 345-3248
Email:   jharris at jlab.org<mailto:jharris at jlab.org>

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