Data Loader

Data Loader enables you to create daily or hourly jobs that import your contact and order data into Bronto. You can also update or remove contact and order data from Bronto.

To view Data Loader, go to Settings > Data Loader.

To use Data Loader you:
  1. Add files to an FTP site that Bronto provides.
  2. Set up import jobs that scan this FTP location for files matching the import settings.
  3. Update the files, or add additional import jobs, as you want to import new or updated content.

When Data Loader finds files matching a File name Matching Pattern during a scan, it will attempt to run the associated import job. Data Loader will import any file that matches the File name Matching Pattern for that import—there is no limit to the number of files you can import at once.

After an import job is run you can view a report to see if your import was successful or troubleshoot an issue.

Note: An import job report is available for 30 days and then deleted.

Bronto scans the FTP site at the frequency you set for Data Loader imports and this setting can be adjusted from the main Data Loader page.

This table explains the elements on the main Data Loader page.

Page Element Description
Configured Imports Contains all of the configured imports for an account.
  • Click the name of an import to view or adjust it.
  • The Enabled toggle can turn on or off an import.
  • The Actions buttons allow you to rename an import, create a copy of an import, run a test import, view reports for an import, or delete an import.
  • The Current Status column shows one of the following statuses:
    • Idle (Default)

      Indicates that Bronto is not currently processing or importing a file. The status returns to Idle after each complete or failed run.

    • Starting

      Indicates that Bronto is ready to process your file.

    • Processing

      Indicates that Bronto is processing your file.

    • Importing

      Indicates that Bronto is importing your file one row at a time.

    • Retrying

      Indicates that Bronto is retrying to import your file after encountering an error.

    • Failed

      Indicates that Bronto is unable to import your file completely.

      Note: Bronto may have partially imported your file. Check the run log for details about your import.
Create Import Creates a new Data Loader import. For specific details about how to create a specific type of import, see the relevant Data Loader help topic.
Account Information
  • Shows whether Data Loader imports are set to run daily or hourly.

    To schedule your Data Loader imports, click Daily or Hourly and select your preference, then click the time to specify the hour.

  • Provides a link to view FTP credentials
  • Provides a link to change the FTP server password.
Uploaded Files Is a list of files that have been added to the FTP server but have not been processed. You can click on a file to download it.
If a file remains in the Uploaded Files list after all scheduled imports have run, then the file did not match any configured imports. If you transfer a file to the FTP server but do not see it in this list, either
  • The configured import ran between the time when the file was transferred and you checked the list.
  • Or the file transfer was not successful.
To investigate, check the reports for the imports that would apply to the file. A test run does not remove a file from this list.