ACS - Import different database for different countries

Forum|Forum|7 years ago
February 28, 2018
11 replies
3928 views

Hi all,

I would like to know if anyone has ever implement a similar procedure to send communications to contacts of different countries.

I explain the case:

Our customer has different database for different countries and he would like to send different comunications for each countries.

I read on the documentation this use case https://helpx.adobe.com/campaign/standard/administration/using/use-case--users-e-security.html and the 4 steps are clear.

After these steps, I have to activate in Custom Resources the option "Add access authorization management fields", publish and create different custom resources for each countries and setting the geographical unit.

So for example, if I have 3 different Field "First Name" (one for UK, one for IT and one for US), when I set Field to update in the action Update data, how can I choose the correct one for the country UK? (I cannot give different names to the same fields)

Once the profiles have been imported, do I have to set something other than the geographical unit in the workflow settings?

Thanks a lot!

Eveline

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by florentlb

Now, I show you an example. I'm going to upload a csv file which looks like that:

---

name;firstname;email;country;birthdate

doedoe;johnn;leborgne+2345@adobetest.com;France;19/03/1986

collins;florent;leborgne@adobetest.com;Italy;17/11/1987

---

johnn doedoe will be new in the database so my workflow will create a new profile with the geounit specified in the file.

florent collins already exists in the database but with a different geounit so my workflow will update the geounit.

1. First I load my file (I have it on my local machine so I don't use a transfer file, but your workflow is good until the load file).

2. Then, I use a reconciliation activity. I use the "Relations" tab only to tell the system that the data I am importing from the file contains also information related to the geounit resource (using the country column of the file). In this specific example, values of the country column of my file ("France" and "Italy") correspond to the Label field of my geounit resource, so I create the link with @label.

3. Now, I can add an Update data activity to my workflow. I use the operation "Insert or Update" because in my file I can have either new profiles or existing ones to update.

In the "Identification" tab, I select "Using reconciliation criteria" and keep Profiles as dimension to update. As a reconciliation key, I use the email column of my file and the email field of my database. You may use another key to match your requirements (if you use a specific field or combinations of field to identify unique records).

In the "Fields to Update" tab, I use the magic wand. I notice here that the system automatically added a "geounit" field to update, thanks to the link I have created in the "Relations" tab of my reconciliation activity.

I remove the "country" field detected by the magic wand because I have no interest in updating that field, I just want to use the "country" column of the file to udpate the geounit, which is already automatically done by the link I've created and mentioned just before.