Implement link to ODXL export of participant details as xlsx #1

gregorwolf · 2016-07-31T19:36:50Z

The event details should contain a link to export the list of participants with all details als xlsx (Excel) using ODXL.

gmahi · 2016-08-04T08:12:40Z

Hallo Gregor, I have added 3rd IconTabFilter to list the registered participants. While I am trying Implement link to ODXL export, I have encountered the following problem while trying to activate ODXL Sample Application. CA_USER_TABLE_COLUMNS_001.calculationview on HCP Trial HANA MDC as "_SYS_BI"."BIMC_DIMENSION_VIEW" does not exist.

if you like I will implement CSV export as in the following example application from https://sapui5.hana.ondemand.com/explored.html#/sample/sap.m.sample.TableExport/code
from the explored.

gregorwolf · 2016-08-04T08:25:22Z

Hi Gmahi, thank you for taking this up. I've added you to the repositories. Please commit your addition for the 3rd Tab showing the list of participants as soon as possible.

Regarding the issue with the ODXL application: That is a known issue with HANA MDC on HCP Trial which I've already field. But you should be able to use the export anyway. Only the sample app will not work.

Please don't invest time into CSV. I hate it as it will cause all kind of problems when importing into Excel.

gmahi · 2016-08-04T17:32:00Z

Hi Gregor,
Thank you for your reply. I am trying to push from SAP Web IDE. But I am
getting the following Error.

Push request failed__https://github.com/sapmentors/SITregOrganizer.git
https://github.com/sapmentors/SITregOrganizer.git: not authorized.

With best Regards,
Mahendra

On Thu, Aug 4, 2016 at 10:25 AM, Gregor Wolf [email protected]
wrote:

Hi Gmahi, thank you for taking this up. I've added you to the
repositories. Please commit your addition for the 3rd Tab showing the list
of participants as soon as possible.

Regarding the issue with the ODXL application: That is a known issue with
HANA MDC on HCP Trial just-bi/odxl#23 which
I've already field. But you should be able to use the export anyway. Only
the sample app will not work.

Please don't invest time into CSV. I hate it as it will cause all kind of
problems when importing into Excel.

—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
#1 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/AER7t-clUWDGxcTjV41Oei1vEn04QEGjks5qcaHygaJpZM4JZGnA
.

Mit freundlichen Grüssen

Mahendra Gulla

+49 1627327599

gregorwolf · 2016-08-04T19:45:44Z

Hi Gmahi,

have you accepted the GitHub invites I've sent?

CU
Gregor

2016-08-04 19:32 GMT+02:00 gmahi [email protected]:

Hi Gregor,
Thank you for your reply. I am trying to push from SAP Web IDE. But I am
getting the following Error.

Push request failed__https://github.com/sapmentors/SITregOrganizer.git
https://github.com/sapmentors/SITregOrganizer.git: not authorized.

With best Regards,
Mahendra

On Thu, Aug 4, 2016 at 10:25 AM, Gregor Wolf [email protected]
wrote:

Hi Gmahi, thank you for taking this up. I've added you to the
repositories. Please commit your addition for the 3rd Tab showing the
list
of participants as soon as possible.

Regarding the issue with the ODXL application: That is a known issue with
HANA MDC on HCP Trial just-bi/odxl#23 which
I've already field. But you should be able to use the export anyway. Only
the sample app will not work.

Please don't invest time into CSV. I hate it as it will cause all kind of
problems when importing into Excel.

—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
<#1 (comment)
237486724>,
or mute the thread
<https://github.com/notifications/unsubscribe-auth/AER7t-
clUWDGxcTjV41Oei1vEn04QEGjks5qcaHygaJpZM4JZGnA>
.

Mit freundlichen Grüssen

Mahendra Gulla

+49 1627327599

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub
#1 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/AChGr1agmZl36E1io63U9YKiBJ7pQSgTks5qciIRgaJpZM4JZGnA
.

gmahi · 2016-08-04T21:42:04Z

Hi Gregor,
Thank you for your reply. it worked after removing the Cache.
With best regards,
Mahendra

gmahi · 2016-08-29T09:50:47Z

