Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Current »

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

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

  • No labels