Developer forum

Forum » Integration » Trouble importing User Groups

Trouble importing User Groups

E-mail notifications
Thomas Overgaard Nielsen
Reply
Posted on 22/11/2016 16:25:01

Hi all

As part of an integration project I am having trouble importing user groups using the Data Integration module and User Provider.
Importing users into existing groups works fine. But trying to import groups the job fails with the following error:

Job Failed with the following message: Cannot parse '' to System.Int. Table: AccessUserGroup. 
Column: AccessUserParentID The failed input row is: [AccessGroupName:"Privat kunde"], [AccessGroupParentGroupName:""]

It seems as if the system at some point tries to map the (empty) string value from AccessGroupParentGroupName to an ID.
Ultimately I planned on forcing a constant group name upon AccessGroupParentGroupName in the import and thus import all groups as children of some existing User Group. But that fails too

I attached the source XML.
DW 8.7.2.8 
My column mappings are pretty straight forward :

 


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 23/11/2016 15:14:29
Reply

Hi Thomas,
you are using a bit old version, could you upgrade to 8.8.1.* (latest is 8.8.1.30) and check if your problem is fixed?
There were a lot of changes in the User provider and for the AccessGroupParentGroupName column too.
Regards, Dmitrij

 
Thomas Overgaard Nielsen
Posted on 07/12/2016 15:03:30
Reply

Hi Dmitriy

Thanks for your suggestion - and sorry for the late reply.
Upgrading to v8.8.1.30 did indeed help .. somewhat.

I am now able to import users and user groups into an exisiting user group by importing this XML:

  <table tableName="AccessUserGroup">
    <item table="AccessUserGroup">
      <column columnName="AccessGroupName"><![CDATA[Privat kunde]]></column>
      <column columnName="AccessGroupParentGroupName"><![CDATA[Webshop]]></column>
    </item>
    <item table="AccessUserGroup">
      <column columnName="AccessGroupName"><![CDATA[Forening]]></column>
      <column columnName="AccessGroupParentGroupName"><![CDATA[Webshop]]></column>
    </item>
    <item table="AccessUserGroup">
      <column columnName="AccessGroupName"><![CDATA[Udl. privat kunde]]></column>
      <column columnName="AccessGroupParentGroupName"><![CDATA[Webshop]]></column>
    </item>
  </table>

However, I would rather not hard code the parent group on the ERP-side.
If I try to force a constant value "Webshop" unto AccessGroupParentGroupName in the import, i get a peculiar result.
Three user groups are indeed created as subgroups to the existing group Webshop .. but all of these three groups are named .. "Webshop" as well.
So it would seem, that the import forces my constant value upon both AccessGroupParentName AND AccessGroupName :)


 

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 08/12/2016 12:41:32
Reply
This post has been marked as an answer

Hi Thomas,
yes, this is a bug. We will fix that in TFS# 28523.
Also when you will get the build with that item you will also need to make a change in the data integration job:

check the "AccessGroupName" column in the "Select key columns" dialog and uncheck any other column you may have there and save and close the job.

Regards, Dmitrij

Votes for this answer: 1
 
Thomas Overgaard Nielsen
Posted on 15/12/2016 13:24:09
Reply

Thank you for your help, Dmitriy

 
Kristian Kirkholt Dynamicweb Employee
Kristian Kirkholt
Posted on 27/01/2017 10:19:04
Reply

Hi Thomas

The problem TFS#28523 "Error importing groups with just group name and constant script for parent group" has now been fixed in version 8.8.1.33 and 8.9.1.1

You are able to find this build in the download section:

http://doc.dynamicweb.com/releases-and-downloads/releases

Please contact Dynamicweb Support if you need any additional help regarding this.

Kind Regards
Dynamicweb Support
Kristian Kirkholt

 
Thomas Overgaard Nielsen
Posted on 27/01/2017 10:38:58
Reply

Thanks for heads up, Kristian :)

 

You must be logged in to post in the forum