Developer forum

Forum » Integration
Subject
Replies
Started by
Last reply
Cross Origin Server issue
Hi forum We are using DW9 to provide a JSON feed with ECOM data. The feed is made and shows the JSON as needed, however we are then trying to access this from an external website using Angular / Javascript but we are getting Cross Origin Server error ...
John Andersen
13/02/2018 09:23:38
Last post: 13/02/2018 10:02:02
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
UBL XML Export of order invoices
Hi We have a client who asks if it is possible to export order invoices at UBL XML files. I have attached an example file of what we would like to export. Can this be done without a big hassle? I am hoping for a reasonably simple setup in Data Integr ...
Hans Ravnsfjall
26/01/2018 11:52:06
Last post: 26/01/2018 15:04:32
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
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
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
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
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
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
Import category fields from CSV
Hi there, I have a CSV file in the following format: Product ID Height Width Metric 1234 123 234 Yes 2345 456 100 Yes 9033 190 200 No In reality, I have many different CSV files with many columns, all that differ per CSV. I would like to import this  ...
Imar Spaanjaars
20/12/2016 14:50:42
Last post: 12/12/2017 01:20:27
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
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
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
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 clarification
Hi, I have a couple of issues, that I want to hear your take on. Some are probably bugs, but maybe the way I use it is wrong. When using the itemprovider, the checkbox "Delete page, paragraph associated with missing items" does not delete pages. Impo ...
Mikkel Ulstrup
06/10/2017 16:41:03
Last post: 25/10/2017 11:07:51