| Issue Number | 3229 |
|---|---|
| Summary | [TMS] Adhoc report of glossary terms |
| Created | 2010-09-21 10:15:07 |
| Issue Type | Improvement |
| Submitted By | Beckwith, Margaret (NIH/NCI) [E] |
| Assigned To | Kline, Bob (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2010-10-28 12:23:05 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/ocecdr/issue.107557 |
BZISSUE::4917
BZDATETIME::2010-09-21 10:15:07
BZCREATOR::Margaret Beckwith
BZASSIGNEE::Bob Kline
BZQACONTACT::Robin Juthe
Lakshmi asked me to request a report for Mauricio, who would like to do some very preliminary testing of alignment using glossary terms. We need an Excel spreadsheet with 2 worksheets, one for English and one for Spanish. The cells need to line up between the two. So, the term in cell 1 in English corresponds to the term in block 1 in Spanish. He would like 10-20 glossary terms and denormalized definitions.
BZDATETIME::2010-09-21 10:18:24
BZCOMMENTOR::Margaret Beckwith
BZCOMMENT::1
Added [TMS] to summary, and added Lakshmi as a cc.
BZDATETIME::2010-09-29 16:14:46
BZCOMMENTOR::Margaret Beckwith
BZCOMMENT::2
Testing comments.
BZDATETIME::2010-09-30 17:49:14
BZCOMMENTOR::Bob Kline
BZCOMMENT::3
Attachment Report4917.xls has been added with description: Requested report
BZDATETIME::2010-10-07 16:38:19
BZCOMMENTOR::Margaret Beckwith
BZCOMMENT::4
It looks good except that I noticed for two of the terms (in both Eng. and Span.) that the Scientific Name tags are still showing in the definitions: doxorubicin and blessed thistle. Also, the defn. for GIST is formatted oddly.
BZDATETIME::2010-10-07 17:02:00
BZCOMMENTOR::Bob Kline
BZCOMMENT::5
(In reply to comment #4)
> It looks good except that I noticed for two of the terms (in both
Eng. and
> Span.) that the Scientific Name tags are still showing in the
definitions:
> doxorubicin and blessed thistle.
I have attached a version of the spreadsheet which strips those tags out (didn't realize that was a requirement).
> Also, the defn. for GIST is formatted oddly.
That's an artificial side effect of the way Excel displays multi-line values on a single line. The replacement report has wrapping turned on so all of the whitespace appears as the users entered it.
Attachment Report4917-a.xls has been added with description: Replacement report with all definition markup stripped
BZDATETIME::2010-10-07 17:07:15
BZCOMMENTOR::Margaret Beckwith
BZCOMMENT::6
I guess I thought denormalized meant that all of the tags would not be showing, but now I think I understand.
And I did set the column to wrap for the definitions, and that one definition still had white space inserted (for example, the first A was on a separate line). It still does even in the new report. I don't think it matters, but I was wondering why it was different.
I will let Lakshmi know this report is finished. Thanks.
BZDATETIME::2010-10-07 17:53:02
BZCOMMENTOR::Bob Kline
BZCOMMENT::7
(In reply to comment #6)
> I guess I thought denormalized meant that all of the tags would not
be showing,
> but now I think I understand.
Right; if you think about the published documents – those are denormalized, but markup is not stripped.
>
> And I did set the column to wrap for the definitions, and that one
definition
> still had white space inserted (for example, the first A was on a
separate
> line). It still does even in the new report. I don't think it
matters, but I
> was wondering why it was different.
That's how the user entered the definition.
BZDATETIME::2010-10-28 12:22:49
BZCOMMENTOR::Margaret Beckwith
BZCOMMENT::8
The report looks fine and I have sent it to Mauricio so I am closing this issue.
BZDATETIME::2010-10-28 12:23:05
BZCOMMENTOR::Margaret Beckwith
BZCOMMENT::9
Closing issue.
| File Name | Posted | User |
|---|---|---|
| Report4917.xls | 2010-09-30 17:49:14 | |
| Report4917-a.xls | 2010-10-07 17:02:00 |
Elapsed: 0:00:00.001687