Developer forum

Forum » Integration » importProductProperties not working

importProductProperties not working

E-mail notifications
Michael Knudsen
Reply
Posted on 24/01/2023 11:13:22

Hello forum,

- in a DW9.13.12 solution with integration to BC (cloud) with plug-in unit version: 1.2.0.31_NAV21.0.49939.52317 are we trying to get some product properties with a request like:

<GetEcomData><tables><Products type="all" setLanguage="LANG2" importProductProperties="true"/><RelatedProducts type="all" /></tables></GetEcomData>

However, when the import job run, it create the produktcategory 'ImportedNAVItemAttributes' but no of the fields are visible even they are in database?  

Checking the following tables in Firehose and the fields fields are created:
<table tableName="EcomProductCategory">
<table tableName="EcomProductCategoryTranslation">
<table tableName="EcomProductCategoryField">
<table tableName="EcomProductCategoryFieldTranslation" />
<table tableName="EcomFieldOption" />
<table tableName="EcomFieldOptionTranslation" />
<table tableName="EcomProductCategoryFieldValue">

Br. Michael Knudsen


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 26/01/2023 09:00:49
Reply

Hi Michael,

could you check if it is a caching issue? So can you restart the website and check?
Does it have a correct language id?
BR, Dmitrij

 
Michael Knudsen
Posted on 30/01/2023 17:01:45
Reply

Hello Dmitriy,

- website have been restarted, but it didn't have any impact. Default language is "LANG2" so that have been double checked.

However, I have been looking closer at the XML, and for some reason is there no translation of the "EcomProductCategoryField" fields in "EcomProductCategoryFieldTranslation"?
When I compare other product category fields (created manually), are they available in the "EcomProductCategoryFieldTranslation".

  <table tableName="EcomProductCategoryField">
    <item table="EcomProductCategoryField">
      <column columnName="FieldId"><![CDATA[ImportedNAVItemAttributes_1]]></column>
      <column columnName="FieldCategoryId"><![CDATA[ImportedNAVItemAttributes]]></column>
      <column columnName="FieldTemplateTag"><![CDATA[ImportedNAVItemAttributes_1]]></column>
      <column columnName="FieldType"><![CDATA[7]]></column>
      <column columnName="FieldDefaultValue"><![CDATA[]]></column>
      <column columnName="FieldPresentationType"><![CDATA[1]]></column>
      <column columnName="FieldDoNotRender"><![CDATA[false]]></column>
      <column columnName="FieldHideEmpty"><![CDATA[false]]></column>
    </item>
  </table>
  <table tableName="EcomProductCategoryFieldTranslation" />

 

Br. Michael Knudsen

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 08/02/2023 20:29:22
Reply

Hi Michael,
there is a typo bug in the BC Plugin codeunit so it lowercases the "setLanguage" parameter for comparison and that is why it does not then include the translation field values.
It will be fixed in the next BC plutin unit version. As a temporary solution for now you can run your query with lowercase setLanguage parameter:
<GetEcomData><tables><Products type="all" setLanguage="lang2" languages="ENU,DAN,DEU" importProductProperties="true"/><RelatedProducts type="all" /></tables></GetEcomData>
Then it will include the translations for the fields.
BR, Dmitrij

 

You must be logged in to post in the forum