Developer forum

Forum » Integration
Subject
Replies
Started by
Last reply
Lazy loading LI prices loads from db
Hi there, I have a site that uses live prices. When I view a list or details price I get the price from the ERP. All good. When I turn on "Lazy load product info" the prices are loaded lazily (I get a spinner before seeing the price) but th ...
Imar Spaanjaars
23/04/2024 17:51:15
Last post: 24/04/2024 10:31:57
Duplicate live requests for multiple countries
Hi there, I have a site using a recent version of live integration. When logged in I am getting customer specific prices. However, the LI logs show that two requests are made for each product: for two different VAT countries (DK and GB in my case). T ...
Imar Spaanjaars
23/04/2024 17:23:34
Last post: 23/04/2024 21:38:18
Importing address takes a very long time
Hi there, I have an XML file with user and addresses. When I trim the file to 2K users and 3K addresses, the import completes in under 20 seconds. When I expand the file to 45K addresses, the job never seems to complete (or at least, it's been ru ...
Imar Spaanjaars
23/04/2024 16:31:58
Last post: 24/04/2024 08:46:37
Integration job fails instantly but work on another site
Hello forums, I have two websites with identical integration jobs using an identical staging table as the source and using dynamicweb provider as the destination provider. The websites use two different databases and the staging table exists in both. ...
Skylar Kennedy
16/04/2024 21:23:57
Last post: 17/04/2024 15:00:55
Set custom field before product info request is sent
I would like to temporarily set a product field whenever a request is sent to ERP to get product information. I do not want the field to be saved, it is a dynamic value which depends on the customer and context. I tried something like this, but I fee ...
Martin Moen
10/04/2024 08:44:43
Last post: 10/04/2024 11:19:25
LiveIntegration - removing lines of type Fixed
Hi, We noticed that ProcessOrderLines method in OrderHandler.cs is not handling fixed orderlines (OrderLineType == "2") which ends removing them. This prevents custom fees from added to the order, ending in order total mismatch. Can this be ...
Mario Santos
05/04/2024 11:50:25
Last post: 05/04/2024 14:00:23
Update order with 'shipped quantity'
Hi, In our project (DW10, SWIFT & NAV '13) we would like to update orderlines with the 'amount shipped'. Flow: 1. Order placed on DW 2. Order created in NAV 3. Order partially shipped in NAV 4. Orderline in DW gets updated with 'a ...
Davy Capiau
25/03/2024 13:45:02
Last post: 19/04/2024 11:49:34
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