Hello!
A few of our protocols have an alarm log table, and we would like to automate the process of exporting the table via a C # automation script and the scheduler module. Is this function currently available in the Skyline Automation library? As I can't find it so far.
Kind regards,
Amber Rowe
Hi Amber,
Another alternative for your use use could be using Data Aggregator. This DxM allows you to run GQI queries periodically at fixed times. For example, using the data source Get parameters for elements where, you can query the content of that table across all the elements using a particular driver. Data Aggregator will execute the query periodically (for example, once a day) and store the result of the query in a CSV file.
Hope it helps.
Hi Amber,
As far as I know, there's currently no built-in function in the Skyline Automation library that lets you export an entire table directly as a C# object. If something like that exists, I haven’t come across it either.
That said, one practical approach could be:
- Define a custom class in your C# code to represent a table row, with properties for each column (e.g. strings).
- Use the table’s key indexes of the table to loop through the rows and populate a
List<YourClass>
with the values. - Once your data is in the list, you can serialize it to XML using any standard C# XML library and save it to a folder on your server.
If that sounds like a viable path, I’d be happy to help. If there’s a smarter or simpler way already available in the library, I’d be curious to hear about it!
Best regards,