This section lists the errors that a Worksheet could have.
The Worksheet does not have the expected number of columns.
The Worksheet Header column names do not have the expected number of columns.
The number of rows in the Worksheet matches the expected number of rows GalaxyeClinical derived from the CDASHIG PDF.
A Worksheet column contains a null value when CDASHIG PDF says the column should contain a string or number.
The length of the data in a Worksheet column is out of range according to the rules that GalaxyeClinical defined for Worksheet columns after reviewing the CDSAHIG PDF.
If the App detects a worksheet error, it:
Logs the exception.
Sends an email containing details about the error to firstname.lastname@example.org.
Redirects the user to an "Error" page.
The "Error" page asks the user to forward a copy of the logs to email@example.com to troubleshoot.
Third-party code that reads Excel Worksheets or performs operations on the database requires particular attention to reduce the risk of errors.
To reduce risks, the eClinical MDR App wraps calls to third-party code, which performs operations on Excel spreadsheets and the database, in try/catch blocks.
If an error occurs, the code in the catch block logs the error, sends an email to firstname.lastname@example.org, and redirects the user to an "Error" page.