Hallo Gregor, I have added 3rd IconTabFilter to list the registered participants. While I am trying Implement link to ODXL export, I have encountered the following problem while trying to activate ODXL Sample Application. CA_USER_TABLE_COLUMNS_001.calculationview on HCP Trial HANA MDC as "_SYS_BI"."BIMC_DIMENSION_VIEW" does not exist.

if you like I will implement CSV export as in the following example application from https://sapui5.hana.ondemand.com/explored.html#/sample/sap.m.sample.TableExport/code
from the explored.

gmahi · 2016-08-29T09:56:03Z

Hallo All,
I am trying implement link to ODXL export of participant details. I am getting the following error.
Error: parseGetRequest(no args): Invalid querypath com/sap/sapmentors/sitreg/odataorganizer/service.xsodata/Events(1)&$format=xlsx&download=Participants.xlsx does not match schema/table pattern.

Could you please let me know, where I am going wrong .
With best regards
Mahendra

onDataExport: function(oEvent) {
            var odxlServiceEndpoint = "/destinations/HANAMDC/com/sap/sapmentors/sitreg/odxl/service/odxl.xsjs";
            var oModel = this.getView().getModel(); //odata is the model, which is binding to the table
            var oTable = this.byId("idPartipicantsTable");
            var oContext = oTable.getBindingContext();
            var sPath = oContext.getPath();
            // var sServiceUrl = oModel.sServiceUrl;
            var sServiceUrl = '/com/sap/sapmentors/sitreg/odataorganizer/service.xsodata';
            var odataQuery = sServiceUrl + sPath;
            console.log(odataQuery);
            var sUrl = odxlServiceEndpoint + odataQuery ;
            var extension = "xlsx";
            var fileName = 'Participants'+"." +extension;
        var url = sUrl + "&$format=" + extension + "&download=" + fileName;
            // downloadSheetLink.download = fileName;
            var encodeUrl = encodeURI(url);
            sap.m.URLHelper.redirect(encodeUrl, true);
            console.log(encodeUrl);
        },

gregorwolf · 2016-08-29T10:25:19Z

Hi Mahendra,

you have to provide the View or Table name in the URL instead of the OData Service. In this case please use the View:

com.sap.sapmentors.sitreg.odataorganizer.procedures::ParticipantsRead

and for the export you have to filter by the EventID.

Best regards
Gregor

gmahi · 2016-08-30T08:13:39Z

