AudienceView Documentation

• Utilities Content Map
• The Maximum Number of Records that can be Processed
• Business Intelligence Queries (Extracts)
• Utilities Customers
  • Utilities Customers Pages
    • Utilities Customers-Query Select Page
    • Utilities Customers-Customer Marketing Page
    • Utilities Customers-Add Offers Page
  • Performing Customers Batch Processes
    • Updating Customer Marketing Data in Batches
    • Generating Offers in a Batch
      • Searching for Customers Eligible for Offers
      • Selecting Customers Eligible for Offers
      • Making Customer Offers
• Utilities Customer Merge
  • Utilities Customer Merge Pages
    • Utilities Customer Merge-Search Page
    • Utilities Customer Merge-Details Page
    • Utilities Customer Merge-Details Page (AudiencView 6.3.2)
    • Utilities Customer Merge-Query Page
    • Utilities Customer Merge-Results Page
  • Merging Customer Accounts in a Batch
    • Creating and Executing a Customer Account Merge Query (Prior to AudienceView 6.3.2)
    • Creating and Executing a Customer Account Merge Query (AudienceView 6.3.2)
    • Modifying an Executed Customer Account Merge Query
    • Merging a Batch of Customer Accounts
• Utilities Orders
  • Utilities Orders Pages
    • Utilities Orders-Query Select Page
    • Utilities Orders-Order Invoice Page
    • Utilities Orders-Order Update Page
    • Utilities Orders-Order Marketing Page
  • Performing Orders Batch Processes
    • Printing Order Invoices in a Batch
    • Updating Orders in a Batch
      • Searching for Orders to Update in a Batch
      • Updating Order Details in a Batch
      • Adding Gifts to Orders in a Batch
      • Adding Miscellaneous Items to Orders in a Batch
      • Deleting Performances or Bundles from Orders in a Batch
    • Updating Order Marketing Data in a Batch
• Utilities Offers
  • Utilities Offers Pages
    • Utilities Offers-Query Select Page
    • Utilities Offers-Offer Invoice Page
    • Utilities Offers-Offer Update Page
  • Performing Offers Batch Processes
    • Printing Offer Invoices
      • Searching for Applicable Offers to Invoice
      • Generating Offer Invoices
    • Updating Offers in a Batch
      • Searching for Offers to Update in a Batch
      • Updating Offer Start and End Dates in a Batch
      • Updating Offer Statuses in a Batch
      • Declining Offers in a Batch
      • Removing Promotional Codes from Offers in a Batch
      • Updating Promotional Codes on Offers in a Batch
• Utilities Renewals
  • Utilities Renewals Pages
    • Utilities Renewals-Search Page
    • Utilities Renewals-Details Page
    • Utilities Renewals-Seating Page
    • Utilities Renewals-Gifts Page
    • Utilities Renewals-Miscellaneous Items Page
    • Utilities Renewals-Results Page
  • Handling Renewals
    • Creating an Offer Renewal
    • Creating an Order Renewal
    • Creating an Update Order Renewal
    • Working with Renewal Seat Rules
      • Creating a Renewal Seat Rule
      • Modifying a Renewal Seat Rule
      • Deleting a Renewal Seat Rule
    • Working with Renewal Gift Rules
      • Creating a Renewal Gift Rule
      • Modifying a Renewal Gift Rule
      • Deleting a Renewal Gift Rule
    • Working with Renewal Miscellaneous Item Rules
      • Creating a Renewal Miscellaneous Item Rule
      • Modifying a Renewal Miscellaneous Item Rule
      • Deleting a Renewal Miscellaneous Item Rule
    • Running a Renewal
    • Modifying a Renewal
    • Deleting a Renewal
• Utilities Print
  • Utilities Print Pages
    • Utilities Print-Print Query Select Page
    • Utilities Print-Order Print Page
    • Utilities Print-Print Cancel Page
  • Printing in Batches
    • Printing and Reprinting Tickets in a Batch
    • Cancelling Printed Tickets in a Batch
• Utilities Performance
  • Utilities Performance Pages
    • Utilities Performance-Template Page
    • Utilities Performance-Admissions Page
    • Utilities Performance-Tickets Page
  • Modifying Performances in a Batch
    • Searching for Performances to Update in a Batch
    • Updating Performance Holds, Price Zones or Fill Zones in a Batch
    • Adding Admissions to Performances in a Batch
    • Removing Admissions from Performances in a Batch
    • Adding or Cancelling Third Party Tickets
      • Notes About Entering Ticket Numbers
      • Adding Third Party Ticket Numbers
      • Cancelling Third Party Ticket Numbers
• Utilities Pledges
  • Utilities Pledges Pages
    • Utilities Pledges-Tax Receipts Page
    • Utilities Pledges-Thank You Letters Page
  • Handling Pledges in a Batch
    • Extracting Tax Receipt Data
    • Extracting Thank You Letter Data
    • Using Mail Merge to Print Tax Receipts and Thank You Letters
• Utilities Dataloader
  • Utilities Dataloader Pages
    • Utilities Dataloader-Search Page
    • Utilities Dataloader-Load Page
    • Utilities Dataloader-Results Page
  • Using the Dataloader
    • How the Dataloader Works
    • Best Practices for Dataloader Use
    • The Control Files for the Dataloader
    • Editing the Control File
    • Adding Control Files to the Dataloader Control File List
    • Creating a Dataloader Job
    • Scheduling a Dataloader Job to be Run
    • Updating the Details of a Dataloader Job
    • Deleting a Dataloader Job

Product Guides > 6.3.0 Product Documentation > 6.3.0 Application Documentation > AudienceView User Guides > Utilities Guide > Utilities Dataloader > Using the Dataloader

---

Table of Contents | Previous

---

The dataloader is an application that allows organizations to load large quantities of organization data into the AudienceView database. The use of the dataloader makes the process of entering large amounts of transactional data into AudienceView more concise and less time consuming. The dataloader performs a high-speed loading of information by circumventing the presentation layer of the application and works directly with the application layer and its underlying functionality.

By using the internal AudienceView operations in the application layer, this ensures that all data is integrated properly into the database, ensuring that all data records and entities are logically entact. All connections between data entities and all system-created identifiers and GUIDs are created as if a user was entering the data via the presentation layer and the UI. The difference is that the information is entered much faster.

Typically, it is legacy customer and order data that is loaded into AudienceView using the dataloader. However, any large amount of data can be added into the system as long as the same information could be added manually by a user. More generally, if the data entity to be loaded already has a business object (BO) and a collection object (CO), the dataloader can be used to load the data related to that object.

To use the dataloader, you must create a control file that lays out the data that is to be entered. The control file organizes the data that is entered via the data file and interfaces with the AudienceView application layer to enter the data.

The AVScheduler service that runs on your server is used to run the dataloader. Ensure that the AVScheduler user (sched in most cases) has the necessary permission(s) to log in and performn the commands identified in the control file.

The following sections describe how to work with the dataloader:

• How the Dataloader Works: Describes how the dataloader works.
• Best Practices for Dataloader Use: Describes how some best practices for using the dataloader.
• The Control Files for the Dataloader: Describes how the control files work.
• Editing the Control File: Describes how to edit an existing control file.
• Adding Control Files to the Dataloader Control File List: Describes how to add the control files to the dataloader control file list.
• Creating a Dataloader Job: Describes how to create a new dataloader job.
• Scheduling a Dataloader Job to be Run: Describes how to schedule a dataloader job.
• Updating the Details of a Dataloader Job: Describes how to update the details of an existing dataloader job.
• Deleting a Dataloader Job: Describes how to delete an existing dataloader job.