CDR Tickets

Issue Number 3824
Summary Filter changes for new Spanish CAM summaries
Created 2014-11-05 17:11:36
Issue Type New Feature
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Englisch, Volker (NIH/NCI) [C]
Status Closed
Resolved 2014-11-18 14:56:03
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.141229
Description

I am posting below, email conversation I had with Volker with regards to possible filter changes for new Spanish CAM Patient and HP summaries:

.................
Hi William,

• Medicina complementaria y alternativa, CDR 766007 (About PDQ CAM CDR 445621)- NEW Misc. doc

Currently there doesn't exist a ‘About PDQ CAM’ misc doc, so this requires a filter change.

• Preguntas para su proveedor de atención de la salud sobre medicina complementaria y alternativa, CDR 766008 (Questions to ask your health care provider about CAM, CDR 445622)-NEW Misc. Doc.

Currently, the EN version uses CDR445622 while the ES version uses CDR446986. If you need to use a different document ID this does require a filter change.

• Información adicional, CDR 446984 (To Learn More, CDR 445623) – EXISTING Misc. Doc, extensively revised

There is no filter change necessary when the same document is being used unless the document structure changes.

Thanks,

Volker
___________________________________
Volker Englisch
NCI OCPL – Office of Communications & Public Liaison
Contractor: Sapient Government Services
NCI: 240-276-6583

From: Osei-Poku, William William.Osei-Poku@icfi.com
Sent: Wednesday, November 05, 2014 10:09 AM
To: Englisch, Volker (NIH/NCI) [C]
Subject: RE: Spanish CAM summaries

From what I understand, that is what I understand. I will create a Jira ticket soon so that you can take a look. I just wanted to be sure you need to make a filter change before creating the issue.
Thanks,
William

From: Englisch, Volker (NIH/NCI) [C] volker@mail.nih.gov
Sent: Wednesday, November 05, 2014 10:05 AM
To: Osei-Poku, William
Subject: RE: Spanish CAM summaries

I’m not sure why I would need to change a filter but if I do such a change needs to be submitted as a JIRA ticket.

Is this the first time we’re translating CAM summaries?

Thanks,

Volker
___________________________________
Volker Englisch
NCI OCPL – Office of Communications & Public Liaison
Contractor: Sapient Government Services
NCI: 240-276-6583

From: Osei-Poku, William William.Osei-Poku@icfi.com
Sent: Tuesday, November 04, 2014 5:22 PM
To: Englisch, Volker (NIH/NCI) [C]
Subject: Spanish CAM summaries

Hi Volker,
Linda is about to publish a couple of CAM HP and Patient summaries. This appears to be the first time she doing this, so I assume that you need to make changes to the filters to use new Misc. docs that she has created, right? Here are the two new Misc. docs and an existing one that has been revised.

• Medicina complementaria y alternativa, CDR 766007 (About PDQ CAM CDR 445621)- NEW Misc. doc
• Preguntas para su proveedor de atención de la salud sobre medicina complementaria y alternativa, CDR 766008 (Questions to ask your health care provider about CAM, CDR 445622)-NEW Misc. Doc.
• Información adicional, CDR 446984 (To Learn More, CDR 445623) – EXISTING Misc. Doc, extensively revised

Also, in one of the Misc. docs, it doesn’t have a DocType for Spanish summaries so I assume, I need to put in a ticket so that Bob can add it in, right?
Thanks,
William

Comment entered 2014-11-06 17:49:39 by Englisch, Volker (NIH/NCI) [C]

Do we have these new misc. documents available on DEV, QA, and STAGE?

For the documents that are new we'll have to remember to change the document CDR-ID that is hard coded for the documents before we move the filters to PROD. The CDR-IDs for these documents will not be the same on different tiers.

Comment entered 2014-11-07 11:51:01 by Osei-Poku, William (NIH/NCI) [C]

Do we have these new
misc. documents
available on DEV, QA,
and STAGE?

We currently have them on PROD. We will copy the changes to the lower tiers for testing.

Comment entered 2014-11-10 12:46:19 by Osei-Poku, William (NIH/NCI) [C]

