Page History

You can import the data into Ascora by using the standard Timesheet Import template.

Import Process

1. Go to Reports → User Timesheet → Download Import Template.

Image Added

2. Enter the information in the Excel template.

Image Added

Tip
The information you enter in the template must match the data in Ascora. For example, the Labour Role must be identical to the Labour Role setup in Ascora in order to import correctly.

...

3. After completing the necessary details, go back to Reports → User Timesheet but this time, click Import.

Image Added

4. Select your Import file and click Open.

Image Added

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

Header	Compulsory Field	Default Value If Not Specified	Possible Values (If Applicable)	Notes
START DATE	Yes			Use format DD/MM/YYYY
START TIME	Yes			Use format HH:MM AM/PM or HH:MM in 24 Hour
END DATE	Yes		Yes/No	Use format DD/MM/YYYY
END TIME	Yes			Use format HH:MM AM/PM or HH:MM in 24 Hour
USER	Yes			Must match User name in Ascora
CHECK IN TYPE		General	See Table Below
QUOTE OR JOB NUMBER				If no Quote/Job number is specified or no match is found, Timesheet will be imported as a General timesheet
SECTION NUMBER				The display number of the Section in Ascora (e.g. 01, 02, etc)
STAGE				The Stage name as entered in Ascora
ACTIVITY				Must match the Activity name in Ascora and be applicable for the Stage
INCLUDES MEAL BREAK		False	Yes/No
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.
RATE TYPE		Normal	See Table Below
LABOUR ROLE				Must match the Role name in Ascora
NOTES

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

...