Developer forum

Forum » Integration » Import ProductLongDescription from BC

Import ProductLongDescription from BC

Tomas Gomez
Reply

Hi,

In a Swift solution, I configured a product integration from a Busines Central OnPremise. The field products are imported correctly except the ProductLongDescription. According the documentation on BC mappings this field is not imported automatically (only the ProductShortDescription but not the ProductLongDescription)

What is the best method to import a long description from BC? An alternative would be to create a custum field on BC and import it inside the ImportedNAVItemAttributes category, but then it eould needed to copy that value to the ProductLongDescription field. Anothe possibility would to manually enrich the description in the Ecom module, but his is a very standard field so for sure there has to be an easier way :-)

Regards
Tomas


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Tomas,
in the one of the latest versions of the Dynamicweb Plugin Unit app for the BC there was a new feature implemented called "support custom fields":
https://doc.dynamicweb.com/documentation-9/integration/integration-framework/requests-responses#sideNavTitle1-2-13
Type in the search and choose:


Choose "Item" and select the field you need in the drop down, fx:




Then the custom field will appear in the get products response:
Request:
<GetEcomData><tables><Products type="all"  setLanguage="abc" /></tables></GetEcomData>
Response:
<?xml version="1.0" encoding="utf-16"?>
<tables version="1.2.0.21_NAV19.0.29480.30268">
  <table tableName="EcomProducts">
    <item table="EcomProducts">
      <column columnName="ProductID"><![CDATA[1000]]></column>
      <column columnName="ProductLanguageID"><![CDATA[abc]]></column>
      <column columnName="ProductVariantID"><![CDATA[]]></column>
      <column columnName="ProductNumber"><![CDATA[1000]]></column>
      <column columnName="ProductName"><![CDATA[Bicycle]]></column>
      <column columnName="ProductShortDescription"><![CDATA[]]></column>
      <column columnName="ProductPrice"><![CDATA[4,000.00]]></column>
      <column columnName="ProductStock"><![CDATA[32]]></column>
      <column columnName="ProductWeight"><![CDATA[0]]></column>
      <column columnName="ProductVolume"><![CDATA[0]]></column>
      <column columnName="ProductManufacturerID"><![CDATA[]]></column>
      <column columnName="ProductActive"><![CDATA[true]]></column>
      <column columnName="ProductVariantCounter"><![CDATA[0]]></column>
      <column columnName="ProductDefaultUnitID"><![CDATA[Unit_PCS]]></column>
      <column columnName="ProductEAN"><![CDATA[]]></column>
      <column columnName="ProductNo"><![CDATA[1000]]></column>
      <column columnName="ProductDescription"><![CDATA[Bicycle]]></column>
      <column columnName="ProductSearchDescription"><![CDATA[BICYCLE]]></column>
      <column columnName="ProductAssemblyBOM"><![CDATA[No]]></column>
      <column columnName="ProductAllowInvoiceDisc"><![CDATA[Yes]]></column>
    </item>
Then you can map the fields from the xml to the needed Dynamicweb Products field in the Data integration job mappings.

BR, Dmitrij

 
Tomas Gomez
Reply

Hi Dmitriy,

Thanks for the info. Actually, we also informed our client about that link but he told us that "in the ERP the options shown in the link do not appear (Dynamicweb Custom Fields List or Dynamicweb custom field configuration edit)"

Could it be because it is an OnPremise installation of BC? Is our client missing any configuration to display those options?

Regards,
Tomas

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply
This post has been marked as an answer
Hi Tomas, Maybe the installed app is an old one. What is your extension bersion number? You can download the latest from the doc site, there are versions for BC 14, 18, 19. BR, Dmitrij
Votes for this answer: 1
 
Tomas Gomez
Reply

Thanks, we will inform our client to check the version number.

 
Tomas Gomez
Reply

Hi Dmitriy ,

Our client installed the new plug-in (see image 1) but there is not a feature called "Dynamicweb custom fields list"  (see image 2) .

Could it be because it is an OnPremise BC? Are we missing any other configuration?

Regards,
Tomas

 

bc1.png bc2.png
 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Tomas,
the problem is that it is not merged to BC14, so I am sorry but it is not available in 1.2.0.19 BC14.
Could you use the version 1.2.0.21 for BC18/BC19?
BR, Dmitrij

 
Tomas Gomez
Reply

Hi Dmitriy ,

Thanks or the prompt answer, we will inform our client to try it.

Regards,
Tomas

 
Tomas Gomez
Reply

Hi Dmitriy,

Our client tried to install the Dynamicweb Plug-In Unit 1.2.0.21 Runtime Package for the DBC18 version, but he got the following error.

Is it possible to fix this error?

WARNING: UnhandledErrorMessage

Publish-NAVApp : File contains corrupted data.
At line:1 char:1
+ Publish-NAVApp -ServerInstance DBC_COSTO -Path 'F:\Dynamicweb\PluigIn ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Publish-NAVApp], FileFormatException
    + FullyQualifiedErrorId : System.IO.FileFormatException,Microsoft.Dynamics.Nav.Apps.Management.Cmdlets.PublishNavA
   pp

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Tomas,
have you downloaded this version? Then un-zipped it and read and follow the instructions from the readme.txt file?
Then run the command: 
Publish-NAVApp -ServerInstance BC -Path 'C:\Dynamicweb_Dynamicweb Plug-In Unit_1.2.0.21.app' -SkipVerification
From the command you posted it seems you have a wrong name: "F:\Dynamicweb\PluigIn ....".
Try to check the command and its arguments carefully.
BR, Dmitrij

 

You must be logged in to post in the forum