This example shows how to read all alarms and corresponding parameters from L5X file and store them as Excel. file
Objectives:
Extract Alarm Tags and Alarm Parameters from ControlLogix program and store them for further review or processing.
Requirements:
1) Creation of a Digital Alarm table in Excel with alarm tag and alarm parameter information.
2) Creation of an Analog Alarm table in Excel with alarm tag and alarm parameter information.
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 - Reading from L5X to Excel.kiptr"
(go to the end of this page to find attachments)
Step 5
Navigate to Document element (with tag PRJXXX-PSEC001-SCRIPT001-DOC001)
Step 6
Attach the L5X file "KiptrExample.L5X"
(go to the end of this page to find attachments)
Step 7
Navigate to the script element (tag PRJ001-PSEC001-SCRIPT001) and click "Run Script".
Step 8
Save the file (xlsx). You can now open it in any Excel editor and check the list of alarms.
| 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. |