Developer forum

Forum » Integration
Subject
Replies
Started by
Last reply
Changes in Destination Table Results in Slow Performance in Data Integration Job
I am noticing that if changes are being made to the destination table in a data integration job (i.e. adding, renaming, or removing fields) it is causing significant performance issues. This seems to happen even though the fields are being updated in ...
Byron Head
22/03/2024 16:18:45
Last post: 22/03/2024 16:30:03
Liveintegration - ERP controls shipping calculations
Hi, We have setup in Dynamicweb to let BC controll the shipping fee calculactions. How do we explain to the ERP partner how they need to setup it on the BC side to return shipping fee? I have looked through doc site but cant find documentation. ...
Magnus Holmberg
22/03/2024 10:50:43
Last post: 28/03/2024 15:59:34
URL handlers with multiple sites and submitting an order from the backend
Hi there, I have multiple live integration connections set up like this: http://1.2.3.4:9090/DynamicwebService_Company1_Test;User.AccessUser_ErpConnectionSource;Company1 http://1.2.3.4:9090/DynamicwebService_Company2_Test;User.AccessUser_ErpConnectio ...
Imar Spaanjaars
10/03/2024 17:01:29
Last post: 25/03/2024 14:12:38
Error loading custom table with varbinary (blob) datatype in SQL Server
I created a data integration job to pull product image files from AX into a custom table in SQL Server. The source is XML and the destination is the DynamicWeb Provider. The custom table has three columns that correspond with the three columns in my  ...
Byron Head
21/02/2024 21:19:21
Last post: 21/02/2024 22:19:34
When is the ShippingMethodCode sent to ERP in LiveIntegrations?
Hi guys, I have a project that is integrated with BC. We have defined a couple of ShippingMethods in DW, according to the definitions and codes in BC. On the carts, I see that the value for ShippingMethodCode is saved correctly on the order. But I do ...
Adrian Ursu
21/02/2024 09:47:26
Last post: 21/02/2024 11:04:12
LiveIntegration when order is sumitted, then price is wrong in DW and receipt on orderline
Hi, I have an issue with live integration and my shop. It seems the creation of an order sets the standard price for an orderline, and not the discountet price from BC. Discounts are handled by BC. I can see in my log that what is sent to the BC is & ...
Jan Sangill
16/02/2024 14:23:50
Last post: 08/04/2024 09:25:14
From BC D365 on-prem to BC D365 cloud
I have a potential customer for Dynamicweb who has D365 on premise but will move to D365 cloud in the future. How much of the investment will be wasted in terms of what needs to be changed in Dynamicweb? It's only changes in DW that I'm curio ...
Kim Søjborg Pedersen
12/02/2024 09:56:20
Last post: 12/02/2024 10:33:21
OData error reporting
(Reposting this; I originally posted this in the Development category) Hi there, I have a site with 7 jobs that connect using the OData provider (prices, products, orders, order lines and more). Every now and then (roughly every other day) all 7 jobs ...
Imar Spaanjaars
20/01/2024 14:16:15
Last post: 06/02/2024 17:34:41
BC Live order integration
Hi, Is there any documentation where fields from dynamicweb orders ends up in BC? And is it possbile to map the fields in BC without using some sort of extension? Best regards Magnus ...
Magnus Holmberg
16/01/2024 13:53:48
Last post: 17/01/2024 22:03:35
Change in date handling in OData provider
Hi there, Previously, when I imported datetime minvalue from BC (0001/1/1) into DynamicWeb it would end up as 0001/1/1 in the database also (I am using datetime2 as the column type which should support this). After upgrading to Dynamicweb 9.16.4, the ...
Imar Spaanjaars
06/12/2023 13:27:03
Last post: 03/01/2024 09:39:28
Dynamicweb.DataIntegration.Providers.DynamicwebViewProvider not included in App zip
Hi there, I downloaded 9.16.4 to update a site. I noticed that the ZIP doesn't include the DynamicwebViewProvider dll anymore. I do see it, however, referenced in the Admin csproj file: <PackageReference Include="Dynamicweb.DataIntegratio ...
Imar Spaanjaars
06/12/2023 10:47:41
Last post: 06/12/2023 14:01:10
Retrieving Stock Location information in Live Integration
Hi guys, I have a project where I need to ask BC to send over Stock Location availability in the Live Integration response and map the info to the existing Stock Locations in Dynamicweb. Basically, I need to map information to Stock Matrix based on t ...
Adrian Ursu
22/11/2023 11:03:43
Last post: 28/11/2023 19:53:25
Live Integration Discount
Hi, I have a situation where I might be missing some setting, but I'm unsure what is misconfigured. It concerns a dw 9.15.10 solution connected to BC14 via LiveIntegration, there the Live Prices are enabled, and ERP Controls discounts is checked. ...
Justin Sjouw
14/11/2023 16:52:26
Last post: 27/12/2023 12:47:50
How-to's for Live Integration / Custom Connectors
Can someone point me in the direction of some how-to's / examples (if they exist) on the dev / installation of connectors on the customer side? Is using a connector the only approach? We also have the possibility of creating a JSON based RestAPI  ...
Stephen Anthony Jackson
10/11/2023 10:48:18
Last post: 14/11/2023 13:06:27
Deactivate missing users and endpoint provider
Version: DW 9.16.1. I cant get the "Deactivate missing users" option to work when applied to a "User provider" as destination and a "Endpoint provider" (oData) as a source. No errors, but the missing users from the oData ...
Martin Moen
05/11/2023 12:12:39
Last post: 06/11/2023 10:17:13
Adding adapter breaks job
Hi there, Adding an adapter to an integration job breaks that job with an exception. Steps: 1. Open integration job 2. Click Add Adapter 3. Type a name and choose ConcatanateFieldsAdapter [sic] 4. Click Save and Close 5. Click Save and Close again 6. ...
Imar Spaanjaars
26/10/2023 22:07:23
Last post: 07/06/2024 07:46:31
PATCH option for Endpoints
Hi guys, I have noticed there is no PATCH option when using the Endpoints. Is this by design? Can I override this limitation? I need to be able to edit records in BC without using the DataIntegration Batch jobs. I am trying to use the endpoint from t ...
Adrian Ursu
18/10/2023 18:29:09
Last post: 19/10/2023 09:53:48
ForeignKey conflict when using double underscores (__)
Hi guys, I have some data containing double underscores (__) as follows: ProductID, ProductCategoryId, ProductCategoryFieldId, GroupId. I am trying to export and import this data into DW. Most of the data can be imported correctly but I get some weir ...
Adrian Ursu
17/10/2023 13:30:25
Last post: 18/10/2023 11:23:26
Fail on importing exported CSV files.
Hello. I am trying to do a simple export/import using ECom Provider as export source (have tried both name and ID options), and CSV provider as destination. As part of this process, I have to delete the 3-byte headerless CSV's created for empty e ...
Stephen Anthony Jackson
16/10/2023 13:04:39
Last post: 20/10/2023 18:34:45
AX LiveIntegration settings "ERP shipping item type"
Hi, Could you please advice what is the purpose of the setting "ERP shipping item type" in AX LiveIntegration component in DW? In documentation this setting does not exist, trying to play around with this setting did not have any impact (se ...
Tomas Vasiliƫnas
12/10/2023 15:34:37
Last post: 12/10/2023 15:51:24