How to Extract Citect SCADA 2016 Alarms into a CSV File?

Question:

Hello everyone, I am a newcomer to this forum and the realm of automation. The image displayed here typically showcases purple text related to Historical Events and Active Alarms. I am interested in extracting this information into a csv file for further analysis or visualization. Currently interning at an open-pit mining company, I have been unable to find a solution within the company and am seeking alternative methods to access and analyze this data. As someone unfamiliar with automation, I am eager to explore and create an engaging end-of-studies project. I am also curious to know if this task is achievable within the Siemens platform. Thank you in advance for your help!

Top Replies

Hello, I noticed that this post is a few months old and hasn't received any responses yet. From what I remember, previous versions of Citect (such as those prior to 2016) stored alarm history in a text file on the server. Each event was recorded on a single line in chronological order, requiring some processing to analyze factors such as active alarms, acknowledgments, and inactivity. I hope this information is useful to you.

Welcome to the forum! Your project sounds fascinating. With data extraction, you might want to look into Siemens's Process Historian tool. It can gather, store, and sort data, then export this information into csv or excel files for your analysis and visualization tasks. For the automation side, you might need to work with their WinCC platform. If you're new to this, consider reaching out to Siemens's support; they often have comprehensive guides or tutorials that could aid you with your project. Aside from that, using a Python script to automate the extraction could be beneficial too. There's a variety of data scraping libraries available in Python, such as BeautifulSoup, that you might find useful. Good luck with your project!

Welcome to the forum and the world of automation! It sounds like a great project you're undertaking. Siemens does have various solutions that might help you with data extraction. I'd recommend looking into WinCC, which has some built-in capabilities for recording and exporting data in different formats, including CSV. Apart from that, you could use scripting languages such as Python to automate the task. They are efficient for web scraping and data extraction. Python also has libraries such as pandas, which can directly export your data into a CSV file. As you advance, you'll discover that the possibilities are endless in automation. Do keep us posted about your progress!

Hey there and welcome to the forum! It's great to see your enthusiasm for data extraction and automation. As a matter of fact, you're in luck! Siemens has a robust Data Management Software system that allows extraction of this information. You should be able to access various event logs and export them in .CSV format for your project. However, it might be a bit intricate for a newcomer, so I'd suggest you to refer some of the tutorials that Siemens provides, or ask your immediate superior or IT team member for assistance. Also, do keep learning about automation, it's a valuable skill in today's world not just in mining, but almost all industries. Good luck on your project!

Welcome to the forum and the fascinating world of automation! As far as I know, Siemens provides several data extraction methods. If you're working with a SCADA system such as WinCC, for example, you can exploit SQL Server Reporting Services to extract data which can then be formatted into a .csv file. As for the extraction from within the automation platform, it would mostly depend on what system the company is working with. There's always a solution out there, so don't get discouraged. Also, I would suggest familiarizing yourself with common data extraction techniques used in automation; this will not just aid in your project currently but will also be beneficial for your career moving forward. Good luck with your project!

More Replies →

Streamline Your Asset Management
See How Oxmaint Works!!

✅   Work Order Management

✅   Asset Tracking

✅   Preventive Maintenance

✅   Inspection Report

We have received your information. We will share Schedule Demo details on your Mail Id.

To add a comment, please sign in or register if you haven't already..   

Frequently Asked Questions (FAQ)

FAQ: 1. Question: How can I extract Citect SCADA 2016 alarms into a CSV file?

Answer: Answer: There are various methods to extract alarms from Citect SCADA 2016 into a CSV file, such as using scripting or third-party tools.

FAQ: 2. Question: Is it possible to export Historical Events and Active Alarms data from Citect SCADA 2016 for further analysis?

Answer: Answer: Yes, it is possible to export Historical Events and Active Alarms data from Citect SCADA 2016 into a CSV file for further analysis or visualization.

FAQ: 3. Question: Can I extract alarms data from Citect SCADA 2016 for a project at an open-pit mining company?

Answer: Answer: Yes, you can extract alarms data from Citect SCADA 2016 for analysis or visualization, which can be beneficial for projects in industries like open-pit mining.

FAQ: 4. Question: Is it feasible to access and analyze alarm data from Citect SCADA 2016 if I am new to automation?

Answer: Answer: Yes, even if you are new to automation, there are alternative methods available to access and analyze alarm data from Citect SCADA 2016, such as extracting data into a CSV file.

FAQ: 5. Question: Can I achieve the task of extracting alarms into a CSV file within the Siemens platform?

Answer: Answer: While Citect SCADA 2016 is not

Ready to Simplify Maintenance?

Join hundreds of satisfied customers who have transformed their maintenance processes.
Sign up today and start optimizing your workflow.

Request Demo  â†’