Developer forum

Forum » Integration
Subject
Replies
Started by
Last reply
Azure and Microsoft.ACE.OLEDB.12.0 error on import
Hi, The solution is hosted in Azure and I get the error The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. when trying to import from excel to PIM. Normally I just install the driver but what do I do in Azure? Bes ...
Kim Søjborg Pedersen
07/07/2021 11:55:30
Last post: 09/07/2021 10:08:00
Data integration with destination as Item Provider deletes items on other sites
Hi Forum, Does anyone know how to solve this issue: We have set up an integration job with the item provider as destination. In 'New items root page' we have set the root page to the Swedish language site. We wish the job to clean up and remove missi ...
Helene Kjærbøl
23/06/2021 10:47:28
Last post: 08/07/2021 12:13:06
Inconsistent date format between Export and Import
Hi guys, I have a situation on DW 9.9.8. I am exporting regularly the content of the EcomPrices table in order to give the admins a starting point for reimporting Prices. The problem I have is the date format. If I use the same date format for PriceV ...
Adrian Ursu
07/07/2021 10:37:32
Last post: 07/07/2021 23:48:22
Users import issue - timeout
Hi, I’m experiencing some issues when trying to import users from an XML file provided by Business Central. The process seems to fail due to Timeout after 1 hour. Maybe it’s related to the huge number of user addresses. Below you can see  ...
Ricardo Pereira
07/07/2021 18:04:45
Last post: 07/07/2021 22:32:49
Is the DW Codeunit 12.0.16 for BC18 compatible with BC Cloud 18.2?
Hi DW, We have a client who is upgrading to BC cloud version 18.2 from 18.1 and wants to know if the current version of the DW Codeunit (12.0.16) is compatible with the newer BC Cloud version 18.2. Last time microsoft pushed a upgrade they didnt have ...
Jannich Ariyanayagam
07/07/2021 11:49:42
Last post: 07/07/2021 18:59:25
Deleted orderlines are cached when editing order
Hi, We are experiencing and issue reported in forum post, https://doc.dynamicweb.com/forum/integration/orderprovider-feature-remove-missing-order-lines-not-working?PID=1605. The fix Mario completed to clear the cache before getting the order and call ...
Shawn Tehini
23/06/2021 22:42:58
Last post: 30/06/2021 13:32:54
BC14 Live integration Filter products
Hi, Is it possible to filter out products from BC codeunit plugin whenever DW connector asks for products? :) Right now we only want to fetch 2000 products to the shop when doing a full import but we get 70000 products from BC and the ERP supplier do ...
Jannich Ariyanayagam
25/06/2021 14:53:34
Last post: 25/06/2021 15:34:48
Notifications of scheduled task
Hi, I configured a scheduled task to send a notification. It is just to settup the e-mail data but it doesn't send any mail when I run the task, not even when "Only on failure" is unchecked. Do I miss any other configuration to receive a mail wheneve ...
Tomas Gomez
17/06/2021 14:00:41
Last post: 18/06/2021 13:50:34
Endpoint, OData, and JSON provider data mismatch
Hello, I have been working with the Endpoint and OData providers creating data integration jobs from Custom API pages in BC. Currently I am working on a products import and am running into a data mismatch error. Import job failed: cannot parse '125'  ...
Jeremy Fesmire
16/06/2021 00:41:24
Last post: 17/06/2021 10:50:59
Bad response times loading products lists with live integration enabled
Hi, we have very long loading times when showing product listing pages. I can see in the live integration log file that we have 500+ calls to BC when loading the product listing, and we are just listing 24 products on each page. It seems that live in ...
Johan Ulff
14/06/2021 09:09:04
Last post: 16/06/2021 14:05:28
Web connector request directly from code
Hi, can we do Dynamicweb connector request directly from code? We want to make a price request like below and skip the live integration price request. The connector request is normally encrypted with a key, how do we do this from code? <GetEcomDat ...
Johan Ulff
15/06/2021 09:07:20
Last post: 15/06/2021 09:20:21
License error in Live Integration
Hi there, I am on a staging server and encountering some issues with Live Integration. On cart calculation calls I get this error: License is not valid. I tracked it down to the license manager which does this: private static bool IsFeatureEnabled {  ...
Imar Spaanjaars
10/06/2021 22:50:48
Last post: 11/06/2021 11:44:23
Multiple instances of live integration add-in
Hi, Is it possible to create more than one instance of the ERP Live integration Add-In? Our customer has 2 BC instances for different countries with different webservices so we need to create another live integration. Or should we use the other versi ...
Johan Ulff
10/06/2021 10:14:11
Last post: 10/06/2021 13:52:24
VAT calculation on BC orders
Hi We have a weird issue with VAT calculation when creating orders using live integration towards a BC18 running code unit version 1.2.0.13. It seems that the database columns "OrderPriceBeforeFeesWithoutVAT" and "OrderPriceBeforeFeesVAT" are not get ...
Chris Søgaard
08/06/2021 12:38:18
Last post: 10/06/2021 09:36:29
Import price from ERP on familiy products
I would like to get feedback from the community on one particular issue we have related to importing prices. In our scenario we are importing all products from ERP (NAV). There are two import jobs, one for products, and another one for prices. This i ...
Martin Grønbekk Moen
08/06/2021 22:09:28
Last post: 09/06/2021 15:45:07
AX 2012 auto-charges
Hi, I am getting this error when submitting orders to AX that have auto-charges: Exception: Exception of type 'Microsoft.Dynamics.Ax.Xpp.InvalidRemoteCallException' was thrown. This is happening when calling the function "salesLine.initFromInventTabl ...
Jon Thorne
04/06/2021 03:51:34
Last post: 07/06/2021 20:46:40
Importing customers or contacts
Hi, I am using the following request to get all customers från BC: <GetEcomData><tables><Customers type="all" importContacts="false"/></tables></GetEcomData> and all contacts with this request: <GetEcomData><tab ...
Johan Ulff
03/06/2021 15:26:31
Last post: 07/06/2021 11:31:47
Shipping method code and agent in BC integration
Just wondering, how are we supposed to handle shipping in the BC integration? DW is sending a node in the XML for OrderShippingMethodId with an walue of SHIP[X] but BC does not know this code. Are there any settings in the BC integration mapping thes ...
Martin Grønbekk Moen
02/06/2021 20:25:52
Last post: 03/06/2021 08:31:02
Creating users and sending them activation/password reset link
Hi, We're experimenting with using the User Provider data integration method to allow support staff to create new Dynamic web users from our CRM system. We already have a working flow like this: Record is created in an external database table with al ...
Þórhallur Hálfdánarson
08/05/2018 17:03:27
Last post: 03/06/2021 08:18:04
Wrong format of Ship-to address
Hello forum, - we are getting users/customers from BC using the Dynamicweb integration tool using the request below: <GetEcomData><tables><Customers type="all" importSalesPeople="false" /></tables></GetEcomData> When we  ...
Michael Knudsen
19/05/2021 16:53:53
Last post: 02/06/2021 22:59:50