CDR Tickets
| Issue Number | 4671 |
|---|---|
| Summary | Audio Import Tool Creating Error Message |
| Created | 2019-10-01 12:47:25 |
| Issue Type | Bug |
| Submitted By | Englisch, Volker (NIH/NCI) [C] |
| Assigned To | Englisch, Volker (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2020-02-19 18:48:54 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/ocecdr/issue.250530 |
Every time the audio import tool runs (ocecdr-3373.py) an error message gets created in the log file. This error doesn't prevent the tool from running but should be fixed regardless.
The error comes from trying to convert the "CDR ID" column header of the spreadsheet contained in the audio *.zip file to an integer:
{{2019-09-18 13:27:30.223 [ERROR]
D:/cdr/Audio_from_CIPSFTP/Week_133.zip row 0 Traceback (most recent call
last): }}
{{ File "D:\Inetpub\wwwroot\cgi-bin\cdr\ocecdr-3373.py", line 160, in
init }}
{{ self.nameId = int(getCellValue(sheet, row, 0)) }}
ValueError: invalid literal for int() with base 10: 'CDR ID'
~volker - I think this may have been fixed by Kepler. If you agree, let's mark this ticket as part of the that release (fixed).
OK, now Jira ate my comment but it kept the image.
I tested the audio import tool again and saw the attached error, although the script did run.
As for the original error message: It's possible that the test import file is to blame for the error. I tried to use a different file to import instead but ran in the attached message.
Hmm, I don't get that error message.
This is just a guess, but I wonder if this is another instance of the problem with Windows file permissions. If my account put the ZIP file in the audio directory, and was the last to write to the log file for this script, could attempts by your account to read and/or write to/from these files be stumbling on the file permissions problem? Unfortunately, CBIIT unilaterally closed my ticket for that problem, so I'm not very hopeful we'll get much joy from that corner. :-(
I have created a test audio zipfile so we can tackle this ticket together.
~volker: please determine whether this ticket can be closed.
No more error in the log file. Closing ticket.
Hurrah!
| File Name | Posted | User |
|---|---|---|
| image-2019-11-25-16-21-39-804.png | 2019-11-25 16:22:01 | Kline, Bob (NIH/NCI) [C] |
| Screen Shot 2019-11-25 at 16.05.17.png | 2019-11-25 16:08:09 | Englisch, Volker (NIH/NCI) [C] |
Elapsed: 0:00:00.001300