Skip to end of metadata
Go to start of metadata

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.




2. Enter the information in the Excel template.



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.




4. Select your Import file and click Open.




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


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


Template Guide

ColumnHeader/Column Name

Compulsory Field

Default Value If Not SpecifiedPossible Values (If Applicable)

Notes

ASTART DATEYes

Use format DD/MM/YYYY
BSTART TIMEYes

Use format HH:MM AM/PM or HH:MM in 24 Hour
CEND DATEYes
Yes/No

Use format DD/MM/YYYY

DEND TIMEYes

Use format HH:MM AM/PM or HH:MM in 24 Hour
EUSERYes

Must match User name in Ascora
FCHECK IN TYPE
GeneralSee Table Below
GQUOTE OR JOB NUMBER


If no Quote/Job number is specified or no match is found, Timesheet will be imported as a General timesheet
HSECTION NUMBER


The display number of the Section in Ascora (e.g. 01, 02, etc)
ISTAGE


The Stage name as entered in Ascora
JACTIVITY


Must match the Activity name in Ascora and be applicable for the Stage
KINCLUDES MEAL BREAK
FalseYes/No
LMEAL BREAK HOURS


Use decimal format (e.g. 7.5). If Includes Meal Break is true and Hours not specified, will use default lunch duration.
MRATE TYPE
NormalSee Table Below
NLABOUR ROLEYes

Must match the Role name in Ascora

If left blank, import won't create labour line but only timesheet details

ONOTES



PAPPLY TIMESHEET RULESYes

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.

Check In Type

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

GeneralGeneral
JobJob, Job Check In
QuoteQuotation, Quote
TravelTravel


Rate Type

NormalDefault
Time and a HalfTime and a Half, 1.5
Double TimeDouble Time, 2
Double Time and a HalfDouble Time and a Half, 2.5



  • No labels

0 Comments

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account.