...
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
| 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. |
Check In Type
When importing Timesheet data, the mapping table below can be used to ensure the Timesheet is imported as the expected type.
...