•Spreadsheet Validation – The Wizard will validate the information based on the data type of the column e.g. date, number, a string of characters and any associated LOV's.
•Server side Validation – The upload process will perform the spreadsheet validation and then attempt to execute the transaction. Any database errors, or user-defined errors that prevent the transaction being uploaded will be written back into the worksheet.