Select Output Format for Reports

You can specify the format for your output for the Reports data. Currently, XML (also known as EIWM) and JSON formats are supported for the Engineering data in the reports. In addition, you can also generate the output in CSV format together with XML or JSON formats. Reports data can be generated in PDF, CSV or XLSX formats. Output is generated based on the mappings specified and the files are placed in the staging area for all formats.

To specify the output format for reports:

1. On the Reports tab, click Options.

   

2. In the Report output format area, select the required output format for report data:

   The following formats are supported:

   • None: Select this option if you do not want to generate report data.

   • PDF: Selected by default, this option enables you to generate the output in the PDF format.

   • CSV: Select this option if you want to generate the output in the CSV format.

   • XLSX: Select this option if you want to generate the output in the XLSX format.

3. In the Engineering Output format area, select the required output format for Model data:

   The following formats are supported:

   • None:Select this option if you do not want to generate an output file with the engineering data.

   • XML (EIWM): Selected by default, this option enables you to generate the output in the XML format (also known as EIWM).

   • JSON: Select this option if you want to generate the output in JSON format.

   • CSV: (Optional) Select this box if you want to generate the output in CSV format together with one of the above formats. If you have selected this option, do the following:

     Note: To avoid overwriting the output files, the CSV option for engineering output format cannot be used together with the CSV option for report output format.

     

     1. From the Available Column names list, select a header column for the CSV file. The column is added to the Column names area.

        Note: The list displays column names generated from characteristics and properties defined in EIWM class mappings for all selected elements.

     2. Repeat the above step to add more column names.

     3. (Optional) After adding the required column names, you can rearrange their order by using the arrow keys.

     4. When Auto-append columns from context is enabled, gateway will automatically generate column names for all engineering data that is extracted based on specific context (Grid, Database view, drawing, and so on).

     5. (Optional) Select the Evaluate All Positions WRT /* check box to specify if the elements must be evaluated from their root nodes in AVEVA™ E3D Design. By default, the check box is cleared.