Server error when importing XLS file
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
SchoolTool |
Fix Released
|
High
|
Alan Elkner | ||
1.0 |
Fix Released
|
Medium
|
Gediminas Paulauskas | ||
1.4 |
Fix Released
|
High
|
Alan Elkner | ||
1.7 |
Fix Released
|
High
|
Alan Elkner |
Bug Description
Tried importing sample XLS spreadsheet from
http://
Achieved the following
Exception
XLRDError: No sheet named <'Resources'>
Traceback
File "/usr/lib/
result = publication.
File "/usr/lib/
return mapply(ob, request.
File "/usr/lib/
return debug_call(obj, args)
Extra information: <zope.app.
File "/usr/lib/
return obj(*args)
File "/usr/lib/
return self.index(*args, **kw)
File "/usr/lib/
return self.im_
File "/usr/lib/
sourceAnnotat
File "/usr/lib/
strictinsert=0, sourceAnnotatio
Template "/usr/lib/
File "/usr/lib/
self.
File "/usr/lib/
handlers[
File "/usr/lib/
self.
File "/usr/lib/
return expression(self)
Template "/usr/lib/
Expression: <PathExpr standard:
File "/usr/lib/
return self._eval(
File "/usr/lib/
return ob()
File "/usr/lib/
self.
File "/usr/lib/
sh = wb.sheet_
File "/usr/lib/
raise XLRDError('No sheet named <%r>' % sheet_name)
Changed in schooltool: | |
status: | New → Fix Released |
Changed in schooltool: | |
status: | New → Triaged |
Changed in schooltool: | |
milestone: | karmic → 2009.4.14 |
Changed in schooltool: | |
milestone: | 2009.4.14 → august-1 |
Changed in schooltool: | |
milestone: | august-1 → karmic |
Changed in schooltool: | |
milestone: | lucid → 1.4.0 |
tags: | added: import |
tags: | added: traceback |
Changed in schooltool: | |
milestone: | 1.4.0 → next |
Changed in schooltool: | |
status: | Won't Fix → In Progress |
Changed in schooltool: | |
milestone: | next → 1.5.0 |
status: | In Progress → Fix Committed |
Added Resources sheet to spread sheet and tried to re-import and got the following.
Exception
IndexError: list index out of range
Traceback
File "/usr/lib/ python2. 4/site- packages/ zope/publisher/ publish. py", line 133, in publish callObject( request, obj) python2. 4/site- packages/ zope/app/ publication/ zopepublication .py", line 167, in callObject getPositionalAr guments( ), request) python2. 4/site- packages/ zope/publisher/ publish. py", line 108, in mapply pagetemplate. simpleviewclass .SimpleViewClas s from /usr/lib/ python2. 4/site- packages/ schooltool/ export/ templates/ import. pt object at 0x579f0d0> python2. 4/site- packages/ zope/publisher/ publish. py", line 114, in debug_call python2. 4/site- packages/ zope/app/ pagetemplate/ simpleviewclass .py", line 44, in __call__ python2. 4/site- packages/ zope/app/ pagetemplate/ viewpagetemplat efile.py" , line 83, in __call__ func(im_ self, *args, **kw) python2. 4/site- packages/ zope/app/ pagetemplate/ viewpagetemplat efile.py" , line 51, in __call__ ions=getattr( debug_flags, 'sourceAnnotati ons', 0), python2. 4/site- packages/ zope/pagetempla te/pagetemplate .py", line 115, in pt_render ns=sourceAnnota tions)( ) python2. 4/site- packages/ schooltool/ export/ templates/ import. pt" python2. 4/site- packages/ zope/tal/ talinterpreter. py", line 271, in __call__ interpret( self.program) python2. 4/site- packages/ zope/tal/ talinterpreter. py", line 346, in interpret opcode] (self, args) python2. 4/site- packages/ zope/tal/ talinterpreter. py", line 586, in do_setLocal_tal engine. setLocal( name, self.engine. evaluateValue( expr)) python2. 4/site- packages/ zope/tales/ tales.py" , line 696, in evaluate python2. 4/site- packages/ schooltool/ export/ templates/ import. pt", line 1, column 0 u'view/ update' > python2. 4/site- packages/ zope/tales/ expressions. py", line 217, in __call__ econtext) python2. 4/site- packages/ zope/tales/ expressions. py", line 211, in _eval python2. 4/site- packages/ schooltool/ export/ simporter. py", line 581, in update import_ sections( wb) python2. 4/site- packages/ schooltool/ export/ simporter. py", line 504, in import_sections section( sh, row) python2. 4/site- packages/ schooltool/ export/ simporter. py", line 495, in import_section timetables( sh, row, section) python2. 4/site- packages/ schooltool/ export/ simporter. py", line 444, in import_timetables import_ timetable( sh, row, section) python2. 4/site- packages/ schooltool/ export/ simporter. py", line 430, in import_timetable value(rowx= row, colx=2) python2. 4/site- packages/ xlrd/sheet. py"...
result = publication.
File "/usr/lib/
return mapply(ob, request.
File "/usr/lib/
return debug_call(obj, args)
Extra information: <zope.app.
File "/usr/lib/
return obj(*args)
File "/usr/lib/
return self.index(*args, **kw)
File "/usr/lib/
return self.im_
File "/usr/lib/
sourceAnnotat
File "/usr/lib/
strictinsert=0, sourceAnnotatio
Template "/usr/lib/
File "/usr/lib/
self.
File "/usr/lib/
handlers[
File "/usr/lib/
self.
File "/usr/lib/
return expression(self)
Template "/usr/lib/
Expression: <PathExpr standard:
File "/usr/lib/
return self._eval(
File "/usr/lib/
return ob()
File "/usr/lib/
self.
File "/usr/lib/
row = self.import_
File "/usr/lib/
row = self.import_
File "/usr/lib/
self.
File "/usr/lib/
resources[day_id, period_id] = sh.cell_
File "/usr/lib/