Understanding ‘Field Types’ required while formatting a CSV file to Import into Web TimeSheet
Find resources designed to help you get the most from Replicon
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 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 fields are those for which only pre-defined values are valid.
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.
By default, date fields must be in the format dd/mm/yyyy, for example 25/01/2007.
Time fields can be formatted using any standard time format accepted by Web TimeSheet.
Example: 5:30 PM, 17:30, or 17.50 may be used to import a time entry of 5:30 PM.
Numeric values can be either whole numbers or decimals.
Boolean fields are used to set a flag to either Yes or No.
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.
For most data types, the command includes a boolean field to specify whether the entry should be disabled. As a result, a negative value (No) is typically used to indicate the entry should be enabled.