Developer forum

Forum » Integration
Subject
Replies
Started by
Last reply
Export an excel (or CSV) file for each order that goes in a specific OrderState
Hi guys, For a project that is not integrated with an ERP, I need to create a file for each order that enters a specific OrderState. What would be the best approach for this? Is there a default way of doing it? If not, what is the best custom way of  ...
Adrian Ursu
13/04/2018 17:16:43
Last post: 13/04/2018 17:51:45
Data Integration Missing...
Hi DW, For some reason my Data Integration is deactive its greyed out and missing from the integration tab. How do i enable it? im on a Full trial license. Attached a screenshot hope it helps you see my problem. Best regards Jannich ...
Jannich Ariyanayagam
26/03/2018 09:13:27
Last post: 28/03/2018 08:31:52
Importing to EComProducts does not add to EcomFieldOption and EcomFieldOptionTranslate
When importing from CSV or Excel to EcomProducts via EcomProvider the Custom fields defined af List types are populated correct in the EcomProducts table. However the different values found, are not added to EcomFieldOption and EcomFieldOptionTransla ...
Lars Bruun
22/03/2018 14:52:45
Last post: 02/07/2018 14:34:06
Import AccessUserAddress Fail
Hi I would like to import new shipping address to "AccessUserAddress" table. I had export "AccessUserAddress" to excel to get the Data Dictonary. In this excel, I input the additional new shipping address for an existing user, see attached. After imp ...
Tan Pang Lin
02/03/2018 05:29:50
Last post: 05/03/2018 10:53:39
Running Data Integration job
We have an issue on servers where TLS 1.0 and 1.1 have been disabled. If you access Admin using https and try to run a data integration job, an error is returned. The error is: 'Web exception occured: The underlying connection was closed: An unexpect ...
Terri Donahue
27/02/2018 20:02:30
Last post: 28/02/2018 09:47:54
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
ecom provider and multiple shop
Hi, I have data integrations set up to two shops. If I set "Delete products / groups for languages included in input" it deletes products across all shops! What is the recommended setup om a multiple shop solution to prevent that? DW 9.3.x Regards Ki ...
Kim Søjborg Pedersen
07/02/2018 15:01:08
Last post: 26/02/2018 13:41:21
SQL query. Grouping customers bought items in a list
Hi i'm making a new website for a client. I'm trying to make an SQL query that outputs a list of Ecommerce orders, based on bought products, make sense? I got a SQL query that looks like this (from the old website) SELECT * FROM joom2.fkwhv_virtuemar ...
Jens Mouritzen
05/02/2018 21:19:52
Last post: 15/02/2018 09:21:40
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
eConomic integration not working by feb 14 2018
The Dynamicweb integration to eConomic is a good feature for shop customers that are too smal for Nav and is easy to set up. eConomic has informed customers that the integration uses the Connect method that will not work by feb 14 2018. Instead the C ...
Per Søgaard
26/01/2018 10:57:27
Last post: 14/03/2018 13:24:55
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
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
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
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
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
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
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
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