Log in to AnswerLog in to Follow
Densingh Daniel
18Views
5Comments
Not able to upload data from excel sheet
Question
Beginner
Reactive
Data
OutSystems 11
Development

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. 

0
0
on 4th Mar

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


Regards,

Marvei

0
0
on 4th Mar

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.


0
0
on 4th Mar

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


0
0
on 4th Mar
Tom Zhao
Champion

HI 

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

Kind regards,

0
0
on 4th Mar
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
0
0
on 5th Mar
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.