Automated Production Report Generation with OPC Data Hub

Automated Production Report Generation with OPC Data. Hub Your Host Today: Colin Winchester, Director of Support Presenter: Win Worrall, Application Engineer IMPORTANT: You must phone into the teleconference to hear the audio portion of the presentation. Instructions were emailed to you. Please let the host know via private chat if you need the call in information provided to you via chat.

Automated Production Report Generation with OPC Data. Hub You may private chat with the host here Ask questions to panelists here

Automated Production Report Generation with OPC Data. Hub While we are sharing applications, the toolbar shown below appears in the bottom right corner of your screen. You can access Chat with Host and the Q&A with Presenters Panels by clicking on the icons as shown. Private Chat with Host Q&A with Panelists

Automated Production Report Generation with OPC Data. Hub Agenda – 45 Minutes u Overview of the OPC Data. Hub u Basic information on Scripting u Live Demonstration u Additional Application Examples u Questions & Answers u Use the Web-Ex Q&A at any time

OPC Data. Hub Functionality Overview OPC Scripting http: //www. softwaretoolbox. com/opcdatahub

Background on OPC Data. Hub Scripting u Powerful scripting engine included u u u Support for Windows GUI Support for ODBC connections Gives you lots of options u u u Attach scripts to item point changes Build Custom dashboards Custom log files Interact with ODBC Databases Transform data (i. e. math/calculations) Create full simulation programs

Background on OPC Data. Hub Scripting u Unique Properties u u Dynamic Environment Event Driven Object Oriented Included features u u Scripting Editor Debugging tools Example code Full Programmers Manual

Automated Production Report Generation with OPC Data. Hub u Live Demonstration u u u Connecting to OPC Server Connecting to Database Creating report from script Emailing report Viewing the report through a Web Page

Automated Production Report Generation with OPC Data. Hub u Live Demonstration ODBC Database OPC Data. Hub Scripting Engine Script OPC Server ASP Page OPC Data. Hub Data Engine Web Browser HTML Document Email/SMS Text message

OPC Data. Hub Script Use Examples u Ways Scripting can be used u Populate the OPC Data. Hub with a large number of OPC or ODBC items Script to import data items Multiple & Varied OPC Data Sources OPC Data. Hub ODBC Data Sources

OPC Data. Hub Script Use Examples u u Mathematical conversion of items Triggered Data exchange between control Systems Server When the value changes on a specified tag, pass all group values to the other server OPC tag = F(OPC Tag) Or OPC tag = OPC Tag OPC Data. Hub ODBC Database Server

OPC Data. Hub Script Use Examples u Create special internal items u u u To hold values To use for time-delay Use to create sliding average or trending alarm Add internal points Multiple & Varied OPC Data Sources OPC Data. Hub ODBC Data Sources

OPC Data. Hub Script Use Examples u u Custom Dashboard Pop-up alarms

OPC Data. Hub Script Use Examples u More Examples: u u u Custom supervisory control strategies Import/Export to CSV or any text file Custom user interaction Launch other applications Dynamic Web content

OPC Data. Hub Scripting Use your imagination u Built-in support for: u u u Read and write files on disk ODBC (database) connectivity MATLAB connectivity Windows GUI programming Dynamic data types Partial code evaluation Repeat, one-shot and time-of-day timers ASP-conversion of text files Execute other Windows programs Modify OPC Data. Hub configuration Custom extensions – loadable DLLs u u e. g. , math libraries, graphics libraries Unified event model - run code when: u data changes, a timer fires, or user interaction

What Tools are Needed? u No tag count limits u u No limits on # of clients, # of servers used Scripted Report Generation on a Single PC – 1 Data. Hub License - $995 u All features below included u u u OPC Data. Hub Webserver - $3750 u u u Email/SMS ODBC Data Logging Bridging & Aggregation Scripting No Server OS Required No other web server software required (no IIS) Contact us if you need professional service work

Contact Information & Other Learning Opportunities u Questions later? u Colin Winchester u u u Win Worrall u u u cwinchester@softwaretoolbox. com 888 -665 -3678 x 1327 or 704 -849 -2773 x 1327 wworrall@softwaretoolbox. com www. softwaretoolbox. com/opcdatahub Other learning opportunities u u www. softwaretoolbox. com/opcdatahub and click on Videos/Training Visit www. softwaretoolbox. com/webinars