Simple table extension to add a new field.

If you are starting to learn development in D365 then understanding the difference between the customization and extensions is something to investigate. Extension being the new concept to allow smaller changes and better hotfixing procedure in production. This is a simple example of creating an extension to add a new field to a table.

D365FO 1611 – Update3 (7.0.4307.16141)

https://player.vimeo.com/video/201936145

In a previous post you can see the process of creating a new model and project.

Creating a new model file

If you are just starting out with D365 or moving from AX2012 then it helps to have a little orientation on where to find things. If you are coming from AX2012 then you will have a lot of basic concepts that still apply in D365 but there are new ways to do things.

When starting development you will need to create a new model. A model can be used to package up the development we are doing so you can later deploy to an environment. To actually do work within Visual Studio you will need to create a project. A project is like any other Visual Studio in that it organizes the items you are working on.

D365FO 1611 – Update3 (7.0.4307.16141)

https://player.vimeo.com/video/191507350

Anuncios

The Txt2Al Conversion Tool

Original URL…

The Txt2Al conversion tool allows you to take existing Dynamics NAV objects that have been exported in .txt format and convert them into the new .al format. The .al format is used when developing extensions for Dynamics 365 for Finance and Operations, Business edition. Converting the objects consists of following two steps:

  1. Exporting the objects from C/SIDE in a cleaned format.
  2. Converting the objects to the new syntax.

To run the Txt2Al conversion tool

To run the Txt2Al conversion tool, follow the steps outlined below.

  1. Start with a clean Dynamics NAV database and make an export of all the baseline objects in the command line using the following syntax: finsql.exe Command=ExportToNewSyntax, File=<filename.txt>, Database="<databasename>", ServerName=<servername> ,Filter=Type=table;ID=<tableID> The following example exports the table 225 from the Demo Database NAV 10-0 database:
    finsql.exe Command=ExportToNewSyntax, File=exportedObjects.txt, Database="Demo Database NAV (10-0)", ServerName=.\NAVDEMO ,Filter=Type=table;ID=225
  2. Import your solution using the import option in C/SIDE.
  3. Export all new and/or modified objects using the following syntax: finsql.exe Command=ExportToNewSyntax, File=<filename.txt>, Database="<databasename>", ServerName=<servername> ,Filter=Type=table;ID=<tableID> The following example exports the table 225 from the Demo Database NAV 10-0 database:
    finsql.exe Command=ExportToNewSyntax, File=exportedObjects.txt, Database="Demo Database NAV (10-0)", ServerName=.\NAVDEMO ,Filter=Type=table;ID=225
  4. Create .delta files using the Compare-NAVApplicationObject powershell script. For more information, see How to: Develop an Extension v1.0.
  5. Go to the \Program Files(x86)\DynamicsNAV\100\RoleTailored Client folder and locate the txt2al.exe converter tool.
  6. Run the tool from the command line using the following syntax:
    txt2al --source --target --rename --type --extensionStartId
Parameter Description
–source=Path Required. The path of the directory containing the .delta files.
–target=Path Required. The path of the directory into which the converted AL files will be placed.
–rename Rename the output files to prevent clashes with the source .txt files.
–type=ObjectType The type of object to convert. Allowed values: Codeunit, Table, Page, Report, Query, XmlPort
–extensionStartId The starting numeric ID of the extension objects (Default: 70000000). It will be incremented by 1 for each extension object.
–help Show help screen.