Project: User-Defined Variable Types and Lists

This scenario demonstrates how to use lists and user-defined types to process data sets.

Scenario Overview

This scenario presents an automation solution used to send text (SMS) messages to customers who have outstanding debts.

The main workflow reads customers' details and debt amounts from an Excel spreadsheet and provides only the relevant customer details to a sub-worflow which will simulate the sending of the SMS messages.

Once messages have been sent to all customers, the details of each message sent are written to a text file.

Download Project Files

  1. Download the project file here.

  2. Unzip and copy the files to %AppData%/Nice_Systems/AutomationStudio/Projects.

  3. Download the Excel spreadsheet here.

  4. Copy the Excel file to c:/temp.

Explore and Complete the Solution

This video explains how to create the user-defined types and variables needed for the solution. It then explores the two workflows.