Rich Ex

Forum Replies Created

Viewing 15 posts - 1 through 15 (of 22 total)
  • Author
    Posts
  • in reply to: ChartPro Export to Excel #8319
    AvatarRich Ex
    Participant

    Hi Mikhail ,
    So looking at a custom report I would need to start by looking at the MinDataRep file for Chart and Chartpro , I will share with the forum if I can make it work .

    Thanks
    Rich

    in reply to: ChartPro Export to Excel #8312
    AvatarRich Ex
    Participant

    Hi Mikhail ,
    You are correct Chart Plugin was deactivated , not sure why, I had not changed it ?
    It is now showing the channel numbers in the Excel report , thank you so much.

    Final point with this question I see you can make custom report requests with chart Pro can you have it so the Excel files shows the channel name or is it like the on screen ‘data’ field and just shows the channel number .

    Thanks again
    Rich

    in reply to: ChartPro Export to Excel #8308
    AvatarRich Ex
    Participant

    Hi , date as requested ,

    2021-02-22 09:36:40 <V-SCADA-01><DefaultAppPool><ACT> Application shutdown
    ——————————————————————————–
    ——————————————————————————–
    2021-02-22 09:42:26 <V-SCADA-01><DefaultAppPool><ACT> Initialize common web application data
    2021-02-22 09:42:26 <V-SCADA-01><DefaultAppPool><ACT> Connect to SCADA-Server “localhost”
    2021-02-22 09:42:26 <V-SCADA-01><DefaultAppPool><ACT> Refresh the tables of the configuration database
    2021-02-22 09:42:27 <V-SCADA-01><DefaultAppPool><ACT> Fill input channels properties
    2021-02-22 09:42:27 <V-SCADA-01><DefaultAppPool><ACT> Fill output channels properties
    2021-02-22 09:42:27 <V-SCADA-01><DefaultAppPool><ACT> Fill input channel statuses properties
    2021-02-22 09:42:27 <V-SCADA-01><DefaultAppPool><ACT> User information has been added. IP address: 10.1.0.99. Session: qcgpwkn51mr3xi3y5frj3wsi
    2021-02-22 09:42:28 <V-SCADA-01><DefaultAppPool><ACT> Login: admin (Administrator). IP address: 10.1.0.99
    2021-02-22 09:42:28 <V-SCADA-01><DefaultAppPool><ACT> User information has been updated. IP address: 10.1.0.99. Session: qcgpwkn51mr3xi3y5frj3wsi
    2021-02-22 09:42:28 <V-SCADA-01><DefaultAppPool><ACT> Retrieve components from the installed plugins
    2021-02-22 09:43:08 <V-SCADA-01><DefaultAppPool><ACT> Logout: admin. IP address: 10.1.0.99
    2021-02-22 09:43:20 <V-SCADA-01><DefaultAppPool><ACT> User information has been added. IP address: ::1. Session: drmo402hd3wl2rac0fue5auy
    2021-02-22 09:43:27 <V-SCADA-01><DefaultAppPool><ACT> Login: admin (Administrator). IP address: ::1
    2021-02-22 09:43:27 <V-SCADA-01><DefaultAppPool><ACT> User information has been updated. IP address: ::1. Session: drmo402hd3wl2rac0fue5auy
    2021-02-22 09:43:27 <V-SCADA-01><DefaultAppPool><ACT> Retrieve components from the installed plugins
    2021-02-22 09:43:46 <V-SCADA-01><DefaultAppPool><ACT> Check “Chart Pro” registration:
    Registration key is valid. Expiration date is 23/02/2021
    Computer code: =0AAB8F2568031BE8-62CD277682F0E4D0-D53E5B16E5CE474F-66A5C6A3327FDFAC-63BD67BC4DDCAB88-630AE59F4EBCA807-5EC21FE4FB7E503E-C4F6F90346DA6721=
    2021-02-22 09:43:46 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 218 trend from SCADA-Server. File: m210222.dat
    2021-02-22 09:44:10 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 218 trend from SCADA-Server. File: m210222.dat
    2021-02-22 09:44:10 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 213 trend from SCADA-Server. File: m210222.dat
    2021-02-22 09:44:10 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 257 trend from SCADA-Server. File: m210222.dat
    2021-02-22 09:44:32 <V-SCADA-01><DefaultAppPool><ACT> Generate “Minute data” report by the user admin
    2021-02-22 09:44:32 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 218 trend from SCADA-Server. File: m210222.dat
    2021-02-22 09:44:33 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 213 trend from SCADA-Server. File: m210222.dat
    2021-02-22 09:44:33 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 257 trend from SCADA-Server. File: m210222.dat

    Versions are , Webstation = 5.1.2.0
    Chartpro = 5.1.0.1

    I only have Libra office not MS Excel , is this an issue ?

    Thanks
    Rich

    in reply to: ChartPro Export to Excel #8303
    AvatarRich Ex
    Participant

    Hi Mikhail ,
    C:\SCADA\ScadaWeb\plugins\Chart\lang\PlgChart.en-GB.xml YES exists as does the en-GB file in the Chartpro folder.

    Here is the latest from the ScadaWeb.log … as you see I’m using Chartpro to generate the Excel files…

    Registration key is valid. Expiration date is 20/02/2021
    Computer code: =0AAB8F2568031BE8-62CD277682F0E4D0-D53E5B16E5CE474F-66A5C6A3327FDFAC-63BD67BC4DDCAB88-630AE59F4EBCA807-5EC21FE4FB7E503E-C4F6F90346DA6721=
    2021-02-19 08:56:56 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 213 trend from SCADA-Server. File: m210219.dat
    2021-02-19 08:57:10 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 213 trend from SCADA-Server. File: m210219.dat
    2021-02-19 08:57:10 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 218 trend from SCADA-Server. File: m210219.dat
    2021-02-19 08:57:23 <V-SCADA-01><DefaultAppPool><ACT> Generate “Minute data” report by the user admin
    2021-02-19 08:57:23 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 213 trend from SCADA-Server. File: m210219.dat
    2021-02-19 08:57:23 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 218 trend from SCADA-Server. File: m210219.dat
    2021-02-19 08:58:11 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 213 trend from SCADA-Server. File: m210219.dat
    2021-02-19 08:58:11 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 218 trend from SCADA-Server. File: m210219.dat
    2021-02-19 08:59:12 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 213 trend from SCADA-Server. File: m210219.dat
    2021-02-19 08:59:12 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 218 trend from SCADA-Server. File: m210219.dat

    Thank you
    Rich

    in reply to: ChartPro Export to Excel #8298
    AvatarRich Ex
    Participant

    Hi Mikhail
    Here are the screenshots of the 2 files .

    excel1
    Websettings

    Thank you
    Rich

    in reply to: ChartPro Export to Excel #8294
    AvatarRich Ex
    Participant

    Hi Mikhail ,
    In Webstation I had the ‘Application Parameters’ ‘Culture’= “” at first , I have now changed them to “en-GB” as I am British , but the excel file is still showing the column headings as [ValColTitle].

    Thanks
    Rich

    in reply to: Can Not Set The Start Page #8282
    AvatarRich Ex
    Participant

    Dear Mikhail ,

    Many thanks , that fixed it .

    Kind Regards
    Rich

    in reply to: Time Off Timer #8192
    AvatarRich Ex
    Participant

    Thank you Mikhail , thank you Manjey .

    Yes I see that I should not add the delay in the formula . I will try what you said about making another channel and using a timestamp for comparison .

    As always thank you.

    Rich

    in reply to: Webstation To Slow #8021
    AvatarRich Ex
    Participant

    Hi , yes it did happen again even after updating to the latest version .

    —I have found the problem that caused the Webstation to grind to a halt —

    I had a ‘calculated real’ channel that was writing events , unfortunately the input was changing very fast , this caused the Server events .dat file to get very big , over 68Mb in a short time and then slow the whole web station down to a crawl .

    Once I turned off the ‘write events’ on the channel the issue stopped .

    Hope this helps , Rich

    in reply to: Entering Data Into A Table #8005
    AvatarRich Ex
    Participant

    Hi All
    On a final note … how do I add screen shots on here ?

    in reply to: Entering Data Into A Table #8004
    AvatarRich Ex
    Participant

    All sorted !

    Thank you gentlemen , I was near but missed the Cmd out !

    So to enter data by hand into a table and make it usable ….

    Add an INPUT Channel , (231 in my case ) ,Type = Calculated real , enter the OUTPUT Channel on the same line (1231 in my case).
    Then …
    Add an OUTPUT ,command type = Standard , tick FORMULA used , formula = SetVal(231,Cmd) .

    Hope this helps .
    Thanks Again
    Rich

    in reply to: Webstation To Slow #7962
    AvatarRich Ex
    Participant

    Hi Mikhail ,
    No I have none of what you mention .
    It was a very strange issue .
    I have fixed it now , I had to uninstall and then reinstall the software for Rapid Scada and now it is working again , this does show that it was not actually Rapid Scada that caused the problem I suppose so may have been a windows related issue as I did notice that there were Win10 updates waiting to be installed after the restart .

    Thank you Sir for your help
    Rich

    in reply to: Loss Of Signal #7564
    AvatarRich Ex
    Participant

    As always Mikhail

    Thank you

    in reply to: Loss Of Signal #7556
    AvatarRich Ex
    Participant

    Hi ,

    Think I have found it myself , CnlStat ..

    So If CnlStat>0 we have a good signal on this channel , thats my understanding .
    Is this correct .

    Thanks
    Rich

    in reply to: Real or Discrete . #7498
    AvatarRich Ex
    Participant

    Hi Mikhail ,
    Thanks very much for the info , understood .
    I now have the SetVal working , I was trying to use it in the result channel and not the source channel .

    Thank you.

Viewing 15 posts - 1 through 15 (of 22 total)