Design Export

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:

CheckboxWhen SelectedWhen Cleared
Use legacy modeThere is no extra section for dimension names, design values and names are exported side-by-side.
  • Dimension names are exported separately from design values.

  • Along with design container values, design_status is exported, containing design_id, feasible state, design status, and the pareto_design flag for each design.

Use prettified modeJSON 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 Show additional options.

OptionDescription
Auto-save behavior

Select one of the following options:

  • No auto-save

  • Actor execution finished

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, No auto-save is selected.

Retry executionWhen selected, retries a node execution if it failed. Set the following options:
  • Number of retries: Maximum number of retry attempts.

  • Delay between attempts: Time in milliseconds between each retry attempt.

Slots
Slot NameSlot TypeData TypeDescriptionConnection Required
InOut
CSVDelimiterx Delimiter for data of CSV file. This can be a character, space, or tab separating the elements in each line.x
MDBPathx Path location of the file which is to be extracted.x
OutPathx Optional path of the csv file. Default "out.csv" 
Designx A design to be exported.
Designsx Container of designs to be exported.
OutPathx Path of the extracted csv file.