The Txt2Al conversion tool
DEPRECATED WITH Starting with Business Central 2022 Release Wave 2 (v21) this tool is no longer available.
The Txt2Al conversion tool allows you to take C/AL objects, which were created in Dynamics NAV or Business Central Spring 2019 (version 14), and convert them into the new .al format. The .al format is used when developing extensions for Dynamics 365 Business Central. Converting the objects consists of following two steps:
- Exporting the objects from C/SIDE in a cleaned .txt format.
- Converting the objects to the new syntax.
Where to get the Txt2Al conversion tool
The Txt2Al conversion tool (txt2al.exe) is only available with version 14, which is the last version to support C/AL. Use this version no matter what later version you may eventually be upgrading to. The AL objects created by the tool will be compatible with later versions.
You find the txt2al.exe on the installation media (DVD) in the "DVD\RoleTailoredClient\program files\Microsoft Dynamics NAV\140\RoleTailored Client" folder. Or, it's installed locally with Dynamics NAV Development Environment, for example, in the "C:\Program Files (x86)\Microsoft Dynamics 365 Business Central\140\RoleTailored Client" folder.
Using the Txt2Al conversion tool
To run the Txt2Al conversion tool, follow the steps outlined below.
- Start with a clean Dynamics NAV database and compile the database.
It's very important that you compile the database to get the right result in the next step. - 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 (13-0) database:
finsql.exe Command=ExportToNewSyntax, File=exportedBaselineObjects.txt, Database="Demo Database NAV (13-0)", ServerName=.\NAVDEMO ,Filter=Type=table;ID=225 - Import your solution using the import option in C/SIDE and compile the database.
It's very important that you compile the database to get the right result in the next step. - 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 231 from the Demo Database NAV (13-0) database:
finsql.exe Command=ExportToNewSyntax, File=exportedNewModifiedObjects.txt, Database="Demo Database NAV (13-0)", ServerName=.\NAVDEMO ,Filter=Type=table;ID=231 - Run the Set-ObjectPropertiesFromMenuSuite cmdlet, which will convert MenuSuite information on pages and reports in the generated AL objects to enable them for search. For more information, see Making Pages and Reports Searchable in the Web client
- Create .delta files using the Compare-NAVApplicationObject PowerShell script. For more information, see Generating DELTA Files.
- Go to the \Program Files(x86)\Microsoft Dynamics 365 Business Central\140\RoleTailored Client folder and locate the txt2al.exe converter tool.
- Run the tool from the command line using the following syntax:
txt2al --source --target --rename --type --extensionStartId --injectDotNetAddIns --dotNetAddInsPackage --dotNetTypePrefix --translationFormat --addLegacyTranslationInfo
Parameters
| 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. |
| --stacktrace | Display the stack trace of exceptions raised during the conversion. |
| --help | Show help screen. |
| --injectDotNetAddIns | Inject the definition of standard .NET add-ins in the resulting .NET package. The standard .NET add-ins are a set of add-ins that are embedded into the platform. |
| --dotNetAddInsPackage=Path | Specify the path to an AL file that contains a definition for a .NET package containing .NET type declarations that should be included in the .NET package definition that's produced by the conversion. This parameter should be used to inject a custom set of .NET control add-in declarations. The file should contain something similar to the example shown below. |
| --multithreaded | Run using multiple threads. This parameter improves performance but results in non-repeatable extension numbers and .xlf content. |
| --dotNetTypePrefix | Specify a prefix to be used for all .NET type aliases created during the conversion. |
| --translationFormat=ObjectType | Specify the format to use when generating translation files. The allowed values are: Xliff, Lcg. |
| --addLegacyTranslationInfo | Add information to the translation file that can be used to migrate existing translations/translated resources. During conversion, XLIFF files from all the ML properties in the app are extracted. If this switch is set, a comment is added in the generated XLIFF that specifies what the ID of the translation item would be in C/SIDE. This acts as a mapping that allows you to convert existing translation resources for your app. |
| --runtime | Specify the target runtime for the converted AL. The default is the latest supported runtime. The string should be in a format similar to major.minor. |
| --objectFileNamePattern | Specify the pattern for naming AL files that contain AL objects by using the following placeholders: {name} - object name, {type} - object type, {id} - object ID. This parameter only takes effect if --rename is specified. The default is {name}.{type}. |
| --extensionObjectFileNamePattern | Specify the pattern for naming AL files containing AL extension objects by using the following placeholders: {name} - extension object name, {type} - extension object type, {id} - object ID, {targetName} - the name of the object being extended, {targetId} - the ID of the object being extended. This parameter only takes effect if --rename is specified. The default is {name}.{type}-{targetName}. |
| --format | Format the converted AL code using the standard formatter. |
| --dataClassificationDefaulting | Specify the DataClassification property for all table fields that don't have it specified. For more information, see DataClassification Property. |
| --tableDataOnly | For table objects, specifies to convert only the table and field definitions, including properties. Methods and trigger code isn't included. Note: This parameter was first introduced in Business Central version 14.2 (cumulative update 11) and Business Central version 15.5. |
Note
It's recommended to only use the conversion tool for export. Importing objects that have been exported can damage your application.
Tip
You can use the Dynamics NAV Development Shell cmdlet Export-NAVApplicationObject with the -ExportToNewSyntax flag set instead of using finsql. From the command prompt in the Dynamics NAV Development Shell, run Get-Help Export-NAVApplicationObject -full to see the full syntax.
See also
Developing extensions
AL development environment
Page extension object
Report object
Page properties