| Issue Number | 3201 |
|---|---|
| Summary | Dictionary Report for Wayne |
| Created | 2010-07-29 16:02:55 |
| Issue Type | Improvement |
| Submitted By | Juthe, Robin (NIH/NCI) [E] |
| Assigned To | Kline, Bob (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2010-07-30 14:58:23 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/ocecdr/issue.107529 |
BZISSUE::4888
BZDATETIME::2010-07-29 16:02:55
BZCREATOR::Robin Juthe
BZASSIGNEE::Bob Kline
BZQACONTACT::William Osei-Poku
We would like to create an ad hoc report for Wayne which he can use to record URLs of Cancer.gov pages that are related to dictionary terms. We would like the report to include every published term in the dictionary, but be organized by the glossary term concept (rather that the glossary term name) to avoid duplication. Please exclude blocked and/or unpublished terms from the report.
The output should be in Excel.
The columns (from left to right) in the report should be: CDR ID, Term Names, Page Title, PDQ Patient Summary URL, Drug Info Summary URL, Other URL.
1. The CDR ID should be the CDR ID of the Glossary Term Concept
record.
2. The Term Names that are linked to each Concept should be listed in a
single cell in alphabetical order, separated by commas.
3. The report should be sorted alphabetically by first term name (after
step 2 is complete).
4. The last four columns should be blank.
5. Please make the last 3 columns (which will contain URLs) much wider
than the others.
We envision that this spreadsheet (once filled in) will eventually be used to populate RelatedExternalRef, RelatedSummaryRef, and RelatedDrugSummaryLink elements in the Glossary Term Concept records in the CDR.
Thanks!
BZDATETIME::2010-07-30 12:11:05
BZCOMMENTOR::Bob Kline
BZCOMMENT::1
Fixed the version target (you probably don't want to wait for CDR 2.0, which might be a few years in the future). :-)
Are we just interested in the English names (that is the content of /GlossaryTermName/TermName/TermNameString)? Or does he need Spanish names as well?
BZDATETIME::2010-07-30 13:27:27
BZCOMMENTOR::Robin Juthe
BZCOMMENT::2
We only need the English term names listed.
And thanks for correcting the version target - good to know!
BZDATETIME::2010-07-30 13:57:20
BZCOMMENTOR::Bob Kline
BZCOMMENT::3
Attachment Request4888.xls has been added with description: Report for Wayne
BZDATETIME::2010-07-30 13:58:14
BZCOMMENTOR::Bob Kline
BZCOMMENT::4
Feel free to tweak the column widths further before passing this on (or perhaps let him do what he wants along those lines).
BZDATETIME::2010-07-30 14:34:42
BZCOMMENTOR::Robin Juthe
BZCOMMENT::5
This looks great - thank you.
BZDATETIME::2010-07-30 14:50:51
BZCOMMENTOR::Robin Juthe
BZCOMMENT::6
Bob, is this report run based on data on Mahler or on Bach?
BZDATETIME::2010-07-30 14:56:01
BZCOMMENTOR::Bob Kline
BZCOMMENT::7
That was from Bach; does he need data from Mahler instead (I assumed not, since we were talking about restricting the report to terms which have been published, which would imply the production system, since we don't publish from the other systems)? Are you seeing anything which looks suspicious? I worked from the current working copies of the documents, not the latest publishable versions. I'm happy to re-do it any way you need me to.
BZDATETIME::2010-07-30 14:57:31
BZCOMMENTOR::Robin Juthe
BZCOMMENT::8
No, there's nothing suspicious and your assumptions were all correct. I just wanted to be sure this was done on Bach before closing the issue. Thank you!
BZDATETIME::2010-07-30 14:58:23
BZCOMMENTOR::Robin Juthe
BZCOMMENT::9
Closing issue.
| File Name | Posted | User |
|---|---|---|
| Request4888.xls | 2010-07-30 13:57:20 |
Elapsed: 0:00:00.001902