Importing a CSV file into a table for Fiori

[Former Member]

Hello,

I create a fiori application with sap web ide  and i need to import a csv file from my desktop and show its content into a table in my fiori application

Please could some one help me

Ameni,

Subject was edited by: Michael Appleby

[liz_cawley]

Hello Dhawefi,

SAP Web IDE offers a visualization extension plugin (Vizpacker) that can handle this. Reference the Visualization Extension Plugin for SAP Web IDE help guide for more information.

Kind Regards,

Liz Thorburn

(SAP Technology RIG)

[Former Member]

thank you ,  but i want to add a button that upload the file from my desktop

[jamie_cawley]

Hi Dhawefi,

Please take a look at

https://sapui5.netweaver.ondemand.com/sdk/explored.html#/entity/sap.ui.unified.FileUploader/samples

Regards,

Jamie

SAP - RIG

[Former Member]

Hello Jamie

Thank you ,

i try this code , i putted in my detail.view.xml this code :<l:VerticalLayout> <u:FileUploader id="fileUploader" name="myFileUpload" uploadUrl="upload/" width="400px" tooltip="Upload your file to the local server" uploadComplete="handleUploadComplete"/> <Button text="Upload File" press="handleUploadPress"/> </l:VerticalLayout>

and i put in detail.controller.js the 2 functions : handleUploadComplete and handleUploadPress

And when i run and i press in the button to load the file but it doesn't work !

Best Regards,

Ameni,

[jamie_cawley]

Hi Ameni,

Without any type of error or what "doesn't work" means, it would be hard to assist you.  Please provide descriptive details.

Regards,

Jamie

SAP - RIG

[Former Member]

Hi Jamie,

when i press in the button the file couldn't be loaded  , i get this errors

Thanks,

Best Regards,

Ameni,

[Former Member]

Hi Jamie,

i dont' know what i put in the the upload URL : it should be a url of a server ??

Best Regards,

Ameni,

[jamie_cawley]

That would be the directory where the file would be uploaded.  This would require appropriate rights to be setup on this directory otherwise it will result in the 405 error.

Regards,

Jamie

SAP - RIG

[Former Member]

Hello Jamie,

thank you , i want to show the data from my excel in my fiori application and i want to register this data in my hana database (i work with sap web-base workbench),

how can i do this please

Best Regards,

Ameni,

[jamie_cawley]

I would suggest that you do some research to understand the pieces involved and what approaches you can take. There's a few blog you can reference such as the following which should help you get started.

Regards,

Jamie

SAP - RIG

[santhu_gowdaz]

refer this tread

Importing CSV files using jQuery and HTML5