Skip to main content

Employee Assignment Flexible Header Import - High-Level File Structure

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 (and, by inference, which tables).  The header row will includ

Updated over 2 weeks ago

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 (and, by inference, which tables). The header row will include fields from a set of tables. The header row does not need to list all the fields in a table, nor does it need to reference each available table; it should only list as many fields as will be imported. The order in which it lists these fields will dictate the order in which the data will appear in the subsequent data rows.

Immediately following the header row 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(s). There must be one value column for each field-definition column declared in the header (though the columns can be left blank when appropriate).

The file should not contain blank lines or lines with nothing but commas either between the data rows or at the end of the file.

Did this answer your question?