Hi ,

I’m using an OnlineTableControl to view the logged tags (10 tags, all of them are event controlled triggered upon one event).

In online table control datas are coming upon some event continuously.

I want this data exported to a csv file automatically without clicking export to excel

I’m using WinCC V7.0 SP3.

One more question while triggering event two times data is coming in on line table control how to stop that.

regards

------------------------------------------------------------------------------------------
Split from OnlineTableControl auto export WinCC V7sp2.

bg2492

Hello support services,

the controls have a method for every toolbar-button.
The means, you could use a VB-script, which calls the "Export"
Method for the control, to "push" the Export-Button of the
control.


Dim objctrl
Set objctrl = ScreenItems("Control1")
objctrl.Export()




Regards

Georg Berghof

 

 Thank you Georg, this is very useful.

However, after clicking export new window dialog pops up and you should click ok and since my path is dependent on the date, it also asks you if you want to create a new folder. Any idea how to automate this? I am not very familiar with vbs so every piece of advice would be useful. Thank you!

A possible solution could be to create an action that set an internal tag to 1 if export is needed (for example every hour).
In the @AlarmOneLine picture you could make an invisible control, and create a script that reads that tag, set is back to 0 and then exports the data to the desired location.

I'm not 100% sure about the Table Control, but for the AlarmControl I implemented this solution, and it works :)