Interpreter Manual Item Import File Format Validation

When you attempt to create a manual item import batch the system performs validation to ensure that the Interpreter Review module can read the contents of the import file.

The following conditions must apply to the import file:

• the first row must consist of column headers and each column header must be unique

• individual fields within the file must be separated by a delimiter character, such as a comma, tab, pipe or some other type of character that must be specified at the time of import.

• no grouping rows, such as summed totals, can exist in the file

• each row must contain data that can be imported independently of any other row

• the first row that contains no data signals the end of the file (for XLS or XLSX files only) all dates must be in the format dd/mm/yyyy

• all times must be in 24 hour format hh:mm.

Applying Formatting to Import Files

Data that is output by a third-party application may not be in a format that is readable by the Interpreter Manual Item Import module. Therefore, an import file will usually require some level of formatting before it can be uploaded. The formatting can be applied manually or via an automated macro script.

Import File Examples

The example below shows an example of an incorrectly formatted import file:

In the example above, the import data is not formatted correctly because the data includes grouping rows with summed totals. The next example shows the same data but this time formatted correctly to remove the grouping and grouped totals: