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.
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.
- Using Microsoft Access, open the PLC database file ace_plc.mdb.
- Open the table for the series type.
- Remove the CATEGORY field from the table.
- Save the database file.
- In AutoCAD Electrical toolset, run the PLC Database Migration Utility.
- Enter the text strings for each category.
- Click OK.