1 / 17

Automated Production Report Generation with OPC DataHub

Automated Production Report Generation with OPC DataHub. Your Host Today: Colin Winchester, Director of Support Presenter: Win Worrall, Application Engineer.

elmo-osborne
Download Presentation

Automated Production Report Generation with OPC DataHub

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Automated Production Report Generationwith OPC DataHub 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.

  2. Automated Production Report Generationwith OPC DataHub You may private chat with the host here Ask questions to panelists here

  3. Automated Production Report Generationwith OPC DataHub 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

  4. Automated Production Report Generationwith OPC DataHub Agenda – 45 Minutes • Overview of the OPC DataHub • Basic information on Scripting • Live Demonstration • Additional Application Examples • Questions & Answers • Use the Web-Ex Q&A at any time

  5. OPC DataHubFunctionality Overview OPC Scripting http://www.softwaretoolbox.com/opcdatahub

  6. Background on OPC DataHub Scripting • Powerful scripting engine included • Support for Windows GUI • Support for ODBC connections • Gives you lots of options • 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

  7. Background on OPC DataHub Scripting • Unique Properties • Dynamic Environment • Event Driven • Object Oriented • Included features • Scripting Editor • Debugging tools • Example code • Full Programmers Manual

  8. Automated Production Report Generationwith OPC DataHub • Live Demonstration • Connecting to OPC Server • Connecting to Database • Creating report from script • Emailing report • Viewing the report through a Web Page

  9. ODBC Database OPC DataHub Scripting Engine Script ASP Page Data Engine OPC Server HTML Document Automated Production Report Generationwith OPC DataHub • Live Demonstration OPC DataHub Email/SMS Text message Web Browser

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

  11. Server Server OPC DataHub Script Use Examples • Mathematical conversion of items • Triggered Data exchange between control Systems 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 ODBC Database OPC DataHub

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

  13. OPC DataHub Script Use Examples • Custom Dashboard • Pop-up alarms

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

  15. OPC DataHub Scripting Use your imagination • Built-in support for: • 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 DataHub configuration • Custom extensions – loadable DLLs • e.g., math libraries, graphics libraries • Unified event model - run code when: • data changes, a timer fires, or user interaction

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

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

More Related