Developer forum

Forum » Integration
Started by
Last reply
Important:  Did you know: about parameterized conditionals?
The idea of paramaterizing a Data Integration job, is basically that WHERE-conditions are set upon calling a job. So you can have a general job for multiple purposes, by setting the condition variables on the fly. Learn more here: https://doc.dynamic ...
Morten Snedker
14/09/2015 10:24:00
Last post: 09/02/2018 11:43:53
Important:  Data Integration jobs work locally / in test, but not live?
At helpdesk we frequently receive cases like: When running Data Integration jobs locally (test, staging) it works well, but when trying to execute on live solution, it fails (not with error, but just doesn't complete). Solution: Make sure that the we ...
Morten Snedker
11/07/2014 10:18:02
Last post: 27/08/2014 17:08:29
Dactivate missing products doesn't work
Hi, I'm currently working on a soltion with 3 different shops in 3 dirreferent languages. The products comes from NAV and almost all products exists in every shop. The product ID is the same and this should not be a problem because the primary key on ...
René Poulsen
04/07/2016 13:35:43
Last post: 13/08/2020 12:25:09
Product Groups integration has issue
EcomGroupsRelations table, not correctly picking the parentId, this version is 9.8.8 this same data set works fine on 9.6.13 Thanks ...
Shiwanka Chathuranga
20/07/2020 11:23:23
Last post: 12/08/2020 09:06:28
No data in DataIntegration log file
Hi I have made a Scheduled Task Addin using the Dynamicweb Templates Extension for Visual Studio. The addin runs fine, but there is no data in the log (\Files\System\Log\DataIntegration\[ScheduledTaskAddinName TimeStamp].log) after the task has runne ...
Lars Larsen
06/08/2020 12:06:34
Last post: 06/08/2020 13:16:31
Export failed orders as Excel
Hi guys, Is there any way I can export failed orders as independent files instead of cumulated in one excel file? And by failed I mean completed (new) but failed to be synced with the ERP. I am happy with any option. Data integration or order details ...
Adrian Ursu
03/08/2020 14:08:19
Last post: 03/08/2020 21:32:55
Performance DataIntegration module when SSL is enabled on SQL Server
Does anyone else experienced a huge performance drop in dataintegration when enabling SSL connections on the SQL server? And knows a solution to fix it? We have an integration that ran in about 15 minutes, after enabling SSL connections on SQL, the p ...
Ben Doorn
31/07/2020 15:57:36
Last post: 31/07/2020 21:19:03
Excel import cannot parse '1' to an System.Int32
Hi guys, I am trying to import an excel file that contains a few columns defines as numbers. I am using a Data integration job using Excel as source and EcomProvider as a destination. No matter how I format it, I keep getting the error below. Import  ...
Adrian Ursu
25/07/2020 15:28:02
Last post: 27/07/2020 10:41:12
Importing stock units, how to get output in product.units
Hello, We have a custom integration where we fill the following tables to get stock units (piece, box, pallet etc.) for our product-variants: EcomStockUnits EcomPrices EcomProductVariantOptions This seems to work since I can see them in the CMS on th ...
Hans Kloppenborg
29/06/2020 16:15:40
Last post: 29/06/2020 16:28:44
Import products from XLS on Azure
Hi, We're trying to import products into our DynamicWeb enviroment, but seem to run into an issue. When selecting a XLS files with product data, and clicking 'import products', we get the attached screenshot. When exporting and importing (and the sys ...
Ambert van Unen
25/06/2020 12:07:53
Last post: 25/06/2020 14:28:42
CSV Provider without string delimiter
Hi there, I would like to know if anyone has some pointers to avoid using string delimiters in the csv provider when writing a file. Do I need to write my own provider? Best Regards, Kasper ...
Kasper Laursen
22/06/2020 09:29:41
Last post: 23/06/2020 06:45:34
Fields of source column not updated
Hi, I have a Data Integration from the EcomProducts table to a CSV. When I add new Category Fields to the Product Catalog, these new fields are not included in the dropdown list of the Source colum menus (see image) What is need to update the dropdow ...
Tomas Gomez
03/06/2020 12:32:50
Last post: 12/06/2020 11:01:41
Hey Ill got a problem with the Ecom Provider, when importing new EcomProducts, a new Language is created with "ImportedLANG1", even when a language with same LanguageId "LANG1" exists, and products languageid is set to the new imported language id, c ...
Mark Preisler
24/06/2019 13:37:14
Last post: 10/06/2020 14:55:13
Dataintegration, xml-provider and conditionals
Hi, I'm trying to import users from an xml-file using the Dataintegration-module. I've setup conditionals, to only import the users created after a certain date. My conditional rule is set up like this: and the data in the column is formatted like th ...
Kurt Moskjær Andersen
27/05/2020 10:39:55
Last post: 29/05/2020 10:06:37
Job Failed with the following message: An item with the same key has already been added.
Hi Dynamicweb I run 9.8.5 and whatever data source I choose I get the same error Message: Job Failed with the following message: An item with the same key has already been added. Its a Rapido but all the rapido products is deleted. It sounds like thi ...
Kim Søjborg Pedersen
14/05/2020 13:56:28
Last post: 26/05/2020 14:43:46
Importing item relations
Hey I’m trying to import items and item list relations into DW, but the documentation for this I not that clear about how to do it. ...
Mark Preisler
30/04/2020 08:34:09
Last post: 26/05/2020 14:24:37
DynamicwebConnectorService throughts
Hola amigos, I'm reviewing and advising on some possible changes to one of our client's architecture in regards to how their backend systems are accessed from all possible client side platforms, this would include the Dynamicweb webshop they have and ...
Arnór Halldórsson
20/05/2020 18:26:10
No replies yet
Prepend not working when exporting data
Hi guys, I have a solution running DW 9.7.4 and I have been trying without success to output a feed with products. First, I have tried using the EcomProvider to export a CSV Product feed containing product data (including images). I have selected Pro ...
Adrian Ursu
15/04/2020 10:31:00
Last post: 20/05/2020 13:51:08
StockUnits not updated after import
Dear Dynamicweb, We have an issue with cache not being cleared in: StockUnitService as ClearCache() does not seems to be activated after importing data to EcomStockUnit. Can you please try to look into that? Best regards, Anders ...
Anders Ebdrup
20/04/2020 16:24:55
Last post: 20/05/2020 13:00:34
Prices not updated when using Live integration and Impersonation
Hi guys, We are experiencing a weird behavior on DW 9.8.5 using live integration and impersonation. Basically, what we see is that the prices are cached and persistent when changing the impersonated user. Apparently on logout or change impersonation, ...
Adrian Ursu
15/05/2020 12:49:42
Last post: 18/05/2020 14:36:18