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. |