Important Note

You need to create an automation FTP user on admin panel. You can find the steps for how to create automation FTP user on this link

Create an Automated Flow to Update Your ‘Master Contact’ Table

Under the "Data Space" tab, click on "Automated Flows" to create an automated job for Data Space updates.

Click “New”, choose "Automated Flow" and fill the details (name, start date, end date) of the automated flow.

Add a “File Drop Trigger” to listen to an FTP space. Click “Configure” to configure the node and fill out the necessary data as shown below. You can upload files with TXT, CSV or ZIP extension.

4.Next, you need to add a data space update node for updating a specific table. Click “Configure” and select a data source to configure this node and press “Continue”

Select the Master Contact table as target table on your data space and press continue,

You can make column mapping on this step;

There are 3 Data Table Action Types as shown below

Sample File

If you upload the sample file to the selected folder in the File Drop Trigger, the service receives this file from the FTP and updates your master contact table.

contact_key;email;name;surname;email_permission
contact_key1;user_1@dengage.com;User1_Name;User1_Surname;true
contact_key2;user_2@dengage.com;User2_Name;User2_Surname;false
contact_key3;user_3@dengage.com;User3_Name;User3_Surname;true

Create an Automated Flow to Update any Table of on your Data Space

Under the "Data Space" tab, click on "Automated Flows" to create an automated job for Data Space updates.

Click “Add” and fill the details (name, start date, end date) of the automated flow.

Add a “File Drop Trigger” to listen to an FTP space. Click “Configure” to configure the node and fill out the necessary data as shown below. You can upload files with TXT, CSV or ZIP extension.

Next, you need to add a data space update node for updating a specific table. Click “Configure” and select a data source to configure this node and press “Continue”

Select a target table on your data space and press continue,

6.You can make column mapping on this step;

There are 5 Data Table Action Types as Insert, Update, Insert and Update, Truncate and Insert, Delete

Sample File

If you upload the sample file to the selected folder in the File Drop Trigger, the service receives this file from the FTP and updates your target table.

contact_key;email;name;surname
contact_key1;user_1@dengage.com;User1_Name;User1_Surname
contact_key2;user_2@dengage.com;User2_Name;User2_Surname
contact_key3;user_3@dengage.com;User3_Name;User3_Surname

Create an Automated Flow to Update Your 'Master Device' Table

Under the "Data Space" tab, click on "Automated Flows" to create an automated job for Data Space updates.

Click “Add” and fill the details (name, start date, end date) of the automated flow.

Add a “File Drop Trigger” to listen to an FTP space. Click “Configure” to configure the node and fill out the necessary data as shown below. You can upload files with TXT, CSV or ZIP extension.

Next, you need to add a data space update node for updating a specific table. Click “Configure” and select a data source to configure this node and press “Continue”

Select the Master Device table as target table on your data space and press continue,

You can make column mapping on this step;

There are 5 Data Table Action Types as Insert, Update, Insert and Update, Truncate and Insert, Delete

Mapping for Integration Key

If the integration key is not included in the file, you can select the *Constant Value option to select a specific application defined on your account for this column.

Sample File

If you upload the sample file to the selected folder in the File Drop Trigger, the service receives this file from the FTP and updates your Master Device table.

contact_key;token;integration_key;token_permission
t010101;dn_56a19cf554ddb615f4b35236e4e02fe04dee69d04ab5b24e3830750d90674c2c;your_ios_app;true
t010101;dn_a3314d1e87a7b54e004cf3a1d88e5a2101d51d2431d175fa0a8cf82d733ca5eb;your_web_app;false
t020202;dn_071b9983e913f686c93de1997b1d46b154881cbff2a52188f4a4387e67b7a6a1;your_android_app;true
t030303;dn_071b9983e913f686c93de1997b1d46b15e004cf3a1d88e5a2101de004cf3a1d2;your_ios_app;true