CDR Tickets

Issue Number 4134
Summary Audio Request Spreadsheet - Modify script to send file in a link to user
Created 2016-07-19 13:51:38
Issue Type New Feature
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2016-12-08 16:20:40
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.190652
Description

Last week (7/13/16), while running the "Audio Request Spreadsheet" report to retrieve the spreadsheet, the Excel file was successfully generated but IE crashed and the file was not automatically saved on the local computer (download folder). So, I was not able to save the file before it disappeared.
Using an ad hoc query, I was able to re-create the file. Going forward however, it would be helpful to be able to either run the report again to generate the missing file, or if possible, whenever the files are generated successfully copies should be stored on the server for easy retrieval in cases when they fail to save on the local computer.

Comment entered 2016-08-18 12:01:42 by Osei-Poku, William (NIH/NCI) [C]

Modified title to correctly reflect what going to change.

Comment entered 2016-11-01 15:27:33 by Kline, Bob (NIH/NCI) [C]

We'll need to do this as part of the next release, since deployment involves CBIIT.

Comment entered 2016-12-08 16:20:40 by Kline, Bob (NIH/NCI) [C]

Ready for user testing on DEV.

Comment entered 2016-12-14 14:30:00 by Osei-Poku, William (NIH/NCI) [C]

Verified this on DEV. I am able to get a copy of the spreadsheet after running the report. I have a two of questions.

1. In case my browser crashes, how do I access the stored copy?
2. I was able to run the report but no documents were picked up even though there are at least 3 documents that should have been picked up.

Comment entered 2016-12-14 16:12:39 by Kline, Bob (NIH/NCI) [C]

  1. Your browser is very unlikely to crash between the time the spreadsheet is successfully stored and the URL is sent to your browser (much less likely than when the whole workbook was being sent to your browser), but if that ever happens, let us know when it did and we'll get you the URL.

  2. Which three documents should have been picked up?

Comment entered 2016-12-14 16:21:38 by Osei-Poku, William (NIH/NCI) [C]

Here are the three documents.
CDR0000779347
CDR0000779351
CDR0000779349

Comment entered 2016-12-14 16:30:44 by Kline, Bob (NIH/NCI) [C]

None of those are in the pub_proc_cg table, so they're not picked up.

Comment entered 2016-12-14 17:37:07 by Osei-Poku, William (NIH/NCI) [C]

pub_proc_cg contains documents that have been published to Cancer.gov, right?

Comment entered 2016-12-14 17:43:08 by Kline, Bob (NIH/NCI) [C]

Right. That's a requirement for being picked up for the spreadsheet.

Comment entered 2016-12-14 18:19:07 by Osei-Poku, William (NIH/NCI) [C]

Okay. Thanks!

Comment entered 2017-01-10 19:33:28 by Osei-Poku, William (NIH/NCI) [C]

Verified on QA.

Elapsed: 0:00:00.001331