Developer forum

Forum » Integration
Subject
Replies
Started by
Last reply
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
Import users belong exactly import groups
Hi What does the setting "Import users belong exactly import groups" do/mean? The setting is on the User Destination Provider. Running DW9.3.4 ...
Lars Larsen
11/10/2017 13:54:17
Last post: 11/10/2017 15:14:00
Error when importing assortments
Hi Dynamicweb, When importing assortments in DW 9.3.4 using the DynamicwebProvider, I get an error when importing EcomAssortmentGroupRelations, where some GroupID's doesn't exist in EcomGroups. <item table="EcomAssortmentGroupRelations"> <co ...
Niels Foldager
03/10/2017 13:57:50
Last post: 11/10/2017 13:08:52
Batch Integration Scheduled Task disappearing
Hi, I created a custom BatchIntegrationScheduledTaskAddin, but i kept disappearing when I saved it. It seems that the code is looking for some hardcoded names, when displaying the collection of tasks. Found in ScheduledTasks_cpl.aspx.vb: Dim Integrat ...
Mikkel Ulstrup
09/10/2017 18:34:53
Last post: 11/10/2017 13:05:28
Variant integration - question about the data
Hi, I'm integrating some variants but I got a bit confused... Let's say I have product n°1234 available in 2 sizes (M, value 01, and L, value 02), and 2 colors (red, value 10, and blue, value 11). With extended variants that's 5 lines in all in the d ...
Gaëtan Di Caro
25/01/2017 14:31:34
Last post: 03/10/2017 11:28:12
Delete missing groups in ecomprovider
Hi Dynamicweb, When importing product data with the Ecomprovider, then "Delete missing groups" has no effect when the groups are specified with the "groups" tag in EcomProducts-section. For now it only adds groups to the productgroup-relation and not ...
Anders Ebdrup
04/09/2017 12:55:19
Last post: 21/09/2017 10:32:03
Column naming for EcomProductRelated
Hi, This is DW 8.9.1.9. When importing related products, we have the following columnnames in the database: ProductRelatedProductId ProductRelatedGroupId ProductRelatedProductRelId ProductRelatedSortOrder The import fails, with our XML like this: < ...
Mikkel Ulstrup
13/02/2017 16:28:49
Last post: 20/09/2017 16:33:43
Scheduled tasks showing incorrect logs
Hi there, We noticed that sometimes when you right-click a scheduled task in the list in the backend and choose Log, you get the logs for another task. For example, we have these two tasks: Import users Import users - UK When I open the log for the f ...
Imar Spaanjaars
26/03/2017 14:10:37
Last post: 20/09/2017 16:14:56
Empty productlist and BeforeRender
Hi, If a productlist is empty, will the Ecommerce.ProductList.BeforeRender event be fired or is it only when products are rendered on the frontend? Best regards Kurt Moskjaer Andersen ...
Kurt Moskjær Andersen
07/09/2017 13:08:19
Last post: 07/09/2017 21:07:03
No CalculateOrder request sent on english site
Hi, I have a shop running liveintegration where the cart is calculated throug Request CalculateOrder sent. It works fine on the danish shop but not on the english shop. I can see in the log that Request CalculateOrder is not send on the english site. ...
Kim Søjborg Pedersen
29/08/2017 16:17:41
Last post: 31/08/2017 10:21:18
XML sample for Users, Live price call and order in DW9
Hi Guys, I have the first DW9 project that needs an integration setup. I was wondering if there are any changes in the stucture of the XML files used to send/receive data between DW and ERP (NAV in this case). I can use the code from a previous DW8 i ...
Adrian Ursu
26/08/2017 15:55:44
Last post: 28/08/2017 08:54:43