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.

• Input module - inserted near the right or bottom bus line of the ladder.
• Output module - inserted near the left or top bus line of the ladder.
• Combination module - inserted centered between the bus lines of the ladder.

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.

• 1 - Input module
• 2 - Output module
• 3 - Combination 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.