Design Import

This node imports designs from CSV format, JSON format, or a Spreadsheet file if the InPath input slot is connected, or a file is chosen in the node dialog box. It exports the designs from the ODesigns output slot. The provided designs from the ODesigns slot can be forwarded to, for example, a Data Mining node to create an OMDB file out of it.

You can import designs using one of the following methods:

  • Import settings: Select the appropriate settings for the chosen file.

  • Import settings file: Import designs using a prepared JSON settings file. You can prepare the settings file using the Design Point Import Wizard in postprocessing. When you work up all the pages and are confident with the design container visible on the lower part on the last page, you can export settings with the multi-action button on the lower left side of the wizard.

CSV Format

After selecting the CSV file, the Dimension selection table is displayed. In the Import type column, you can select how each dimension will be imported:

  • Parameter

  • Response

  • Design id

  • Don't import

The format of the exported *.csv files is:

  • The first line can consist 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 Delimiter selection (tabs are selected by default).

JSON Format

You can import JSON design table formats in this node. These JSON files can come from:

  • Exporting a JSON file from an optiSLang design table.

  • Exporting a JSON file from a DesignXplorer design table.

JSON format contains the required information about the design container, so no further settings are needed.

Spreadsheet File

After selecting the spreadsheet file, the following is displayed:

  • Sheet name text field: Enter the correct name of the sheet.

  • Dimension selection table. In the Import type column, you can select how each dimension will be imported:

    • Parameter

    • Response

    • Design id

    • Don't import

The format of the exported *.ods, *.xls or *.xlsx file is:

  • The first row can consist 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.

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
InPathx Path location of the file to be imported.x
SettingsFilePathx  Path location of the settings file. 
Design x A design to be exported. 
Designs x Container of designs to be exported.