In this blog we will focus on developing the XML port and Adding action to the page to Import Data.
We will be developing the XMLPort to import below mentioned format in the Table.
Tag Archives: Import
Quick Tip: How do I import an license (flf) file in Business Central on Premises?
Since C/Side has gone forever, when installing Business Central on Premises you might wonder how to import or upload a license (flf) file into the service tier.
Well the solution is very simple.
Import Tenant Data
My last post was about how I got the customized data out of the tenant database into Xml files. That tenant database was from a NAV 2016 application.
I have updated the tenant database to Business Central and I need to bring in some of the data from these Xml files.
Import CSV files into Business Central
Microsoft Dynamics 365 Business Central can import CSV files. It’s done with the wrongly named XMLPort (at least for this purpose) objects. The challenge is to get the indentions right, so here is a barebone XMLPort object that will read a CSV file.
Excel Buffer Patterns for Import or Update NAV Data from Excel Files
Today I want to present how to use Excel Buffer functionality in order to update/import data in NAV/D365 Business Central based on data from Excel files.
User bulk import with PowerShell
The ps command to add single users in nav is new-navserveruser, detailed info can be found here:
How To Tell Whether Query Folding Is Taking Place When Importing Data From Analysis Services In Power BI And Excel Power Query
As a quick follow-on from last week’s post on how to detect whether query folding is taking place when importing from OData data sources, if you’re importing data from Analysis Services you have a similar problem: how do you know whether query folding is taking place? Ensuring that query folding takes place for as many of the steps in your query – especially those that filter or otherwise reduce the amount of data returned – is very important for data refresh performance.