Page Comparison

If the 3rd party system does not provide a unique timesheet ID, you can add a row to your data import and label it ‘Grouping’, then add values to define the relevant grouping sequence (e.g. 1, 2, 3 etc.). It is important to note that where multiple timesheets for same job and date are required, each row in the import must contain a grouping value.

The values provided for grouping must be able to be sequenced ie; 1, 2, 3, 4 and must be whole numbers. For example, the system will not be able to sequence 1.2, 1.3, 1.4.

Please be aware that if you use alpha numeric numbers to group, the standard sort algorithm places the alpha in order, and then the logic looks at the first number and sorts this first, and then takes the next pass to look for a second number, then orders this etc. As such values like A7, A8, A9, A10, A11 would sort as A10, A11, A7, A8, A9. This would be problematic as the timesheets would be interpreted in the wrong order. If you wish to use alpha numeric, then make sure that the string numbers have the same amount of digits, so the logic will look at the whole number. Using the above example you would supply vales as: A07, A08, A09, A10, A11.