FREE OutSystems Workshops - Build an OutSystems App in 1 hour | ENROLL NOW

Tech Bites - How to import data from an excel file

< Back to Blog

In this video, we’ll show you how to upload and store data from an excel file.

First, it’s essential to check the columns of the excel file to match later those with the structure that’s going to hold the data.

Drag and drop the upload widget that you can find in the widget tree. Then set variables to store the file and the file name. 

Next, drag a button to process the upload. Double-click the button to link it to a new screen action. Here we will require a server action, so create one, name it, and add an input to receive the file. 

Then, drag an Excel To Record List node to the flow. This node receives the file and a record definition that should match the excel columns. Since the entity in which we want to store data has more attributes than the excel file, we must create a structure holding only the necessary attributes. 

Go to the entity, select all the relevant attributes and copy them. Afterwards, create the structure and paste the copied attributes into it.

Back to the flow, set the newly created structure as the record definition of the excel to record node. 

Then, drag a For Each node and set the excel records as the list to iterate through.

Use the entity’s record variable to convert the excel records to Raw data records by assigning each attribute. Use control D to get rid of the assigns that are not required.

 Finally, drag the create raw data entity action to create those records in the database.

Use the previously created server action in the screen action and add a feedback message if necessary. 

Let’s publish and test it in the browser.

Notice that there’s no data in the raw data entity yet. 

Once we upload the excel file and click the button, we get the feedback message and can now check the newly created raw data. 

There you go! I hope you enjoyed it!

Turn Up Academy

Apply to our Turn Up Boot Camp

AND BECOME THE NEXT OUTSYSTEMS CERTIFIED DEVELOPER
(
Senior Instructor
)

Latest Articles

Tech Bites - Set timers to delete records

Set timers to delete records

In this tech bite, we will demonstrate how to set timers to delete records and use an online store as an example.

Tech Bites
Tech Bites - How to import data from an excel file

How to import data from an excel file

In this video, we’ll show you how to upload and store data from an excel file.

Tech Bites
Tech Bites - How to run aggregates for each table row

How to run aggregates for each table row

In some situations, we need to show specific data in a table row or a list item that might not be directly related to the data we are using on the aggregate.

Tech Bites