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 - Should we validate form data on server-side?

Should we validate form data on server-side

When including forms in applications, developers often wonder if they need to re-validate data on the server side after having checked it on the client. Why go to the trouble of checking the data twice?

Tech Bites
The Top 5 Mistakes Handling Asynchronous Data In Outsystems Reactive Apps And How To Avoid Them

The Top 5 Mistakes Handling Asynchronous Data In Outsystems Reactive Apps

When developing an OutSystems reactive web app, you would expect to display data quickly, but it doesn't always happen. Do you know why? We'll explore the reasons and how to tackle them.

DevZone
Tech Bites - How to use Screen templates

How to use Screen templates

Did you know that the OutSystems Platform has tens of screen templates to help you quickly put together your apps? Let me show you how you can use them.

Tech Bites