Login / Signup

Data Table and Export

 
HMI
Last Post by n.kunzer 6 years ago
6 Posts
3 Users
0 Likes
60 Views
RSS
 Anonymous 641
(@Anonymous 641)
Posts: 64
Trusted Member Guest
Topic starter
 

I want a mimic to display archive variable in the format as shown below image and also want to export in a CSV or Excel file. How can we achieve this in PcVue?

4748=749-fdd9166cdf5c4be4532b8339db392815
 
Posted : 28/08/2020 3:33 pm
 Anonymous 621
(@Anonymous 621)
Posts: 14
Active Member Guest
 

Hi Nitesh
its possible by inserting grid and choosing historical. you will be able to add trends in that and get the data with export in CSV or Excel.

 
Posted : 31/08/2020 12:34 pm
n.kunzer
 n.kunzer
(@n-kunzerarcinfo-com)
Posts: 1236
Member Moderator
 

Hi,

What Chinmayi said is not wrong but, if you are using this way you will have a problem: You won't be able getting the text that are stored in the attributes.
So, I advise doing another way:

By Scada Basic script (using UDC feature) in 12.0 and by SQL Variables in 15.0

Nico

 
Posted : 31/08/2020 3:40 pm
 Anonymous 641
(@Anonymous 641)
Posts: 64
Trusted Member Guest
Topic starter
 

Hi,

Thank you for your reply.

Yes. I need to get text data in the table. How to use SCADA Basic for this? Do we have any document, video or example for this?

Regards,
Nitesh

 
Posted : 31/08/2020 5:07 pm
 Giulia Magnesa
(@admin_doc72)
Posts: 493
Member Admin
 

I have a dream....One day we will fill a grid directly with the answer to a SQL request, whithout Scada Basic 😉

 
Posted : 09/09/2020 4:53 pm
n.kunzer
 n.kunzer
(@n-kunzerarcinfo-com)
Posts: 1236
Member Moderator
 

On the pipe Nico....

 
Posted : 09/09/2020 4:58 pm
Forum Jump:
  Previous Topic
Next Topic