Developer forum

Hi Thomas,

Which version of Dynamicweb are you using?

Regards /Snedker

8.4.0.1

Came to think, so never mind the version:

Your config-snippet should go the top of the XML - not the XSL. The whole idea is that you can potentially determine the settings for every XML file you provide. You may want to use the same job to make updates every hour. But the XML at 01:00 should remove rows not provided in XML. For the other 23 imports they should be kept.

BUT! The config setting should be in the XML send to Data Integration. So if you have a translation, naturally, you should have XSL code that sends the config section forward to the final XML.

So: put the config to the top before the very first node in your XML (as given in documentation). Take a look at the transformed XML and make sure it is there, at the top.

Let me know how it goes!

Regards /Snedker

Hi Morten,

They are not in the XSLT file, i'm just using the XSLT file to generate the final XML file (Se attached xt file)

I'm putting the configuration section undet the tabels node, since XML documents cannot contains multiple root elements

I cannot open the file. Please just paste the content to your posting.

You are correct, there should be only one root element. The config section should be the VERY first section, just below the beginning of the root element.

Regards /Snedker

<?xml version="1.0" encoding="utf-8"?>
<tables>
  <config>
    <destination>
      <setting field="RemoveMissingAfterImport">False</setting>
      <setting field="DeactivateMissingProducts">False</setting>
    </destination>
  </config>
  <table tableName="EcomProducts">
    <item table="EcomProducts">
      <column columnName="ProductID"><![CDATA[000274]]></column>
      <column columnName="ProductNumber"><![CDATA[000274]]></column>
      <column columnName="ProductLanguageID"><![CDATA[LANG1]]></column>
      <column columnName="ProductVariantID"><![CDATA[]]></column>
      <column columnName="ProductName"><![CDATA[+Fedtspray lithium+quartz 400ml<br />MOTIP carbon grip (6)]]></column>
      <column columnName="ProductDefaultShopID"><![CDATA[SHOP30]]></column>
      <column columnName="ProductShortDescription" />
      <column columnName="ProductLongDescription"><![CDATA[]]></column>
      <column columnName="VariantGroups" />
      <column columnName="VariantOptions" />
      <column columnName="ProductManufacturerID"><![CDATA[]]></column>
      <column columnName="ProductPrice"><![CDATA[46.75]]></column>
      <column columnName="ProductStock"><![CDATA[552]]></column>
      <column columnName="CITMinQuantity"><![CDATA[1]]></column>
      <column columnName="CITPackages"><![CDATA[1]]></column>
      <column columnName="CITMinStock"><![CDATA[24]]></column>
      <column columnName="CITUnit"><![CDATA[Styk]]></column>
      <column columnName="CITItemGroupID"><![CDATA[0024]]></column>
      <column columnName="IsCampaign"><![CDATA[false]]></column>
      <column columnName="IsCampaignAlwaysActive"><![CDATA[false]]></column>
      <column columnName="PRIVATE"><![CDATA[false]]></column>
      <column columnName="FeaturedProduct"><![CDATA[false]]></column>
      <column columnName="ProductActive"><![CDATA[true]]></column>
    </item>
  </table>
  <table tableName="EcomGroups" />
  <table tableName="EcomGroupRelations" />
  <table tableName="EcomShopGroupRelation" />
  <table tableName="EcomGroupProductRelation">
    <item table="EcomGroupProductrelation">
      <column columnName="GroupProductRelationProductID"><![CDATA[000274]]></column>
      <column columnName="GroupProductRelationGroupID"><![CDATA[10-50-H]]></column>
    </item>
  </table>
  <table tableName="AccessUser" />
  <table tableName="EcomCurrencies" />
  <table tableName="NAV_SELECTION_ITEM" />
  <table tableName="NAV_SELECTION_CUSTOMER" />
  <table tableName="NAV_SYMBOLS" />
  <table tableName="EcomManufacturers" />
  <table tableName="EcomVariantGroups" />
  <table tableName="EcomVariantsOptions" />
</tables>

Is that the produced XML ready for import?

/Snedker

Yes

Hi Morten,

Any news?

Hi Thomas,

Could you try to put the config section to the source(original, not transformed) xml file and see if that work?

Taking config section from transformed xml file will be fixed in 8.4.1 version.
Best regards,
Dmitrij
 

Hi Dmitrij,

In this case i cannot have different source files, so i need the xslt file to override the configuration settings. 

In my opinion,this is a bug, and my customer is waiting for a solution. So can this be done in the next hotfix?

/Thomas

Hi Dmitrij,

Our common customer is waiting, would you please respond?

And what is the bug number for this?

/Thomas

Hi Thomas,
It is already fixed, the bug number is 14368.
Regards,
Dmitrij

Thanks, where can I get this? 

The Download section only includes 8.4.0.3

And it's not on the buglist for 8.4: http://developer.dynamicweb-cms.com/releases/dynamicweb-8-4/bug-fixes-8-4.aspx

Refresh the page, it's there now.And it will be on the buglist the next time the export is run