Developer forum

Currently discussing: Plans to implement a Consent module for GDPR compliance.

Join the discussion!

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: http://developer.dy ...
Morten Snedker
14/09/2015 10:24:00
No replies yet
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
XML Provider Export generate file every time
Hi I've setup an export job of orders, with SQL Provider as source and XML Provider as Destination, I have a xsl that format the xml. Every time I run the job I get a xml file, even if there is no rows from the source. Is there anything I can do to p ...
Allan Have Jakobsen
08/01/2018 09:58:51
Last post: 19/01/2018 09:05:35
DW9: Import fails for non-existing AccessUserAddresses
Hi Dynamicweb, We have an issue when importing user addresses for non-existing users, as you have no logic for deleting excess entries as for secondaryrelations: updateUserIdSql.Append("delete from AccessUserSecondaryRelationTempTableForBulkImport wh ...
Anders Ebdrup
27/12/2017 12:21:40
Last post: 16/01/2018 15:25:02
Exporting and then importing items that have fields of type Item Relations List
Hi, Just a "short" question before digging myself into a dead end... Is it possible to Export and then Import a bunch of paragraph items, which have a field of type Item Relations List AND on these Related Items there are also a field of type Item Re ...
Jacob Storgaard Jensen
26/12/2017 00:39:13
Last post: 26/12/2017 11:38:40
OrderUser export - some issues
We have integration with NAv using the "Integration Framework Batch". On of the tasks is to export users and orders. There we have defined a orderexport and and userexport in the Data Integration. The problem we have is that sometimes the Navison is  ...
Aki Ruuskanen
22/12/2017 08:27:17
Last post: 02/01/2018 13:15:58
Error creating indexes for the table AccessUserSecondaryRelationTempTableForBulkImport1
Hi Dynamicweb, We experience this error when importing into: AccessUserSecondaryRelation Error creating indexes for the table AccessUserSecondaryRelationTempTableForBulkImport1: ExecuteNonQuery: CommandText property has not been initialized It seems  ...
Anders Ebdrup
18/12/2017 19:13:00
Last post: 19/12/2017 15:25:12
Dynamics NAV 2013 to Dynamics NAV 2017
Hi DW, I have gotten a question from one of our customers Data providers who asks: When upgrading from Dynamics NAV 2013 to Dynamics NAV 2017 - can we use the same versions of Dynamicweb Connector Service + Dynamicweb Integration Framework Nav Exampl ...
Michal Vedstesen
14/12/2017 11:43:59
Last post: 18/12/2017 14:47:42
Scheduled task, running activity, DW9
Hi, I have a solution i DW8 with some integration jobs. I have copied those jobs to a DW9 server. The problem is that I cannot get any data when I run a job. The scheduled tasks work. If I test it on the server with "Dynamicweb Service Test App" i ge ...
Aki Ruuskanen
04/12/2017 12:59:28
No replies yet
Trouble importing secondary relations
Hi Dynamicweb, We are having some issues with importing secondary user relations as we end up have duplicates entries. In the method: UpdateUserSecondaryRelationBeforeMoveToMainTable we have this section: if (existingUserId > 0) { string sourceSec ...
Anders Ebdrup
29/11/2017 21:36:20
Last post: 23/01/2018 23:19:59
Add Group reference to Product by GroupNumber
Hi Dynamicweb, Will it be possible to have extended the below search in the EcomProvider with: or GroupNumber= '" + group + "': private void AddGroupReferenceToProduct(string productID, string languageID, string group, string sorting, string primaryG ...
Anders Ebdrup
27/11/2017 18:26:16
Last post: 19/12/2017 10:48:13
Keep imported source table
Hi Dynamicweb, When setting up especially a new integration job it would be nice to have the option to keep the temporary "BulkImport"-table even though the import fails, as it will make it much easier to debug data problems. Hope it can be possible? ...
Anders Ebdrup
27/11/2017 18:07:03
Last post: 28/11/2017 15:47:52
Can't run activity with parantheses in the name
Hi I have an Integration activity which contains parantheses in its name. When the name contains parantheses it can't be runned. It's stucked with the message "No log information is present". But if I remove the parantheses in the name then I can run ...
Lars Larsen
24/11/2017 14:19:29
Last post: 29/11/2017 08:16:03
Integration conditionals not working
Hi, I am trying to import users from an Excel spreadsheet, and I am setting up a conditional but it doesn't seem to work. Please check the screencast Best Regards, Nuno Aguiar ...
Nuno Aguiar
13/11/2017 17:11:15
Last post: 14/11/2017 10:32:44
Requirements to AX version
The REQUIREMENTS doc don't mention any AX versions, I have a customer asking about AX 4 can be used with the integration framework? Regards Kim ...
Kim Søjborg Pedersen
07/11/2017 09:29:50
Last post: 07/11/2017 09:34:58
Importing Products with Variants
Hi guys, I find very often the need to explain internally or to customers how to import products using DataIntegration. I have searched in the documentation for a best-practice how-to but I could not find anything. I know in the past we have used a D ...
Adrian Ursu
31/10/2017 10:41:58
Last post: 31/10/2017 16:13:57
ErpOrderExport - Custom Order fields in ErpOrderExport.xml
Hi, how can I include custom orderfields in the ErpOrderExport.xml ? I think I saw a checkbox somewhere but not sure. Its a standard "New activity from template" and then ErpOrderExport Regards Kim ...
Kim Søjborg Pedersen
26/10/2017 10:49:10
Last post: 26/10/2017 15:14:34
ErpOrderExport log
Hi, I'm using the ErpExportOrders integration template and in the folder Files\System\Log\DataIntegration I can se a log but it contains only Starting export of table: EcomOrders Finished export of table: EcomOrders Starting export of table: EcomOrde ...
Kim Søjborg Pedersen
25/10/2017 13:40:11
Last post: 25/10/2017 14:07:56
ErpOrderExport - Checkbox - Export completed orders only
Hi, what does the checkbox means "Export completed orders only"? Can't find documentaion on this... Is it Completed as in "Completed order state" or as in "don't export carts" like the old checkbox. running 9.3.x ...
Kim Søjborg Pedersen
25/10/2017 10:47:23
Last post: 25/10/2017 11:13:54
Item Provider does not delete relationship
Hi, The Item provider has an option to "Remove missing items after import" which works fine, but if the item is in a relation list (ItemRelationList table) it does not delete that record. This means we'll have bad data in the database. It should dele ...
Nuno Aguiar
19/10/2017 14:15:25
Last post: 28/11/2017 19:17:22