Many questions in Microsoft forum about this topic: “How to generate new dimension ID from data (dimensions values for NAV login) existing on external tables ?”
Use standard NAV to achieve this, you can use standard NAV function DimMgt.GetDimensionSetID(Rec) to create New Dimension SET ID of function existing on UpgradeToolkit since NAV 2013.
This article is to import data from the Excel file into existing NAV table. This import matches the excel entries with the existing NAV table and modifies the records of the table on import of the excel file. To accomplish this, we create a report using Excel Buffer as the DataItem.
Most of us that’s been programming in Dynamics NAV for a while are aware of the Excel Buffer table. It is a super useful table that can be used to create and read Excel files from C/AL code. This table have been around as far as I remember, and now it has some siblings, the XML Buffer and CSV Buffer tables.
Maybe some of you remember my how-to increase performance by reducing db reads.
I wrote it in 2007 when we still had the native DB and also the SQL DB but NOT the service tier with all its extra’s for performance.
Microsoft is trying to make our life easier from an upgrade perspective with merge commandlets and upgrade codeunits. This is nice but sometimes you run into situations that are not fixable with tools like these.
In this article we will see the possibility of having Multiple Excel Sheets Using Excel Buffer Export.
This article is based on a friend request. The Requirement was to import the data in a table From an Excel File. Most of us know this feature is there in standard objects of Microsoft Dynamics NAV from a long time. If you are one of those who don’t know about it please go through the article.