The following Misc. Docs have been created/updated on DEV for testing:

759356 About CAM – New Misc. doc
759355 Questions to ask your health care provider – New Misc. doc
446985 To Learn More about CAM – Comprehensively revised

Comment entered 2014-11-13 17:25:57 by Englisch, Volker (NIH/NCI) [C]

On PROD:
Why are we creating a new document (CDR766008) rather than using/updating the existing one (CDR446986)?

Comment entered 2014-11-13 17:32:50 by Englisch, Volker (NIH/NCI) [C]

446985 To Learn More about CAM – Comprehensively revised

Did you mean CDR446985? The CDR-ID for this document on PROD is CDR446984.
On DEV I actually see two different documents for To Learn More about CAM, one with CDR446984 and one with CDR446985. The filter is currently using CDR446984.

Comment entered 2014-11-13 17:37:33 by Osei-Poku, William (NIH/NCI) [C]

On PROD: Why are we creating a new document (CDR766008) rather than using/updating the existing one (CDR446986)?

Since there is an existing document, let's use that one instead of the new one. Sorry!

Did you mean CDR446985? The CDR-ID for this document on PROD is CDR446984.
On DEV I actually see two different documents for To Learn More about CAM, one with CDR446984 and one with CDR446985. The filter is currently using CDR446984.

Please use CDR446984. We'll update it accordingly. Thanks!

Comment entered 2014-11-17 13:37:11 by Englisch, Volker (NIH/NCI) [C]

William, I'm confused. I'm trying to test the changes and I'm looking for a test document. I'm looking at two patient CAM summaries but those have completely different misc. sections added.
The sections after the Changes to This Summary section for Pain are:

  • About This PDQ Summary

  • Questions or Comments About This Summary

  • Get More information from NCI

The sections after the Changes to This Summary section for Acupuncture are:

  • About this PDQ Summary

  • General CAM Information

  • Questions to Ask your Health Care Provider about CAM

  • To Learn More about CAM

These later sections are the sections I can find in the misc. documents.

What summaries could I use to test with?

Comment entered 2014-11-17 13:40:07 by Osei-Poku, William (NIH/NCI) [C]

What summaries could I use to test with?

You may use CDR0000759366 and CDR0000759367 on DEV

Comment entered 2014-11-17 18:05:05 by Englisch, Volker (NIH/NCI) [C]

I'm unable to run the vendor filter for these documents because the links to the document 765469 (pregunta 1-9) don't exist.
Which document should these links point to?

Comment entered 2014-11-18 08:42:31 by Osei-Poku, William (NIH/NCI) [C]

The link problem has been fixed. Please try again.

Comment entered 2014-11-18 14:55:42 by Englisch, Volker (NIH/NCI) [C]

I have updated the filter but I'm not very confident on testing this for several reasons:
a) I don't know Spanish
b) I don't know which of the CAM summaries should receive which of the misc. docs
c) I'm not sure if all of the misc. docs on DEV have already been updated.

Please check out the result and let me know if I missed anything.

You will note that the HTML returned using PublishPreview already follows the new WCMS release which is a little different from that you will see on PROD.

Comment entered 2014-11-19 16:15:14 by Osei-Poku, William (NIH/NCI) [C]

Here are Linda's findings. I think the issue with the HP summary is because we are currently testing on DEV. Once we move to Production or the Summary is published, it should be fine:

Patient summary

The text under the Información sobre este sumario title (About This PDQ Summary) is missing.

HP Summary:

Información sobre este sumario (About this PDQ Summary) section at the end of the summary.

The text under Reviewer and Updates in this section, the link to the PDQ Cancer Complementary and Alternative Medicine Editorial Board page is not showing. This link should go to a page we translated and Mauricio was going to get created.

Comment entered 2014-11-20 16:33:03 by Englisch, Volker (NIH/NCI) [C]

Which summary did Linda review? Was it the Spanish Acupuncture summary?

Comment entered 2014-11-20 19:44:22 by Osei-Poku, William (NIH/NCI) [C]

