Skip to main content
Post a question

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id : S7fZudLVwjAkQDbcLW3FkM
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Exporting an overview ...
Microsoft Dynamics AX (Archived)

Exporting an overview of the AOT to excel

Like (0) ShareShare
ReportReport
Posted on 19 Aug 2015 13:42:37 by Community Member

Hi all, 

I'm new to this forum and just started my career as an AX 2009 applications manager. 

We are currently in the process of making an overview of all the customization's we have running in AX09 before deciding what customization's will be fazed out so that we can have a production that is running as close to the standard version of AX09 as possible, before we make the jump to AX12 and further.

Communication wit our original AX vendor is nonexistent so I have no way of contacting the developer that was responsible for all our customization's. But I notice that all custom work in the AOT is tied to a name convention. (everything starts with the first 3 letters of our ex vendor name).

My idea was to export all AOT names to excel and filter out everything that doesn't start with the first 3 letters of our vendor name. 

My question however, is if there is a function in AX that enables me to export all the AOT names by type to excel.

Regards,

Ilya

*This post is locked for comments

  • Fausat Profile Picture
    Fausat 220 on 07 Mar 2018 at 13:53:46
    RE: Exporting an overview of the AOT to excel

    I will like to verify your answer please

  • Fausat Profile Picture
    Fausat 220 on 07 Mar 2018 at 13:52:11
    RE: Exporting an overview of the AOT to excel

    Hi Brandon

    Thank you for this concise answer.

    I'm in a similar situation to Ilya Bierivliet  as stated above,  when I followed the answer you gave above, it gave me all the information I needed for the customisation audit of our current system. I haven't tried other suggestions but this one of yours really gladden my day. Thanks a lot.

  • Suggested answer
    Brandon Wiese Profile Picture
    Brandon Wiese 17,788 on 28 Aug 2015 at 22:51:48
    RE: Exporting an overview of the AOT to excel

    From the developer work space, click on Tools, Model management, Model elements.  From this grid you can filter on the Parent name, name, and even on one or more Layers, as well as on one or more Types.  Ctrl-T exports to Excel easily.

  • Daniel Weichsel Profile Picture
    Daniel Weichsel 1,657 on 28 Aug 2015 at 22:17:21
    RE: Exporting an overview of the AOT to excel

    Hi Ilya,

    Note that to use Bhaskar's suggestion, you should right click on the node, then click Add-ins and finally table browser.  A simple "Open" will instead show the help content for the table.

  • 5400 Profile Picture
    5400 7,162 on 28 Aug 2015 at 12:38:06
    RE: Exporting an overview of the AOT to excel

    I don't think so u did copy entire objects correctly. I will recommended you please filter the objects first with your (first 3 letters of our ex vendor name like exm. APJ*).

    One example: Table Name APJDemo, calss Name - APJdemoprocess, Form - APJDemoUI

    you will get above objects as below

    Record Type - Column   Name

    Table                        - APJDemo

    Classes                     - APJdemoprocess

    Forms                       - APJDemoUI

    Same for entire objects which is started with APJ*

    Hope you are cleared now and check.

    If your naming convention is correct, you will get definitely desired object list.

  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 232,038 Most Valuable Professional on 28 Aug 2015 at 12:30:00
    RE: Exporting an overview of the AOT to excel

    Depending on the naming convention is a bad idea - it's more than likely that there are modifications of standard objects, which obviously have their names defined by Microsoft.

    I would recommend to start with Jacob's suggestion. Create and open a new project, then press Ctrl+F3 to open Project filter form, click Select and set Layer to the layer you want, or put some expression there (e.g. >SYP). Confirm it and wait until all objects meeting your criteria are added to the project.

  • Community Member Profile Picture
    Community Member on 28 Aug 2015 at 12:16:40
    RE: Exporting an overview of the AOT to excel

    Hi Bhaskar,

    Thank you for your answer, but sadly I don't get the desired list of all objects.

    In the AOT i go to System Documentation>Tables>and i select UtilIdElements.

    It gives me a short list of methods, relations and indexes.

  • Suggested answer
    5400 Profile Picture
    5400 7,162 on 19 Aug 2015 at 14:23:10
    RE: Exporting an overview of the AOT to excel

    You can go to table \System Documentation\Tables\UtilIdElements - u will get entire object which u have created  in AX as well as standard objects list type wise from where u can copy from in Excel.  

  • jasman Profile Picture
    jasman 1,411 on 19 Aug 2015 at 13:48:25
    RE: Exporting an overview of the AOT to excel

    No.

    But if you want an overview, you can build a "code" project with all customized elements in the AOT.

  • Suggested answer
    Jonathan Halland Profile Picture
    Jonathan Halland 11,306 on 19 Aug 2015 at 13:47:19
    RE: Exporting an overview of the AOT to excel

    Hi Ilya, you can also create a project with all the modifications in the USR or CUS layer to find everything that was changed.

    technet.microsoft.com/.../aa890665(v=ax.50).aspx

    Select source layer as CUS or USR (or do it for both). Untick the "Only include elements present in both layers" checkbox.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,280 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,038 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans