This node extracts designs from a design container if the IDesigns or IMDBPath (monitoring database file *.omdb) input slot is connected and exports it as CSV format, JSON format, or as a Spreadsheet file.
CSV Format
The format of the exported *.csv files is:
The first line consists of # (design id), parameter names, response names, and criteria names. It is similar to the content of the design table.
All other lines contain the corresponding values for each design.
Values are separated by the delimiter value chosen in the CSV settings (tabs are selected by default).
JSON Format
The format of the exported *.json file is dependent on the following export settings:
Checkbox | When Selected | When Cleared |
---|---|---|
Use legacy mode | There is no extra section for dimension names, design values and names are exported side-by-side. |
|
Use prettified mode | JSON is exported in a more readable format with line breaks and indentations. | JSON is exported in one line. |
Spreadsheet File
The format of the exported *.ods, *.xls or *.xlsx file is:
The first row consists of # (design id), parameter names, response names, and criteria names. It is similar to the content of the design table.
All other rows contain the corresponding values for each design.
Values are placed separately in cells.
Sheet is named Sheet1 by default. There is no option to change this.
Additional Options
To access the options shown in the following table, click
.Option | Description |
---|---|
Auto-save behavior |
Select one of the following options:
The project, including the database, is auto-saved (depending on defined interval) after calculating this node/system (either when the calculation succeeds or fails). By default, is selected. |
Retry execution | When selected, retries a node execution if it failed. Set the
following options:
|
Slots
Slot Name | Slot Type | Data Type | Description | Connection Required | ||||
---|---|---|---|---|---|---|---|---|
In | Out | |||||||
CSVDelimiter | x | Delimiter for data of CSV file. This can be a character, space, or tab separating the elements in each line. | x | |||||
MDBPath | x | Path location of the file which is to be extracted. | x | |||||
OutPath | x | Optional path of the csv file. Default "out.csv" | ||||||
Design | x | A design to be exported. | ||||||
Designs | x | Container of designs to be exported. | ||||||
OutPath | x | Path of the extracted csv file. |