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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Export Product details...
Microsoft Dynamics AX (Archived)

Export Product details into Excel using Job

(0) ShareShare
ReportReport
Posted on by Vignesh R 535

Hi Experts,

Hope everyone doing good!

I need to export the all product details with their color and size into Excel sheet.

Excel sheet Output : Item Number | Product Name | Color | Size 

How we will to do it using jobs . Kindly give suggestions to move further.

Advance in thanks and Regards,

Vignesh R

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 305,703 Super User 2026 Season 1 on at

    Hi Vignesh,

    Why do you want to use a Job to do this? You can also use the Excel connector or Data Import Export Framework.

  • Vignesh R Profile Picture
    Vignesh R 535 on at

    Hi Andre,

    I don't have any idea about DIXF. That why I asked, is there any possibilities by using jobs?

    Advance in Thanks and Regards,

    Vignesh R

  • Martin Dráb Profile Picture
    Martin Dráb 239,711 Most Valuable Professional on at

    DIXF is the standard framework for imports and exports data, i.e. exactly your task. It can export to several formats, including Excel spreadsheets. And yes, you can call it from a job, if you really need it.

    The fact that you're not familiar with it is a problem that you should fix by learning it, not by writing jobs.

    If you still want to design, develop, test and maintain custom code rather then using already existing features of AX, please explain which part you're struggling with (obtaining data, writing to files or so).

  • Vignesh R Profile Picture
    Vignesh R 535 on at

    Hi Martin,

    Thanks for your reply. I'm learning DIXF now but as of now i want to write a job to get a Data.

    I'm facing problem to obtaining a data through code and unable to find the relation between three tables EcoResProduct, EcoResColor, EcoResSize.

    Kindly help me Martin.

    Advance in Thanks and Regards,

    Vignesh R

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 305,703 Super User 2026 Season 1 on at

    Hi Vignesh,

    So, your question is now about the data model, right?

    Check the table relations on some other tables to get an overview.

    - EcoResDistinctProductVariant

    - EcoResProductVariantDimensionValue

    - EcoResProductVariantColor

    - EcoResProductVariantSize

    This list might be not complete.

    You can also look at the datasources on the form EcoResProductVariants to learn from it.

  • Vignesh R Profile Picture
    Vignesh R 535 on at

    Hi Andre,

    Yes, my question is about data model.

    In Client Application, I'm able to check the Size and color of each Product. Whereas coming to table level, I'm unable to make a relationship in jobs to get a data into excel-sheet.

    Kindly give some ideas in this case.

    Thanks in Advance and Regards,

    Vignesh R

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 305,703 Super User 2026 Season 1 on at

    HI Vignesh,

    Did you actually tried to understand the data model from the form datasources? If you look at the table relations of these tables, you should be able to have all relationships to create the job and loop the data.

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 16

#2
Nagendra Varma K Profile Picture

Nagendra Varma K 4

#2
Harisgillani Profile Picture

Harisgillani 4

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans