Sorting of the top-level groups

Gaetan Di Caro

Posted on 29/02/2016 14:01:20

Hi,

I'm having a problem with the groups integration. I'm trying to import the original sorting of the groups at the root of the website. For that I have a job with an ecom destination wchich maps to EComGroups.

I mapped the columns 'Shops' and 'ShopSorting' to columns from my source. However, after import I can see that the sorting isn't taken into account. Am I missing something there ? The issue could potentially be related to this : http://developer.dynamicweb.com/forum/integration/group-sorting-reset-to-0-after-integration-.aspx

Right now the solution is only local, I'm using V 8.8.0.1.

Thanks !

2016-02-29_13_45_35-SQLQuery70.sql_-_192.168.16.80_sql2012.master_(PICOPUBLISH_gdc_(61))__-_Microsof.png

2016-02-29_13_50_31-SQLQuery71.sql_-_192.168.16.80_sql2012.master_(PICOPUBLISH_gdc_(63))_-_Microsoft.png

Replies

Dmitriy Benyuk

Posted on 01/03/2016 14:52:53

Hi Gaetan,
I was using XML -> eCom import job with the following xml and mapping with GroupID, Shops, ShopSorting and it was working fine to me:
<?xml version="1.0" encoding="utf-8"?>
<tables>
<table tableName="EcomGroup">
    <item table="EcomGroup">
      <column columnName="GroupID"><![CDATA[GROUP50]]></column>
      <column columnName="ShopGroupShopID"><![CDATA["SHOP2"]]></column>
      <column columnName="Sorting"><![CDATA["32"]]></column>
    </item>
</table>
</tables>
Could you check you source provider data?
Maybe the problem is with the quotation marks around "SHOP1" in your source table, could you try to remove them and check?
Regards, Dmitrij

Gaetan Di Caro

Posted on 03/03/2016 10:01:38

Hi,

I checked the data and I see nothing wrong with it (you can see it on the first screenshot, I have 2 columns : one with the shopid, and one with the sort value). The quotes are here because the documentation asks me to : http://developer.dynamicweb.com/documentation/for-developers/data-integration/providers/ecom-provider.aspx

I tried without them but it doesn't change.

Gaetan Di Caro

Posted on 09/03/2016 08:58:36

Any idea ? I can do a workaround by mapping the ShopGroupRelation table but I'd rather it works as it should to not have to create a new job

Gaetan Di Caro

Posted on 26/08/2016 14:28:13

V8.8.1.9 and it's still not working...

2016-08-26_14_27_13-Lavazza_-_Dynamicweb_Administration.png

Dmitriy Benyuk

Posted on 26/08/2016 16:23:04

Hi Gaetan,
please see the attached source xml file, the job xml file and the mapping, it differs a bit from your mapping, but it helps to import top level groups to the Shop.
If you need also import subgroups include the "ParentGroups" and according "ParentGroupsSorting" columns to your source/destination files/mappings with relevant data.
Regards, Dmitrij

data.xml

job.xml

Gaetan Di Caro

Posted on 29/08/2016 08:07:44

Yes, that's what I do it seems (I truncated the screenshot for the job). The difference however is that I have subgroups. Does your example still work if you have them ? Does the shopid need to be null or empty in case it's a subgroup ?

You must be logged in to post in the forum

Developer forum

Sorting of the top-level groups

Replies