All Categories

Introduction Definitions Login User profile Chatbot Menu

Home Dashboard Newsletters & Lists Leads 360° customer view Clicks Web Recognition Campaigns Overview Create Manage Search Selections Overview Create Manage Search Open Lock Template Runs Overview Search Schedules Overview Search Monitor Overview

Operation Campaign Working with blocks Connecting blocks Grouping blocks Add Memo Signal Context menus Settings Coding information

Audience Builder (data)

Select & Segment Select Split Sample Switch Deduplication Communication pressure Combine & Exclude Combine Exclude Enrich & Edit Upload file Import file Snapshot Web service Enrichment Datamart Aggregations

Campaign Builder (channels & content)

Channels

Email Create Edit Personalization AI Assistant User content Hyperlinks Mapping RSS Settings Contacts Validation A/B testing Test Additional

Preview Export SMS App messages Webpush Landing page Website personalization Content Newsletter wizard Dynamic content HTML editor Data capture RSS Funnel

Key path

Automation

Execute Schedule Webhook Time zones

Reports

Email reports

Manage

General settings TID info Email info Templates Management dashboard Admin settings

Access & entitlement Repository Authorization Email Trackers Tags Statistics Inline CSS Web Embedded forms Integration AI Assistant Webhooks Web service Datamarts Datastores Datalayers System datamarts System E-mail servers Domains Authorization Themes Output blocks Tokens TP Leads Group definitions Leadtype definitions Property definitions Ezines Business Units Ezines Property

Entities XML Preference Center Processes Housekeeping Bot click filtering Mail processing and email address status Feedback loop Number of records in Ternair CDP datastores

Import file

The Import function allows you to import data from a selection in Ternair Campaign to a Ternair Database, such as a marketing database, subscription file or an external database. An import block must be directly connected to an upload or snapshot block.

Please note that in order to use an import block, a client-specific import definition in the settings of Ternair Campaign is required.

Drag an import block to the worksheet and connect the block to an upload or snapshot block.

You can use the import block only if the selection is saved.

Double-click on the import block to open the settings.

This section focuses on the following options; each option consists of a tab in the settings of the import block.

Option	Description
Mapping	Map the target field to a source field. Target fields marked with an asterisk (*) are required.
Preview	View the first ten records in the selection.

Mapping

On the 'Mapping' tab you will find an overview of all available target fields. Map the target field to a source field by clicking on the arrow next to a source field. A drop-down menu appears with the available source fields, or use a fixed value for a target field. Target fields marked with an asterisk (*) are required.

Fixed values: enter a fixed value for all records in the import
Source field: data from the chosen data field of the data source

Preview

The Preview tab shows a summary of the first ten records in the selection.

General settings

Option	Description
Block template	Every import block can be saved as a template. After an import block is saved as a template, it can be used as a template for other import blocks. A block template can be reused by clicking on 'Open block template' in the lower left corner of the import block and selecting the template from the list.
Description	You can specify a description for an import block. The description field is intended to specify a logical description for the block. This makes the contents of the output block easily recognizable in the selection flowchart.
Applicate	Clicking the 'apply' button saves the preliminary settings for the selection block.
Cancel	Use the 'Cancel' button to undo your changes.
Save	Using the 'Save' button allows you to save your changes without (re)calculating the block.

Execute

A final step is to execute the import. Select the import block, right-click and click "execute. Running the import will load the file into a Ternair database.

Import file

Mapping

Preview

General settings

Execute

Video

In this article