OpenCRVS
OpenCRVS Docs 1.1
Search…
⌃K
Links

3.2.3.1 Prepare source file for CRVS Office facilities

Prepare your crvs-facilities source file. This is a csv file for every civil registration office in your country. You can import and create csv files in Excel or Google Drive.
Using our Farajaland crvs-facilities.csv file as an example, update it with the CRVS Office information for your country - do not move the file from this location. Our crvs-facilities.csv file looks like this:
statisticalID
name
partOf
code
physicalType
district
state
2OKicPQMNI
HQ Office
Location/HPGiE9Jjh2r
CRVS_OFFICE
Building
Isamba District
Central Province
JEhYJ82xRI
Isamba District Office
Location/HPGiE9Jjh2r
CRVS_OFFICE
Building
Isamba District
Central Province
JWMRGwDBXK
Ibombo District Office
Location/oEBf29y8JP8
CRVS_OFFICE
Building
Ibombo District
Central Province
Each row will represent a unique "CRVS Office" in your country.
Do not change or re-format the header row as the code requires these names to be precise in order to parse the csv. Do not use commas in any cell and do not have any empty rows.
The statisticalID column is a unique identifier for each office. This could be a unique identifier you already use or alternatively you could create unique identifiers programatically, using Excel or using an online UUID generator website for which there are many free ones available. It is important to note that the statisticalID must contain no spaces, special characters or commas
The name column contains the human readable name for the office. We do not currently support multilingual names for the office. It is important to note that the name must contain no commas
The partOf column shows that the office is part of a higher level administrative division. Notice how we use the districts' statisticalID to set the office as a child of a particular parent district. For example HQ Office district is a child of Isamba district thanks to this partOf value. Perhaps you may also recognise that these form part of FHIR Reference URLs hence the requirement for them to be absent of spaces and special characters:
Location/HPGiE9Jjh2
  • The code column must be set to CRVS_OFFICE
  • The physicalType column must be set to Building
  • The district and state columns are human readable information that populates part of the office address. It appears to the system administrator only at this time to help the user understand which office they are currently managing employees for.
This CSV is converted into JSON during the import process. It is very important that there are no empty extra lines in the csv document as the script will attempt to import empty states. Any commas are treated as separators between data. This is how a csv works. So there must be no commas in any data field.
​