Provides options for merging the PLC database file.
The Spreadsheet to PLC/IO utility uses the module category to calculate the insertion point of a module.
Before AutoCAD Electrical 2009, the Spreadsheet to PLC/IO utility determined the module category based on the value in the DESCRIPTION field or the database table name. For example, if the DESCRIPTION field contained the string “*IN*”, it was considered an input module. In 2009 and later, the PLC database contains a CATEGORY field.
The Migration utility compares the values in the DESCRIPTION field of the PLC database to values you assign as input, output, or combination. If a match is not made, the database table name is compared. If there is a match to the DESCRIPTION field or table name, the CATEGORY value is entered for that module.
|
Input |
Enter text, comma delimited, used to match to the DESCRIPTION value. If there is a match, the module is assigned a CATEGORY value of 1 for input. |
|
Output |
Enter text, comma delimited, used to match to the DESCRIPTION value. If there is a match, the module is assigned a CATEGORY value of 2 for output. |
|
Combination |
Enter text, comma delimited, used to match to the DESCRIPTION value. If there is a match, the module is assigned a CATEGORY value of 3 for combination. |
|
Overwrite existing settings |
Select to overwrite any existing CATEGORY values. If not selected, only blank CATEGORY fields are modified. |
The Migration utility updates all tables in the PLC database based on these values.
Blank spaces within the text are included as part of the search string. For example, “IN{space}*” matches “IN module” but does not match “INPUT”.
If no match is made for a module, the CATEGORY field is not modified. Use the PLC Database File Editor to assign a category to a module. Select a “Spreadsheet to PLC I/O Utility Insertion Point” option on the Module Specifications dialog box.