This program will take a directory of .L5X files and crawl over the IO trees in each program pulling out the name, device model number and IP Address of each device. The data from each program will be put in its own excel sheet. It also will create a sheet with all available IP addresses for each subnet found in the process.
- Save all of your Allen Bradley .ACD programs in .L5X format in a folder on your desktop
- Run the main.py file and follow the prompts:
- Select your folder with the .L5X files
- Type in a name and select a location for the excel file the program will generate.
- You're all done! Check out your new excel file listing all of your PLC's Ethernet devices with name, device model # and IP Address.
- Also, take a look at the last sheet. If all of your PLC's are on the same subnet, you can use this sheet to find the unused addresses.
- xmltodict
- easygui
- xlwt
- os
- collections
Use:
python setup.py py2exe