importing xls crashes on empty group

Bug #382566 reported by Thomas Schweikle on 2009-06-01
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
SchoolTool
Medium
Gediminas Paulauskas
1.4
Medium
Gediminas Paulauskas

Bug Description

Exporting schooltool-2009 data via "administration -> xls-export", then importing data again fails if you edited the data before with "OpenOffice.org 3.1" or with "Microsoft Office 2007". Exporting data, then importing again seems to work without any problems.

Ausnahme

  IndexError: list index out of range
Zurückverfolgung

  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 0xc675b0c>
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 681, in process
  row = self.import_group(sh, row)
File "/usr/lib/python2.5/site-packages/schooltool/export/importer.py", line 666, in import_group
  if sh.cell_value(rowx=row, colx=0) == 'Members':
File "/usr/lib/python2.5/site-packages/xlrd/sheet.py", line 253, in cell_value
  return self._cell_values[rowx][colx]

Changed in schooltool:
assignee: nobody → Justas Sadzevičius (justas-pov)
importance: Undecided → Medium
milestone: none → karmic
tags: added: import
tags: added: traceback
summary: - importing schooltool export.xls fails
+ importing xls crashes on empty group
Changed in schooltool:
milestone: next → 1.6.1
assignee: Justas Sadzevičius (justas-pov) → Gediminas Paulauskas (menesis)
status: New → Fix Committed
Changed in schooltool:
status: Fix Committed → Fix Released
no longer affects: schooltool/1.5
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers