Cookies Settings

Loading

dnb-logo
Integration Manager
Collapse

Step 3: Defining Import Parameters for Batch Workflows

NOTE: You cannot define import parameters for NLMI Batch Matching.

Manually Importing a File

The Import wizard guides you through the import process. You first set up the import parameters and then import the file. For automated batch processes, you need to save the import parameters in the Batch Workflow.

  1. On the Home page window or the Navigation window, click Import.
  2. On the File Import tab, Step 1: Browse an Input file area, click Browse to locate the file you want to import.

  1. In the File Name field, after the file name displays, click Open.

  1. Click Continue.
  2. In the Step 2: Selecting the file format area, to import a delimited text file:
    • In the File Format field, select Delimiter.

    • In the Delimiter field, select Comma, Tab, Semicolon, Vertical bar, or Other. If you select Other, in the text field, type the delimiter you want to use.
    • In the Text Qualifier field, quotes ("), a comma (,) or select {none}. If some of your company names contain commas, you need to select an appropriate text qualifier to avoid misrepresentation of data.

— or —

To import a fixed-width file:

  • Click Fixed width.
  • Click Continue.
  • In the Column selection window, Text Preview area, click the ruler to set each column delimiter. Below the columns field, the widths that you select are represented by number ranges.

  1. Click Continue.

NOTE: If you select First row holds column names, each column name displays in the Field Mapping table.

  1. In the Step 3: Mapping the Fields tab, Action field, select Create New Table and enter the name for the new table or Select Append to Existing and select the table to append to.

  1. In the Field Mapping area, next to the column names, select the Skip check box to skip a column during the import.
  2. Click Import to import the file for a manual batch process.

D&B Integration Manager imports the file to the specified table.

Importing a File

To import a file, you need to register the file pattern while you configure the trigger and perform the following steps:

  1. In the Batch window, Import > File Import field, select a file to import and click Continue.
  2. In the File Format field, select the file format.
  3. In the Delimiter field, select the type of delimiter to separate each field
  4. Click Continue.
  5. Enter the table name and select at least one Field Mapping.
  6. Click Apply.

Importing a Database Table

To import a database table, you need to register the database pattern while configuring the trigger and perform the following steps.

  1. In the Batch window, Import > Database Import field, select the database table that you want to import from the list, and click Next.
  2. Enter the Table name.
  3. In the Field Mapping list, select at least one Field Mapping.
  4. Click Apply.

© Dun & Bradstreet, Inc. 2016. All rights reserved.