AudienceView Connect
AudienceView Documentation

Configuring the Payment Scheduler

To be able to schedule customer payments (Scheduling Payments), the payment scheduler must first be configured. The following two steps must be completed:

Caution
Ensure that you have set a payment processor from email address. For more information, refer to Setting the Payment Processor Email From Address.

Creating the Payment Scheduler Batch File

Hint
To see the usage of the payment processor, and to see the input attributes without any input, complete the following:
  1. Navigate to Start>All Programs>Accessories.
  2. Right-click on Command Prompt and select Run as an Administrator.
    The Command Prompt window appears.
  3. Enter a prompt with the following syntax: C:\AudienceView\Build\Libs\Paymentprocessor.exe.

To create the payment scheduler batch file complete the following:

  1. Log on to the server where AudienceView is installed.
  2. Open the AudienceView folder (C:\AudienceView).
  3. Create a new folder called SchedPayments within the AudienceView folder.
  4. Create a new text file using a text editor, such as Notepad, containing the following information:
    Paymentprocessor.exe Syntax

    1. First set the connection string to the database.
    2. Run PaymentProcessor.exe with attributes

    Requires setting environment variable TS_DB_CONNECTSTR:

    TS_DB_CONNECTSTR=Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=123;Initial Catalog=Tix;Data Source=(local)
    where User ID = database user id
    Password = database password
    Source = database server
    Usage: PaymentProcessor <user name> <user password> -k <masterkeys> -r <user role> -p <payment methods> -s <start date> -e <end date> -m <email address> -f <filename>

     

    Example Batch File

    set TS_DB_CONNECTSTR=FaKeEncrYPtedSTR1ngasjdfkl;hasdfhasdfasdfsa
    C:\Audienceview\Build\audienceview_5_1_0\Libs\PaymentProcessor.exe schedpay P@ssword1 -r "Box Office" -k "" "" -m "test@audienceview.com" -s "2011/03/01"

     

    Information
    To locate your connection string:
    1. Navigate to the AudienceView folder (C:\AudienceView).
    2. Open the folder named after your organization.
    3. Open the Production Desktop folder.
    4. Open the global.asa file.
    5. Copy the information that follows tsapp.setConnectString.
    6. Paste the tsapp.setConnectString information in the "connectstring" portion of the text file.
  5. Save the file as a batch file (e.g. SchedPayments.bat) to the SchedPayments folder.

Creating a Scheduled Task for Payments

Once you create the batch file, you can create a scheduled task to run this batch file at regular intervals.

Before you Begin

Before scheduling payments, ensure you have:

  • The path and file name of the batch file you created earlier.
  • The Windows user name and password used to run the batch file. The scheduled task will run as if it were started by that user.
  • The schedule for the task. For example, do you want this task to run daily? What time of day should this task run?

To create a scheduled task, complete the following:

  1. On the server on which AudienceView is installed, click Start>All Programs>Accessories>System Tools>Task Scheduler
    The Task Scheduler window appears.
  2. Select Create Task from the Action menu.
  3. On the General tab, give the task a name (e.g. ScheduledPayments).
  4. Select the Trigger tab.
  5. Click 'New'.
  6. Set the schedule options.
    Hint
    It is recommend that you set any tasks to run during off hours.
  7. Select the Actions tab.
  8. Click 'New'.
  9. Click 'Browse'.
  10. Navigate to the batch file that you have created for the scheduled payments. For more information, refer to Creating the Payment Scheduler Batch File.
  11. Click 'OK'.
    The file has been attached to the task.
  12. For Hosted Clients:
    1. Select the General tab.
    2. Select the Run whether user is logged on or not radio button.
    3. Click 'Change User or Group'.
    4. Enter hosting\sched in the available field.
    5. Click 'Check Names'.
    6. Click 'OK'.
      The Task Scheduler pop-up will appear.
    7. Enter the password.
      Hint
      If you do not know the password contact hosting via email at hostingteam@audienceview.com.
    8. Click 'OK'.
      If you receive the following error message, contact hosting via email at hostingteam@audienceview.com.
  13. For Enterprise Clients
    1. Select the General tab.
    2. Select the Run whether user is logged on or not radio button.
    3. Click 'Change User or Group'.
    4. In the available field, enter a user that has permission to run a scheduled task.
    5. Click 'Check Names'.
    6. Click 'OK'.
  14. Click 'OK' to complete the scheduled task.