Developer forum

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 ...

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 ...

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 ...

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  ...

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 ...

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  ...

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 ...

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 ...

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  ...

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 ...

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 ...

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? ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...