Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Move Subscription Profiles into Geo and Org Unit

Clarence_Bunch_
Level 4
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
Clarence_Bunch_
Correct answer by
Level 4
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
florentlb
Level 10
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

Clarence_Bunch_
Level 4
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?

florentlb
Level 10
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.

johnwwilcoxmba
Level 5
Level 5

Florent,

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

John

Clarence_Bunch_
Correct answer by
Level 4
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