Excel Exporting

[C_D]

I have successfully set up my RapidSCADA installation and am now collecting data from my devices. What I need to do now is get the data out so I can use it. So far I have found:

[*]Table Views which allow you to view ‘hourly’ data for the past 24 hours.
[*]’Export To Excel’ button which saves out the ‘hourly’ data as an XML.
[*]Charting for individual inputs allows you to view the ‘minute’ data, and this can be extended to multiple series with the Chart Pro add in.

What I really need to be able to do is export the ‘minute’ data to excel, preferably for a specific time range (which may be more or less than 24 hours). My work flow would probably be to look at the chart and identify an area of interest, and then select that range and export it.

What would be the best way to achieve this?

[Mikhail]

It’s great that you ask. The report allows to export minute data to excel is ready. It will be included in the installation package within a few days. It can be executed from the reports page and it is integrated with Chart Pro component.
For now you can choose begin and end dates of a period of a report. In case of requirements to choose a time, some development is needed.

[Mikhail]

The reports are in SpreadsheedML format. It is XML that can be opened by Microsoft Excel and by Libre Office.

[C_D]

This sounds perfect. Can you send it to me so I can trial the report now, or will I need to wait till the installation package is updated and do a reinstall?

[Mikhail]

Please download Rapid SCADA again and update SCADA-Web application. Is it possible to just overwrite the files from ScadaWeb.zip

[C_D]

Mikhail,

The new minute data report is exactly what I needed. Thank you so much.

[Mikhail]

🙂

[radix]

Hi Mikhail,
Is there way we can store/view second wise data ?
If we set Period time is in second in communicator then how can we view it from rapid scada or how can we have it in report ?

[Mikhail]

Hi,
Do you mean that you need to store data every second?

[radix]

Yes, It could be 1, 5 or 15 second data. As communicator allows us to enter number (Period) in any second.

[Mikhail]

There are 3 ways:
1. Optimal. Export these data to DB using DB Export Module. Then use this approach to display charts.

2. Fast to implement. Manually set storing period for minute data in C:\SCADA\ScadaServer\Config\ScadaServerSvcConfig.xml
Cons: large data archives and slow charting

3. Create a custom solution to fit your needs.

[Mikhail]

Notes about a custom solution:
We can develop a module that will allow:
– Choose input channels and set a period of storing for the each selected channel.
– Store separately and fast access trends of these input channels.
– Display charts and export data to different formats.

[Author]

Posts