The import block can be used to import data from a selection in Ternair Campaign into a Ternair database, for example a marketing or subscription database or external database. An import block must be directly connected to an upload or snapshot block.
In order to use an import block a client specific import definition in the settings of Ternair Campaign is required.
Drag an import block onto the worksheet, connect the block to an upload or snapshot block and then specify the settings for the import.
The current selection first needs to be saved before you can import a file. Double click the import block to show its settings (see the image below):
On the ‘Mapping’ tab you will find an overview of all the 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 mandatory.
- Fixed value: submit a fixed value for all of the records in the import
- Source field: data from the specified source field from the data source
The ‘Preview’ tab shows an overview off the first 10 records in the selection.