SchoolTool error

Asked by Chad on 2015-11-16

Was exporting schooltool spreadsheet this morning and it threw out an error.

System failure.

Ticket nr. 999f0a90-3058-440d-afdf-458872411375.

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 710, in export_section_enrollment
  ], ws, row=row)
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:
Open
For:
SchoolTool Edit question
Assignee:
No assignee Edit question
Last query:
2015-11-23
Last reply:
2015-11-23
Tom Hoffman (tom-hoffman) said : #1

It seems you've run into excel's row limit. Do you have a lot of sections for some reason?

Chad (chadelp) said : #2

Yes. 2014 has 1221 sections and 2015 has 1358. We need help urgently as marks are to be entered soon.

Tom Hoffman (tom-hoffman) said : #3

OK, we've made this a high priority, but we've got some work we've got to finish first.

Is there some particular reason you need to do this to enter marks?

Chad (chadelp) said : #4

I am the network administrator, the team needed me to export a master list which I would then use to create passwords for all the new persons. I know the password could be entered directly on the web, but they wanted a sheet on excel with all the details.

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.