Hi Gregor,
Thank you very much for your help. Unfortunately still I am missing something. I have tried
serviceUrl = /com.sap.sapmentors.sitreg.odataorganizer.procedures::ParticipantsRead also
com/sap/sapmentors/sitreg/odataorganizer/procedures/ParticipantsRead. I am getting the same error.
if you have any examples will be very helpful.
Sorry for taking your time.
Best regards,
Mahendra
```
onDataExport: function(oEvent) {
var odxlServiceEndpoint = "/destinations/HANAMDC/com/sap/sapmentors/sitreg/odxl/service/odxl.xsjs";
var oModel = this.getView().getModel(); //odata is the model, which is binding to the table
var oTable = this.byId("idPartipicantsTable");
var oContext = oTable.getBindingContext();
var sPath = oContext.getPath();
var sServiceUrl = 'com.sap.sapmentors.sitreg.odataorganizer.procedures::ParticipantsRead';
var filter = '?$filter=EventID eq' + 1;
var odataQuery = sServiceUrl + filter;
// console.log(odataQuery);
var sUrl = odxlServiceEndpoint + odataQuery;
var extension = "xlsx";
var fileName = 'Participants' + "." + extension;
var downloadSheetLink = this.byId('exportXslx');
var sHref = sUrl + "&$format=" + extension + "&download=" + fileName;
downloadSheetLink.setHref(sHref);
downloadSheetLink.download = fileName;
console.log(sHref);
},

gregorwolf · 2016-08-30T09:12:44Z

Hi Mahendra,

I don't want to distribute odxl in SITreg. So please install odxl in:

system-local/public/rbouman/odxl

then the request for (CSV):

/system-local/public/rbouman/odxl/service/odxl.xsjs/%22SITREG%22/%22com.sap.sapmentors.sitreg.odataorganizer.procedures::ParticipantsRead%22?$filter=%22EventID%22 eq 1&$format=csv&download=com.sap.sapmentors.sitreg.odataorganizer.procedures::ParticipantsRead.csv

or:

/system-local/public/rbouman/odxl/service/odxl.xsjs/%22SITREG%22/%22com.sap.sapmentors.sitreg.odataorganizer.procedures::ParticipantsRead%22?$filter=%22EventID%22 eq 1&$format=xlsx&download=com.sap.sapmentors.sitreg.odataorganizer.procedures::ParticipantsRead.xlsx

should work.

Best regards
Gregor

gmahi · 2016-08-30T21:40:04Z

Hi Gregor,
Thank you very much for your help. I have successfully implemented the feature and committed the same.
With best regards,
Mahendra

gregorwolf · 2016-09-16T09:57:55Z

Hi @SbgMartin,
unfortunately I haven't deployed the ODXL project to our Production instance yet. I've fixed that and now the download works when I start the app from the WebIDE. Please use that as a workaround. @gmahi perhaps you can check why the download isn't working when the the app is deployed as a HTML5 app.
Best regards
Gregor

gmahi · 2016-09-16T10:03:06Z

Hi Gregor,
Thank you for your feed back. I will deploy the app into SAP HANA Cloud platform and check the same.
With best regards,
Mahendra

gmahi · 2016-09-21T10:18:26Z

Hi Gregor, I have deployed the app into HANA Cloud platform and tested, it is working. Is this you want me check or Should I import this app into HANA MDC and check it.

gregorwolf · 2016-09-21T16:21:32Z

OK, when you have it working with the export also as a deployed HTML5 app on HCP using the destination to do the export that's great. Then I have to check where the problem with the export in production comes from.

gregorwolf · 2016-09-29T17:50:05Z

I've tried it again on production and it works just fine. Thanks @gmahi

gmahi · 2016-09-29T20:58:45Z

Hi Gregor,
I am delighted that it is working. Looking forward to meet to you next week
at SIT München.

Thanking you,
With best regards,
Mahendra

On Thu, Sep 29, 2016 at 7:50 PM, Gregor Wolf [email protected]
wrote:

I've tried it again on production and it works just fine. Thanks @gmahi
https://github.com/gmahi

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#1 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/AER7t3LSjdMy2no8aOZBVj7CPr77IGNNks5qu_pNgaJpZM4JZGnA
.

Mit freundlichen Grüssen

Mahendra Gulla

+49 1627327599

gregorwolf added the enhancement label Jul 31, 2016

gregorwolf mentioned this issue Sep 16, 2016

Download function doesn't work #8

Closed

gregorwolf closed this as completed Sep 29, 2016

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Implement link to ODXL export of participant details as xlsx #1

Implement link to ODXL export of participant details as xlsx #1

gregorwolf commented Jul 31, 2016

gmahi commented Aug 4, 2016

gregorwolf commented Aug 4, 2016

gmahi commented Aug 4, 2016

gregorwolf commented Aug 4, 2016

gmahi commented Aug 4, 2016

gmahi commented Aug 29, 2016

gmahi commented Aug 29, 2016

gregorwolf commented Aug 29, 2016

gmahi commented Aug 30, 2016

gregorwolf commented Aug 30, 2016

gmahi commented Aug 30, 2016

gregorwolf commented Sep 16, 2016

gmahi commented Sep 16, 2016

gmahi commented Sep 21, 2016

gregorwolf commented Sep 21, 2016

gregorwolf commented Sep 29, 2016

gmahi commented Sep 29, 2016

Implement link to ODXL export of participant details as xlsx #1

Implement link to ODXL export of participant details as xlsx #1

Comments

gregorwolf commented Jul 31, 2016

gmahi commented Aug 4, 2016

gregorwolf commented Aug 4, 2016

gmahi commented Aug 4, 2016

gregorwolf commented Aug 4, 2016

gmahi commented Aug 4, 2016

gmahi commented Aug 29, 2016

gmahi commented Aug 29, 2016

gregorwolf commented Aug 29, 2016

gmahi commented Aug 30, 2016

gregorwolf commented Aug 30, 2016

gmahi commented Aug 30, 2016

gregorwolf commented Sep 16, 2016

gmahi commented Sep 16, 2016

gmahi commented Sep 21, 2016

gregorwolf commented Sep 21, 2016

gregorwolf commented Sep 29, 2016

gmahi commented Sep 29, 2016