CDR Tickets

Issue Number 4814
Summary [Glossary] Acronyms to exclude from audio spreadsheet
Created 2020-04-16 20:34:18
Issue Type New Feature
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2020-04-30 10:17:34
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.260410
Description

This is related to the global request in OCECDR-4685. We have identified a set of glossary terms that are acronyms and for which no audios would be recorded for them. However, there is currently no way to mark them in the CDR as acronyms so that the global request in OCECDR-4685 could have been applied to them. I am attaching a spreadsheet of the terms (1,852) to this ticket to see if it can be used to run a "global" to mark them with an attribute of

AudioRecording = "No".

Comment entered 2020-04-30 10:17:34 by Kline, Bob (NIH/NCI) [C]

Test run results are available for review on DEV.

Comment entered 2020-04-30 11:13:10 by Osei-Poku, William (NIH/NCI) [C]

I found this one CDR0000446539 which looks like nothing happened to it. It is the very last one on the test results. The others I looked appear to be good.

Comment entered 2020-04-30 11:39:33 by Kline, Bob (NIH/NCI) [C]

It's last because the results are sorted (by default) on the length of the difference between old and new (biggest differences at the top). As for the nothing which happened to it, there wasn't anything to do. Here's what's on the spreadsheet:

and here's what's in the document:

If you look closely, you'll notice that "SNP" is the English TermNameString value (Spanish is "PSN").

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

Okay. Thanks! Please run it in live mode on DEV.

Comment entered 2020-04-30 14:46:26 by Kline, Bob (NIH/NCI) [C]

Live run complete on DEV.

Comment entered 2020-05-07 10:42:54 by Osei-Poku, William (NIH/NCI) [C]

Verified on DEV. Thanks!

Comment entered 2020-05-14 13:50:12 by Kline, Bob (NIH/NCI) [C]

This has been run in test mode on QA. Ready for review.

Comment entered 2020-05-28 13:07:38 by Osei-Poku, William (NIH/NCI) [C]

Test run on QA looks good. With the impending QA refresh OCECDR-4829, we should probably wait to run this in live mode after that.

Comment entered 2020-05-29 15:11:29 by Kline, Bob (NIH/NCI) [C]

Both the refresh and the live global job have been done on QA.

Comment entered 2020-06-25 14:57:35 by Osei-Poku, William (NIH/NCI) [C]

Please run the global in test mode on PROD. Thanks!

Comment entered 2020-06-25 17:49:25 by Kline, Bob (NIH/NCI) [C]

Done. The files are on the DEV server because I can't log into the production server and run it there directly, so I have to run it on one of the lower tiers and point the script at the correct upper tier. The documents are from PROD.

 

https://cdr-dev.cancer.gov/cgi-bin/cdr/ShowGlobalChangeTestResults.py?dir=2020-06-25_15-16-36&Session=guest

Comment entered 2020-06-25 18:14:51 by Osei-Poku, William (NIH/NCI) [C]

Looks good. Please run in live mode on PROD. Thanks!

Comment entered 2020-06-26 18:38:09 by Kline, Bob (NIH/NCI) [C]

Done.

Comment entered 2020-06-29 13:40:19 by Osei-Poku, William (NIH/NCI) [C]

Verified. Thanks!

Attachments
File Name Posted User
Audio Exclusion Term List_12-19-19.xls 2020-04-16 20:34:37 Osei-Poku, William (NIH/NCI) [C]
image-2020-04-30-11-37-06-552.png 2020-04-30 11:37:07 Kline, Bob (NIH/NCI) [C]
image-2020-04-30-11-37-40-834.png 2020-04-30 11:37:41 Kline, Bob (NIH/NCI) [C]

Elapsed: 0:00:00.001694