This example shows how to write the alarms with predefined attributes from Excel file into the L5X file.


Objectives:

Create Alarm tags and Alarm descriptions in a ControlLogix project from alarm definitions in an Excel file.


Requirements:

1) Creation of Digital Alarm Tags and Alarm Descriptions.

2) Creation of Analog Alarm Tags and Alarm Descriptions.

Step 1

Project Interface


Step 2

Enter all the needed information (name, status, etc.) and save the Project Element (PRJ001)


Step 3

Right-click on the Project Element and select "Import Branch"


Step 4

Point to the import file "Alarms - Writing from Excel to L5X.kiptr"

              

(go to the end of this page to find attachments)


Step 5

Navigate to Document element (with tag PRJ001-PSEC001-SCRIPT001-DOC001)


Step 6

Attach your L5X project file where you want your alarms stored or use our example file "KiptrExample.L5X".


(go to the end of this page to find attachments)


Step 7

Navigate to Document element (with tag PRJ001-PSEC001-SCRIPT001-DOC002)


Step 8

Attach your Excel file with alarms and their properties or use our example file "Alarm_List.xls".

(Please check our example for the list of properties and alignment on the sheet)


(go to the end of this page to find attachments)


Step 9

Navigate to the script element (tag PRJ001-PSEC001-SCRIPT001) and click "Run Script".


Step 10

Save the generated project file (L5X), and open it in Logix Designer and check the created code.


Note: Keep in mind that scripts may create errors if something goes wrong. Errors are shown in the browser console. To open the console, right-click anywhere on the web page and select "Inspect element" or "Inspect". Once the tools pane opens navigate to the "Console" tab. The procedure may be different depending on the browser you use.