...
For the STAR tag/value format, you must follow these guidelines:
Set up data records using a tag/value format.
Use a colon (:) as the separator.
Use a tilde (~) as an end-of-line indicator.
With the CSV format, a header record is required for message streams processing, using the letter F preceding the Tag # for the column represented. For example, Entity ID (tag 1163) is represented as F1163 in the header row. All subsequent rows in that column represent the value to be sent for Entity ID. For the CSV streams, the message stream reads the column header, not the column number. This allows the CSV format to include only those columns that are needed.
For the CSV format, you must follow these guidelines:
Set up the data file to contain a header record with the STAR tag number that each column represents. Use the letter F to precede the tag in the header row.
Separate the data record values with a comma ( , ). You can also change the RuleSet rule in the default message stream to use any suitable delimiter, such as the pipe delimiter (|).
If the value contains a comma, enclose it in quotation marks.
Info | ||
---|---|---|
| ||
For each default message stream, sample data files for supported message types are included as part of the Web installation. |