Skip to content

Error Handling

Error Types

The following types of errors are handled by the UI5 Spreadsheet Upload Control:

  • Mandatory Fields: The control ensures that all mandatory fields are filled in before submitting data. If a mandatory field is left blank, an error message is displayed.

  • Mandatory Fields Metadata: The control parses the metadata of the entity set and checks if all mandatory fields are filled in before submitting data. If a mandatory field is left blank, an error message is displayed (CAP Annotation).

  • Column Names Mismatch: The control checks if the column names in the uploaded file match the expected column names. If there is a mismatch, such as an additional column that shouldn't be there, an error message is displayed.

  • Data Type Mismatch: The control checks if the data types in the uploaded file match the expected data types.

  • Custom Errors: The control allows you to add custom errors to the error dialog. You can add errors to the messages property of the SpreadsheetUpload control. After the event, the upload is canceled and the errors are displayed in the Error Dialog (see Events for more information).

  • Backend Errors: If the backend service returns an error, it is displayed. In the case of checks during saving (e.g. RAP or CAP), no error is displayed in the draft scenario in Fiori Element Apps as Fiori Element catches these errors.

  • Duplicate Columns: The control checks if the uploaded file contains duplicate columns. If there is a duplicate column, an error message is displayed.

  • Max Length: The control checks if the length of the data in the uploaded file does not exceed the maximum length of the corresponding field. If the length exceeds the maximum length, an error message is displayed.