Page History

...

5. Once the data is already imported, you would see a window displaying the results of the Import.

Image Added

Template Guide

Column	Header	Compulsory Field	Default Value If Not Specified	Possible Values (If Applicable)	Notes
A	START DATE	Yes			Use format DD/MM/YYYY
B	START TIME	Yes			Use format HH:MM AM/PM or HH:MM in 24 Hour
C	END DATE	Yes		Yes/No	Use format DD/MM/YYYY
D	END TIME	Yes			Use format HH:MM AM/PM or HH:MM in 24 Hour
E	USER	Yes			Must match User name in Ascora
F	CHECK IN TYPE		General	See Table Below
G	QUOTE OR JOB NUMBER				If no Quote/Job number is specified or no match is found, Timesheet will be imported as a General timesheet
H	SECTION NUMBER				The display number of the Section in Ascora (e.g. 01, 02, etc)
I	STAGE				The Stage name as entered in Ascora
J	ACTIVITY				Must match the Activity name in Ascora and be applicable for the Stage
K	INCLUDES MEAL BREAK		False	Yes/No
L	MEAL BREAK HOURS				Use decimal format (e.g. 7.5). If Includes Meal Break is true and Hours not specified, will use default lunch duration.
M	RATE TYPE		Normal	See Table Below
N	LABOUR ROLE				Must match the Role name in Ascora
O	NOTES

When importing Timesheet data, the mapping table below can be used to ensure the Timesheet is imported as the expected type.

...