There are five types of fields available when importing data, as listed below. The field type dictates the type of information that can be specified for the field and how the value should be formatted.

• Text
Text fields are used to specify text values, such as names, descriptions, and codes. Text fields are limited to the number of characters shown in the Size column.

• Set
Set fields are those for which only pre-defined values are valid. For example, when specifying the accrual method for a time off type, each of the available options corresponds to a pre-defined value that must be entered in the import file.

• Date
By default, date fields must be in the format dd/mm/yyyy, for example 25/01/2007. However, this format may be changed in the rtserver.ini file.

• Time
Time fields can be formatted using any standard time format accepted by Web TimeSheet. For example, 5:30 PM, 17:30, or 17.50 may be used to import a time entry of 5:30 PM.

• Numeric
Numeric values can be either whole numbers or decimals.

• Boolean
Boolean fields are used to set a flag to either Yes or No. For example, when adding a client, a boolean field is used to specify whether the client should be enabled in Web TimeSheet. While typically the values Yes or No are used for boolean fields, additional values are valid. Instead of Yes, the values YES, Y, y, and 1 are also acceptable. NO, N, n, or 0 can be used in place of No.

Free trial

Hassle-Free Time Tracking Software from Replicon. Start your Free Trial Today!

Get Started