TAG LINE
SMALL TITLE

Configure Data Imports

Last Updated: Aug 25, 2020

Data Imports are configured in Setup / Extensibility / Data Management / Data Import

Overview

From this screen you can import data from a csv or columnar file into the system. Whatever you wish to bulk import can be done from here, rates, accounts, general ledger codes, countries, etc. Data is manipulated and mapped to the appropriate fields in the system based on data profiles. Data can be imported in a one-off fashion or the import configuration can be saved to be run again at a later date. This guide will walk you through setting up and running a data import.

Prerequisites

Data profiles need to be configured before data imports can be setup.

Data Imports Panel

The Data Imports panel towards the left of this screen allows you to select data import configurations that have been saved. When you select an existing data import on the left the import settings will be shown in the Edit Data Import panel to the right. Actions are also available in this panel which are shown as icons to the right of the Data Imports panel heading. The available actions are described below.

Actions

Icon

Description

Deletes the selected data import

Adds a new data import

Edit Data Import Panel

The information in this panel reflects the currently selected data import. From here you can change import details (Fields will display a red left border if a value is required and purple text if the field is read-only and cannot be modified).

Actions are also available in this panel in the upper right, these are described below:

Actions

Icon

Description

Uploads a file for import

Executes the import

Data Import Fields and Options:

  • Name: a descriptive name that details the data that is imported

  • Data Profile: the data import configuration. Specifies the import target and destination fields in the system along with the import file type, amongst other settings. See the data profile help for more information

  • File To Import: the file that will be imported. Added via the upload (emoji) file action button

  • Envelopes Per Request: the number of json envelopes per request

  • Patches Per Envelope: the number of patch requests to include in each envelope

  • Stop On Error: if set the import process will be halted when an error occurs. If left unchecked the import will continue to execute despite import errors

Visual Map Tab

This tab will display the imported fields (on the left) and the system fields that the imported value will map to (on the right). If the data imported is being modified the action or 'transform' being performed will also be displayed here in between the source field from the import file and the target field in the system.

Transforms are used to modify or generate imported data and are configured on the data profile screen.

Input Sample Tab

This tab will only appear when the data import fields are populated along with supplying the import file. This tab shows the source file contents.

Target Sample Tab

This tab will only appear when the data import fields are populated along with supplying the import file. This tab shows the target data that will be imported once the import is executed.

Import Results Tab

This tab appears when an import is run. It will detail the progress of the import and list any import failures should they occur.