CDR Tickets

Issue Number 3429
Summary [Media] Audio Pronunciation Recordings Tracking Report
Created 2011-10-13 11:22:07
Issue Type Improvement
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2011-11-21 14:34:22
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.107757
Description

BZISSUE::5123
BZDATETIME::2011-10-13 11:22:07
BZCREATOR::William Osei-Poku
BZASSIGNEE::Bob Kline
BZQACONTACT::William Osei-Poku

We need a new report to track the processing of audio pronunciation media documents. I am attaching the specs and mock up of the report.

Comment entered 2011-10-13 11:22:07 by Osei-Poku, William (NIH/NCI) [C]

Attachment Audio Pronunciation Recordings Tracking Report_specs doc.docx has been added with description: Pronunciation Report Specs

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

BZDATETIME::2011-10-13 11:25:13
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::1

corrected typo in title.

Comment entered 2011-10-13 11:26:12 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2011-10-13 11:26:12
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::2

attached a sample of the report.

Comment entered 2011-10-13 11:26:12 by Osei-Poku, William (NIH/NCI) [C]

Attachment Audio RecordingsTracking Report_Sample .xls has been added with description: sample report

Comment entered 2011-10-17 14:12:13 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2011-10-17 14:12:13
BZCOMMENTOR::Bob Kline
BZCOMMENT::3

At one point the specs call for output to the browser, and elsewhere they call for output to an Excel spreadsheet. Which is the real requirement?

Comment entered 2011-10-17 14:51:10 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2011-10-17 14:51:10
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::4

(In reply to comment #3)
> At one point the specs call for output to the browser, and elsewhere they call
> for output to an Excel spreadsheet. Which is the real requirement?

The browser refers to the user interface and the Excel spreadsheet refers to the report. Sorry for the confusion.

Comment entered 2011-10-17 17:24:17 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2011-10-17 17:24:17
BZCOMMENTOR::Bob Kline
BZCOMMENT::5

The description of the interface includes radio buttons for language, but that's not part of the selection criteria listed on the first page of the specs, and I see that only two Media documents have a value for the /Media/MediaContent/MediaLanguage element. Can you elaborate on what you had in mind?

Comment entered 2011-10-17 17:53:17 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2011-10-17 17:53:17
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::6

(In reply to comment #5)
> The description of the interface includes radio buttons for language, but
> that's not part of the selection criteria listed on the first page of the
> specs, and I see that only two Media documents have a value for the
> /Media/MediaContent/MediaLanguage element. Can you elaborate on what you had
> in mind?

That was an oversight. The Spanish media documents are separate documents from the English documents. It seems the way to identify the Spanish documents is to find "Spanish" in the title. The Content Description element would also have 'es' as an attribute in the Spanish documents. In the absence of a specific language element, would it be possible to run the report bases on language?

Comment entered 2011-10-20 15:09:22 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2011-10-20 15:09:22
BZCOMMENTOR::Bob Kline
BZCOMMENT::7

Implemented on Mahler; ready for user testing. I noticed another discrepancy between the specs, which called for a 12pt font, and the sample, which used 10pt. I followed the specification.

Comment entered 2011-10-25 11:22:46 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2011-10-25 11:22:46
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::8

1. Please remove the asterisks on the Processing Status and Comments columns. They were left in the sample inadvertently.

2. We ran the report from 2011-06-01 to current date and another one from 2011-01-01 to current date. I expected all the documents retrieved in the first run (2011-06-01 to current date) to be included in the second run (2011-01-01 to current date), but they were not included.

Comment entered 2011-10-25 13:49:10 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2011-10-25 13:49:10
BZCOMMENTOR::Bob Kline
BZCOMMENT::9

(In reply to comment #8)
> 1. Please remove the asterisks on the Processing Status and Comments columns.
> They were left in the sample inadvertently.

Changed.

> 2. We ran the report from 2011-06-01 to current date and another one from
> 2011-01-01 to current date. I expected all the documents retrieved in the first
> run (2011-06-01 to current date) to be included in the second run (2011-01-01
> to current date), but they were not included.

Fixed.

Comment entered 2011-10-26 15:35:57 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2011-10-26 15:35:57
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::10

Please change the sort criteria to the following:
Primary sort: Processing Status
Secondary sort: Last Publishable Version
Tertiary sort: (if possible): Date Last Modified

Comment entered 2011-11-01 12:33:29 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2011-11-01 12:33:29
BZCOMMENTOR::Bob Kline
BZCOMMENT::11

(In reply to comment #10)
> Please change the sort criteria to the following:
> Primary sort: Processing Status
> Secondary sort: Last Publishable Version
> Tertiary sort: (if possible): Date Last Modified

Can I assume you meant "last version publishable?" for the secondary sort?

Comment entered 2011-11-01 12:59:34 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2011-11-01 12:59:34
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::12

(In reply to comment #11)
> (In reply to comment #10)
> > Please change the sort criteria to the following:
> > Primary sort: Processing Status
> > Secondary sort: Last Publishable Version
> > Tertiary sort: (if possible): Date Last Modified
>
> Can I assume you meant "last version publishable?" for the secondary sort?
Yes. Please.

Comment entered 2011-11-01 14:14:25 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2011-11-01 14:14:25
BZCOMMENTOR::Bob Kline
BZCOMMENT::13

Requested modifications for sorting logic implemented.

Comment entered 2011-11-03 10:17:00 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2011-11-03 10:17:00
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::14

When a user enters an end date that is before the start date, could you display an error message like 'End date cannot be before start date' ?

Comment entered 2011-11-03 15:34:40 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2011-11-03 15:34:40
BZCOMMENTOR::Bob Kline
BZCOMMENT::15

Enhancement implemented on Mahler.

Comment entered 2011-11-03 16:29:14 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2011-11-03 16:29:14
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::16

(In reply to comment #15)
> Enhancement implemented on Mahler.

Verified on Mahler. Please promote to Bach.

Comment entered 2011-11-16 12:10:42 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2011-11-16 12:10:42
BZCOMMENTOR::Bob Kline
BZCOMMENT::17

Promoted to Bach.

Comment entered 2011-11-21 14:34:22 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2011-11-21 14:34:22
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::18

(In reply to comment #17)
> Promoted to Bach.

Verified on Bach. Thank you!
Issue closed.

Attachments
File Name Posted User
Audio Pronunciation Recordings Tracking Report_specs doc.docx 2011-10-13 11:22:07 Osei-Poku, William (NIH/NCI) [C]
Audio RecordingsTracking Report_Sample .xls 2011-10-13 11:26:12 Osei-Poku, William (NIH/NCI) [C]

Elapsed: 0:00:00.001418