Jump to: navigation, search

Big Data Page

If Big Data files are enabled for your account, like the Data page, the Big Data Page works in conjunction with a Big Data File (over 50K rows) to read variables from or write variables to an .xls or .csv file.

Main Tab

Notes:

  • Before you can select a data file, you must have previously created or uploaded one. See Data Files.
  • Once you select a data file, the Prompts and Advanced Options tabs display.

Choose the Options for the Big Data File

  1. Select a big data file.
  2. Select an option.
    • Put Data In—Enables you to put variable values into your Big Data File. The system can either insert a new row each time, or update an existing row, searching for the First, Last, or All rows of data in which the designated variable value matches a row in the designated Data File column.
      1. In the Inserting this data section, select Variable to update the designated variable values all variables and their associated columns or select specific variable/columns.
      2. Specify the destination page, after inserting the data.
    • Get Data Out—Enables you to populate variables with values from your Big Data File. As shown in the graphic below, the system will find the First or Last row where the given variable matches a row in the Data File, and then load the values from that row into the corresponding variables.
      1. Specify the row to first look for the data.
      2. From the drop-down menu, select the column name(s)/variables in which to look.
      3. In the Load Data section, select the columns/variable in which to load the data.
      4. Specify different destination Voice Pages depending on whether or not a row is found.
Main Tab - Get Data Out


Prompts Tab

The Prompts tab enables you to configure Initial and Wait prompts. For more information on uploading prompts, see Audio Files.

  • Initial Prompts—Configure the initial prompt(s) that will be heard when the call reaches the data page.
  • Wait Prompt—Configure an additional wait prompt that will be played in a loop until the data write/read has completed. When operating on large Data Files, it is possible that the query being performed may take several seconds. The time to Get Data Out or Put Data In varies depending on the amount of existing data in the file. The system can play a "processing" sound to callers while waiting. For best results, make sure that the sound file beginning and end "connect" smoothly.


Advanced Options Tab

The system may encounter three exceptional situations that could trigger an error:

  1. The query takes too long to run
  2. The Data File has reached the maximum allowable size
  3. There was an internal system error
  • Error Destination—Configure which page in the IVR the call should be routed to in the event an error occurs.
  • Email Debugging—Choose when to send email logs. You can chose either Never, On Error Only, or Always. You can also specify the email address or addresses that the debug emails will be sent to.

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on 13 May 2016, at 13:08.