Not able to upload data from excel sheet

I created the database using an excel sheet, but there are no records. So I tried updating the action using the bootstrap option. Please see the image for the error. Please give some solution for that. 

Hi @Densingh Daniel , try creating attributes(table columns) with the same names as your Excel columns


Regards,

Marvei

Hi Densingh Daniel, check if the attributes name of the structure used in the boostrap match with the name of the columns of the Excel sheet.


Hi DenSingh,

Based on the screenshot you have shared the column name in the excel file have blank spaces between the text. So, only 1 column Thor is matching. Try to do bootstrap after removing spaces from column headers in excel as below.

1. ClientName

2. Thor

3. BidProjectCode

4. DealQualificationStatus

5. DealStatus

6. RequestDate

Also, refer the below link to get more idea about bootstrap.

https://success.outsystems.com/Documentation/10/Developing_an_Application/Use_Data/Bootstrap_an_Entity_Using_an_Excel_File

Thanks & Kind Regards,

Sachin


Champion

HI 

Could you share the oml file, or at least the Excel file?

Kind regards,

Hi Densingh Daniel, You need to add the attributes of excel sheet (Client name ,Thor, BID project code and all attributes to the entity) then only you can able to bootstrap the data from excel sheet. Regards, Komal
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.