Expand my Community achievements bar.

We are excited to introduce our latest innovation to enhance the Adobe Campaign user experience — the Adobe Campaign v8 Web User Interface!
SOLVED

Move Subscription Profiles into Geo and Org Unit

Avatar

Level 4

In ACS, is it possible to mass update profiles that were created by a subscription service into Geographical and Organizational Units.  I want to mass update the profiles into Geographical and Organizational Units I created through a workflow?  Can you write data into those fields with a workflow?  

1 Accepted Solution

Avatar

Correct answer by
Level 4

John,

I have gotten this to work (while we wait for API to include GEO and ORG).  I had to create 2 custom fields for GEO and ORG (I called them AEM GEO and AEM ORG) and this workflow....Workflow.PNG

View solution in original post

5 Replies

Avatar

Level 10

Hi,

These fields are hidden by default. To be able to update these fields, you need to make them available from the custom resources. When extending the profile resource, you can check the option. Then publish the extension.

Resource extension is described here: Step 2: Configure the resource data structure  (step 6 is about this option).

Hope this helps,

Florent

Avatar

Level 4

Florent,

I already had Geo and Org available from those steps.  How can I write via a workflow to update those fields(Geo and Org) with a value?

Avatar

Level 10

Unfortunately there is no very easy way to do it.

Once the geo and org units are available, you can import a file containing the geo and/or org unit value for each profile, reconcile these profiles with the database so that they are well identified, and then perform the update by matching the value of the geo/org unit field to the one from the file.

For example:

  1. In the Load file activity, additional columns should be defined in the Column Definition tab to include the Org and Geo unit fields in the data transition. Default values of the Org and Geo unit for the data to be imported, can be set under column properties.  a16.pnga17.png
  2. An enrichment (using the Reconciliation activity) is then performed to identify the right Org/Geo unit from the orgUnit or geoUnit schemas.  a18.png a19.png a20.png
  3. In the final update activity, update the orgUnit link with the Org unit field defined in the File loading activity.

Let me know how it goes,

Florent.

Avatar

Level 6

Florent,

Could you please include screenshots of the update activity?  I am having difficulties getting it to work.

John

Avatar

Correct answer by
Level 4

John,

I have gotten this to work (while we wait for API to include GEO and ORG).  I had to create 2 custom fields for GEO and ORG (I called them AEM GEO and AEM ORG) and this workflow....Workflow.PNG