importing xls crashes on empty group

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

Bug Description

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


  IndexError: list index out of range

  File "/usr/lib/python2.5/site-packages/zope/publisher/", line 133, in publish
  result = publication.callObject(request, obj)
File "/usr/lib/python2.5/site-packages/zope/app/publication/", line 167, in callObject
  return mapply(ob, request.getPositionalArguments(), request)
File "/usr/lib/python2.5/site-packages/zope/publisher/", line 108, in mapply
  return debug_call(obj, args)
Extra information: < from /usr/lib/python2.5/site-packages/schooltool/export/templates/ object at 0xc675b0c>
File "/usr/lib/python2.5/site-packages/zope/publisher/", line 114, in debug_call
  return obj(*args)
File "/usr/lib/python2.5/site-packages/zope/app/pagetemplate/", line 44, in __call__
  return self.index(*args, **kw)
File "/usr/lib/python2.5/site-packages/zope/app/pagetemplate/", line 83, in __call__
  return self.im_func(im_self, *args, **kw)
File "/usr/lib/python2.5/site-packages/zope/app/pagetemplate/", line 51, in __call__
  sourceAnnotations=getattr(debug_flags, 'sourceAnnotations', 0),
File "/usr/lib/python2.5/site-packages/zope/pagetemplate/", line 115, in pt_render
  strictinsert=0, sourceAnnotations=sourceAnnotations)()
Template "/usr/lib/python2.5/site-packages/schooltool/export/templates/"
File "/usr/lib/python2.5/site-packages/zope/tal/", line 271, in __call__
File "/usr/lib/python2.5/site-packages/zope/tal/", line 346, in interpret
  handlers[opcode](self, args)
File "/usr/lib/python2.5/site-packages/zope/tal/", line 586, in do_setLocal_tal
  self.engine.setLocal(name, self.engine.evaluateValue(expr))
File "/usr/lib/python2.5/site-packages/zope/tales/", line 696, in evaluate
  return expression(self)
Template "/usr/lib/python2.5/site-packages/schooltool/export/templates/", line 1, column 0
  Expression: <PathExpr standard:u'view/update'>
File "/usr/lib/python2.5/site-packages/zope/tales/", line 217, in __call__
  return self._eval(econtext)
File "/usr/lib/python2.5/site-packages/zope/tales/", line 211, in _eval
  return ob()
File "/usr/lib/python2.5/site-packages/schooltool/export/", line 722, in update
File "/usr/lib/python2.5/site-packages/schooltool/export/", line 108, in import_data
  return self.process()
File "/usr/lib/python2.5/site-packages/schooltool/export/", line 681, in process
  row = self.import_group(sh, row)
File "/usr/lib/python2.5/site-packages/schooltool/export/", line 666, in import_group
  if sh.cell_value(rowx=row, colx=0) == 'Members':
File "/usr/lib/python2.5/site-packages/xlrd/", 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