Developer forum
Subject
Replies
Started by
Last reply
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
13
Subscribe
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
GetPDFForItem returns an empty PDF
Hi, We are having a problem with retrieving order PDFs from BC using the plugin 'Dynamics 365 BC22 - Dynamicweb Plug-In Unit 1.2.0.33 Runtime Package' I have sent the following requests to BC with 'DynamicwebConnectorTestTool (2.5.0)' ...
Roald Haahr
07/06/2023 09:18:06
Last post: 11/07/2023 15:47:18
Need to import Customers with unique AccessUserUserName from Business Center
Hi, I want to import customers from D365 Business Center. using <GetEcomData> <tables> <Customers type="all" /> </tables></GetEcomData> under "Dynamicweb codeunit request". But it is importing all the ...
Girish Kamble
07/07/2023 15:57:02
Last post: 10/07/2023 11:19:35
Integration RunJob - LastRun date/time set before next run
As of v9.15.5 the code has been updated to set the result of "job.LastSuccessfulRun" to the current date/time instead of the last run date/time. In commit "ea3a9f345ce7a3851bf1368084cf7c71e11de48e" this line was added: Line 508: S ...
Jon Thorne
05/07/2023 16:05:41
Last post: 07/07/2023 01:51:14
Debugging the CsvProvider with DW10/.NET7
Hi. I am currently working on an C4 Pim integration for a customer, and we are using DW10... When trying out import from csv file to the Ecom-provider I get information in the log about failing input row. And I wonder if it could be an issue with the ...
Joel Mandell
29/06/2023 11:31:18
Last post: 03/07/2023 08:35:43
Customize EcomProductCategoryFieldValue integration from Business Central
Hello everybody, I need help with the following, I have to customize the variant field in the integration of the EcomProductCategoryFieldValue table, look in AllExtensibilityEvents.svg, but I could not find any event where I can configure the nodes f ...
John Cristian Villamar Cueva
23/06/2023 08:37:04
Last post: 27/06/2023 13:49:12
Import group tree into PIM and Ecom
Hi, Im trying to import groups from ERP to both PIM and Ecom. Source is XML Provider Destination is Dynamicweb provider. I have this tables mapped: Im not getting a ShopGroupRelationsSorting, so every group is set to '0'. I tried to create at ...
Marie Louise Veigert
20/06/2023 12:42:14
Last post: 22/06/2023 10:32:48
Endpoint Management OData Request Error
Hi Matthias, Hoping you can help me with an error I am getting setting up an OData endpoint using endpoint management. The site is https://qa-aci.dw-demo2.com/Admin/Default with endpoint as https://internalcrmlivetest.online.agricover.com/CRMLiveTest ...
Shawn Tehini
08/06/2023 21:28:12
Last post: 19/06/2023 08:52:07
12
Subscribe
Integration Customer Center - GetList-requests using contact number
Hi Dynamicweb, When using Integration Customer Center for retrieving orders, invoices and credit memos from Business Central it is only possible to filter data by customer number. If many contacts share the same customer number then they have access ...
Niels Foldager
12/06/2023 09:12:45
Last post: 12/06/2023 14:59:37
Live integration Order Put ocasionally fails
Hi, At a customer the LiveIntegration with BC Is running smoothly overall, but sometimes, some orders are failing to insert into BC.I have asked the ERP partner to look at logging, but they clean up the event log daily they say (wich is brillian ofco ...
Justin Sjouw
12/06/2023 10:52:59
Last post: 12/06/2023 12:45:00
Integrates available stock with sales unit of measure instead of base unit of measure.
Hi everyone, I ask you for help with the following, I am doing a stock integration between Business Central and Dynamicweb, but it has a peculiarity, BC manages a base unit of measure and two sales units of measure, however in the ERP the stock is ma ...
John Cristian Villamar Cueva
08/06/2023 07:28:20
Last post: 09/06/2023 09:44:13
OAuth 2.0 for Business Central on-premise
Hi, For the authentication with a Business Central On Premise, can we also use the 'OAuth 2.0 for Business Central Cloud' as authenication type? The access token is received but when we try to make a request with the test tool we get a 401 Un ...
Jesse Bakker
08/06/2023 12:41:45
Last post: 08/06/2023 16:04:08