The following procedure describes how to use the Settings Dialog Box to import I/O signals and signal assignments into a database from a file with comma delimited values.
Specify the path to the spreadsheet file in the File Path field. You can enter the path manually, or click Browse to navigate to the file’s location.
Select the Spreadsheet definition page, and enter a character in the Delimiter field (for example, a comma) which defines the start of each entry.
In the Column assignments window, the numbering should match the spreadsheet column numbers where I/O Designer can locate information for items such as Signal name, Signal type, Signal direction, and so on. Use the column index column to move the assignments up or down in the list.