Rate Engine Plus Data File Format
The following file format conventions apply to all Rate Engine Plus data files that you transfer:
- Oracle Utilities prefers to receive all data as tab-separated value (TSV) files. CSV format is also supported.
- Files must use UTF-8 encoding so that both Latin and non-Latin characters can be supported.
- All files should include a header line containing column names.
- Rows can use "line feed" and "carriage return / line feed" as valid end-of-line separators.
- All fields should be included in each generated file. A field that is not required may contain an empty value, but it should still have tabs (that is, the number of tabs should be the same in every row of the file).
- It is strongly recommended that files be compressed for transfer. Zip and gzip compression are supported, but gzip is strongly preferred. Files can be sent uncompressed, but compressing the files will greatly decrease the transfer time. Zip files must contain only one file each. There should be no directories in the zip file.
- Do not remove columns or add columns to the middle of the file. You must coordinate with your Delivery Team before adding columns to the end of a file.