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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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
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 ...
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 ...
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 ...
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
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
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. https://doc.dynamicweb.com/documentation-9/integration/data-integration-module/integration-providers/item-provider#547 ...
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 ...
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 ...
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 ...
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, ...