Fiori Elements List Report OData V4- Excel Export Configuration

[DC]

Hi Team,

We have a FE Odata V4 application in SAP CAP. We are using the Excel Export functionality. This works fine but we need the DATETIME fields to be exported where UTC=false. i.e in the user locale. Also wanting to format other fields also.

We understand we might be able to extend our FE application and attach our custom code in the beforeExport Event.

Just struggling to config the manifest file and create the extension controller. We have done V2 extensions but NOT V4 ones so appreciate any help here 🙂

Is there anyone who has a working example for FE Odata V4 extension please.

Any help very much appreciated.

Cheers

D

[Marian_Zeis · Accepted solution]

Hi Darmesh,

you should be able to add them via Fiori Tooling and Page Map in BAS

Here is the code from the manifest

        "extends": {
            "extensions": {
                "sap.ui.controllerExtensions": {
                    "sap.fe.templates.ListReport.ListReportController": {
                        "controllerName": "namespace.ext.controller.Test"
                    }
                }
            }
        },

[DC · Accepted solution]

Hi Marian,

Thanks for getting back with this information.

I have looked at my BAS and i don't see what you see with your screen illustrations above

My FE application is part of a MTA with CAP Java project

I dont see show controller options!

I have added the manifest entry manually and created the ext controller but when i run it in BAS, i dont see the controller js file loaded in the source tab in chrome debugging.

 "extends": {
    "extensions": {
               "sap.ui.controllerExtensions": {
                    "sap.fe.templates.ListReport.ListReportController": {
                      "controllerName": "packagenameXXX.extension.controller.ListingsExtension"
                    }
                }            
               }
           }

[DC · Accepted solution]

Hi 20eed143c19f4b82bc4cf049916102cb

Thank you for information on this.

I have managed to update the manifest manually and created the controller. I see these in the source tab in chrome now.

We want to use the beforeExport event to modify the settings for DateTime Fields.

What would our ext controller look like. The beforeExport is trigger automatically so how do we catch that in our ext controller??

Any examples would be handy 🙂

Cheers

D

[skymu89]

Hi Darmesh,

Here is example made: Add beforeExport ext example · Cachetian/cap-java-2207-action-based-custom-create@f742697 · GitHub

Referenced documentations:

1. Using Controller Extension - Documentation - Demo Kit - SAPUI5 SDK
2. Spreadsheet Export Configuration - Documentation - Demo Kit - SAPUI5 SDK
3. sap.ui.export.Spreadsheet - API Reference - Demo Kit - SAPUI5 SDK
4. sap.ui.comp.smarttable.SmartTable - API Reference - Demo Kit - SAPUI5 SDK

BR Sky

[DC]

Hi Sky,

Thank you for this information.

Really appreciate your input on this.

Cheers

Dharmesh

[Trulov]

Hi Darmesh,

as Marian said, you can use the VSCode Fiori Tools for generating the necessary Boilerplate coding for your controller extension.

I want to also highlight the IMHO super underrated Flexible Programming Model Explorer for OData V4 FE projects. Here you can find additional code examples for sample use cases

BR Tom