Blueprints - CSV to DHIS2
- Juan J Flamenco
Data elements
Column | Required | Value (default first) | Description |
Name | Yes | Â | Name. Max 230 char. Unique. |
UID | No | UID | Stable identifier. Exactly 11 alpha-numeric characters, beginning with a character. Will be generated by system if not specified. |
Code | No | Â | Stable code. Max 50 char. |
Short name | No | 50 First characters of the name | Will fall back to first 50 characters of name if unspecified. Max 50 char. Unique. |
Description | No | Â | Free text description. |
Form name | No | Â | Max 230 char. |
Domain type | No | AGGREGATE | TRACKER | Domain type for data element, can be aggregate or tracker. Max 16 char. |
Value type | No | INTEGER | NUMBER | UNIT_INTERVAL | PERCENTAGE | INTEGER_POSITIVE | INTEGER_NEGATIVE | INTEGER_ZERO_OR_POSITIVE | FILE_RESOURCE | COORDINATE |TEXT | LONG_TEXT | LETTER | PHONE_NUMBER | EMAIL | BOOLEAN | TRUE_ONLY | DATE | DATETIME | Value type. Max 16 char. |
Aggregation operator | No | SUM | AVERAGE | AVERAGE_SUM_ORG_UNIT | COUNT | STDDEV | VARIANCE | MIN | MAX | NONE | Operator indicating how to aggregate data in the time dimension. Max 16 char. |
Category combination UID | No | UID | UID of category combination. Will default to default category combination if not specified. |
Url | No | Â | URL to data element resource. Max 255 char. |
Zero is significant | No | false | true | Indicates whether zero values will be stored for this data element. |
Option set | No | UID | UID of option set to use for data. |
Comment option set | No | UID | UID of option set to use for comments. |
Organisation Units
Column | Required | Value (default first) | Description |
|---|---|---|---|
Name | Yes | Â | Name. Max 230 characters. Unique. |
UID | No | UID | Stable identifier. Max 11 char. Will be generated by system if not specified. |
Code | No | Â | Stable code. Max 50 char. |
Parent UID | No | UID | UID of parent organisation unit. |
Short name | No | 50 first char of name | Will fall back to first 50 characters of name if unspecified. Max 50 characters. Unique. |
Description | No | Â | Free text description. |
Opening date | No | ####### | Opening date of organisation unit in YYYY-MM-DD format. |
Closed date | No | Â | Closed date of organisation unit in YYYY-MM-DD format, skip if currently open. |
Comment | No | Â | Free text comment for organisation unit. |
Feature type | No | NONE | MULTI_POLYGON | POLYGON | POINT | SYMBOL | Geospatial feature type. |
Coordinates | No | Â | Coordinates used for geospatial analysis in Geo JSON format. |
URL | No | Â | URL to organisation unit resource. Max 255 char. |
Contact person | No | Â | Contact person for organisation unit. Max 255 char. |
Address | No | Â | Address for organisation unit. Max 255 char. |
No | Â | Email for organisation unit. Max 150 char. | |
Phone number | No | Â | Phone number for organisation unit. Max 150 char. |
Option sets and Options
Column | Required | Value (default first) | Description |
|---|---|---|---|
OptionSetName | Yes | Â | Name. Max 230 characters. Unique. Should be repeated for each option. |
OptionSetUID | No | UID | Stable identifier. Max 11 char. Will be generated by system if not specified. Should be repeated for each option. |
OptionSetCode | No | Â | Stable code. Max 50 char. Should be repeated for each option. |
OptionName | Yes | Â | Option name. Max 230 characters. |
OptionUID | No | UID | Stable identifier. Max 11 char. Will be generated by system if not specified. |
OptionCode | Yes | Â | Stable code. Max 50 char. |