#Backoffice - How to enable export excel in backoffice (hybris 6.6)

[Former Member]

HYBRIS6.6 #BACKOFFICE #EXCELEXPORT

From the release notes of hybris 6.6 its clear that hybris is not providing the excel import/export functionality in backoffice and cockpit. However when I installed OOB it only shows export to CSV file option. No excel export was available in backoffice.

Please help me out to enable excel export function in hybris 6.6

[nicolabeghin]

For anyone interested: in order to enable excel import/export to item types different than Product:

in this example we got to add import/export to Category item type

 <?xml version="1.0" encoding="UTF-8"?><config xmlns="http://www.hybris.com/cockpit/config">
     <context merge-by="type" type="Category" component="listviewactions" module="platformbackoffice">
         <y:actions xmlns:y="http://www.hybris.com/cockpit/config/hybris" xmlns:advanced-search="http://www.hybris.com/cockpitng/config/advancedsearch" xmlns:c="http://www.hybris.com/cockpitng/config/common" xmlns:df="http://www.hybris.com/cockpitng/component/dynamicForms" xmlns:dsb="http://www.hybris.com/cockpitng/config/dashboard" xmlns:editorArea="http://www.hybris.com/cockpitng/component/editorArea" xmlns:explorer-tree="http://www.hybris.com/cockpitng/config/explorertree" xmlns:grid-view="http://www.hybris.com/cockpitng/component/gridView" xmlns:list-view="http://www.hybris.com/cockpitng/component/listView" xmlns:na="http://www.hybris.com/cockpitng/config/notifications" xmlns:simple-search="http://www.hybris.com/cockpitng/config/simplesearch" xmlns:wz="http://www.hybris.com/cockpitng/config/wizard-config">
             <y:group qualifier="common">
                 <y:action action-id="com.hybris.backoffice.widgets.actions.sync" property="selectedObjects"/>
             </y:group>
             <y:extended-group qualifier="export" show-group-header="false">
                 <y:action action-id="com.hybris.backoffice.widgets.actions.excel.export" property="pageable.typeCode">
                     <y:parameter>
                         <y:name>actionName</y:name>
                         <y:value>label.export.excel</y:value>
                     </y:parameter>
                 </y:action>
                 <y:action action-id="com.hybris.backoffice.widgets.actions.excel.exporttemplate" property="pageable.typeCode">
                     <y:parameter>
                         <y:name>actionName</y:name>
                         <y:value>label.export.exceltemplate</y:value>
                     </y:parameter>
                 </y:action>
                 <y:action action-id="com.hybris.cockpitng.listview.action.export.csv" property="exportColumnsAndData">
                     <y:parameter>
                         <y:name>actionName</y:name>
                         <y:value>label.export.csv</y:value>
                     </y:parameter>
                 </y:action>
                 <y:extended-action action-id="com.hybris.backoffice.widgets.actions.excel.export"/>
             </y:extended-group>
         </y:actions>
     </context>
 </config>
 

[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.

[Former Member]

What is the use of this Excel Export facility when it only works with the Product type as in most applications the Product model is extended to include new attributes??

[Former Member]

As Lukasz commented, Excel export/import is only applied to Product type by default. You can find it in the following page. https://help.hybris.com/6.6.0/hcd/bb77d8ae51e546138bec07a396f0803e.html

[former_member638520]

Right, OOTB it is applied to Product. Nevertheless you can easily configure excel feature for other types ;-)

[Former Member]

Lukasz, noted. Thanks for your confirmation :)

[Former Member]

Then how to enable it in other area like Report Definition and then search by type? Given link is not giving detail around this. Please suggest.

[Former Member]

Sorry but I am not able to add the OOBT excel upload functionality in Report Definition and then Search By Type. Could you please help me providing detail how to add export to excel functionality in Report Definition and then Search By Type. Thanks.

[former_member638520]

Hi, Probably Excel feature won't work with report definition. This functionality uses ComposedType and AttributeDescriptor which don't exists in report definition.

Regards,

Lukasz

[former_member638520]

Hi,

Excel export/import OOTB is enabled for Product type. Do you have the following actions in your collection browser for product type?

Regards

Lukasz

[Former Member]

Then how to enable it in other area like Report Definition and then search by type?