Event Logging : Factory Talk View

sachincool786

Member

S

Join Date

Dec 2014

Location

india

Posts

48

• Oct 26, 2015

• #1

Hi!!!

Could anyone tell me how can i log a single single event happening in Scada like login/logout, any tag changes value, operator input etc. I don't have any historian.

1. without making event list of every tag in development
2. using VBA
3. with the help of SQL

It would be highly appreciable.

Thank You.

 

gclshortt

Member

Join Date

Dec 2014

Location

Ontario

Posts

3,217

• Oct 26, 2015

• #2

The following thread should help you in getting tag information from Factory Talk using VBA.
http://forums.mrplc.com/index.php?showtopic=23632

This should get you started, once you have the information then getting it to the database would be from the following thread:
http://www.mrexcel.com/forum/excel-questions/617788-visual-basic-applications-connect-sql-server.html

Hope this helps,
Garry
http://www.accautomation.ca

 

sachincool786

Member

OP

S

Join Date

Dec 2014

Location

india

Posts

48

• Oct 27, 2015

• #3

Thank You.!!!

 

sachincool786

Member

OP

S

Join Date

Dec 2014

Location

india

Posts

48

• Jan 4, 2016

• #4

Isn't there any straight forward example???
any written code???

 

gclshortt

Member

Join Date

Dec 2014

Location

Ontario

Posts

3,217

• Jan 4, 2016

• #5

Instead of using VBA, I would use AdvancedHMI. This software is free of charge and uses visual basic in Visual Studio.
http://sourceforge.net/projects/advancedhmi/

Regards,

 

sachincool786

Member

OP

S

Join Date

Dec 2014

Location

india

Posts

48

• Jan 4, 2016

• #6

But i have a standalone SE running SCADA in a PC, I can't use it.
Please give me a straight forward example of Perfect Event logging in FT vIew SE v8