web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Database log setup - d...
Finance | Project Operations, Human Resources, ...
Unanswered

Database log setup - different table id

(0) ShareShare
ReportReport
Posted on by hfou 4

Hi all,

I wanna import data from AX12 into D365. The data are Database log setup. I have the data in excel, where i have Table name, Table id, Field name, Type of change and Signature controlled. I have created an x++ runnable class that will be used for the import of the excel file. The import itself works fine. But the problem is about the table name.

The table name is stored in the DatabaseLog table and is created using tableId2PName, that creates a name of the table based on the Id of the table. But the ID in AX12 is different than in D365, it means that for example instead of table Customers I get table Split. 

Is there something I can do with that, please?

I know, there are some more easy ways how to import the data, but the requirement is to use the runnable class.

Many thanks

I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 237,878 Most Valuable Professional on at

    You said that your excel file contains table name, so why are you trying to use table ID, especially now, when you've realized that it's a bad idea?

    If you have the AOT name available, get its F&O ID from the name, instead of trying to use the ID that the table used to have in your AX 2012 environment.

  • hfou Profile Picture
    hfou 4 on at

    Hi Martin,

    yea, I know, thats what I wanted to do of course, but the problem is, in the table DatabaseLog, there is no field, where the value could be stored. The value in the table name is computed using table ID, so while importing, I just import the table ID and the table name is computed automatically. In the table, there are only fields logType, logTable and logField. The table is in System documentation in AOT, so I am not sure, if I am able to do some extension of that. And even if I would add field of the table to store the name, in the table, there has to be ID of the table and NAME of the table, which would be not connected correctly.

  • Martin Dráb Profile Picture
    Martin Dráb 237,878 Most Valuable Professional on at

    Your task can't be done (at least not in a generic way) with mere table IDs. Not only that IDs can differ between AX 2012 and F&O, but also between different environments. Application IDs were made installation-specific already in AX 2012 (although standard tables still had table ID fixed there).

    If you're saying that you aren't currently able to export table names, then you give up this task or you'll create a different export solution. For example, writing a job that exports data to a CSV file isn't difficult.

    Then create a data entity for import, where you'll do the conversion from table names and field names to IDs (and throw an error if such a name can't be found in F&O).

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

    Hi Fachuh,

    If you need the Dynamics 365 table and field ID mapping, you can change the parameters of the URL to

    ?mi=SysTableBrowser&TableName=SysTableIdView and ?mi=SysTableBrowser&TableName=SysTableFieldIdView. You can then create a formula in Excel to replace the old IDs with the new IDs based on the table names.

    Note that some table names might have changed and tables and fields are added in Dynamics 365. For sure, you should review if the database log requirements would be actual and complete.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 646 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans