Keep all data in staging

(0) Share

Report

Posted on by Community Member

When I tested in D365, system automatically post data directly to Target Table. Only when there is a error on rows, these rows are still in Staging Table.

I need to keep all data in Stage Table before confirming them to Target Table ( same function "Get Staging Data" in AX 2012). Any suggestion for this case ?

Thank you so much.

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Community Member on at

Like (0)

Report

Thank you so much Sukrut Parab,

I only see "Skip Staging" in Export function.

Could you please post a picture or link in Import function for me easily to follow.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Sukrut Parab,

Thank you for detailing by pictures.

But this could be used after successful importing and it is already in system.

I would like to view stage data when select the file source and only import to staging table.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

Like (0)

Report

Hi Peter,

Are you using an import project or are you using services or the Excel add-in? Until now I have seen data being present in staging at all time when you do manual imports in data management. What entity did you use?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi André,

I used Import Project.

My step is describe below

- Create new import project

- Type name, Source data format: Excel , entity : Customers, select the file, select the sheet.

Then check Staging Data: there is no row

Click Import to start

Refresh the import and check result: data is already copy to target

Then view Staging Data: all rows were copied to Target

System automatically copied Data from Staging to Target without any Confirmation.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

Like (0)

Report

Hi Peter,

Now I understand you want to import in staging only; at another point in time you want to move to the target. That has been changed between AX2012 and the current version. What would be the reason to have it paused in staging first?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Peter,

Did you figure out the solution to this I am too having the same issue can you share the solution please?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Dorai,

I am sorry that currently I cannot find any solution for this issue. May be as André said, D365 changed it's flow.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Peter,

I found a workaround, when you reuse the import data project job you can uncheck "Execute target step" that will not copy to target, you can review in stating and copy to target.

Regards,

Murali Dorai

Was this reply helpful? Yes No