Data Logging & Alarms

#1

Hi,
How to log data in Elipse SCADA & show in online window,
to do Data logging it required any other software/sql etc.
is it possible to log data in excel and if yes how?
if any documents/ Procedure to do so please give me.

Thanks
Ashok Naphade

#2

Hello @Ashok123,

It’s not necessary another software to log data in Elipse SCADA. You can use a historic to do that.
To show data in a online window, you’ll need to use the Browser object.
About the Excel data, you can use a ISAM connection (sample) or you can use DDE tags.
The Elipse SCADA Manual shows you how to use Historics, Browsers and DDE tags. Click here to download or access:

  • C:\Program Files (x86)\Elipse SCADA\manual.pdf
  • C:\Program Files (x86)\Elipse SCADA\tutorial.pdf

Best regards,

#3

@Ashok123,

Another option to export data from a historic file to Excel is using the PrintToFile method.
Look this article: http://kb.elipse.com.br/pt-br/questions/2332

Best regards,

#4

Thanks,

1)But when My SCADA is online then the Values are not updating in Browser.
What to do to update values when scada is running.
2) in My application i want to save data batch wise but batch will start/Stop automatic from PLC
so to do these type of logging need any scripting?
So how to do batch wise data loging & how to access historical data once my batch wise data store?

Thanks

#5

Hello @Ashok123,

  1. To update the browser, use the UpdateQuery method.
    Sample:
    In a Button Click event, use this line:
    Browser1.UpdateQuery()

2)Look these articles:
http://kb.elipse.com.br/pt-br/questions/5217
http://kb.elipse.com.br/pt-br/questions/852

Best regards,

#6

thanks

Its my mistake to explain the data logging.
Actually i want to log data after cycle complete.
i will get cycle complete from plc at that time only data will save only onece.
&
How to give scroll to browser horizontal as well as vertical

thanks

#7

Hello @Ashok123,

To register just when something happend, change the Write Time to 0, unmark “Use the Write Time to save records” and use the WriteRecord method from Historic.
About the scroll, you can create a slider to scroll verticaly. To do that, you’ll need to configure the slider limits with the registers count and this slider will be linked with CurSel property from Browser. Try this sample.