Server error when importing XLS file

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
  result = publication.callObject(request, obj)
File "/usr/lib/python2.4/site-packages/zope/app/publication/zopepublication.py", line 167, in callObject
  return mapply(ob, request.getPositionalArguments(), request)
File "/usr/lib/python2.4/site-packages/zope/publisher/publish.py", line 108, in mapply
  return debug_call(obj, args)
Extra information: <zope.app.pagetemplate.simpleviewclass.SimpleViewClass from /usr/lib/python2.4/site-packages/schooltool/export/templates/import.pt object at 0x579f0d0>
File "/usr/lib/python2.4/site-packages/zope/publisher/publish.py", line 114, in debug_call
  return obj(*args)
File "/usr/lib/python2.4/site-packages/zope/app/pagetemplate/simpleviewclass.py", line 44, in __call__
  return self.index(*args, **kw)
File "/usr/lib/python2.4/site-packages/zope/app/pagetemplate/viewpagetemplatefile.py", line 83, in __call__
  return self.im_func(im_self, *args, **kw)
File "/usr/lib/python2.4/site-packages/zope/app/pagetemplate/viewpagetemplatefile.py", line 51, in __call__
  sourceAnnotations=getattr(debug_flags, 'sourceAnnotations', 0),
File "/usr/lib/python2.4/site-packages/zope/pagetemplate/pagetemplate.py", line 115, in pt_render
  strictinsert=0, sourceAnnotations=sourceAnnotations)()
Template "/usr/lib/python2.4/site-packages/schooltool/export/templates/import.pt"
File "/usr/lib/python2.4/site-packages/zope/tal/talinterpreter.py", line 271, in __call__
  self.interpret(self.program)
File "/usr/lib/python2.4/site-packages/zope/tal/talinterpreter.py", line 346, in interpret
  handlers[opcode](self, args)
File "/usr/lib/python2.4/site-packages/zope/tal/talinterpreter.py", line 586, in do_setLocal_tal
  self.engine.setLocal(name, self.engine.evaluateValue(expr))
File "/usr/lib/python2.4/site-packages/zope/tales/tales.py", line 696, in evaluate
  return expression(self)
Template "/usr/lib/python2.4/site-packages/schooltool/export/templates/import.pt", line 1, column 0
  Expression: <PathExpr standard:u'view/update'>
File "/usr/lib/python2.4/site-packages/zope/tales/expressions.py", line 217, in __call__
  return self._eval(econtext)
File "/usr/lib/python2.4/site-packages/zope/tales/expressions.py", line 211, in _eval
  return ob()
File "/usr/lib/python2.4/site-packages/schooltool/export/simporter.py", line 581, in update
  self.import_sections(wb)
File "/usr/lib/python2.4/site-packages/schooltool/export/simporter.py", line 504, in import_sections
  row = self.import_section(sh, row)
File "/usr/lib/python2.4/site-packages/schooltool/export/simporter.py", line 495, in import_section
  row = self.import_timetables(sh, row, section)
File "/usr/lib/python2.4/site-packages/schooltool/export/simporter.py", line 444, in import_timetables
  self.import_timetable(sh, row, section)
File "/usr/lib/python2.4/site-packages/schooltool/export/simporter.py", line 430, in import_timetable
  resources[day_id, period_id] = sh.cell_value(rowx=row, colx=2)
File "/usr/lib/python2.4/site-packages/xlrd/sheet.py"...

Worked this out now, by using the following file.

/usr/lib/python2.5/site-packages/schooltool/export/sample_data.xls

This is on intrepid with the install run from apt-get install schooltool-2008

However failing gracefully would be nice.

Yes, that's what Ignas is working on this week. And I'll work on documentation as soon as I get our 2009 budget done...

Dear All,
 I have same Problems when I try to import sample data into Schooltool: Error Description following:

Exception
 IndexError: list index out of range
