CDR Tickets
| Issue Number | 5303 |
|---|---|
| Summary | Correspondence Mailer fails on names with special characters |
| Created | 2023-11-28 13:10:56 |
| Issue Type | Improvement |
| Submitted By | Osei-Poku, William (NIH/NCI) [C] |
| Assigned To | Kline, Bob (NIH/NCI) [C] |
| Status | QA Verified |
| Resolved | 2023-11-29 11:09:29 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/ocecdr/issue.369193 |
When running a correspondence mailer for board members, the letter (.rtf file link) fails to display if the name of the board member has an accented character. When that character is removed or replaced, the mailer generates without any problem. This issue first happened on PROD with Aimée Kreimer about a week ago.
Repro Steps on DEV.
I have modified CDR0000022106 (Barry Andérson) to add the character with accent.
Navigate to the OCC Board Managers admin menu.
Click on the Board Member Correspondence Mailers report (Under Mailers)
Select PDQ PDQ Pediatric Treatment Editorial Board (Default selection)
Select Editorial Board Invitation Letter (Under Letter)
Select Andérson, Barry (Under Board Members)
Click Submit
When you receive the email notification, the status message in the first link indicates that the mailer failed. (The message DEV appears to be different from the message I saw on PROD. Please let me know if you want to see the message from PROD.
The second link does not have the .rtf letter link.
Investigating. Probably don't need a screenshot for the PROD message, but let me know what the nature of the difference was if it's not obvious why it's different.
This is the message from PROD:
[Errno 2] No such file or directory: 'Aim{\uc1\u233?}e_Kreimer.rtf'
Compared to the error from DEV:
Miscellaneous document 'NO INVITATION LETTER AVAILABLE' not found
That is helpful. You're dealing with two different problems. One is the bug in the mailer software which I'm tracking down and fixing. The second is really an artificial problem, I think. because—as far as I can tell—the users have decided that they don't need invitation letters for prospective members of the Pediatric Treatment editorial board. For that problem, I think all you need to do is pick another board for your repro case.
I think I've got this working on DEV. Give it a try. You should probably be able to generate the needed mailer for the production system by running the request on DEV. The letter may need to be edited to adjust any data which is different for the recipient data on the two tiers. If you want the tracking documents to record the generation of the mailer you'll need to wait until the fix is promoted, or you can temporarily adjust the CDR person document to replace the non-ASCII characters in the name on PROD, generate the mailer letter, then edit the letter and the CDR document to restore the diacritics.
Yes, this seems to be working on DEV. Thanks!
I would like to fix this. It has come up a few times during troubleshooting other correspondence mailer problems. I suppose we need to provide you with the text of the invitation letters for the Pediatric Treatment editorial board, right? Do we need to create a misc. doc also? I will create a new ticket to handle this when I have answers to the questions. Thanks!
Acceptance Criteria
Board Managers > PCIB Management Reports > Mailer Reports > Create Correspondence Mailer
Select PDQ Screening and Prevention Editorial Advisory Board
Select Advisory Board Invitation Letter
Select Kriemer, Amiée (that's the mangled version of the name of QA)
Click Submit
Verify that the correspondence document is successfully generated
Confirm that the diacritic mark for é appears correctly in the document and its file name
Verified on QA. Thanks!
| File Name | Posted | User |
|---|---|---|
| Correspondence Mailer _ Accented character_Message.PNG | 2023-11-28 13:06:04 | Osei-Poku, William (NIH/NCI) [C] |
| Correspondence Mailer _ Accented character.PNG | 2023-11-28 13:06:57 | Osei-Poku, William (NIH/NCI) [C] |
Elapsed: 0:00:00.001410