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
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
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
Upload file
The Upload function allows you to load data from an external file into Ternair. The upload can then be used as input for other selection or output blocks.
Drag an upload block to the worksheet.
You can use the upload block only if the selection has been saved.
Double-click on the upload block to open the settings.
On the left side, an upload shows the preview of the internal table. On the right side you will find the settings.
This section focuses on the following options; each option consists of a tab in the settings (right side) of an upload block.
The preview (on the left side of the screen) is always visible.
Icone | Option | Description |
|---|---|---|
| File | Upload file |
| Settings | Choose a retention period |
File
Upload
You can upload your file in two ways:
Upload from your computer
Automated upload from FTP location
Click green upload button to select the file you want to upload. You can only upload files of type .xls, .xlsx, .xlsb, .txt or .csv.
Key
After uploading the file, specify which column in the file contains the key and what kind of key it is (for example, accountid or email address).
File has header line
If the File has header line option is selected in an upload block, the first line is not counted as a record.
Column types
If the Use column types from file option is selected, the column (data) types from the uploaded Excel file in Ternair are used as field types for these fields.
The maximum number of characters in a column is 999.
The following data types are supported:
Date
Number
Currency
Other/text
Depending on the data type, the corresponding operators are available for this field. See Selection for more details on selection operators.
Global upload
A 'global upload' can be used as a source in other selections. Existing global upload blocks are always read-only files.
Settings
The 'Settings' tab allows the user to set a retention period.
The retention period determines how long the upload is available within Ternair.
General Settings
Options | Description |
|---|---|
Block template | Every upload block can be saved as a template. After an upload block is saved as a template, it can be used as a template for other upload blocks. A block template can be reused by clicking on 'Open block template' in the lower left corner of the upload block and selecting the template from the list. |
Description | You can specify a description for an upload block. The description field is intended to specify a logical description for the block. This makes the content of the output block easily recognizable in the selection flowchart. |
Cancel | Use the Cancel button to undo your changes. |
Save | Use the 'Save' button to save your changes without (re)calculating the block. |
Calculate
As a final step, the upload must be calculated. Select the upload block, right-click and click "calculate. Performing the upload will load the file into Ternair.
In the selection flowchart, the upload block shows the number of rows (records) with a value in the key column.
A successfully uploaded file can be saved as a source in other selection functions such as Select, Split, Sample, Switch or Deduplicate. Connect the upload block to another (selection) block by drawing an arrow from the upload block to the selection block.
The upload can be used as input for other blocks (in the selection) at a later time.
