CDR Tickets

Issue Number 4806
Summary [Glossary] Exclude marked terms from audio spreadsheet
Created 2020-04-02 10:42:28
Issue Type Improvement
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2020-04-29 08:30:16
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.259447
Description

Please modify the Audio Request Spreadsheet to exclude terms that have the attribute "Audio Recording" set to "No".

Comment entered 2020-04-17 12:02:45 by Osei-Poku, William (NIH/NCI) [C]

We agreed to move this ticket from Maxwell into Leibniz yesterday.

Comment entered 2020-04-20 19:03:13 by Kline, Bob (NIH/NCI) [C]

Installed on DEV.

Comment entered 2020-04-28 17:18:34 by Osei-Poku, William (NIH/NCI) [C]

There are several terms with audios on the spreadsheet - examples - 44175 44342, 44388, 44428. I think these are the result of the alternates removed by the global (OCECDR-4685). The alternates have been removed from the spreadsheet (as expected), however, the primary terms still remain on the spreadsheet even though they already have audios. If this is the case, could you please exclude these terms from the spreadsheet?

Comment entered 2020-04-29 08:30:08 by Kline, Bob (NIH/NCI) [C]

Done.

Comment entered 2020-04-29 08:40:51 by Kline, Bob (NIH/NCI) [C]

FYI: The script now creates the spreadsheet in a standard Excel workbook, rather than a file using the legacy format used by older versions of Excel, starting in the 1980s. Downstream processing (review and import) assumes this file format will be retained.

Comment entered 2020-04-29 10:44:31 by Osei-Poku, William (NIH/NCI) [C]

Sounds good.
Verified on DEV. Thanks!

Comment entered 2020-06-15 10:48:02 by Osei-Poku, William (NIH/NCI) [C]

Verified on QA. Thanks!

Elapsed: 0:00:00.001359