Page History

...

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

Image Added

Unsuccessful imports will also show the error message and details will be in the pink highlight.

Image Added

Template Guide

Column	Header/Column Name	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	Yes			Must match the Role name in Ascora If left blank, import won't create labour line but only timesheet details
O	NOTES
P	APPLY TIMESHEET RULES	Yes			Put YES if Timesheet Rules apply otherwise, put NO. This is the settings in Administration → Timesheet Rules such as when Time and a Half starts getting charged and when Double Time starts getting charged.

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

...