How to build XS APPLICATION to upload Excel to HANA DB Table

[Former Member]

Hi Experts,

I am very new to HANA and currently working on a solution to upload a Excel file to HANA DB table via XS APPLICATION.

These are the steps which I have completed so far:

Step 1: Create HCP trail account

Step 2: Create HANA DB within HCP enviroment

Step 3: Connect to  HANA DB (HCP)  using Eclipse

Step 4: Create a XS Project> Create Schema>Create KPI_MASTER_TABLE

Outstanding steps:

Step 5: Create XS application to upload the Excel file from an URL link to KPI_MASTER_TABLE

Which possibilities are there to successfully cover step 5?

Any advise or solution is appreciated.

Thanks in advance.

Cheers,

Rabie

[SergioG_TX · Accepted solution]

Rabie,

welcome to HANA and XS.

in order to accomplish this, you will need to have a couple things:

1) a file uploader control on your UI that allows you to browse and select your file,

2) an xsjs service that receives the posted file

you have to have a minimum of these two files in order to read from the ui into the server side.

There may be some examples here on scn or you may google it as well

good luck

[Former Member · Accepted solution]

Hi Sergio,

Thanks for advising. I completed your first suggested step

(a file uploader control on your UI that allows you to browse and select your file).

However, in Eclipse which file format do I need to choose in order to create a server side javascript file xsjs?

Cheers,

Rabie

[SergioG_TX · Accepted solution]

you can simply create a file, and give the prefix .xsjs that's the prefix

[roland_bouman]

Were Sergio's answers helpful for you? If so, please mark his answer as correct.

If you still need help, let us know.

We created a custom web client application (based on angular) to upload excel workbooks to SAP/HANA and we also created a xsjs webservice that our application relies upon to accept the upload, and store the workbook serverside in a database blob. If you need help with specific details on implementing that then we can share our know-how here on scn.

[Former Member]

Hi Roland,

Thanks for reaching out to me . It would be great if you can share your advise on how to achieve the above goal. Since i am new into the XS application and HANA i have been searching googling for weeks now.

Steps completed:

1 created All HANA tables

2 created Views

3 created XS project.

Remaining steps:

4 build application to upload kpi excel data to kpi tabel in HANA

Looking to work this out with your advise.

Cheers,

Rabie

[roland_bouman]

Hi Rabie!

It's going to take a bit of text to explain, but I will get back on this. Please give me a day or two and I'll explain it in a scn blog.