Hi community I am new in this field and facing an issue while uploading an Excel file (ID, Name, Image, and Address) to the Database Table.Best RegardsMrityunjay Verma
hi @mrityunjay verma,
Could you please elaborate more what the error you are facing now.
please attached OML or snapshot of error.
Kind regards,
Sanjay Kushwah
Hi mrityunjay ,
you can follow this url
https://www.youtube.com/watch?v=0NVHxmiPGDs
Thanks,
Narendra Tiwari
Hi mrityunjay verma,
Kindly Elaborate your issues or share the OML. Than only we can understand your issue clearly.
Gokulprasanth M
Hi @GOKULPRASANTH M , @Sanjay KushwahI am using ExcelToRecordList to upload data in the database.
I have attached the OML filePlease go through the OML.
Thanks and Regards
Mrityunjay Verma.
Hello @mrityunjay verma
You cannot do this directly as images into excel is not existing inside cells its only embedded into excel file.
The other ways to do that:
- Save binary data of image into excel file instead of image itself in column of type text then convert it to Binary data into OutSystems
- Save URL of image into excel sheet then into OutSystems download image and save it as Binary data into table
Note : You have a Colum called Image so its create issue to insert excel Data to Outsystem Database:
Thanks
Hi @Md Mansur ,Could you please explain how I can do this or attach an Oml file if you have done this it will help me.
Mrityunjay Verma
You can follow this Post.
Or you can go to this Post.
Hi mrityunjay
Try to separate images from excel and entity
Saving images in same entity as other data always a huge performance toll. That is the main root cause of issues you are facing
Use one to one relation (Outsystems word is Extension Entity)
If there are few records then manually upload file or have some cloud location to store images and add links into images data
Hi @Mangesh Phanse,
Could you attach an Oml file if you have done this it will help me.Thanks
Hi @mrityunjay verma
As required sharing changes in your attachment.
you may have to do some changes like file upload, file store location or manually uploading file to 'DemoEntity' in OML ui will have upload image option