Finance | Project Operations, Human Resources, ...

Enable enum value when exporting to BYOD

(0) Share

Report

Posted on by AstridMalanka

449

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.

All responses (17)

Answers (0)

Alireza Eshaghzadeh 12,146 Super User 2024 Season 2 on at

Like (0)

Report

RE: Enable enum value when exporting to BYOD

I guess you need to click on "Yes" on Did this answer your question?
AstridMalanka 449 on at

Like (0)

Report

RE: Enable enum value when exporting to BYOD

Where do I mark verified?
Alireza Eshaghzadeh 12,146 Super User 2024 Season 2 on at

Like (0)

Report

RE: Enable enum value when exporting to BYOD

Great!

No problem.

Please mark the thread as verified to help other community members.
AstridMalanka 449 on at

Like (0)

Report

RE: Enable enum value when exporting to BYOD

Thanks, that shows that every enum is an integer, which brings me back to how do I export the enum name to the BYOD, but I did learn a lot, and I really appreciate it :)
Suggested answer

Alireza Eshaghzadeh 12,146 Super User 2024 Season 2 on at

Like (0)

Report

RE: Enable enum value when exporting to BYOD

Ok. Go to the "Configure entity export to database" > Choose actual Azure SQLDB and click on Publish > Find entity and click on "Compare source names"

Filter for the field "FulfillmentStatus"
AstridMalanka 449 on at

Like (0)

Report

RE: Enable enum value when exporting to BYOD

Thanks, that one I did already, the one I did not know where to find is this one.

And I am the developer, but this is new to me, so I am trying to learn as we go
Suggested answer

Alireza Eshaghzadeh 12,146 Super User 2024 Season 2 on at

Like (0)

Report

RE: Enable enum value when exporting to BYOD

Hei Astrid,

Please follow steps to get "Attribute type":

1-Add the entity on export data project and click on "Entity attribute"

2- Add new column to the form (i.e. Field enum name)

3-Filter for the field

Regarding the enum values you can use development box (e.g. DevLabs) to check what values are defined for this field on VS. It has the following values:

0 - Unknown

1 - Pending

2 - Picking

3 - Partially picked

4 - Picked

5 - Partially packed

6 - Packed

7 - Partially invoiced

8 - Invoiced

When it comes to the custom entity, you can check with developer to create a custom entity to export these values as label name.
AstridMalanka 449 on at

Like (0)

Report

RE: Enable enum value when exporting to BYOD

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?
Suggested answer

Alireza Eshaghzadeh 12,146 Super User 2024 Season 2 on at

Like (0)

Report

RE: Enable enum value when exporting to BYOD

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.
AstridMalanka 449 on at

Like (0)

Report

RE: Enable enum value when exporting to BYOD

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.