PLC Database Migration Utility Dialog Box

Migrates the PLC Database to include the module category field.

Find
 Command entry:  AEPLCMIGRATE

Before 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.

Note: 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.

How to re-run the PLC Database Migration Utility

If you do not get the desired results you can run this utility again.

  1. Using Microsoft Access, open the PLC database file ace_plc.mdb.
  2. Open the table for the series type.
  3. Remove the CATEGORY field from the table.
  4. Save the database file.
  5. In AutoCAD Electrical toolset, run the PLC Database Migration Utility.
  6. Enter the text strings for each category.
  7. Click OK.