Microsoft Dynamics AX (Archived)

Export data in csv file using Data import export framework

(1) Share

Report

Posted on by Community Member

Hi All,

I am new to Data import export framework in AX 2012 R3.

I want to export some data in csv format by using this framework.

If anyone have some idea then please share with me.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

5400 7,162 on at

Like (0)

Report

1. Create processing group with entity and source Type "AX"

a) Do get staging to export the data from target to staging.

2. Create processing group with same entity source type "File" as CSV with sample file.

a) Do generate Mapping

3. Go to first processing group -execution history -> export to file

   a) Select second processing group from look-up

   b) Export file path location

   c) Ok.

Please find the link which will help you step by step.

community.dynamics.com/.../microsoft-dynamics-ax-2012-file-exchange-export-using-data-import-export-framework-dixf

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Bhaskar,

Thanks for your reply. Now I am able to export data.

I have one more doubt. I want to provide range before exporting data, we can provide range in select button while running processing group but I want like hardcoded. User should not change the range value.

How can I achieve this?

Was this reply helpful? Yes No
5400 7,162 on at

Like (0)

Report

If you are using this entity for only export then you can do in target query node and lock the range. if you are using this entity for import also, you have to add the range dynamically for this entity in \DataDictionary\Tables\DMFDefinitionGroupEntity\Methods\resetQuery.

Was this reply helpful? Yes No
new_axys 135 on at

Like (0)

Report

trouble with this is, when generating the sample file you must know which fields to choose. there is no such button as "select all" what a pain :(

Was this reply helpful? Yes No
AMOLAK 30 on at

Like (0)

Report

Mr.Bhasker please tell me if i need to export one or more field in ax2012 in csv file so how can i do.

plz tell me steps.

thanks in advance.

Was this reply helpful? Yes No
Yugene on at

Like (0)

Report

Yeah! This is a real pain. I am wondering if there is a reason why Microsoft did it that way.

Was this reply helpful? Yes No