Developer forum

Forum » Integration
Subject
Replies
Started by
Last reply
Data integration Export - Import xlsx
Hi When running an integration job the data column mapping includes all fields into the xlsx sheet even though only tree fields has been selected in a first run. In the second run one field ProductLanguageId has been deleted, but still ALL fields are ...
Ole Sørensen
16/05/2018 12:21:28
Last post: 18/05/2018 08:18:24
Delete & archive source files, and URL triggered integration jobs
Hi, I have a setup where I have a data integration job aimed at a specific directory, the integration job is triggered via URL whenever a file get´s written into the directory by a webservice running on my webserver. The integration job is set to Del ...
Arnór Halldórsson
09/05/2018 15:08:04
Last post: 03/07/2018 15:09:27
Creating users and sending them activation/password reset link
Hi, We're experimenting with using the User Provider data integration method to allow support staff to create new Dynamic web users from our CRM system. We already have a working flow like this: Record is created in an external database table with al ...
Þórhallur Hálfdánarson
08/05/2018 17:03:27
Last post: 03/06/2021 08:18:04
Microsoft Dynamics 365 CRM
Hello, we have a client interested in interrating with their CRM system. Which integration framework if any, or is it this on that should be used : https://doc.dynamicweb.com/documentation-9/integration/other-systems/microsoft-dynamics-crm-online Reg ...
Peter Vendelby
07/05/2018 13:26:22
Last post: 07/05/2018 14:51:19
Deactivation of products based on shopid
Hello, We are trying to figure out how to only deactivate products from a specific shop, and the special thing here is, that the products is not in a group, but only have a DefaultShopId. Any idea of how that can be achieved? Best regards, Anders ...
Anders Ebdrup
03/05/2018 17:08:48
Last post: 04/05/2018 08:53:04
Send password to some users
Hi Dynamicweb, When importing users with the user provider we only want to send out passwords to some of the users in the same import. Do you have some input how to achieve this? Best regards, Anders ...
Anders Ebdrup
02/05/2018 09:06:54
Last post: 02/05/2018 09:25:40
Data integration from multiple files
Hi, We have a client that´s using a 3rd party PIM system (InRiver) and when the client makes changes to the product catalogue in the PIM they send us information about the product / group that they changed in the form of XML files. However, this data ...
Arnór Halldórsson
23/04/2018 19:00:59
Last post: 24/04/2018 14:56:55
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