Finance | Project Operations, Human Resources, ...

Enable enum value when exporting to BYOD

(0) Share

Report

Posted on by AstridMalanka

Hi,

When I export to my BYOD some columns are enum values, I would like to get the description of the value or I think it is called name.

I understand from previous posts here that the is something I need to enable. EnableEnumSymbolSupportForImportExport. But I am not sure where.

I tried finding it on my data management working space, but I was not able to find find what I needed.

I enabled some compatibility options on the data export and import, but I did not get the result I wanted.

For example, there is a column on the entity SalesOrderLineV2, FulfillmentStatus, I would like to get the name and not just the value.

That enum comes from the table RetailSalesLine, and there it has a different name.

How do I export the names instead of the values?

Thanks

Astrid.

I have the same question (0)

All responses (17)

Answers (0)

Suggested answer

Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at

Like (0)

Report

Hi AstridMalanka,

Have you tried to activate "use enum lable" for the entity on the "Mapping detail" while exporting data?

Was this reply helpful? Yes No
AstridMalanka 8 on at

Like (0)

Report

I am trying it right now, but is there a way to do it for all the entities that I export, or at least all for the columns in one entity?

Otherwise I need to go column by column

Was this reply helpful? Yes No
AstridMalanka 8 on at

Like (0)

Report

it did not work, I marked the columns that were enums and exported again, but it did not export as a name, rather as a value

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at

Like (0)

Report

This feild is accessible on data project > mapping detail> Use enum table for each entity.

Have you checked the data in azure sql database? Do you mean that there has not any difference? Can you come up with a example?

Was this reply helpful? Yes No
AstridMalanka 8 on at

Like (0)

Report

I followed your recommendation

and then I exported it to the BYOD on azure. and I still got values and not names

so I am not getting the name attached to the value.

I also would like to know if there is a way to do it for the whole entity or all the exports and not go column by column

thanks

Was this reply helpful? Yes No
AstridMalanka 8 on at

Like (0)

Report

sorry, i am not sure what happened with the first picture

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at

Like (0)

Report

Please try to activate checkmark for «FULFILLMENTSTATUS» and then try again. On your attached screenshot, it seems that you use another field.

Was this reply helpful? Yes No
AstridMalanka 8 on at

Like (0)

Report

It is still not working, the first time I tried it I also had the correct field. I read something about the EnableEnumSymbolSupportForImportExport enabled, but I am not sure how to enable it.

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at

Like (0)

Report

Hei Astrid,

I have tested this on Excel and it works fine while it indicated integer value for "FulfillmentStatus" in AzureSQLDB.

I have checked the entity attribute for external DB og it has "Integer" as type and this standard function "Use enum lable" cannot change it to character in AzureSQLDB via BYOD export.

As a workaround you can provide enum values separately or create a custom entity for this purpose.

Was this reply helpful? Yes No
AstridMalanka 8 on at

Like (0)

Report

Oh, that is good to know, I didnt know I can check that.

I am not sure how to check the attribute type on the first picture, to the database, can you guide me?

Also, to provide the enum values on a customer entity, do you have any link or idea what I can follow. I do know how to create a customer entity and add related columns, is this a manual one?

Was this reply helpful? Yes No