Export data to excel automatically at equal interval of time

(1) Share

Report

Posted on by Apratim

149

Hi Everyone,

I have a requirement where I have to export Sales table and Sales Line records for Few particular orders to excel sheet. This export of records from Sales table and sales Line to excel sheets for each should be automated twice in a day at 12 hours of interval. Can anyone please guide me how can I achieve this.

Thank You!!!

All responses (12)

Answers (1)

Apratim 149 on at

Like (0)

Report

Export data to excel automatically at equal interval of time

Hi Martin,

Thankyou again!

I Will work with the solution provided by Andrea and get back to you. But how will I mark those sales id once it is exported through Excel. So that I can filter on those which are unmarked.

Thankyou everyone!!!
Verified answer

Martin Dráb 230,214 Most Valuable Professional on at

Like (1)

Report

Export data to excel automatically at equal interval of time

You can filters in data management (number 2 in andreasraithel's reply). If you have a field indicating whether the data should be exported, you can use it in the filter.
Apratim 149 on at

Like (0)

Report

Export data to excel automatically at equal interval of time

Hi Andreas,

Thankyou for the reply!

I know that we can Export using Data management framework. But the reason why want to achieve this technically through code is that I can't consider those sales order in this export which are already exported earlier.

Thanks!
Raj Borad 494 on at

Like (0)

Report

Export data to excel automatically at equal interval of time

Hi Apratim,

As per my knowledge, for your solution for getting few particular orders, you need to develop the class and run it as a batch job.

Using this you can be able to add the format of Excel and export only the required columns from the Sales Table and Sales Line based on some conditions.

Thanks,

Raj Borad.
Apratim 149 on at

Like (0)

Report

Export data to excel automatically at equal interval of time

Hi Martin,

I want to export Sales header and Sales line into two different Excel File!

Thanks!
Suggested answer

andreasraithel 4,823 Super User 2024 Season 2 on at

Like (1)

Report

Export data to excel automatically at equal interval of time

Hy Apratim,

you can do that Export using Data management framework.

Just create a data export project, insert the two entities ((1) SO Header and SO Line).

Then set a filter (2) for each of the two lines to filter only the few related Sales Orders.

When all the filters are set use "export in batch" (3) to setup a bazch and assign the desired recurrancy.

You will see each run of the batch in data project job exection history and you can download the created files as a package or as Excel with in the execution details form.

When you need to provide the files on a specific local folder or share you to automate this e.g. with Power Automate.

Hope this helps.

Herzliche Grüße / kind regards,

Andreas Raithel

D365FO Solution Architect
Martin Dráb 230,214 Most Valuable Professional on at

Like (0)

Report

Export data to excel automatically at equal interval of time

Moved from Dynamics AX forum.

Sales orders and sales order lines are two tables. How do you want to export them to Excel? To two separate files? To a single table where all header fields are repeated on all lines from the same header? Or somehow else?

You can't start designing a solution without having some idea about the required output. But don't restrict yourself too early if users don't have strong business requirements; you could unnecessarily force yourself to a more difficult solution than needed.
Apratim 149 on at

Like (0)

Report

Export data to excel automatically at equal interval of time.

Hi Martin,

I'm using this AX version :

Installed product version : 10.0.35 (10.0.1627.138)Installed platform version : Update59 (7.0.6972.170)

Thanks!!!
Apratim 149 on at

Like (0)

Report

Export data to excel automatically at equal interval of time.

Hi Andre,

Thanks !
André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at

Like (1)

Report

Export data to excel automatically at equal interval of time.

Hi Apratim,

Please answer the question from Martin about the exact Dynamics AX version. That determines how to answer your question.