OG 311 Deko Macros and Databases

Length

Suggested length: 2 days

Overview

Deko operators will learn to take advantage of the programming power of macros and create graphics using databases as a rich source of timely data. This is a technical introduction for both programmers and non-programmers bridges the gap between "recording keystrokes for a macro" and more sophisticated programming. Though this course is designed for the non-programmer, it is a moderately technical course.

Audience

This course targets:

  • Experienced CG operators
  • Deko art designers

Broadcast programmers

Prerequisites

  • Attendees should review the macro concepts in the Deko User Guide before attending
  • Database familiarity is ideal but not required

Objectives

At the end of this course, you will be able to:

  • Understand string and integer variables
  • Use arithmetic operators in macros
  • Use the Commands Reference
  • Use the getstring and getnum commands
  • Invoke and use the Prompt window
  • Use comparison operators for if, else and end statements
  • Program with conditional commands
  • Set up a loop
  • Customize macros
  • Use arrays in macros
  • Use Excel spreadsheets and Access databases for data
  • Register an ODBD database
  • Create a graphic that updates directly from a database
  • Retrieve and manipulate data to create a graphic
  • Create a macro to build multiple graphics