Workbook upload errors with migration to new student ID scheme [2020:H]

[Ghislain Hachey]

The 20 characters constraint is not long enough in the DB. And we need to include data validation with clear user feedback for this as well as the error returned by system currently is

And the error in the SQL Server when loading with XlListUtilities

‌

[Brian Lewis]

Size of stuCardID increased to 40, in Student_ and related table ExamCandidates.

Trying to provide a validation for this i suggest we leave for now, noting from here:

https://blog.sqlauthority.com/2019/04/08/sql-server-identify-the-columns-responsible-for-string-or-binary-data-would-be-truncated/

‌

that Sql Server 2019 introduces a ore detailed error message that supplies the table, column and truncated value; which wold be relayed to the client as the code currently stands.

‌

[Brian Lewis]

fix(workbook): support student card id up to 40 chars Resolves #794

→ <<cset 50cfeebd0a4f>>