Developer forum

Forum » Integration » Ecom Groups Import - Fail to import tree structure (nested groups)

Ecom Groups Import - Fail to import tree structure (nested groups)

Finn Frost
Reply

Hi,

Im trying to use the DataIntegration module, the XML Provider (Source) and the Ecom Provider (destination), to import Groups to the Product Catalog.
The import executes well, but all groups are placed in the root of the shop, but they were expected to be place in 3 groups in the shop, and all other groups as subgroups for those 3 groups.

Instead of beeing imported as:

ShopName

- Fag
--- BogFøring
--- Læge

They are being imported like:

ShopName

- Fag
- BogFøring
- Læge

 

Below is a snippet of my xml group import:

 

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<tables>
  <table tableName="EcomGroups">
    <item table="EcomGroups">
      <column columnName="GroupID"><![CDATA[PbFag]]></column>
      <column columnName="GroupName"><![CDATA[Fag]]></column>
      <column columnName="ParentGroups" isNull="true" />
      <column columnName="Shops"><![CDATA[SHOP4]]></column>
      <column columnName="GroupLanguageID"><![CDATA[LANG1]]></column>
      <column columnName="GroupNavigationShowInMenu"><![CDATA[true]]></column>
      <column columnName="GroupNavigationShowInSiteMap"><![CDATA[true]]></column>
      <column columnName="GroupNavigationClickable"><![CDATA[true]]></column>
      <column columnName="GroupInheritOrderLineFields"><![CDATA[true]]></column>
    </item>
    <item table="EcomGroups">
      <column columnName="GroupID"><![CDATA[PbFagLæge]]></column>
      <column columnName="GroupName"><![CDATA[Læge]]></column>
      <column columnName="ParentGroups"><![CDATA["PbFag"]]></column>
      <column columnName="Shops"><![CDATA[SHOP4]]></column>
      <column columnName="GroupLanguageID"><![CDATA[LANG1]]></column>
      <column columnName="GroupNavigationShowInMenu"><![CDATA[true]]></column>
      <column columnName="GroupNavigationShowInSiteMap"><![CDATA[true]]></column>
      <column columnName="GroupNavigationClickable"><![CDATA[true]]></column>
      <column columnName="GroupInheritOrderLineFields"><![CDATA[true]]></column>
    </item>
    <item table="EcomGroups">
      <column columnName="GroupID"><![CDATA[PbFagBogføring]]></column>
      <column columnName="GroupName"><![CDATA[Bogføring]]></column>
      <column columnName="ParentGroups"><![CDATA["PbFag"]]></column>
      <column columnName="Shops"><![CDATA[SHOP4]]></column>
      <column columnName="GroupLanguageID"><![CDATA[LANG1]]></column>
      <column columnName="GroupNavigationShowInMenu"><![CDATA[true]]></column>
      <column columnName="GroupNavigationShowInSiteMap"><![CDATA[true]]></column>
      <column columnName="GroupNavigationClickable"><![CDATA[true]]></column>
      <column columnName="GroupInheritOrderLineFields"><![CDATA[true]]></column>
    </item>
  </table>
</tables>

 

Any help is much appreciated.


Replies

 
Dmitriy Benyuk
Reply
This post has been marked as an answer

Hi Finn,

I was able to import your xml and it was imported with the expected result with groups hierarchy.
Have you included the "ParentGroups" column into the job mappings?
See below:



Best regards,
Dmitrij

Votes for this answer: 1

 

You must be logged in to post in the forum