Skip to Content (Press Enter)
2026-02-24 09-32-11
RUDO MURIEL MUNYAVI
586Views
2Comments
Solved
How to bootstrap data/ import excel data
Question

Hi. Pls assist i am trying to bootstrap data from an excel sheet with about 200 records. The records do not match.

Where am i missing it. I also want to upload the Identifier in the excel sheet so on the entity i set identifier so that it is not auto generated.

Screenshots attached

Capture2.PNG
0
0
01 Sep 2020
Copy Link
2022-10-16 15-30-09
Miguel Chaparra
Solution

Hi Rudo,


Firstly, you need to validate the Excel file:

  1. Open the Excel file, check that the Excel sheet has the name of the Entity and the column headers have the names of the entity attributes.

  2. Close the Excel file. The bootstrap can't read the Excel file if it's open.


The problem in your case is that your excel headers don't match with the entity's attributes because excel header have spaces between each word. Remove the spaces between words like this:


Try to bootstrap again and you will see the following:

Now only the id is missing. When you hover your mouse, you will find why:

So change the type of your id to an integer, if you want to, you can change it back to long integer later on.



Hope it helps,


Regards,

Miguel Chaparra

See solution in context
1
0
01 Sep 2020
Copy Link
2024-01-09 14-27-21
Tomás Dionísio

Hello RUDO MURIEL MUNYAVI,

I think this documentation can help you solve the issue.

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

Please make sure that your attribute's datatypes match your excel values.


Give it a try! ;)


Regards,

Tomás

0
0
01 Sep 2020
Copy Link
2022-10-16 15-30-09
Miguel Chaparra
Solution

Hi Rudo,


Firstly, you need to validate the Excel file:

  1. Open the Excel file, check that the Excel sheet has the name of the Entity and the column headers have the names of the entity attributes.

  2. Close the Excel file. The bootstrap can't read the Excel file if it's open.


The problem in your case is that your excel headers don't match with the entity's attributes because excel header have spaces between each word. Remove the spaces between words like this:


Try to bootstrap again and you will see the following:

Now only the id is missing. When you hover your mouse, you will find why:

So change the type of your id to an integer, if you want to, you can change it back to long integer later on.



Hope it helps,


Regards,

Miguel Chaparra

1
0
01 Sep 2020
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.