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, ... / Import EcoResCategory ...
Finance | Project Operations, Human Resources, ...
Answered

Import EcoResCategory via DMF

(0) ShareShare
ReportReport
Posted on by vicky1234 64

Hi,

I would like to know if there is an entity to import EcoResCategory data via the DMF import functionality.
I checked multiple entities but it seems the one which i found is not for DMF imports as it does not even contains the staging table.

I mean you have the name,level,parent and so on.

pastedimage1648739913283v1.png
thanks,

VK

  • Verified answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Import EcoResCategory via DMF

    DisplayOrder dertermines the sorting order on Category hierarchy form.

    For an example, in the screenshot below, Sports has a Display order value of 0.00, Apparel has a value 1.00 and Gifts has a values of 2.00. In the form they are arranged in this order.

    pastedimage1648832153118v1.png

  • vicky1234 Profile Picture
    vicky1234 64 on at
    RE: Import EcoResCategory via DMF

    My bad ,

    Its there on the ecorescategory table the field name is DisplayOrder.

    Thanks

  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Import EcoResCategory via DMF

    Hi Vicky,

    I don't see a field DisplayValue. ExternalId is saving GUID values from other systems in case you are integrating D365 F&O with another system

  • vicky1234 Profile Picture
    vicky1234 64 on at
    RE: Import EcoResCategory via DMF

    Just wanted to ask what is the purpose of the Displayvalue and the ExternalId with value as {00000000-0000-0000-0000-000000000000}

  • vicky1234 Profile Picture
    vicky1234 64 on at
    RE: Import EcoResCategory via DMF

    thanks Gunjan,

    I have tested and I confirm that its the entity used to import hierarchies as well.

    You are the best :)

  • Verified answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Import EcoResCategory via DMF

    Hi Vicky,

    This entity takes care of the categories and hierarchies only. It doesn't import products. Please take a look at the underlying tables in the entity.

  • vicky1234 Profile Picture
    vicky1234 64 on at
    RE: Import EcoResCategory via DMF

    Hi Gunjan bhai,

    thanks for the reply.

    I want to import the category and hierarchies and not the product.

    the one which you shared is related to importing the products associated with a hierarchy.

    Let me know if I am missing something important

  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: D365 fno EcoresCategory Entity for DMF

    Hi Vicky,

    You can use EcoResProductCategoryEntity. You can set the Category hierarchy and import the records.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,884 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,760 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans