Server error on import from xls

Bug #940133 reported by Nooruddeen Mohung
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
SchoolTool
Triaged
High
Douglas Cerna

Bug Description

Server Error

An internal server error has occurred. This most likely means that you have found a bug in SchoolTool. Please report it on the issue tracker.
Exception

KeyError: datetime.date(2012, 2, 20)

Traceback

File "/usr/lib/python2.7/dist-packages/zope/publisher/publish.py", line 132, in publish
  result = publication.callObject(request, obj)
File "/usr/lib/python2.7/dist-packages/zope/app/publication/zopepublication.py", line 207, in callObject
  return mapply(ob, request.getPositionalArguments(), request)
File "/usr/lib/python2.7/dist-packages/zope/publisher/publish.py", line 107, in mapply
  return debug_call(obj, args)
Extra information: <schooltool.skin.flourish.zcml_content.FlourishMegaImporter_import.html object at 0xf3501ac>
File "/usr/lib/python2.7/dist-packages/zope/publisher/publish.py", line 113, in debug_call
  return obj(*args)
File "/usr/lib/python2.7/dist-packages/schooltool/skin/flourish/page.py", line 67, in __call__
  self.update()
File "/usr/lib/python2.7/dist-packages/schooltool/export/importer.py", line 1324, in update
  return MegaImporter.update(self)
File "/usr/lib/python2.7/dist-packages/schooltool/export/importer.py", line 1296, in update
  imp.import_data(wb)
File "/usr/lib/python2.7/dist-packages/schooltool/export/importer.py", line 263, in import_data
  return self.process()
File "/usr/lib/python2.7/dist-packages/schooltool/export/importer.py", line 415, in process
  term.remove(day)
File "/usr/lib/python2.7/dist-packages/schooltool/term/term.py", line 140, in remove
  self._schooldays.remove(date)

Tags: import xls
Changed in schooltool:
importance: Undecided → High
status: New → Triaged
assignee: nobody → Alan Elkner (aelkner)
Revision history for this message
guillermo (guillermopisotejada) wrote :

Saludos
Estoy probando Schooltoll para una institución universitaria , instale la versión 2.O en ubuntu , y todo bien , solamente al querer importar datos desde excel ,dio un error , probe con el formato indicado igual da un error , probe tratandop de importar con archivo SCV , la errores , no tengo idea de lo que pueda ser... ¡será la versión 2.0 . si pruebo con otra versión anterior ?gracias

 Excepción XLRDError: Expected BOF record; found 0x4b50

Traza

File "/usr/lib/python2.7/dist-packages/zope/publisher/publish.py", line 132, in publish
  result = publication.callObject(request, obj)
File "/usr/lib/python2.7/dist-packages/zope/app/publication/zopepublication.py", line 207, in callObject
  return mapply(ob, request.getPositionalArguments(), request)

Revision history for this message
Douglas Cerna (replaceafill) wrote :

Guillermo:

La traza que has pegado en tu comentario la obtienes porque tratas de subir un archivo que no es XLS en la opción de Importar Datos (en el URL /import.html). Ese error ya ha sido registrado anteriormente (https://bugs.launchpad.net/schooltool/+bug/904968).

No entiendo esta parte de tu comentario:

"solamente al querer importar datos desde excel ,dio un error , probe con el formato indicado igual da un error"

Trata de importar nuevamente tu archivo XLS y comparte el error que obtienes en ese caso.

Saludos.

Revision history for this message
Tom Hoffman (tom-hoffman) wrote :

Is this still a bug?

Changed in schooltool:
assignee: Alan Elkner (aelkner) → Douglas Cerna (replaceafill)
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.