Data Integration activity failing with Item Provider destination and large XML file
Hello, I have a Data Integration activity that fails with the error below when the imported XML file is large ( > 10 Mb). Breaking the file into smaller parts allows the activity to complete successfully, however, because the destination provider ...
Often, partial updates of product details with NAV
Hi guys, We have a request from one of our customers to run often updates of products on a solution integrated with NAV. The database has about +15k products and the update is supposed to update some information on existing products. The NAV partner ...
Collation Error in Endpoint Management Adding New Endpoint
Hi, Building a new endpoint to associate with an authentican for a connection to F&O. Getting the following error: "Cannot resolve the collation conflict between "Danish_Norwegian_CI_AS" and "Latin1_General_100_CI_AS_KS_WS_SC" in the equal to ope ...
Dynamics BC integration and customer specific prices / campaigns
We have a issue with the Live Discount provider, related to customer specific prices and disabling line discount It is bit hard to explain, but I will give it a try. In BC we have setup a customer specific price for lets say "Product A" and "Customer ...
Martin Grønbekk Moen
Sync discount definitions between BC14 and Dynamicweb
Hi guys, Has anybody tried to sync the discount definitions between Business Central 14 and Dynamicweb? I have a request like this in one of our projects and my initial attempt is to say that it cannot be done. I just need to be sure before giving a ...
No replies yet
Hi, I'm exporting products from ecomproducts table to xml using Data Integration. How do I use conditionals to export products from a set of GroupIds? I tried this with no luck. "Groups - Contains - GroupX" "Groups - Contains - GroupY" And also this. ...
Avoid "KillAll" cache on import jobs
Dear Dynamicweb, We have a high performance webshop and would very much like to have added an extra checkbox on the destination settings for the Dynamicweb-provider and the Ecom-provider to disable the KillAll of all caching in the ecommerce and cont ...
Endpoint Provider and OData Provider - any guide?
Hi Dynamicweb, Do you have any documentation regarding the new integration providers in Dynamicweb 9.10 - "Endpoint Provider" and "OData Provider". Especially about the object type "Custom" and the ability to freely map entities without a dedicated o ...
Data Integration - Custom Destination Provider and OrdersProvider
I am creating a new Data Integration activity with Orders Provider as source and a custom Destination Provider (see attached file). When I create the activity, I select mapping for each table defined by the provider: When I run the activity I expect ...
TestTool - Using OAuth authentication to Business Central
Is it possible to configure the TestTool to use OAuth for connection to Business Central? Currently are we using Basic Auth, but is will be deprecated https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/deprecated-features ...
Error message with new default live integration
Hi there, I have a 9.10 project that has its own live integration. When using some functionality like the customer center we run into exceptions like this: Note how it's failing on the logger; I guess because it doesn't have a settings file. However, ...
What's the point of having the request body on a connection endpoint in Endpoint management?
Hi there, I am trying to understand how to use the Endpoint Manager for integration. I like the global concept of defining URL and credentials in a single location and then point to that configuration from my scheduled tasks. It seems, however, that ...
Cannot alter order after visiting checkout page
Hello, I am having a problem that I suspect is related to some logic in the DW code. My scenario is as follows. 1. I open the page that renders the information step of the cart app. The user is allowed to add items to the cart in this step, for each ...
Source file in data integration job is not updated
Running a 9.9.1, I am experiencing that a source XML file is not updated in the data integration job when I add a new property. This is an annoyance I have faced on other projects as well, so either I'm missing something or there is some sort of prob ...
custom call to ERP webservice using Integration Framework 2
Hi, I am setting up an integration using IF2 with Live Integration. I have some custom functionality that I would like to implement, which means that I would simply like to CallErpService(WithMyCustomXML) and get back the response XML from the ERP. H ...
Jonas Krarup Dam
How to avoid encoding of æ ø å in a product export?
I am making a product export (an xml file of all products) using the data integration. One of the fields in the product export is the product description, which is the standard wysiwyg ckeditor in the backend. The product descriptions are in Danish a ...
IntegrationCustomerCenterItem prefix on documents when using GetList request
Hi guys, We have received a request from a customer to change the name of the pdf files that are saved from IntegrationCustomerCenter. It looks like they get an "IntegrationCustomerCenterItem" prefix and I have no idea if I can edit this prefix witho ...
Integration with Microsoft NAV 2018 with discounts calculated in ERP
Hi guys, I have an unusual situation with one of our integrations. We are using DW 9.9.6 and Live Integration Framework v2 with code-unit 18.104.22.168. The customer is using discounts in NAV and we want to use ERP for the discount calculation. We have mad ...
Import job failed: cannot parse '1' to an System.Int32.
Hi guys, I am constantly having issues with Data Integration jobs where I use Excel as input. No matter if I use Dynamicweb Provider or EcomProvider, the columns that are supposed to be identified as Int, are mapped in the job as Double and the impor ...
Integration to Amazon
Hi, We want to integrate DW with Amazon, both the PIM products and the eCom orders. Reading the docs, there are two options (with or without Channable). Which are the pros-and-cons of each option? And, from your experience, how do you test the order ...