She reviewed two summaries CDR0000759366 (Patient) and CDR0000759367 (HP).

Comment entered 2014-11-21 14:36:21 by Englisch, Volker (NIH/NCI) [C]

Patient summary
The text under the Información sobre este sumario title (About This PDQ Summary) is missing.

You're saying the text is missing. However, the misc. doc is listed with an audience of HP. Is the problem that the text is missing or that the section is displayed at all?

For my information: The document included is CDR684064 (Información sobre este sumario del PDQ).

Comment entered 2014-11-21 14:51:47 by Englisch, Volker (NIH/NCI) [C]

I think the issue with the HP summary is because we are currently testing on DEV.

I don't think that's the problem.
The HP version is attaching the content of CDR684064 and this file appears to be identical on both, DEV and PROD.
What's the CDR-ID of the document that Linda has updated on PROD?

The titles of the misc. documents are all very similar that's why I rather refer to CDR-IDs for these and having the titles in Spanish doesn't make it easier. :-)

Comment entered 2014-11-21 15:01:18 by Osei-Poku, William (NIH/NCI) [C]

You're saying the text is missing. However, the misc. doc is listed with an audience of HP. Is the problem that the text is missing or that the section is displayed at all?

Below is Linda's response. Also, she said the Misc doc for the Patient summary is CDR0000751604.


I checked the Misc. doc for the patient summaries, Información sobre este sumario del PDQ, CDR id 751604, and it contains all the text.

When I checked the Acupuntura patient summary in Pub Prev, only the title is showing.

It shows like this:

Información sobre este sumario del PDQ
Información general sobre medicina complementaria y alternativa
There should be text after the first title.

Thank you,
Linda

Comment entered 2014-11-21 15:43:34 by Osei-Poku, William (NIH/NCI) [C]

The HP version is attaching the content of CDR684064 and this file appears to be identical on both, DEV and PROD.
What's the CDR-ID of the document that Linda has updated on PROD?

765468 That is the CDR ID of the HP on PROD.

Currently The BoardNamelink to the PDQ CAM board page, BoardName and the LOElink to the Levels of Spanish summary are not showing on DEV.

Comment entered 2014-11-22 23:03:29 by Englisch, Volker (NIH/NCI) [C]

I'm just wondering why the type of the summary sections are different for HP and patient.
The HP version (CDR684064) has a type of For more information - Health professional summary while the patient version (CDR751604) has a type of Get more information from NCI - Patient summary.
Shouldn't the type be the same?

Comment entered 2014-11-22 23:17:54 by Englisch, Volker (NIH/NCI) [C]

765468 That is the CDR ID of the HP on PROD.

Sorry, I don't need the CDR-ID of the summaries. I'm only interested in the misc. documents at this point because I have the feeling Linda may have updated the wrong document.
You're saying the summary is CDR765468. This is a HP summary. The file that Linda updated is CDR751604. This document is marked for patient audience. That's probably the reason why the section is empty. A misc. doc for patients will never be attached to an HP summary.

Let me double-check these documents again on Monday for the CDR-IDs on DEV.

Comment entered 2014-11-24 07:41:41 by Osei-Poku, William (NIH/NCI) [C]

I'm just wondering why the type of the summary sections are different for HP and patient.
The HP version (CDR684064) has a type of For more information - Health professional summary while the patient version (CDR751604) has a type of Get more information from NCI - Patient summary.
Shouldn't the type be the same?

Response from Linda:
I am not sure. I went to the English patient and HP versions and the doc. types are the same as the Spanish.
I don't know who decided on the document types. Judy may know but she is on vacation.

Comment entered 2014-11-24 07:48:54 by Osei-Poku, William (NIH/NCI) [C]

I'm only interested in the misc. documents at this point because I have the feeling Linda may have updated the wrong document.

This is the misc doc for Patient summaries -751604. It is an existing Misc. Doc that she didn't need to update.

Comment entered 2014-11-24 08:04:21 by Osei-Poku, William (NIH/NCI) [C]

