[Rich Ex]

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

[Rich Ex]

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

[Rich Ex]

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

[Rich Ex]

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

[Rich Ex]

Hi Mikhail
Here are the screenshots of the 2 files .

Thank you
Rich

[Rich Ex]

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

[Rich Ex]

Dear Mikhail ,

Many thanks , that fixed it .

Kind Regards
Rich

[Rich Ex]

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

[Rich Ex]

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

[Rich Ex]

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

[Rich Ex]

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

[Rich Ex]

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

[Rich Ex]

As always Mikhail

Thank you

[Rich Ex]

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

[Rich Ex]

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.

[Author]

Posts