need to display data from an excel into the ui

Question

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 -

01 Jun

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

01 Jun

Champion

Hello Saif,

Please go through with the below link.

Thanks & Kind Regards,

Sachin

01 Jun

Hi Saif,

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

Thanks

Vinod

01 Jun

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.

01 Jun

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