SchoolTool error

Asked by Chad

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:
Last reply:
Revision history for this message
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?

Revision history for this message
Chad (chadelp) said :
#2

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

Revision history for this message
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?

Revision history for this message
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.

Revision history for this message
fhgfjnf grfdeg (pale939) said :
#5

There are some very useful softwares are available these days to solve this issue you can click here https://organiselife.com.au/ and learn about it.

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.