CDR Tickets

Issue Number 5228
Summary Global to add demographic information to Spanish Media docs
Created 2023-04-10 16:32:09
Issue Type Task
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2023-04-27 11:45:41
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.343152
Description

This is a global request to add demographic information to Spanish Media docs. A similar one is being done for the English Media docs in this ticket - OCECDR-5184 . The same demographic information from the spreadsheet will be added to the corresponding Spanish media documents using the TranslationOf element to identify the Spanish media docs.

Comment entered 2023-04-27 11:45:41 by Kline, Bob (NIH/NCI) [C]

Run in test mode on DEV.

https://cdr-dev.cancer.gov/cgi-bin/cdr/ShowGlobalChangeTestResults.py?dir=2023-04-27_10-36-50

Comment entered 2023-04-28 14:53:23 by Osei-Poku, William (NIH/NCI) [C]

  1. I am not able to determine why CDR0000466540 is not included in the test run.

  2. There was one error  - CDR0000805517  "Element 'MinWidthPixels': '' is not a valid value of the atomic type 'xs:integer'."  I assume this error is in the spreadsheet. If that is the case, I would like to fix it before the live run.

Comment entered 2023-04-28 16:07:10 by Kline, Bob (NIH/NCI) [C]

  1. Two different documents claim to be the translation of CDR435997, so the lookup table constructed by the software from the query_term table used the other one

  2. There are no MinWidthPixels values in the spreadsheet (this is about demographics, not image dimensions). The error message means what it says: the document has an empty string where an integer is required in the MinWidthPixels element.

Comment entered 2023-04-28 16:15:54 by Kline, Bob (NIH/NCI) [C]

By the way: this ticket says "Targeted Release: Pauling" but that's wrong. This ticket was created after the set of tickets in Pauling was finalized and well after User Acceptance Testing had begun.

Comment entered 2023-05-02 11:33:54 by Osei-Poku, William (NIH/NCI) [C]

Thanks for the response. Please run in live mode on DEV.

Comment entered 2023-05-02 15:05:20 by Kline, Bob (NIH/NCI) [C]

What are your plans for dealing with the problem of multiple Spanish documents claiming to be THE translation of the same English document?

Comment entered 2023-05-02 15:48:38 by Osei-Poku, William (NIH/NCI) [C]

It was removed from one of the documents on all tiers before asking to run in live mode. The other error has also been fixed. That was only on DEV.

Comment entered 2023-05-02 16:29:05 by Kline, Bob (NIH/NCI) [C]

Live mode completed on DEV.

Comment entered 2023-05-23 13:45:50 by Osei-Poku, William (NIH/NCI) [C]

Please run in test mode on QA. Thanks!

Comment entered 2023-05-24 07:44:05 by Kline, Bob (NIH/NCI) [C]

https://cdr-qa.cancer.gov/cgi-bin/cdr/ShowGlobalChangeTestResults.py?dir=2023-05-24_07-35-16

Comment entered 2023-05-25 15:13:01 by Osei-Poku, William (NIH/NCI) [C]

Please run in live mode on QA. Thanks!

Comment entered 2023-05-25 16:05:12 by Kline, Bob (NIH/NCI) [C]

Live mode on QA completed successfully.

Comment entered 2023-05-30 12:48:37 by Osei-Poku, William (NIH/NCI) [C]

Verified on QA. Please run in test mode on PROD. Thanks!

Comment entered 2023-05-30 13:49:38 by Kline, Bob (NIH/NCI) [C]

https://cdr-dev.cancer.gov/cgi-bin/cdr/ShowGlobalChangeTestResults.py?dir=2023-05-30_13-13-57

Comment entered 2023-05-31 18:28:50 by Osei-Poku, William (NIH/NCI) [C]

Please run in live mode on PROD. Thanks!

Comment entered 2023-06-01 08:34:24 by Kline, Bob (NIH/NCI) [C]

Live mode on PROD completed.

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

Verified on PROD. Thanks!

Elapsed: 0:00:00.001346