An Example Database Script Template

In this sample script template, the script reads all the data from a database table named physician_locator and plays back output one row at a time, looping back and repeating this process until there is no more data.

Figure database.aef Script shows the database.aef script template as it appears in the Design pane of the Cisco Unified CCX Editor window.

database.aef Script

The table shows the physician_locator database table.

Physician_Locator Database Table

ZIP_CODE

CATEGORY

NAME

SPOKEN_NAME

ADDRESS

PHONE

11111

chiropractor

john doe

(audio document)

222 main st. bedrock ca

5551112222

22222

podiatrist

jane wong

(audio document)

333 oak st. bubble city ny

5552344343

33333

dentist

jim smith

(audio document)

435 state st. oakwood tn

5556458978

99999

general

tia gomez

(audio document)

382 first st. river city ia

5557674444