Ghi băng lại

  File "/usr/lib/python2.5/site-packages/zope/publisher/publish.py", line 133, in publish
  result = publication.callObject(request, obj)
File "/usr/lib/python2.5/site-packages/zope/app/publication/zopepublication.py", line 167, in callObject
  return mapply(ob, request.getPositionalArguments(), request)
File "/usr/lib/python2.5/site-packages/zope/publisher/publish.py", line 108, in mapply
  return debug_call(obj, args)
Extra information: <zope.app.pagetemplate.simpleviewclass.SimpleViewClass from /usr/lib/python2.5/site-packages/schooltool/export/templates/import.pt object at 0xbabdb4c>
File "/usr/lib/python2.5/site-packages/zope/publisher/publish.py", line 114, in debug_call
  return obj(*args)
File "/usr/lib/python2.5/site-packages/zope/app/pagetemplate/simpleviewclass.py", line 44, in __call__
  return self.index(*args, **kw)
File "/usr/lib/python2.5/site-packages/zope/app/pagetemplate/viewpagetemplatefile.py", line 83, in __call__
  return self.im_func(im_self, *args, **kw)
File "/usr/lib/python2.5/site-packages/zope/app/pagetemplate/viewpagetemplatefile.py", line 51, in __call__
  sourceAnnotations=getattr(debug_flags, 'sourceAnnotations', 0),
File "/usr/lib/python2.5/site-packages/zope/pagetemplate/pagetemplate.py", line 115, in pt_render
  strictinsert=0, sourceAnnotations=sourceAnnotations)()
Template "/usr/lib/python2.5/site-packages/schooltool/export/templates/import.pt"
File "/usr/lib/python2.5/site-packages/zope/tal/talinterpreter.py", line 271, in __call__
  self.interpret(self.program)
File "/usr/lib/python2.5/site-packages/zope/tal/talinterpreter.py", line 346, in interpret
  handlers[opcode](self, args)
File "/usr/lib/python2.5/site-packages/zope/tal/talinterpreter.py", line 586, in do_setLocal_tal
  self.engine.setLocal(name, self.engine.evaluateValue(expr))
File "/usr/lib/python2.5/site-packages/zope/tales/tales.py", line 696, in evaluate
  return expression(self)
Template "/usr/lib/python2.5/site-packages/schooltool/export/templates/import.pt", line 1, column 0
  Expression: <PathExpr standard:u'view/update'>
File "/usr/lib/python2.5/site-packages/zope/tales/expressions.py", line 217, in __call__
  return self._eval(econtext)
File "/usr/lib/python2.5/site-packages/zope/tales/expressions.py", line 211, in _eval
  return ob()
File "/usr/lib/python2.5/site-packages/schooltool/export/importer.py", line 722, in update
  imp.import_data(wb)
File "/usr/lib/python2.5/site-packages/schooltool/export/importer.py", line 108, in import_data
  return self.process()
File "/usr/lib/python2.5/site-packages/schooltool/export/importer.py", line 438, in process
  data['gender'] = sh.cell_value(rowx=row, colx=8)
File "/usr/lib/python2.5/site-packages/xlrd/sheet.py", line 253, in cell_value
  return self._cell_values[rowx][colx]

Tom Hoffman, can you help me?

Justas, can you look at missthom's traceback, please?

It seems that you are using the old sample data XLS. To obtain the new one, go to the "XLS Import" page in your SchoolTool and click on the "sample_data.xls" link.

Thank you for your bug report. We'll implement more user-friendly handling of this error for the next SchoolTool bugfix release.

I assume the sample XLS file you can download from SchoolTool works, but some older file from internet doesn't? So use the newer file...

Is this "won't fix" or assigned to the next milestone? It can't be both.

I don't think we need to fix importing those old files, thus Won't fix.
But still, more graceful handling of missing sheets would be nice to have, thus I want someone to look at it for next milestone.

Alan's been working more on the spreadsheet import.