I have attached a screenshot from DEV displaying the portion of the summary with missing misc. doc information. Basically, the misc doc info. isn't showing at all under the highlighted section.

Comment entered 2014-11-24 17:46:42 by Englisch, Volker (NIH/NCI) [C]

I have attached a screenshot from DEV displaying the portion of the summary with missing misc. doc information.

I really don't know what the problem was but the problem of the missing section seems to be working now.
Maybe I had forgotten to save the latest changes in the CDR and you were still running an older version of the filter.

Comment entered 2014-11-24 18:55:58 by Englisch, Volker (NIH/NCI) [C]

The text under Reviewer and Updates in this section, the link to the PDQ Cancer Complementary and Alternative Medicine Editorial Board page is not showing. This link should go to a page we translated and Mauricio was going to get created.

The link depends on the existence of a board but a board doesn't exist for Spanish summaries. The board name is also missing in the section Grados de comprobación científica.
What should be displayed for the board name and what is the URL for the BoardNameLink to be created?

Comment entered 2014-11-25 12:34:13 by Osei-Poku, William (NIH/NCI) [C]

What should be displayed for the board name ?

The board should be the "PDQ Complementary and Alternative Medicine Editorial Board"

and what is the URL for the BoardNameLink to be created?

Here is the URL http://www.cancer.gov/cancertopics/pdq/cancer-cam-board

Comment entered 2014-11-25 12:38:28 by Englisch, Volker (NIH/NCI) [C]

It appears that the filter is picking up the board name translation content from the board's organization document. Even if you enter the name in English the information should come from the BoardNameTranslation element.

Comment entered 2014-11-25 12:45:01 by Osei-Poku, William (NIH/NCI) [C]

Should it be okay now or we need to enter the name in the Translation element ?

Comment entered 2014-11-25 12:53:23 by Englisch, Volker (NIH/NCI) [C]

The translation element doesn't exist currently for the CAM board. That's why the link and the board name are not displayed.
Let me know if you want me to make the change on DEV but you will have to do in on PROD for the filter changes to work correctly.

Comment entered 2014-11-25 14:41:09 by Englisch, Volker (NIH/NCI) [C]

Here is the URL http://www.cancer.gov/cancertopics/pdq/cancer-cam-board

Shouldn't the URL contain an espanol in there somewhere? I thought it should be

http://www.cancer.gov/espanol/pdq/cancer-cam-board
Comment entered 2014-11-25 15:00:12 by Englisch, Volker (NIH/NCI) [C]

I've added the translated board name (some test string) and it looks to me that all the information is now showing up on the PP report.
Please take another look and let me know if the URL to the CAM board page needs to be modified.

Comment entered 2014-11-25 15:45:45 by Osei-Poku, William (NIH/NCI) [C]

Looks like the URL should rather be:
www.cancer.gov/espanol/pdq/medicina-complementaria-alternativa-consejo-editorial

Comment entered 2014-11-25 15:57:33 by Englisch, Volker (NIH/NCI) [C]

The URL has been updated on DEV.

Comment entered 2014-12-02 12:46:38 by Osei-Poku, William (NIH/NCI) [C]

The URL appears to be working well. Could you make the anchor/link text "Consejo Editorial del PDQ® de Medicina Complementaria y Alternativa" ?

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

For the HP summary, the link to the level of evidence summary (759385) is not being created. I have attached a screenshot of HP summary 759367 showing where the link should go. The anchor/link text is "sistema formal de jerarquización de la medicina factual" as highlighted in the attached screenshot.

Comment entered 2014-12-04 07:34:45 by Osei-Poku, William (NIH/NCI) [C]

Increased the priority.

Comment entered 2014-12-05 14:44:34 by Englisch, Volker (NIH/NCI) [C]

Could you make the anchor/link text "Consejo Editorial del PDQ® de Medicina Complementaria y Alternativa"?

The text displayed is controlled via the element BoardNameTranslation in the board's organization document.

For the HP summary, the link to the level of evidence summary (759385) is not being created.

The missing link has been fixed.

This is ready for review on DEV.

