Developer forum

Forum » Integration
Subject
Replies
Started by
Last reply
Multiple Product Units combined with a simple stock import
Hi , I have defined and imported different product units. As you can see in the screenshot below, the defined 'Sales unit' is always the base unit: "always 1 piece". My source file with the stock quantities only has 1 line per produ ...
Davy Capiau
28/08/2023 17:11:35
Last post: 01/09/2023 15:09:06
EcomDiscount best practices
Hi, I'm using the DynamicwebProvider to import different discount rules. I have some questions: What is the best practice to import the translations of the rules in the EcomDiscountTranslations table? I want to avoid needing to export the rule id ...
Davy Capiau
10/08/2023 09:40:09
Last post: 29/08/2023 16:20:01
Liveintegration and manipulating salesline price via BC plugin custom unit
Hi, we are trying to extend the BC plugin unit on Cloud. We have looked a little at this thread: https://doc.dynamicweb.com/forum?PID=1605&ThreadID=87816 We are trying to manipulate it, and when we do, we sometimes get an error. Look at my attach ...
Jan Sangill
05/07/2023 08:08:21
Last post: 26/08/2023 09:07:04
BC Integration - Invoice discount including shipping fee
I have found an issue when trying to apply a full credit/discount to an order. This issue is related to the shipping fee. I want to apply an invoice discount amount of the full value of the order including the shipping fee. In the BC code unit the sh ...
Jon Thorne
23/08/2023 04:34:39
Last post: 23/08/2023 16:01:00
XML error when sending a request to Live Int
I try to get live prices but get a error that says: "Fjärrservern returnerade ett fel: (500) Internt serverfel. Response: The following exception was encountered when processing XML data: 'Data at the root level is invalid. Line 6, posi ...
Fredrik
23/08/2023 13:14:57
Last post: 23/08/2023 15:09:43
Connecting to BC gives error "Most Times"
Hello, I'm dealing with a difficult issue here, as the Plugin in BC seems to be installed correctly, I have a DynamicWebService installed locally that is configured correct;y, and I can use the testtool to get resuts from BC. However the response ...
Justin Sjouw
13/07/2023 15:32:12
Last post: 22/08/2023 15:58:34
Power BI integration
We have a client that wants to be able to access certain data from DW and use into Power BI. Is there any "easy" way of doing this? Or maybe its done before? We are thinking to expose data through and API endpoint, but thought it would be g ...
Anders Thoresen
22/08/2023 12:21:46
Last post: 22/08/2023 14:58:28
Changing input files result in full re-mapping
Hi, Is the behaviour seen here considered normal? or is there a way to preserve mapping from a previous version of a file i.e we have a new CSV file, with some fields added, and want to add these fields in the import job, it seems we need to redefine ...
Justin Sjouw
27/07/2023 10:40:11
Last post: 22/08/2023 14:25:06
Differences results between using Connector Test Tool and Liveintegration in backoffice
Hi, Im experience some differences between using the "DynamicwebConnectorTestTool (2.5.0)" and the liveintegrationen in Dynamicweb Admin backoffice. Both are set up to use the same Web service URL from the server. Any suggestions to why thi ...
Marie Louise Veigert
21/08/2023 10:36:42
Last post: 21/08/2023 12:01:40
Generate Passwords overwrites edited passwords
Hi guys, I have an integration job with NAV, we retrieve users from NAV and save them in DW or update their details. In the process, we are using the "Generate password for users". But I have noticed that if a user changes their password, t ...
Adrian Ursu
10/08/2023 14:09:13
Last post: 14/08/2023 11:23:22
Complete data in Business Central: Sales Header and Sales Line
Hello everyone, I have had a problem in the integration of orders between DW and BC 14.0 OnPrem, I must complement some data from the SalesHeader and SalesLine tables, for this I added the code in the OnBeforeUpdateSalesHeader event and the data is a ...
John Cristian Villamar Cueva
20/07/2023 01:21:50
Last post: 11/08/2023 16:31:50
Remove missing rows after import
Hi, I'm using the Ecom Provider on a DW 9.15.3 solution, to update products. Each language layer has its own integration job. When updating the Groups on a product, new product group relations are created, but the old and no longer active relatio ...
Kurt Moskjær Andersen
04/08/2023 14:08:18
Last post: 10/08/2023 08:07:09
User additional address import incorrect overwrite
Hi, I have created users via the user provider. Now I'm trying to add extra addresses via the user providers' AccessUserAddress table. During the first import my 2 additional (not-identical) addresses are imported. But then when reimporting,  ...
Davy Capiau
08/08/2023 14:58:33
Last post: 08/08/2023 15:33:40
Handling of DateTIme during import
Hi, Is there documentation about the handling of DateTiem fields in the import? I'm dealing with several possbile formats from a source and would like to know If there is anything I can/should do during import to make sure the source format is co ...
Justin Sjouw
26/07/2023 13:41:09
Last post: 07/08/2023 08:29:19
Conditionals not working while importing
Hi, When trying to skip rows where a value is null or empty I set this conditional, but it doesn't work: The result: the import behaves as if there was no conditional. I also tried with !@NULLOREMPTY My specific case: - CSV import - AccessUser Ta ...
Davy Capiau
02/08/2023 13:14:14
Last post: 02/08/2023 15:19:34
Need filtering of data and custom fields response from Business Central
We use the "Integration Customer Centre" to get data from Business Central and show it on the front end. While getting data from Business Central we have created End Point which communicates with Business Central. The End Point is configure ...
Girish Kamble
01/08/2023 16:34:21
Last post: 01/08/2023 17:34:19
Handling of empty decimal
Hello, Similar to https://doc.dynamicweb.com/forum?ThreadID=88520&PID=1605 I need to handle decimals with a CSV or Excel source and DynamicWeb and Ecom provider. I now have an error handling an empty value in a CSV, what is the preffered way to h ...
Justin Sjouw
27/07/2023 09:46:31
Last post: 28/07/2023 13:59:55
PIm Groups not visisble in PIM
Hello, I. working on importing a Group structure in PIM. The PIM Warehouse is defined as SHOP3 All groups are imported into EcomGroups (with a GROUPID provided in the source file) All GoupID's are added to EcomShopGroupRelation to connect them to ...
Justin Sjouw
25/07/2023 10:44:29
Last post: 25/07/2023 13:36:14
Customer integration Dynamicweb to Business Central for B2C
Hello, I am working on an integration from Dynamicweb to Business Central, for a B2C, but I am not very clear, how and where I can validate, if a user does not exist as a customer in the ERP, in order to create the customer before transferring the or ...
John Cristian Villamar Cueva
23/06/2023 09:08:44
Last post: 24/07/2023 12:54:54
OrderCustomerNumber in user integration from DW to BC
Hi, We have a B2C where users are created in DW and need to be integrated into BC. This way, we create the users in BC when the user places his first order. The problem is that, when placing an order, the UserID is not present in any field of the ord ...
Tomas Gomez
10/07/2023 13:07:00
Last post: 12/07/2023 13:02:39