Query Form CSV Export
- Last UpdatedMay 10, 2023
- 2 minute read
While performing a CSV Export of the Query Forms, you must configure the following details as part of the Export Definition:
Primary data separator: This is the character (or characters) that will separate the columns of data in the CSV file.
Secondary data separator: Columns might contain many values. For example, in the Object aliases column, if one of the items in the Search results is 'V-2', then the aliases for this item could be 'SRP|VPD|/V-2' and 'SRP|PDS|Valve-2'. In the CSV file, the secondary data separator in the Object aliases column would separate these two values.
Include Clash Information: When choosing the primary and secondary data separators, you must ensure that the actual values that appear in the columns in the CSV file do not contain either of these separators. In this case, the user should choose a different separator and export the data again.
Selecting this option includes information at the bottom of the CSV file about any clashes detected during the creation of the file where values did contain instances of either of the separators. The line number (in the file) and the column number of any clashes are given. If no clashes were detected, then no clash information is included in the file.
Include Column Header Information: Select this option if the user would like an initial record in the CSV file that contains a header for each column. Selecting this option causes additional fields to be made visible on the page where the user can insert the header text for each column. If the user leaves a field blank, then a system defined header will be used which is based on the column type. A text box with the text "UOM" will be displayed next to the attribute field when this option is selected, and a Property is added in the User Defined Columns section of the Export Search Results Screen.
Format for Excel: Select this option if the user intends to view the downloaded CSV file using Microsoft Excel. Using this option prevents Excel doing its own (sometimes misleading) interpretation of the CSV data.