Program Participation Data File Format

All program participation data files generated by your extract program need to meet the following standards to load successfully into the Oracle Utilities Opower platform:

• Oracle Utilities prefers to receive all data as tab-separated value (TSV) files.
• Files must use UTF-8 encoding so that both Latin and non-Latin characters can be supported.
• All rows should have the same number of tabs even if some fields have null values. It is important that null values are represented by empty strings and not denoted by /N, NA, null, or another value.
• Rows can use "line feed" and "carriage return / line feed" as valid end-of-line separators.
• 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.