Developer forum

Forum » Integration » Importing assortment permissions for user groups

Importing assortment permissions for user groups

E-mail notifications
Tobias Belling
Reply
Posted on 16/08/2018 09:55:31

Hi,

We have an issue when importing assortments. We try to import to the table EcomAssortmentPermissions, but get an error with:

2018-08-14 13:16:53.304: No rows were imported to the table: EcomAssortmentPermissions.

The batch job does succeed, but as it states, no rows are importet to the Permissions table.

The id's in the xml below af from the accessuser table and are user groups.

<table tableName="EcomAssortmentPermissions">

<item tableName="EcomAssortmentPermissions">

<column columnName="AssortmentPermissionAssortmentID"><![CDATA[B2B]]></column>

<column columnName="AssortmentPermissionAccessUserID"><![CDATA[4]]></column>

</item>

<item tableName="EcomAssortmentPermissions">

<column columnName="AssortmentPermissionAssortmentID"><![CDATA[B2BPreorder]]></column>

<column columnName="AssortmentPermissionAccessUserID"><![CDATA[14799]]></column>

</item>

<item tableName="EcomAssortmentPermissions">

<column columnName="AssortmentPermissionAssortmentID"><![CDATA[B2P]]></column>

<column columnName="AssortmentPermissionAccessUserID"><![CDATA[35799]]></column>

</item>

</table>

 

Any idea what goes wrong?

 

Kind regards

Tobias


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 16/08/2018 10:02:08
Reply

Hi Tobias,
what provider do you use as Destination? Ecom or Dynamicweb?
Have you checked if the rows you are importing to the EcomAssortmentPermissions table are not already there?
Regards, Dmitrij

 
Tobias Belling
Posted on 16/08/2018 10:49:03
Reply

Hi Dmitriy.

I am using an Ecom Provider for destination.

I have just checked again the database again, after doing the import. The table seems to only contain those I made manually added using Dynamicweb admin.

Kind regards,

Tobias

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 16/08/2018 11:08:09
Reply
This post has been marked as an answer

Hi Tobias,
that is a bug, tfs# 53530 created for that. As a workaround you can try to use the SQL destination provider and import directly to EcomAssortmentPermissions table
or use the Ecom provider but include the "AssortmentPermissionCustomerNumber" or "AssortmentPermissionExternalID" column in the source xml(instead of "AssortmentPermissionAccessUserID") and in the job mappings.
AssortmentPermissionCustomerNumber should correspond to the user customer number, AssortmentPermissionExternalID to the user external Id.
Regards, Dmitrij

Votes for this answer: 1
 
Kristian Kirkholt Dynamicweb Employee
Kristian Kirkholt
Posted on 13/09/2018 11:31:05
Reply

Hi Tobias

The problem TFS#53530 "Ecom and Dynamicweb destination providers: not possible to import to EcomAssortmentPermissions table" has now been fixed in Package:

  • Dynamicweb.DataIntegration.Providers.DynamicwebProvider 2.0.1
  • Dynamicweb.DataIntegration.Providers.EcomProvider 2.0.1

You are able to find this update in the backend Package update section.

Also the correction are part of the 9.5 release 

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

 

You must be logged in to post in the forum