Comment entered 2014-12-05 15:38:11 by Osei-Poku, William (NIH/NCI) [C]

The text displayed is controlled via the element BoardNameTranslation in the board's organization document.

Done. Thanks!

Verified on DEV. Please proceed to the next steps.

Comment entered 2014-12-05 17:55:57 by Englisch, Volker (NIH/NCI) [C]

The following filters have been updated in subversion:

  • R13001: CDR335424.xml - Denormalization Filter: Summary

  • R13001: CDR000157.xml - Vendor Filter: Summary

QC reports to run the diffs have been started.

Comment entered 2014-12-08 14:17:28 by Englisch, Volker (NIH/NCI) [C]

William, it appears that the Levels of Evidence Spanish translation as well as the various misc. documents will need to exist on QA before we can run a successful publishing job.

The good news is that the filter changes did not break any other summary types.

Comment entered 2014-12-09 16:15:01 by Englisch, Volker (NIH/NCI) [C]

Please let me know when the Spanish version of the LOE has been created on QA and I can rerun the diff reports.

Comment entered 2014-12-09 17:28:32 by Osei-Poku, William (NIH/NCI) [C]

Please let me know when the Spanish version of the LOE has been created on QA and I can rerun the diff reports.

Sure. I copied all the files from DEV to QA earlier this morning but Linda has not had the time to review them. I will let you know as soon as she reviews them.

Comment entered 2014-12-10 10:44:50 by Osei-Poku, William (NIH/NCI) [C]

The documents are ready on QA. Thanks!

Comment entered 2014-12-17 17:54:29 by Englisch, Volker (NIH/NCI) [C]
Comment entered 2014-12-22 16:05:53 by Englisch, Volker (NIH/NCI) [C]

It appears the problem reported off-line - the link under the “Grados de comprobacion cientifica” does not work - was a combination of a data problem and a filter problem. The problem also existed on DEV but wasn't noticed because we didn't publish to Cancer.gov on DEV.
The updated filter expected a URL to the LOE Summary of
http://cancer.gov/...
but the URL for the Spanish LOE Summary was listed as
http://www.cancer.gov/...

The filter has been changed to accept both versions for the Spanish summaries just like for the English summaries.

The following filter has been updated in subversion:

  • R13045: CDR000157.xml - Vendor Filter: Summary

Unfortunately, the QA Gatekeeper server is currently down and I'm unable to reprocess the summary and push to Cancer.gov.

Comment entered 2014-12-29 11:48:54 by Osei-Poku, William (NIH/NCI) [C]

Hi Volker,
I am checking to see if the the issue with the QA Gatekeeper server has been resolved?
Thanks,
William

Comment entered 2014-12-29 12:14:24 by Englisch, Volker (NIH/NCI) [C]

It's my first day at work since my last comment and I don't have the answer yet but you would probably want to review the change on DEV first as the problem already existed there.

Comment entered 2014-12-29 12:48:54 by Osei-Poku, William (NIH/NCI) [C]

The link appears to work fine on DEV.

Comment entered 2014-12-29 17:07:38 by Englisch, Volker (NIH/NCI) [C]

I haven't been able to publish the document but the PP report works and is properly linking.

Comment entered 2014-12-30 14:50:05 by Englisch, Volker (NIH/NCI) [C]

I ran a diff report on QA. Everything looks good and the filter changes did not break anything.

Would you like to wait until we're able to publish the test summary to QA or would you like to go ahead and put this in production?

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

I think we can go ahead to put it into production.

Comment entered 2014-12-30 14:59:31 by Englisch, Volker (NIH/NCI) [C]

OK, please make sure all the misc. documents are ready on PROD.

Comment entered 2014-12-31 10:06:20 by Osei-Poku, William (NIH/NCI) [C]

All documents are ready on PROD.

Comment entered 2014-12-31 13:18:23 by Englisch, Volker (NIH/NCI) [C]

I've noticed that the documents CDR446984 (Informacion adicional - To learn more - CAM patient summary) are slightly different on DEV and on PROD.
Hope that's OK.

