When you attempt to queue an import batch for processing the system will perform validation of the field mapping that has been applied to ensure that fields that have been mapped are sufficient to theoretically create manual items in interpreted timesheets within Interpreter Review. These validations are described below.
If any of the field mapping or data type validation checks fail, the Import batch will not be queued for processing and an error message will be displayed to identify the reason why the validation failed.
For a full list and description of the fields that can be mapped and the applicable data type of each field, see Mapping Fields.
Field Mapping Validation
When you attempt to queue a Timesheet Import batch for processing, the system will first check if fields have been mapped to identify the FastTrack job order to which each row in the import file corresponds. Specifically, the system will check if any of the following fields have been mapped:
Job ID
Job Alt No
Purchase Order Number
If none of the abovementioned fields have been mapped, Timesheet Import will check if all of the following combinations of fields have been mapped:
Candidate ID or Candidate Alt No or Candidate Full Name or (Candidate Firstname + Candidate Surname)
Manual Item Date or Timesheet Week Ending Date.
Next, if not checked in the above process, the system will check if the Manual Item Date has been mapped.
Where successful, the system will then check if the following items have been mapped:
Pay Code Import Code OR Pay Code Name
Pay Quantity
Pay Rate AND/OR Reimbursement Net AND Reimbursement GST/VAT Value (the import may include both manual and reimbursement items, or one or the other).
Bill Code Import Code OR Bill Code Name
Bill Quantity
Bill Rate
Data Type Validation
When you attempt to queue a Manual Item Import batch for processing the system also checks that the type of data that is provided in each mapped column within the import file matches the data type of FastTrack field to which that column is mapped. For example, if a column header is mapped to a field that must contain a date value, Manual Item Import will check that the corresponding column contains dates and not any other type of data. For example if the date is not the correct format a pop up message will display 'Error: Date contains an invalid format type for the field mapping. Required date format is DD/MM/YYYY.’