more quick actions
minimize quick actions
Hello all,
I got a customer who wants to display a mimic contains the status of a device. He wants to display both Real-time status and historical status, for historical status, there is a Request button(with the time selection) to trigger.
As i know, PcVue can only replay historical data in Trend viewer and log viewer. For this kind of requirement, is it easy to make it with scripts?
3Q.
Posted : 20/02/2013 2:40 pm
You can extract Trend data using SVTREND and log data using SVLOG - but it is not simple. There is a sample project showing the use of SVTREND in the KB.
Cheers, Robin
Posted : 20/02/2013 4:54 pm
Thanks, Robin.
Yes, it's not so easy. We need to get the value back from the file, and then based on it to display the status.
When check with the customer, they'll use our Proprietary unit. And, for one device, there are 40-50 bits, and in one station there will be 50-60 this kind of device. In the long run, the station will have 100 devices.
🙁
Posted : 21/02/2013 12:04 pm
Why not another solution?
The status is managed by a system register isnt? SYSTEM..
If it's OK then the value is 0.
If Not OK then the value is > 0.
1. Configure a High threshold at 1 with the Log option set.
2. Create an Associated Label DEVICE_STATUS
- Bit 0 = DEVICE OK
- Bit 1 = DEVICE OUT
3. Create a special Domain or Nature: DEVICE_STATUS
Now when you request the status of 1 device you can use the LOGDISPLAY SB function with FILTER mode to display the history of one device only...
Posted : 22/02/2013 1:14 pm
Thanks Nico.
The customer wants to display the historical status with color and text in the mimic, not in the log viewer.
At the moment, Florent is working with SVLog to make a demo.
Posted : 26/02/2013 2:57 pm
But Nico solution is good since you can customise the log viwer to fit your customer requirement.
The historical status can be view a list of text with specific color (you can use customise color according to the alarm level for example.
Posted : 28/02/2013 5:23 pm
Hello,
This customer doesn't like the way Logviewer display data. So we need to made a demo to display data in another way.
It seems SVLOG works only with proprietary archive unit. How can we retrieve LOG data from SQL database. Should we need to use SVSQL or by direct coding in VBA ?
Thank you by advance for your help.
Posted : 04/03/2013 8:58 am
Are you 100% sure that SVLOG only works with Proprietary Archive Units? We don't have this limitation in the Help and we are normally quite careful about limitations like this. Perhaps it is just a problem in the version of PcVue that you are using? If so please report it as an SPR.
Using SVLOG (if it can be made to work) is going to be a lot easier that using VBA - IMHO.
Cheers, Robin
Posted : 04/03/2013 3:48 pm
Ok Robin, thanks for your answer, I will report it as SPR. I used PcVue 10 SP1 on Windows 7 64 bit OS.
When I will have the answer about this issue, I will report it here.
Best regards.
Posted : 04/03/2013 3:54 pm
Ok SVLOG works with HDS. The problem come from the loglist name in the SVLOG verbs. In fact this name is case sensitive. If we respect this rules, it works.
Best regards.
Posted : 15/03/2013 9:45 am
I advise you make a SPR
Posted : 15/03/2013 11:28 am
Ok I made the SPR 27756
Posted : 15/03/2013 11:39 am