What are the different field types while formatting a CSV file for import ?
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. 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.
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 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 values can be either whole numbers or decimals.
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.