EDT and tables wizard for AX 2012

[Blog bot]

Источник: http://alexvoy.blogspot.com/2017/12/...r-ax-2012.html
==============

[COLOR=rgba(0, 0, 0, 0.54)]AX 2012 Wizard allows to create new Extended data types and new tables with relations, delete actions, indexes and find methods, based on a simple Excel file. Two sample Excel files are included in the zip-package.[/COLOR]
[COLOR=rgba(0, 0, 0, 0.54)]
[/COLOR][COLOR=rgba(0, 0, 0, 0.54)]Just import two classes (ADO class is to support Excel import).[/COLOR]
[COLOR=rgba(0, 0, 0, 0.54)]
[/COLOR][COLOR=rgba(0, 0, 0, 0.54)]You can set up new types (if needed) and new tables with all bells and whistles, then run the Wizard and can go fishing until it does its job.[/COLOR]
[COLOR=rgba(0, 0, 0, 0.54)]
[/COLOR][COLOR=rgba(0, 0, 0, 0.54)]Happy fishing![/COLOR]
[COLOR=rgba(0, 0, 0, 0.54)]
[/COLOR]


It creates:
first
- all new types based on basic types; (ignores if exists)
- all new labels for US-EN and FR-CA or finds existing one for US-EN;
second
- new tables;
- new fields;
- new field group with all new fields and the same label as for table;
- new index based on the first field and set is as cluster index;
- normal relation to the main table if given (one only);
- cascade delete action for all new relations from subordinated tables;
- method find based on the first field.

If it fails to open Excel file, check your currently installed Excel version and adapt the connection string.

Источник: http://alexvoy.blogspot.com/2017/12/...r-ax-2012.html