Adding Data to Datasets

There are 2 ways you can add data to your datasets:

1. Inserting Single Records

2. Importing Data

Inserting Single Records

This method involves manually adding new records to the dataset, one at a time.

To do this:

• Open the dataset

• Click on the "Insert New Record" Button

• A row is added to your dataset

• In the added row, fill in the values for each field in the row:

  • Double clicking on the cell for the field you want to fill.

  • Enter a value, making sure that they match the data type and format specified for each field.

  • Press enter on your keyboard once done, for the cell value to be saved

  • Repeat the process for each field

• Your record will be saved once you have completed filling in each field in the row.

• The insert process is shown below

Inserting a single record

Importing Data

This method involves importing data from an external source, such as a spreadsheet or a database.

Currently, you can only import data from a CSV file so make sure your data has been exported to a CSV format.

To import data into your dataset:

• Open your dataset

• Click on the "Import Data" button

• In the view that appears, click on the "Choose A File" button and browse to the desired file on your local machine. You can also drag your CSV file to the drop area displayed.

Choose a file to import

It is important to note that the structure of the data stored in the CSV file MUST match the structure of your dataset.

Also, the column names in your CSV file must be in lower case and spaces replaced with an underscore (_)

• Click on "Import Data"

• If your CSV data matches the structure of your dataset, you should see a success message and all the new records appear in your dataset.