Excel Exporting

Forum Home Forums Understanding the Software Excel Exporting

This topic contains 11 replies, has 3 voices, and was last updated by Mikhail Mikhail 3 years, 1 month ago.

Viewing 12 posts - 1 through 12 (of 12 total)
  • Author
    Posts
  • #1012
    Avatar
    C_D
    Participant

    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?

    #1013
    Mikhail
    Mikhail
    Moderator

    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.

    #1014
    Mikhail
    Mikhail
    Moderator

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

    #1019
    Avatar
    C_D
    Participant

    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?

    #1024
    Mikhail
    Mikhail
    Moderator

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

    #1069
    Avatar
    C_D
    Participant

    Mikhail,

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

    #1074
    Mikhail
    Mikhail
    Moderator

    🙂

    #1223
    Avatar
    radix
    Participant

    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 ?

    #1224
    Mikhail
    Mikhail
    Moderator

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

    #1230
    Avatar
    radix
    Participant

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

    #1234
    Mikhail
    Mikhail
    Moderator

    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.

    #1238
    Mikhail
    Mikhail
    Moderator

    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.

Viewing 12 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic.