need to display data from an excel into the ui

Hi everyone,

my current entity structure includes the below sample data . while  trying to push custom data using excel, the data is not getting imported


Process being followed for importing data 



the execel file i am reffering to - 


Hi,

While importing data from excel there are 2 points which we need to consider : 

1. Name of the column must be same in excel as they are in database entity. OR

2. Number of columns must be same in excel and database entity. So OutSystems will map according to number of columns by ignore the column name. 

Also you need to check datatype.

Regards


Hi Saif,

Please check Bootstrap server action, It only imports the data if there is no data in entity.


Thanks

Vinod

Hello @saif sheikh,

For this you have to create custom bootstrap action and need to create structure that contains columns same as in excel sheet. Ex.

and logic will be like-

Also as per your entity if you need to assign that system users and Static entity references you need to do that manually/separately.


Regards,

Narendra Bhangale.

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