Q: Default end date and description for leave

Selecting the Default end date and description for leave option in your user settings will cause UpSheets to automatically set the following values on import: The result of this setting being enabled is that you do not need to provide the end_date or description in your file.

Question 1

File Formats for Combined Timesheets, Leave and Adjustments in a single file (Australia)

Accepted Answer

UpSheets allows you to upload multiple different transaction types in a single file, so long as all of the required fields are included.

For more information on individual file formats see File Formats for Timesheets, Leave and Adjustments (Australia)

NOTE: All columns must be included in the file, even if their values are left blank. This is required to keep formats consistent and allow UpSheets to determine the type of transaction being uploaded automatically.

PLEASE NOTE - IN ALL OF THE EXAMPLES, YOU MAY USE A SINGLE 'FULL_NAME' FIELD INSTEAD OF 'FIRST_NAME/LAST_NAME'

PLEASE NOTE - IN ALL OF THE EXAMPLES, YOU MAY USE A SINGLE 'FULL_NAME' FIELD INSTEAD OF 'FIRST_NAME/LAST_NAME'

You may optionally provide a Start Time and End Time column instead of the Hours column

Question 2

Using Start Time and End Time instead of Hours

Accepted Answer

Most file formats require a column for Hours in order to upload data, but it is also possible to provide a Start Time and End Time column and have UpSheets calculate the hours automatically.

To do so, select the Enable Start/End Times option on the Import screen when importing your file:

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/3hKtDQmL6g/start_end.png (start_end)

On the following screen make sure you select columns for Start Time and End Time. You may optionally also select a column for Hours* which will be used if the Start Time and End Time are not set.

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/AdXfkcueFe/times.png (times)

If all fields are provided, the Start Time and End Time will be used instead of Hours

Question 3

File Formats for Combined Timesheets, Leave and Adjustments in a single file (NZ & UK)

Accepted Answer

UpSheets allows you to upload multiple different transaction types in a single file, so long as all of the required fields are included.

For more information on individual file formats see File Formats for Timesheets, Leave and Adjustments

NOTE: All columns must be included in the file, even if their values are left blank. This is required to keep formats consistent and allow UpSheets to determine the type of transaction being uploaded automatically.

PLEASE NOTE - IN ALL OF THE EXAMPLES, YOU MAY USE A SINGLE 'FULL_NAME' FIELD INSTEAD OF 'FIRST_NAME/LAST_NAME'

Timesheet, Leave and Adjustment file Format - Combined NZ ONLY

(Download Sample)

Timesheet and Adjustment file Format - Combined NZ ONLY

(Download Sample)

Timesheet and Leave file Format - Combined

(Download Sample)

Leave and Adjustment file Format - Combined NZ ONLY

(Download Sample)

PLEASE NOTE - IN ALL OF THE EXAMPLES, YOU MAY USE A SINGLE 'FULL_NAME' FIELD INSTEAD OF 'FIRST_NAME/LAST_NAME'

You may optionally provide a Start Time and End Time column instead of the Hours column

Question 4

Default end date and description for leave

Accepted Answer

Selecting the Default end date and description for leave option in your user settings will cause UpSheets to automatically set the following values on import:

The result of this setting being enabled is that you do not need to provide the end_date or description in your file.