SchoolTool export issue

Asked by Chad on 2016-09-23

The new school year has begun and we usually export the school, advance the year and import the changes. But we cannot as we got this error. Your assistance is critical as the school admins are on edge.

System failure.

Ticket nr. e3d2fdfe-3b16-4db4-b788-c8237d87374e.

Please contact your administrator.

Exception
row index (65536) not an int in range(65536)
Traceback
File "/usr/lib/python2.7/dist-packages/schooltool/task/tasks.py", line 184, in runTransaction
  result = callable(*args, **kw)
File "/usr/lib/python2.7/dist-packages/schooltool/report/report.py", line 451, in execute
  report_file = self.renderToFile(renderer, *args, **kwargs)
File "/usr/lib/python2.7/dist-packages/schooltool/report/report.py", line 500, in renderToFile
  self.renderReport(renderer, stream, *args, **kw)
File "/usr/lib/python2.7/dist-packages/schooltool/export/export.py", line 935, in renderReport
  workbook = renderer(*args, **kw)
File "/usr/lib/python2.7/dist-packages/schooltool/export/export.py", line 920, in __call__
  self.export_sections_enrollment(wb)
File "/usr/lib/python2.7/dist-packages/schooltool/export/export.py", line 737, in export_sections_enrollment
  ws, year, term, section, row=row)
File "/usr/lib/python2.7/dist-packages/schooltool/export/export.py", line 718, in export_section_enrollment
  ws, row=row, col=0)
File "/usr/lib/python2.7/dist-packages/schooltool/export/export.py", line 301, in print_table
  self.print_row(cells, ws, row=(row+y), col=col)
File "/usr/lib/python2.7/dist-packages/schooltool/export/export.py", line 306, in print_row
  self.write(ws, row, col+x, cell.data, **cell.style)
File "/usr/lib/python2.7/dist-packages/schooltool/export/export.py", line 155, in write
  ws.write(row, col, data, style)
File "/usr/lib/python2.7/dist-packages/xlwt/Worksheet.py", line 1030, in write
  self.row(r).write(c, label, style)
File "/usr/lib/python2.7/dist-packages/xlwt/Worksheet.py", line 1078, in row
  self.__rows[indx] = self.Row(indx, self)
File "/usr/lib/python2.7/dist-packages/xlwt/Row.py", line 42, in __init__
  raise ValueError("row index (%r) not an int in range(65536)" % rowx)
Exception
<ExceptionWithTraceback (ValueError('row index (65536) not an int in range(65536)',))>
Traceback
File "/usr/lib/python2.7/dist-packages/schooltool/task/tasks.py", line 211, in __call__
  result = self.runTransaction('execute', True, self, *args, **kwargs)
File "/usr/lib/python2.7/dist-packages/schooltool/task/tasks.py", line 201, in runTransaction
  raise failure

Question information

Language:
English Edit question
Status:
Answered
For:
SchoolTool Edit question
Assignee:
No assignee Edit question
Last query:
2016-09-25
Last reply:
2016-09-25
Manfred Hampl (m-hampl) said : #1

I do not know anything about SchoolTool, but for me the error message
row index (65536) not an int in range(65536)
seems to indicate that there is too much data in one of the tables (limit is 65536, and you apparently have more).
Do you have a chance to clean up (=remove) old data (from past years etc.)?

Tom Hoffman (tom-hoffman) said : #2

Yes... you have over 65,536 sections, apparently, which exceeds the capacity of our .xls library.

Chad (chadelp) said : #3

What can I do? If I delete data from past years, wouldn't it mean I would lose that data? What if a child needs a transcript?

Manfred Hampl (m-hampl) said : #4

The problem seems to be only in the excel export functionality. I assume that the rest of the application is still working.
Do you see a way to avoid that excel export?

Can you help with this problem?

Provide an answer of your own, or ask Chad for more information if necessary.

To post a message you must log in.