Developer forum

Forum » Integration » Import user groups in a tree structure fails

Import user groups in a tree structure fails

Michael Knudsen
Reply

Hello forum,

- according to documentation (https://doc.dynamicweb.com/documentation-9/integration/integration-framework/data-integration-activities/user-provider#sideNavTitle1-3), it should be possible to import user groups in a tree structure, but I can't get more than one level succesful imported and the rest will be added to 'root'. Is this a failure?

Import done on DW9.13.6 with Swift and import job with Source: XML / Destination: User Provider

 

  • AccessUserGroup contains user group data. A tree structure is defined by using the AccessGroupParentGroupName field. An empty node means the group is placed in the root of the tree, otherwise we match on AccessGroupGroupName
 
<?xml version="1.0" encoding="utf-8"?>
<tables>
<table tableName="AccessUserGroup">
<item table="AccessUserGroup">
  <column columnName="AccessGroupGroupName">Customers</column>
  <column columnName="AccessGroupName">Customers</column>
  <column columnName="AccessGroupParentGroupName">Accounts</column>
</item>
<item table="AccessUserGroup">
<column columnName="AccessGroupGroupName">SalesPersons</column>
<column columnName="AccessGroupName">SalesPersons</column>
<column columnName="AccessGroupParentGroupName">Accounts</column>
</item>
<item table="AccessUserGroup">
<column columnName="AccessGroupGroupName">DeliveryCodes</column>
<column columnName="AccessGroupName">DeliveryCodes</column>
<column columnName="AccessGroupParentGroupName">Accounts</column>
</item>
<item table="AccessUserGroup">
<column columnName="AccessGroupGroupName">3310</column>
<column columnName="AccessGroupName">3310</column>
<column columnName="AccessGroupParentGroupName">SalesPersons</column>
</item>
<item table="AccessUserGroup">
<column columnName="AccessGroupGroupName">3350</column>
<column columnName="AccessGroupName">3350</column>
<column columnName="AccessGroupParentGroupName">SalesPersons</column>
</item>
<item table="AccessUserGroup">
<column columnName="AccessGroupGroupName">Franko</column>
<column columnName="AccessGroupName">Franko</column>
<column columnName="AccessGroupParentGroupName">DeliveryCodes</column>
</item>
<item table="AccessUserGroup">
<column columnName="AccessGroupGroupName">Franko2500</column>
<column columnName="AccessGroupName">Franko2500</column>
<column columnName="AccessGroupParentGroupName">DeliveryCodes</column>
</item>
</table>
</tables>

Br. Michael Knudsen


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Michael,
the problem can be in the table mappings, can you try to add mapping for AccessGroupParentGroupName to AccessUserParentID?
BR, Dmitrij

 
Michael Knudsen
Reply

Hello Dmitriy,

- I'm not able to select AccessUserParentID from a AccessUserGroup table. Or how should I do that?

Below you'll find my mapping:

Br. Michael Knudsen

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply
This post has been marked as an answer

Hi Michael,
sorry, I was wrong about that column. Could you change your mapping so it looks like that (remove AccessGroupName):

BR, Dmitirj

Votes for this answer: 1
 
Michael Knudsen
Reply

Thank you Dmitriy, that did the trick, but I'm not sure why :-)

 

You must be logged in to post in the forum