Wednesday, May 6, 2015

Export list of model elements to Excel - Ax 2012

Hello Guys..!

Here I'm sharing code for export list of model elements to excel .


Step 1: Open "Microsoft Dynamics Ax management shell" from Administrator Tools.

Step 2 : paste the below code

(Get-AXModel -Model 'VAR Model' -Details).Elements | select path, elementtype | `
Export-Csv -NoTypeInformation -Delimiter ';' c:\varmodel.csv


Note : In this example I'm exporting VAR Model.
          Go to c:\varmodel.csv


That's it


@Rahul Talasila

1 comment:

  1. Great walkthrough exporting model elements into Excel is such a time-saver when reviewing customizations in AX 2012. I used a similar script for auditing model layers and it worked flawlessly. For anyone setting up dev/test environments, checking out Pc Builds can also help ensure your hardware is optimized for running heavy Dynamics workloads.

    ReplyDelete

What is the primary purpose of using a Solution in Microsoft Power Platform & ALM?

As organizations embrace low-code development with Microsoft Power Platform , it becomes essential to manage and govern apps, flows, and dat...