Comment entered 2014-12-31 13:49:24 by Englisch, Volker (NIH/NCI) [C]

The following filters have been (modified to adjust for the CDR-ID on PROD and) copied to PROD:

  • R13001: CDR335424.xml - Denormalization Filter: Summary

  • R13059: CDR000157.xml - Vendor Filter: Summary

Comment entered 2014-12-31 15:16:39 by Osei-Poku, William (NIH/NCI) [C]

The Patient version is producing the following error in PP:

CDRPreview web service error: Xml data validation error,The 'Err' element is not declared.Validation error occurred when validating the instance document.,6,3

Comment entered 2014-12-31 15:38:15 by Englisch, Volker (NIH/NCI) [C]

I was afraid of that! The fact that the misc. documents on the different tiers are having different numbers isn't very helpful and since I don't understand Spanish it doesn't make it easier.

The filter is trying to access CDR766007, which is blocked on PROD. Should this be replaced with CDR446985? We used CDR759356 on DEV.

Comment entered 2014-12-31 15:38:23 by Osei-Poku, William (NIH/NCI) [C]

The links to the Levels of evidence summary and to the misc doc for the HP version aren't working.

Comment entered 2014-12-31 15:44:19 by Osei-Poku, William (NIH/NCI) [C]

It should be using CDR446985 instead of 766007 and instead of 766008 it should use CDR446986

Comment entered 2014-12-31 15:52:31 by Englisch, Volker (NIH/NCI) [C]

The links to the Levels of evidence summary and to the misc doc for the HP version aren't working.

I think I've tried all the links in the misc. sections after the Changes section for the Acupuntura - HP summary and they all work. Which links are you referring to?

Comment entered 2014-12-31 15:55:30 by Englisch, Volker (NIH/NCI) [C]

I've replaced the misc. document that's blocked on PROD with CDR446985. The PP report for the patient summary now works.

Comment entered 2014-12-31 15:59:34 by Osei-Poku, William (NIH/NCI) [C]

The following text should be links in the HP version but they are not:
"Información sobre este sumario del PDQ "
and
"sistema formal de jerarquización de la medicina factual"

So, the links are not created at all.

Comment entered 2014-12-31 16:13:15 by Englisch, Volker (NIH/NCI) [C]

This was working on DEV, wasn't it? My guess is that the link is being created but stripped since the document (the link target) doesn't exist.
I believe once you make the Acupuntura summary publishable the link will appear.

Comment entered 2014-12-31 16:30:38 by Osei-Poku, William (NIH/NCI) [C]

I've replaced the misc. document that's blocked on PROD with CDR446985. The PP report for the patient summary now works.

PP came up for the Patient version and everything looks good. Thanks!

Comment entered 2014-12-31 16:43:54 by Osei-Poku, William (NIH/NCI) [C]

One of the links works now after the summary was made publishable. However, this one "Información sobre este sumario del PDQ" (Misc. doc 684064) is still missing.

Comment entered 2014-12-31 16:50:28 by Englisch, Volker (NIH/NCI) [C]

Which document did you make publishable? The document CDR765468 (Acupuntura - HP) is not publishable and that's preventing the link to appear.

Comment entered 2015-01-02 13:00:07 by Osei-Poku, William (NIH/NCI) [C]

The document is publishable now and all the links are working. Thank you!!.

I will wait for the summaries to be published to Cancer.gov before closing this issue.

Comment entered 2015-01-08 12:07:19 by Osei-Poku, William (NIH/NCI) [C]

The first two summaries published to cancer.gov but there are two links that aren't working in one of the summaries. Volker reported this to the GK team to look into it.

Comment entered 2015-02-04 12:39:20 by Osei-Poku, William (NIH/NCI) [C]

Verified on PROD.

Attachments
File Name Posted User
Miscellanous Doc for CAM HP summaries.docx 2014-12-02 14:22:13 Osei-Poku, William (NIH/NCI) [C]
Spanish summary on Dev.docx 2014-11-24 08:02:46 Osei-Poku, William (NIH/NCI) [C]

Elapsed: 0:00:00.002036