Student Numbers as Strings or Numeric Values

[applebyter]

Problem
When adding students to a course enrolment, student numbers must be formatted as text. If they are numeric values the file is reported as being valid but generates an error and does not load the students.

Solution
Revise the file loading code to convert numeric values to strings.

Alternative Solution
Alternatively, revise the parsing code so it does not assume student numbers are strings. Currently it uses the .substring method to extract the student number. (This seems to be a clumsier fix.)

Context
The file generated by Allocate+ with student room allocations is an Excel file that has student numbers formatted as text. The tool loads this file correctly.

If someone generates this file using another approach or converts the Excel file to CSV, the student numbers will be numeric values.