[Pansophy] Datamine Reports NCR (Op/Cl)

[Mike Dickey]

Hi Tiffany,

Sorry, I was out yesterday.

I figured out how to get a data dump from the report (attached).  I'm still working of figuring out a fix for the report, which is proving to be much more involved than I thought it would be.

I'll let you know once I have the problem corrected.

Mike Dickey
SRF Inventory Technician
Jefferson Lab
12000 Jefferson Ave
Newport News, VA 23606
(757) 269-7755

From: Tiffany Ganey <ganey at jlab.org>
Sent: Tuesday, August 24, 2021 8:28 AM
To: Mike Dickey <mdickey at jlab.org>
Cc: pansophy at jlab.org
Subject: RE: Datamine Reports NCR (Op/Cl)

Good morning Mike,

I tried to export the C100R NCR report to excel this morning.  Although I didn't get an error message, it also didn't open the file in excel.  When I clicked the Excel button, the screen "flickered" but no popup box or window opened.  I tried the export to PDF button, which did work ok, but I would prefer to use the report in excel.

Tiffany Ganey

From: Mike Dickey <mdickey at jlab.org<mailto:mdickey at jlab.org>>
Sent: Thursday, August 19, 2021 3:58 PM
To: Tiffany Ganey <ganey at jlab.org<mailto:ganey at jlab.org>>; pansophy at jlab.org<mailto:pansophy at jlab.org>
Subject: RE: Datamine Reports NCR (Op/Cl)

Hi Tiffany,

I found that this problem is affecting 4 pages.

Travelers (O/C) - Fixed
NCRs (O/C) - Still working on it
D3s (O/C) - Fixed
NCRs by ENGR - Still working on it

I will continue working on this in the morning.

Sorry for the inconvience.

Mike Dickey
SRF Inventory Technician
Jefferson Lab
12000 Jefferson Ave
Newport News, VA 23606
(757) 269-7755

From: Mike Dickey
Sent: Thursday, August 19, 2021 1:42 PM
To: Tiffany Ganey <ganey at jlab.org<mailto:ganey at jlab.org>>; pansophy at jlab.org<mailto:pansophy at jlab.org>
Subject: RE: Datamine Reports NCR (Op/Cl)

Hi Tiffany,

I'll have a look, but it could take a bit.

Mike Dickey
SRF Inventory Technician
Jefferson Lab
12000 Jefferson Ave
Newport News, VA 23606
(757) 269-7755

From: Pansophy <pansophy-bounces at mailman.jlab.org<mailto:pansophy-bounces at mailman.jlab.org>> On Behalf Of Tiffany Ganey
Sent: Thursday, August 19, 2021 1:35 PM
To: pansophy at jlab.org<mailto:pansophy at jlab.org>
Subject: [Pansophy] Datamine Reports NCR (Op/Cl)

Hello,

I'm trying to export the Datamine >> Reports >> NCR Reports >> NCRs (Op/Cl) report for C100R to excel; however, I get an error message when I click the Excel button.


Thanks,

Tiffany Ganey

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20210825/e7592326/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: C100R NCR Report 25-Aug-2021.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 20906 bytes
Desc: C100R NCR Report 25-Aug-2021.xlsx
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20210825/e7592326/attachment-0001.xlsx>