It's easy to get started with OutSystems Platform. If you have an Excel file with your data, you can import it into a database and quickly create an enterprise-grade app manage your data.

To create an app with data imported from an Excel file, you need to:

Let's do this! In this example we'll use an Excel file with employee information, and create a simple employee management app.

1. Create an App

We'll be creating a new app to store employees. An application doesn't do anything by itself, you need to add modules to your app. A module is where you design the data model, implement the logic, and design the UI of your apps.

In OutSystems Platform IDE, create a new application called "EmployeePortal", and then add a new module to it.

2. Create a Database Table from an Excel File

OutSystems Platform stores your application data in a relational database. This means that the first step in creating an app, is defining its data model.

We already have an Excel file containing employee information like:

On the 'Data' layer at your right-hand side, right-click the 'Entities' folder, and choose 'Import Entities from Excel'.

When importing an Excel file, OutSystems Platform creates a database table (an Entity in OutSystems lingo), with the necessary columns (Attributes in OutSystems lingo) to be able to store the data in the database.

Behind the scenes, OutSystems Platform also creates logic to import each row in the Excel file into a database record. So after publishing your application, that logic runs automatically, and you get your database populated with the data that is on the Excel file.

3. Create a Screen to List Records

Now that we have contacts stored on the database, we can create a screen that lists all the contacts.

Drag a List Screen to the screen flow, and choose the Contact entity.

A new screen is created, with a header, menu, and footer. The screen also contains a list that displays 50 records at a time, and has pagination and search functionality.

4. Create a Screen to Create and Edit Records

Creating a screen to create and edit records, is as easy as creating a list screen. Drag a Detail Screen into a screen flow and choose the ‘Employee’ entity from the list.

A new screen is created, with a header, menu, footer, and a form to create new records or edit existing ones. The server-side logic to create and edit records is also created for you.

5. Allow Deleting Records

To implement a full CRUD app, we are just missing the delete functionality. Let's implement that!

On the detail screen:, at the right of the Cancel button:

  1. Drag a button to the right of the Cancel button;
  2. Right-click on it and choose 'Link to New Delete Screen Action'.

OutSystems Platform creates server-side logic to delete the employee record, and a link to invoke that logic.

6. Publish Your App

Now we just need to make the app go live. Click the 1-Click Publish button to publish your application to your environment on the cloud.

When the application is deployed, click the Open in Browser button to test your application in a browser.

The application is accessible at http://<environment url>/<module name>

Want to Learn More?

You've just created a simple contact management app, but things don't end here. We could extend the app to allow storing more phone numbers for a single contact, adding photos, or even fetch information from REST APIs.

If you want to continue learning, go check the Online Training. It's a good starting point to learn how to develop with OutSystems Platform.

See Also

Workspace Overview