The input data file should be a CSV-formatted text file. A comma (“,”) will be used to separate each column. A carriage-return+line-feed character combination will be used to terminate each row. If a carriage-return+line-feed character combination must be included as part of the data of a single column, the column’s data should be enclosed in double-quotes. The same is true if a comma must be included as part of the data of a column. If a double-quote character must be included as part of the data of a column, then it should be “escaped” by being immediately proceeded by another double-quote character. (e.g. "Hello world" would be encoded as ""Hello World"" if the double-quotes were required as part of the value for a field.)

The file will consist of one header row, followed by one or more data rows. The header rows explicitly state which fields will be updated.

Immediately following the header rows there should be one or more data rows. Each data row shall contain the necessary command, key and data values needed to import one row of data into the database table.

The first non-blank row in the import file shall be interpreted as the header row. The header rows shall be used to define which fields will be imported. There are 6 required fields in the header:

Following the header row are one or more data rows. All subsequent columns, should contain data. The field order should exactly match the field order specified in the header row, as should the field count. Each data row will contain the following mandatory columns: