Import EcoResCategory via DMF

(0) Share

Report

Posted on by vicky1234

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.

thanks,

I have the same question (0)

All responses (8)

Answers (2)

Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Vicky,

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

Was this reply helpful? Yes No
vicky1234 66 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
vicky1234 66 on at

Like (0)

Report

thanks Gunjan,

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

You are the best :)

Was this reply helpful? Yes No
vicky1234 66 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

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

Was this reply helpful? Yes No
vicky1234 66 on at

Like (0)

Report

My bad ,

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

Thanks

Was this reply helpful? Yes No
Verified answer

Gunjan Bhattachayya 35,423 on at

Like (1)

Report

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.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Import EcoResCategory via DMF

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Import EcoResCategory via DMF

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates