« Import Processing Log   |   Encoding »

Format of Exported Files (Full-featured)

Designer
This manual is in pilot operation.

File and Row Format

Exported files are text files in CSV format (comma-separated). File data is separated into rows. The line break character is LF (line feed).

Each field value is enclosed in double quotation marks. Line break characters within strings enclosed in double quotation marks are not treated as row delimiters. If a field value string contains double quotation marks, they are replaced with two consecutive double quotation marks [1]. Rows in the file are arranged in the following order:

  1. File Header rows (0 or more rows, n rows): The number of rows depends on the form design.

  2. Column Header row (0 or 1 row): Whether this row is output depends on the form design.

  3. Content rows (0 or more rows, n rows): The number of rows depends on the document content.

The number of fields and the content of fields in the File Header rows are specified by the Designer. In the Column Header row and Content rows, the number of fields is either equal to the number of document columns or that number plus one, according to the conditions below.

If the form design specifies that row headers are not to be output, the number of fields matches the number of document columns. In this case, column titles are output in the Column Header row and column values are output in the Content rows.

If the form design specifies that row headers are to be output, one additional field is added at the beginning of both the Column Header row and Content rows. In the Column Header row, this field is included only for alignment and its value is blank. In the Content rows, the row title for each row is output in this field.

Format of Value Fields

In the Content rows, Value Fields output the values of document cells as strings. The content of the output strings depends on the cell Data Type, as described below:

  • For numeric data, values edited with the displayed sign and digit grouping are output. Formatting such as comma separators, decimal points, and the number of decimal places is ignored, but % display is applied. For negative values, the minus sign is prefixed.

  • For string data, the value is output as is.

  • For logical data, one of the strings TRUE or FALSE is output.

  • For enumerated data, the label of the selected value is output.

Encoding

The Encoding applied to export files can be specified by the user during operation and does not depend on the form design. When exporting string data that includes characters other than ASCII characters, such as Japanese characters, it is important to specify the encoding correctly. The following three encodings are available:

  • UTF-8

  • UTF-8 with BOM (fusion_place >= 14.1)

  • Shift JIS

1. These rules regarding the use of line break characters and double quotation marks within each field are designed to ensure compatibility with Microsoft Excel data integration.