Migrates the PLC Database to include the module category field.
FindBefore 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 or later, the PLC database contains a CATEGORY field.
The Spreadsheet to PLC/IO utility uses the module category to calculate the insertion point of a module.
The PLC Database 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 PLC Database Migration utility updates all tables in the PLC database based on these values.
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.
If you do not get the desired results you can run this utility again.