How to export relational attribute to excel sheet using export action

[sumit_rajan]

Hi Experts,

I want to export relational attributes to excel sheet with export action from backoffice. For example : I have an item type Product and it has an attribute ratePlan, which is another item type and also there is one to many relation between product and rate plan. But when i try to export the product data to excel sheet, i am getting the value of ratePlan empty. Can someone please help me in solving this issue.

Regards,

[bruno_maciel01]

The out-of-the-box Export to Excel tool, supports attributes of the following types: String, Number, Date, Boolean, and all enums which extend de.hybris.platform.core.model.enumeration.EnumerationMetaTypeModel, because this the Boolean and list attributes are being displayed like you mentioned.

So in order to export (or import) new attributes which are references to another types (in your case, the custom map), you need to provide appropriate translators and validators to it. I would kindly ask you to check how to do it using our help pages Excel Translators in Backoffice and Excel Validators in Backoffice.

For further content, I also kindly suggest you to check this Excel Export and Import in Backoffice Framework - Technical Details.