| Issue Number | 3238 |
|---|---|
| Summary | [Glossary Audio] Spreadsheet of Term Names and Pronunciations |
| Created | 2010-10-04 17:00:20 |
| Issue Type | Improvement |
| Submitted By | Juthe, Robin (NIH/NCI) [E] |
| Assigned To | Kline, Bob (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2010-10-22 13:15:14 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/ocecdr/issue.107566 |
BZISSUE::4927
BZDATETIME::2010-10-04 17:00:20
BZCREATOR::Robin Juthe
BZASSIGNEE::Bob Kline
BZQACONTACT::William Osei-Poku
To begin the larger project of adding audio pronunciations to the glossary term name (GTN) documents, we discussed developing a spreadsheet of all current glossary term names with their phonetic pronunciations (when available) and a place to store information about the audio recordings for each term.
From left to right, the desired columns are:
CDR ID (This is the CDR ID of the GTN document)
Term Name String (EN)
Pronunciation (This is the phonetic pronunciation from the
TermPronunciation element in the GTN document, when it is populated;
otherwise, this will be blank)
Term Name String (ES)
Recording File Name (This is the file name for the audio file)
Recording Language
Recording Creator (This may be deemed unnecessary if the same person
records all of the files, but we can delete this column later if it's
not useful)
The last 3 columns will be blank for the time being.
There are some term name documents that have multiple translated (ES) term names. I'm not sure how best to handle these..maybe they could be listed in a subsequent row with the CDR ID repeated in that row?
BZDATETIME::2010-10-04 18:20:57
BZCOMMENTOR::Bob Kline
BZCOMMENT::1
I think we should drive the structure of the sheet by the assumption that there will be one row per audio file. So the columns would be:
CDR ID
Term Name
Language
Pronunciation
Filename
Creator
Would that work for you?
BZDATETIME::2010-10-05 08:51:58
BZCOMMENTOR::Robin Juthe
BZCOMMENT::2
(In reply to comment #1)
> Would that work for you?
Yes, that makes sense to me.
BZDATETIME::2010-10-12 09:08:43
BZCOMMENTOR::Bob Kline
BZCOMMENT::3
Attachment Report4927.xls has been added with description: Requested report
BZDATETIME::2010-10-12 09:09:35
BZCOMMENTOR::Bob Kline
BZCOMMENT::4
Can't change status and attach a file at the same time.
BZDATETIME::2010-10-14 13:07:44
BZCOMMENTOR::Bob Kline
BZCOMMENT::5
Attachment Report4927-resorted.xls has been added with description: Sorted by language then by term name
BZDATETIME::2010-10-15 17:15:59
BZCOMMENTOR::Volker Englisch
BZCOMMENT::6
(In reply to comment #4)
> Can't change status and attach a file at the same time.
Correct! It's planned to be available for Bugzilla 4.2.
BZDATETIME::2010-10-15 17:32:10
BZCOMMENTOR::Bob Kline
BZCOMMENT::7
We're sort of hijacking this issue, but the Bugzilla [Help] link appears to be busted, too.
BZDATETIME::2010-10-22 11:36:35
BZCOMMENTOR::Volker Englisch
BZCOMMENT::8
(In reply to comment #7)
> the Bugzilla [Help] link appears to be busted, too.
Real users don't use documentation! Ok, Ok, if you insists. Go ahead and try it now.
BZDATETIME::2010-10-22 12:26:20
BZCOMMENTOR::Bob Kline
BZCOMMENT::9
(In reply to comment #8)
> (In reply to comment #7)
> > the Bugzilla [Help] link appears to be busted, too.
>
> Real users don't use documentation! Ok, Ok, if you insists. Go
ahead and try
> it now.
Thanks!
And now back to our regularly-scheduled Bugzilla issue. Since this isn't the issue for actually loading the sound clips into the CDR, I would guess that if the attached spreadsheet is satisfactory you can probably close the issue, right?
BZDATETIME::2010-10-22 13:15:14
BZCOMMENTOR::Robin Juthe
BZCOMMENT::10
Closing issue.
| File Name | Posted | User |
|---|---|---|
| Report4927.xls | 2010-10-12 09:08:43 | |
| Report4927-resorted.xls | 2010-10-14 13:07:44 |
Elapsed: 0:00:00.000622