Skip to main content

Databases and Scripting Class

Course Overview​

Expert instructors will teach you how to create database structures and leverage them to make your Ignition screens more dynamic. You will learn to work with Named Queries and design projects around dynamic data. This course will use Python scripting and a database connection to show additional features such as creating editable schedule windows, dynamic reports and alarm notification, scripting efficiencies, and more. Full itinerary available below.

Prerequisite​

Students should have earned the Core Certification before attending as this class will not cover Core Ignition concepts. Some prior knowledge of databases and scripting is also highly recommended but not required. Visiting the Databases and Scripting sections of the Inductive University will be a helpful starting point.

Certification​

This course gives you the opportunity to earn a Gold certification during class. Labwork prompts will be assigned at the end of each day and reviewed by an instructor the following morning. Students must attend and complete labwork on all 5 days to earn certification. Gold Certifications require a Core certification before they are valid. Verify with your class provider if certification is available in this class.

Itinerary​

Day 1​

AM ContentPM Content

Class introduction​

  • What is this class about?
  • What are the class expectations?

Installation & Activation​

  • Installing Ignition
  • Ignition and database restore
  • Ignition license activation
  • Relational database design

SQL Tutorial​

  • SELECT
  • SQL functions and keywords
  • GROUP BY
  • ORDER BY
  • JOINs
  • INSERT, UPDATE, DELETE

Lunch Break

Scripting Tutorial​

  • Script Console
  • Hello World
  • Lists and Dictionaries
  • Datasets
  • Using Named Queries
  • Extension Functions

Named Queries and Vision Components​

  • Creating Named Queries
  • Named Query driven dynamic components:
    1. Template Repeater
    2. Dropdown List

QA and Labwork

Day 2​

AM ContentPM Content

Named Queries and Vision Components​

  • Parameterized Named Queries
  • Parameterized popup windows
  • Named Queries
    1. Update query mode
    2. Named Query security

Lunch Break

Displaying Database Data on Components​

  • Equipment Scheduler component
  • SQL CASE statements
  • Scripting
    1. Working with datasets

QA and Labwork

Day 3​

AM ContentPM Content

Extension Functions​

  • Right click menus
  • Project library scripting functions
  • Named Queries
    1. Update query mode

Lunch Break

CSV Import/Export​

  • Exporting database data to CSV file
  • Importing CSV data to database
  • Script performance evaluation
  • Importing Python libraries

QA and Labwork

Day 4​

AM ContentPM Content

Reporting​

  • Nested Queries
  • Table Groups
  • Charts inside of tables
  • Storing PDF reports to SQL database
  • Report Viewer component
  • Viewing PDF reports stored in a SQL database

Lunch Break

Overhead Display​

  • Power Table Overview
  • Complex Table JOINs
  • Cell renderer Java imports

Client Messages​

  • Client and Gateway Message Handlers
  • Creating and using a Message Handlers

QA and Labwork

Day 5​

AM ContentPM Content

Alarm Notifications​

  • Notification Block
    1. Calculated Rosters
  • Alarm associated data
  • The alarm event object

Dynamic Charting​

  • Ad-Hoc Easy Chart
  • Easy Chart extension functions
    1. onTagsDropped
  • Script performance evaluation
  • Importing Python libraries

Backups and Exports in Ignition​

  • Tag exports
  • UDT exports
  • Tag Group exports
  • Project exports
  • Gateway backups

Lunch Break

QA and Labwork