JAMRenumbering README

This extension implements the old renumbering utility from C/AL to AL.

New GUI for invoke all commands 2025

All the commands will be removed, and substituted bay a GUI with buttons. The GUI is called by command "JAM Open AL Renumber Tool":

We can see 2 main sections:

1. Object renumber. Sections to invoke 3 actions for create, open and apply renumering from CSV file. Select an option and push right button execute.
2. Fields renumbering. The same of above but refered to fields in tableextensions.

In the bottom we have 4 remaining options in desplegable "Other Actions":

1. Generate empty Objects with new IDs action.
2. Generate empty Objects keeping old IDs action.
3. Generate empty C/SIDE Objects action.
4. Insert fields C/SIDE.
5. Update CSV with new objects.

Clear Filename Button: Clears the file path to allow the user to select a different file in "Open file" next execution.

if you still want to enable commands in command palette check the setting JAMRenumbering.EnableCommandPalette.

The diference between 1 and 2 empty object options is that the first one will generate new IDs for all objects, and the second one will keep the old IDs and copy them to a new workspace, copying also the app.json file. This is useful when you need to create the same app, with the same objects IDs, the same App ID, and no logic to have no issues when publishing, for example in an on-premise environment, with an earlier version of BC. Then the logic could not work in this version, and it rather have only data objects for further cloud upload. Check the page explanation for more details.

Option 1 create an upgrading app with new IDS, and tables instead tableextensions, and no logic. Also create a new codeunit with datatransfer to save and to bring back data to the new tables.

Features

This 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": In new Renumber page actions go to "Object Renumbering", then choose "Create initial CSV file" and push "Execute"

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": In new Renumber page actions go to "Object Renumbering", then choose "JAM Renumber Al Objects from CSV file" and push "Execute"

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. In new Renumber Page actions is "Other Actions", then Choose "Update CSV with new objects" and push "Execute".

Renumbering fields from tableextension

A new feature is added to the Renumbering command, to renumber fields from tableextension. This works alike previous renumbering options:

• First create a new CSV file with existing fields form existing tableextensions. The SCV file has a last column with the new ID of the field. You can create the CSV file with the command "JAM Create CSV table with extension fields to renumber". In new Renumbering page go to "Field extension renumbering" then choose "1 Create initial CSV File" and push "Execute".

• Whren the new ids are filled in the CSV file, we can can launch the fields renumbering with the command "JAM Apply field extension renumbering from CSV file". This commnadwill open a file dialog to select the CSV file with the tableextencion fields renumbering and then will execute the renumbering. In new Renumbering page go to "Field extension renumbering" then choose "JAM Apply field extension renumbering from CSV file" and push "Execute".

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". Will ask for object starting new Id and target folder. In new Renumbering page go to "Other Actions" then choose "Generate empty Objects" and push "Execute".

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. In new Renumbering page go to "Other Actions" then choose "Generate empty C/SIDE Objects" and push "Execute".

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 object

Needed 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:

1. With F1 execute "JAM Insert extension fields into old CSIDE table definition text file". In new Renumbering page go to "Other Actions" then choose "Insert fields C/SIDE" and push "Execute".
2. Select the old txt C/SIDE file with standart table definitios.
3. Select new txt C/SIDE file to save these standar tables with extension fields inserted.

Requirements

Visual Studio Code and AL language.

Extension Settings

This extension contributes the following settings:

• JAMRenumbering.EnableCommandPalette If you want to use command palette instead renumbering tool webview check this setting.

Known Issues

Not yet.