AudienceView Connect

Creating a Script Definition

Once you have created a script and before you can run the script, you must define which source files will be used.

To create a script definition, complete the following:

  1. Open the General Configuration application from the AudienceView Desktop.
  2. Select the Script Definition tab.
    The Scripts Definition|Search page appears.
  3. Click 'Create New'.
    The Scripts Definition|Edit page appears.
  4. Enter a name for the script definition in the 'Name' field.
  5. Enter a brief description of the script definition in the 'Description' field.
  6. Enter the name of the folder/group that you want to put the script definitions in. This allows you to easily search of them via the Script Definition|Search page.
  7. Select the script that you want to use from the 'Application Script' dropdown.
    Only scripts that have a 'Content Type' of Application Scripting will appear.
  8. Click 'Add Source'.
    The sources section expands.
  9. Enter the name of the source file that has been saved to the server.
  10. Select the source file type from the 'Source Type' dropdown.
    • Business Intelligence: The source file is an extract from Business Intelligence.
    • Comma Separated Value: The source file is a .CSV file.
  11. Enter the name of the header column in the 'Key Column' field.
  12. If the script uses multiple source files (and they have all been added to the sources section), select the parent file from the 'Parent Source' dropdown.
  13. Enter the parent column of the source file in the 'Parent Source Column' field.
  14. For every source file that you want to add, repeat the process from Step 8.
  15. Optionally, you can add additional fields/information, providing that they exist in the script:
    1. Click 'Add Field'.
      The execution fields section expands.
    2. Enter the system field that the information is pulled from (e.g. _01_user_name) in the 'Field' field.
    3. Enter the text used to identify the criteria on the user’s screen in the 'Label' field.
    4. Select how you want the field to be validated from the 'Type' dropdown:
      • bigInteger
      • binary
      • currency
      • dateTime
      • duration
      • fixedInteger
      • guide
      • integer
      • password
      • phoneNumber
      • string
    5. Select the field's 'Subtype'
    6. Enter a group name in the 'Group' field to help categorize fields.
    7. Select whether the field is Required or Optional from the 'Required' dropdown.
      If an option is not selected, the field will default to Required.
    8. Select a predefined list to bind to the field from the 'List' dropdown.
    9. Enter the maximum number of fields that can be populated with values in the 'maxValues' field.
      If the value is set higher than 1, then  will appear allowing users to add additional fields.
    10. If a list is selected in the 'List' field, the 'Default Value' will be populated with the lists' options (once the script definiton has been saved). Select the the default option of the field.
  16. For every field that you want to add, repeat the process from Step 15a.
  17. Click 'Create'.
    A window confirms that the application created the script.
  18. Click 'OK'.

Once you have created a script definition, you can schedule and run the script using the Utilities - Data Management pages.