JAMRenumbering READMEThis extension implements the old renumbering utility from C/AL to AL. FeaturesThis Renumber implementation has two commands: "Create initial CSV file" and "JAM Renumber Al Objects from CSV file" Go to command palette and find "JAM Create Initial Renumbering CSV ready for fill new ids": This command create a CSV template from workspace objects with NewID empty: When you fill this column, you can go to next step: Renumber. The command will ask where you want to save CSV file. Go to Command palette and find "JAM Renumber Al Objects from CSV file": Command will ask the source CSV file with the renumbering and execute renumbering over all AL objects in current workspace. At the end of command changed objects will be open in the editor, and then you can review and save all or discard this renumbering: New command "JAM Update previous CSV Renumbering file with new objects in workspace", merge an existing CSV objects with set renumbering with new objects in workspace. The steps are: F1 "JAM Update previous CSV Renumbering file with new objects in workspace", select previous CSV file and then select target new merged file. They can be the same. Renumbering fields from tableextensionA new feature is added to the Renumbering command, to renumber fields from tableextension. This works alike previous renumbering options:
New empty table objects generation command.Sometimes in upgrading processes we need a copy of app tables and tableextensions, but logic, only fields and primary key, no procedures, triggers, and no other properties. You can generate these empty tables in a target directory, executing this command in the original app workspace: "JAM Generate empty logic table objects in target folder" You can get Empty table object for C/SIDE previous versions with "JAM Generate empty logic C/AL table objects in target single txt file" command. Instead a folder for a set of object files, you must select a single txt target file to save all objects. This could be useful for upgrade toolkits. If you open the target workspace you could see the new empty tables only with the fields: Insert extension fields in an old C/SIDE txt table objectNeeded for upgrade toolkits (IMO). New command "JAM Insert extension fields into old CSIDE table definition text file" to perform an insertion in a C/SIDE txt object the extension ot the fields of my current extension workspace. Steps:
RequirementsVisual Studio Code and AL language. Extension SettingsNo setup needed. Known IssuesNot yet. Release Notes0.0.1Initial release. 0.0.2New empty table objects generation command. 0.0.3Remove "extends" and extended object from name in csv 0.0.4Repository visibility issue: Thanks dannoe!! 0.0.5Issue with tablerelation. When found "TableRelation = "Item Variant".Code WHERE("Item No." = FIELD("Item No.")" creates new field this way: FIELD("Item No."){} 0.0.6Avoid generate empty tableextension file if no fields added. 0.0.7Generate empty table objects in CAL format. Beta feature, still Testing. 0.0.8Generate empty table objects in CAL format. working. 0.0.9Generate empty table objects in CAL format. All the objects in a single txt file, instead multiple files. 0.1.0Insert extension fields in an old C/SIDE txt table object with command "JAM Insert extension fields into old CSIDE table definition text file" 0.1.1Issue with object declaration search. Previously, we asume the first line was the object declaration, but now we search for the object declaration in the whole file. 0.1.2Add new command "JAM Fix Txt2AL" to fix the txt2al conversion more common issues: lack of application Area, and remove Scope internal deprecate statements. 0.1.3Add new command "JAM Fix Implicit REC in page fields" to fix the implicit REC in page fields, adding the explicit REC in page fields. 0.1.4Exclude implicit REC in page fields in Fix Txt2AL command. 0.1.5Remove command "JAM Fix Implicit REC in page fields" and command "JAM Fix Txt2AL". You can get these commands in the "JAM Variable name extension" extension. 0.1.6Execute removing of commands announce in the previous version. 0.1.7Fixed error in the command "JAM Insert extension fields into old CSIDE table definition text file". Write twice the extension fields in the old txt file in some conditions. 0.1.8Use image free common from https://icons.iconarchive.com/icons/icons8/ios7/512/Programming-Variable-icon.png 0.1.9Use the image free common from https://publicdomainvectors.org/en/free-clipart/Thumb-up-with-animal-numbers/80824.html 0.2.0Error taking the object declaration from the first line. It is now the first line with the object declaration. 0.2.1Fixing some erratic behavior in renumeration related to asynchronous execution. Showing execution log in the output channel. 0.2.2New feature to renumber fields from tableextensions. 0.2.3Fix on new feature to renumber fields from tableextensions. Only apply renumbering in first field of the extension it cathchs and leave the rest of the fields as is. 0.2.4Avoid renumbering error due asynchronous execution. 0.2.5Issue when the object declaration is not the first line. Leave two declation lines in the object. 0.2.6Extend the name of the command to "JAM Create Initial Renumbering CSV ready for fill new ids". Case ignore matching object type. |