Hello,

I have been trying to bootstrap an excel file to a Bookings Entity, which has a RoomId and StatusId associated.
As such I included in the excel file the columns for those two identifiers, passing an integer according to the correct Id of the room/ status I wanted to record. However, I get an empty slot when the bootstrap is verifying the columns, even though the value on the excel has been defined as a number.

Thanks for your help.

Nagesh Gupta wrote:

Hello,

I have been trying to bootstrap an excel file to a Bookings Entity, which has a RoomId and StatusId associated.
As such I included in the excel file the columns for those two identifiers, passing an integer according to the correct Id of the room/ status I wanted to record. However, I get an empty slot when the bootstrap is verifying the columns, even though the value on the excel has been defined as a number.

Thanks for your help.

Hi Nagesh,

Have a look at these posts for solutions to your issue:

https://www.outsystems.com/forums/discussion/36862/bootstrap-data-from-excel/

https://www.outsystems.com/forums/discussion/34133/excel-import-and-add-a-foreign-key/

Kind regards,

Nordin



Hi Nagesh Gupta!

The column names in Excel need to have exactly the same name and type than the attributes of your Entity. In other case, bootstrap won't work.

Best Regards,

Nuno Pereira

Nagesh Gupta wrote:

Hello,

I have been trying to bootstrap an excel file to a Bookings Entity, which has a RoomId and StatusId associated.
As such I included in the excel file the columns for those two identifiers, passing an integer according to the correct Id of the room/ status I wanted to record. However, I get an empty slot when the bootstrap is verifying the columns, even though the value on the excel has been defined as a number.

Thanks for your help.


Have you tried Debug?