Control.com - Nerds in Control
from the Communication department...
PLC Data Collection
  | Posted by charz  on 11 July, 2012 - 12:12 pm |
Dear All,
Im an Electrical Engineer new to automation, I have a Schneider plc, citect scada, then the software installed on the pc's are opc, MS sql. Now my questions are
1.How all these are interconnected to generate a report in excel?
2.what is opc? how it works
Regards,
Charz.
Im an Electrical Engineer new to automation, I have a Schneider plc, citect scada, then the software installed on the pc's are opc, MS sql. Now my questions are
1.How all these are interconnected to generate a report in excel?
2.what is opc? how it works
Regards,
Charz.
|  | Posted by Wassim Daoud on 13 July, 2012 - 1:02 pm |
Hi Charz,
> 2.what is opc? how it works
Here are some tutorials that should help you get stated with OPC:
http://www.matrikonopc.com/resources/opc-tutorials.aspx
Hope this is helpful!
Cheers,
Wassim
> 2.what is opc? how it works
Here are some tutorials that should help you get stated with OPC:
http://www.matrikonopc.com/resources/opc-tutorials.aspx
Hope this is helpful!
Cheers,
Wassim
|
Dear Charz,
I suggest you take a look at XLReporter from SyTech since it natively interfaces to Citect SCADA both for OPC and MS SQL. See the link below for more information.
http://www.sytech.com/download/Tech_Citect.pdf
A 3 minute video explains how to create Excel reports directly from an OPC Server.
http://www.sytech.com/flash/Product/RealTime/RealTimeDataReporting. html
Hope it helps.
Jim
I suggest you take a look at XLReporter from SyTech since it natively interfaces to Citect SCADA both for OPC and MS SQL. See the link below for more information.
http://www.sytech.com/download/Tech_Citect.pdf
A 3 minute video explains how to create Excel reports directly from an OPC Server.
http://www.sytech.com/flash/Product/RealTime/RealTimeDataReporting. html
Hope it helps.
Jim
Your use of this site is subject to the terms and conditions set forth under Legal Notices and the Privacy Policy. Please read those terms and conditions carefully. Subject to the rights expressly reserved to others under Legal Notices, the content of this site and the compilation thereof is © 1999-2013 Nerds in Control, LLC. All rights reserved.
Users of this site are benefiting from open source technologies, including PHP, MySQL and Apache. Be happy.
Fortune
7:30, Channel 5: The Bionic Dog (Action/Adventure)
The Bionic Dog drinks too much and kicks over the National
Redwood Forest.
