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

Move Subscription Profiles into Geo and Org Unit

Avatar

Avatar
Validate 10
Level 2
Clarence_Bunch_
Level 2

Likes

10 likes

Total Posts

58 posts

Correct Reply

4 solutions
Top badges earned
Validate 10
Validate 1
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Validate 10
Level 2
Clarence_Bunch_
Level 2

Likes

10 likes

Total Posts

58 posts

Correct Reply

4 solutions
Top badges earned
Validate 10
Validate 1
Give Back 5
Give Back 3
Give Back
View profile
Clarence_Bunch_
Level 2

02-08-2017

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?  

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 10
Level 2
Clarence_Bunch_
Level 2

Likes

10 likes

Total Posts

58 posts

Correct Reply

4 solutions
Top badges earned
Validate 10
Validate 1
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Validate 10
Level 2
Clarence_Bunch_
Level 2

Likes

10 likes

Total Posts

58 posts

Correct Reply

4 solutions
Top badges earned
Validate 10
Validate 1
Give Back 5
Give Back 3
Give Back
View profile
Clarence_Bunch_
Level 2

25-09-2017

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

Answers (4)

Answers (4)

Avatar

Avatar
Validate 1
Level 4
johnwwilcoxmba
Level 4

Likes

35 likes

Total Posts

78 posts

Correct Reply

14 solutions
Top badges earned
Validate 1
Ignite 1
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Validate 1
Level 4
johnwwilcoxmba
Level 4

Likes

35 likes

Total Posts

78 posts

Correct Reply

14 solutions
Top badges earned
Validate 1
Ignite 1
Give Back 5
Give Back 3
Give Back
View profile
johnwwilcoxmba
Level 4

25-09-2017

Florent,

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

John

Avatar

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile
florentlb
Level 10

03-08-2017

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

Avatar
Validate 10
Level 2
Clarence_Bunch_
Level 2

Likes

10 likes

Total Posts

58 posts

Correct Reply

4 solutions
Top badges earned
Validate 10
Validate 1
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Validate 10
Level 2
Clarence_Bunch_
Level 2

Likes

10 likes

Total Posts

58 posts

Correct Reply

4 solutions
Top badges earned
Validate 10
Validate 1
Give Back 5
Give Back 3
Give Back
View profile
Clarence_Bunch_
Level 2

03-08-2017

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

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile
florentlb
Level 10

03-08-2017

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