Timesheet import format

Column

Column Title

Description

System Data Entry Field

Data Type

Format

Mandatory

Validation

Examples

A

Project Code

Code used to identify the project that was worked on

Projects -> Summary -> Project Code

Text

Any combination of numbers, characters and punctuation

Yes

This Project Code must be present within your system.

There cannot be duplicate in your system.

MA331

B

Task Name

The name of task or Work Stage that was worked on

Projects -> Work Structure -> Task Name

Text

Any combination of numbers, characters and punctuation

No

The task must be present within your system.

Cannot be duplicate (including sub tasks)

Stage A - Feasibility

C

Work Detail

Details of the work done

Timesheet -> Current Timesheet -> ‘Add Extra Information’ Icon -> Work Detail

Text

Any combination of numbers, characters and punctuation

No

This Work Detail must be present within Admin -> Company Settings -> Work Detail

Cannot be duplicate

Travel Time

D

User

The User who did the work

Admin -> Users -> First Name & Last name

Text

<first name> <last name> or

<last name>, <first name>

Yes

This User must be set up in Admin -> Users.

You can import time for deleted user. You cannot import time to generic users.

Cannot be duplicate

Phil Goodman OR

Goodman, Phil

E

Date

The date the hours were worked

Timesheet -> Current Timesheet

Date

DD/MM/YYYY OR

DD-MM-YYYY OR

DD.MM.YYYY

OR

DD MM YYYY

OR

DD/MM/YY OR

DD-MM-YY OR

DD.MM.YY OR

DD MM YY

Yes

Must be between 1/1/1900 and 1/1/2079

If using a 2 digit year, less than 50 will mean 2000, more than or equal to 50 implies 1900

Must be a real date (e.g. not 31-Feb)

1/3/2007 OR

1-3-2007 OR

1.3.2007 OR

1 3 2007 OR

01/03/2007 OR

01-03-2007 OR

01.03.2007 OR

01 03 2007

F

Core Time

Number of core hours worked

Timesheet -> Current Timesheet

Number

amount.decimal

No (If empty will assume 0)

Positive number

Max hours = 35791394

7 OR

4.5

G

Extra Time

Number of hours worked outside of Core hours (This is costed at the Global Extra Time Rate set in Admin -> System Settings -> Approval Setting)

Timesheet -> Current Timesheet -> ‘Add Extra Information’ -> Extra Time

Number

amount.decimal

No

Positive number

Max hours = 35791394

2 OR

1.5

H

Notes

Additional Information about the hours worked

Timesheet -> Current Timesheet ‘Add Extra Information’ -> Notes

Text

Any combination of numbers, characters and punctuation

No

Went to visit client, got stuck in traffic.