Regions are geographic boundaries, currently used in mSupply to help in displaying data on maps. At the moment they are only used in certain customisations but more use of them will follow as development progresses.
The first row of the spreadsheet is for the column headers and is not imported.
There must be 3 columns in the spreadsheet in the order shown in the following table:
Column number | Column letter | Field | Description |
---|---|---|---|
1 | A | Region name | Mandatory. 255 alphanumeric characters. The name of the region |
2 | B | Geometry | Optional. Lots of alphanumeric characters. The JSON geometry definition of the region. If it is entered then it must be valid according to the geoJSON FeatureCollection schema. |
3 | C | Parent | Optional. 255 alphanumeric characters. The name of this region's parent region. |
Here is an example spreadsheet you can use: region_import_blank_template.xlsx
Choose File > Import > Import regions from the menus and you will be asked to select the import file from a file window. After you have selected the file (if it is valid) you will be shown this window:
mSupply uses the Region field to determine whether the region being imported is a duplicate; a region with the name as one already in the database is determined to be a duplicate. In the If a duplicate is detected section you tell mSupply what to do if it encounters a duplicate region during the import:
The Value column shows the values mSupply has found in the cells for that row of the spreadsheet. You can move through the rows of the spreadsheet using the Previous and Next buttons. If you try to go beyond the first or last row of the spreadsheet mSupply will let you know.
You can carry out the import by clicking on the Import now button or cancel it by clicking on the Cancel button.
During the import:
When the import has finished you will be shown a message telling you how many assets were imported and how many rows of the spreadsheet were skipped.
Previous: 17.09. Importing assets | | Next: 17.11. Importing requisitions |