To import from SMS (Student Management System), first you need to do the External Database Configuration.

Go to the Database in the Database Menu and click External Database. There will be another drop down menu and click the External DB Configurations.

Diagram 2.3.1 Location of the External DB Configurations

External Database Configurations Window will appear.

Diagram 2.3.2 External Database Configurations Window

After done filling the slots, click Test Configuration  button. 

A pop-up message will appear, stating that it has been successful.

Diagram 2.3.3 Pop-up Success

Warning! If you fill incorrectly, an error to the test connection pop-up will appear.

After done with External Database Configuration, you need to do the Data Mapping. Data Mapping is important in creating the database.

To open the Data Mapping, go to the Database on the Database Menu and select External Database. Another drop down menu will appear and select Data Mapping.

Diagram 2.3.4 Location of the Data Mapping

Data Mapping window will appear.

Diagram 2.3.5 Data Mapping Window

But you will also be able to import your own configurations and data mapping to the database.

All you have to do is go to the Database on Database Menu and select External Database. Another drop down menu will show up and click on Import Configurations and Mappings.

Diagram 2.3.6 Location of the Import Configurations and Mapping

A window pop-up will show up. You can choose the file that you want to import. Note that the file must be in .xml extension. Click Open.

Diagram 2.3.7 Import Configurations and Mappings Pop-up

Once successful, a pop-up will appear showing it has been successful.

Diagram 2.3.8 Pop-up Success

To import the database, you need to go to the Database on Database Menu and select View Database.

Diagram 2.3.9 Location of View Database

Diagram 2.3.10 Location of Import Database in View Database

Once you click Import Database , a pop-up window will appear.

Diagram 2.3.11 Import data from SMS Pop-up Window

You may choose the data to include in operation and click Ok afterwards. 

Once you click okay, a pop-up will appear showing it has been successful.

Diagram 2.3.12 Successful Pop-up

After done with import, you may view your database on the same View Database Window.

Diagram 2.3.13 View Database