...
Spreadsheets are imported based on "Spreadsheet Import Templates." These templates specify the columns and prespecified pre-specified values that are present in the given spreadsheet.
Columns are the actual data elements from the spreadsheet (database columns) that are imported into the OpenMRS database.
Prespecified Pre-specified values can be illustrated with a simple example. Let us assume that one of the columns in a spreadsheet is an Obs Value Numeric - an observed numeric value. According to the design of the OpenMRS databasedata model, in order to create a new row in the obs table, two columns which are linked to other tables must be specified. Specifically, a person for whom this is an observation, and a concept describing the exact type of observation, must be specified.
Note that if another column, like such as "Person: Birthdate," is present in the template, the spreadsheetimport module Spreadsheet Import Module will not require the specification of a person to create an observation. Rather, it will link the observation to the person created with the corresponding birthdatedate of birth. If you also have a, for example, a "Person Name: Given Name" column, the given name created will also reference the correct person.
...