Data Format Rules

This page provides a guide on the Data Format Rules.

When using the import.csv file there are a number of data formatting rules that need to be observed. These rules are tabulated below and apply to both new records being loaded into brevity as well as existing records that are being updated.

Data Attribute	Data Format Rule	Expected input format

Data Attribute	Data Format Rule	Expected input format
`Date`	`yyyy-mm-dd`	`2020-02-27`
`Time`	`YYYY-MM-DD HH:MM:SS`	`2020-02-27 23:59:00`
`Boolean`	`1 for yes / 0 for No`	`1`
`Dropdown`	`Name of Selection + dropdown value`	`3422 Bus`
`Look up Field`	`Name of the look up + ID of the record`	`10 Casual`