steven-bale / alrenumbering

JAMRenumbering README

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

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 CSV file":

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.

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 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".
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

No setup needed.

Known Issues

Not yet.

Release Notes

0.0.1

Initial release.

0.0.2

New empty table objects generation command.

0.0.3

Remove "extends" and extended object from name in csv

0.0.4

Repository visibility issue: Thanks dannoe!!

0.0.5

Issue with tablerelation. When found "TableRelation = "Item Variant".Code WHERE("Item No." = FIELD("Item No.")" creates new field this way: FIELD("Item No."){}

0.0.6

Avoid generate empty tableextension file if no fields added.

0.0.7

Generate empty table objects in CAL format. Beta feature, still Testing.

0.0.8

Generate empty table objects in CAL format. working.

0.0.9

Generate empty table objects in CAL format. All the objects in a single txt file, instead multiple files.

0.1.0

Insert 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.1

Issue 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.2

Add 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.3

Add 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.4

Exclude implicit REC in page fields in Fix Txt2AL command.

0.1.5

Remove 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.6

Execute removing of commands announce in the previous version.

0.1.7

Fixed 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.