32
Views
10
Comments
I want to upload an Excel file (ID, Name, Image, and Address) in Database Entity?
Question
Application Type
Reactive
Service Studio Version
11.54.66 (Build 63364)

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 Regards
Mrityunjay Verma


2023-12-16 19-57-03
Sanjay Kushwah

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

2024-05-06 07-41-12
Narendra Tiwari

Hi mrityunjay ,

you can follow this url

https://www.youtube.com/watch?v=0NVHxmiPGDs

Thanks,

Narendra Tiwari

2022-07-05 06-54-15
GOKULPRASANTH MUNUSAMY

Hi  mrityunjay verma,


Kindly Elaborate your issues or share the OML. Than only we can understand your issue clearly.



Thanks,

Gokulprasanth M


2023-07-10 08-35-55
Mrityunjay Verma

Hi @GOKULPRASANTH M , @Sanjay Kushwah
I am using ExcelToRecordList to upload data in the database.

I have attached the OML file
Please go through the OML.

Thanks and Regards 

Mrityunjay Verma.

Screenshot 2024-07-18 154212.png
ExceltoRecordList.oml
UserImage.jpg
Md Mansur

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 

2023-07-10 08-35-55
Mrityunjay Verma

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.

Thanks and Regards

Mrityunjay Verma

2024-05-06 07-41-12
Narendra Tiwari

Hi mrityunjay ,

You can follow this Post.

Or you can go to this Post.

Thanks,

Narendra Tiwari

2023-10-19 05-09-59
Mangesh Phanse

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

 

2023-07-10 08-35-55
Mrityunjay Verma

Hi @Mangesh Phanse,

Could you attach an Oml file if you have done this it will help me.

Thanks 

Mrityunjay Verma


2023-10-19 05-09-59
Mangesh Phanse

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

ExceltoRecordListProposedChanges.oml
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.