AudienceView Connect

The Control Files for the Dataloader

To load data into the application, the dataloader must act as a user of the application. This means that user, password and role information are required to be included in the control file configuration information to access the necessary application operations. This information must be detailed in the control file.

The control file then builds and defines the data structure for the entire data load in the system. Once the structure is built, the dataloader is able to load in the information from the data file.

For the dataloader to execute the data load, both the control file and the associated data files must be stored in a specific folder on the AudienceView application server. This folder will vary depending upon your server configuration, so consult an AudienceView System Delivery associate for further details.

Any of the AudienceView business objects (BO) are available to have associated data loaded into the application using the Dataloader. For example, if your organization had historical customer order data that you wanted to load into the application, it could be entered into the system using a control file specific to loading order data using the rules defined in the order BO. A specific dataloader control file would have to be created for the specific BO load as well as a separate control file for each of the order components (e.g. admissions, miscellaneous items). As well, the format for the data file would have to be determined as well to align for the data structure determined by the control file. In the specific case of order loading, there is an API available to pay off orders using specific payment defaults for legacy data. Consult an AudienceView System Delivery associate for further details.

To configure the paths where the dataloader can find the control and data files, complete the following:

  1. Open the Registry application from the AudienceView Desktop.
  2. Navigate to the System::Business Objects::TSdataloaderJobBO node.
  3. Specify the path for the control files in the 'Control Files Path' field.
  4. Specify the path for the jobs files in the 'Jobs Path' field.
  5. Click 'Apply'.
    A window confirms that the application updated the Registry.
  6. Click 'OK'.

This information must also be reflected in the file AVScheduler.exe.config.

Search for the following parameters:

    <add key="saveLocation" value="C:\"/>
    <add key="jobsLocation" value="C:\Jobs\"/>

where the 'value' is the path of the folder for the control file path and the job locations respectively.

The control file names must now be added to the dataloader control files list. For more information, refer to Adding Control Files to the Dataloader Control File List.