Manual
- Ensure correct Namespace is selected (this is usually PV)
- Go to Ensemble → Configure → Data Lookup Tables
- Click Open and choose the appropriate Lookup
- Use the boxes at the right hand side to enter the key and the value
- Click Save
- Go to Ensemble → Configure → Production and start the Production
Automatic
Script ukrdc/ukrdc-scripts/scripts/ImportData.py
This script takes as an argument, a CSV file and merges the data in it to a HealthShare XML file of the same name.
The resultant XML file is then imported to HealthShare.
Limits:
- Only two HealthShare tables are handled: SURVEYUNITS or PRVOrder.
- The <filename>.csv is the same as the table name.
- Each CSV file contains two columns, the key and the entry, no header required.
Usage:
- Clone ukrdc/ukrdc-scripts
- Install python 3.5.
- create virtualenv in ukrdc-scripts/venv
- install requirements with pip install -r requirements.txt
- Create csv file for data to import
- Export table from HealthShare as XML to the ukrdc-scripts folder (Either SURVEYUNITS.xml or PRVOrder.xml).
- Run script:
python scripts/ImportData.py SURVEYUNITS.csv
or
python scripts/ImportData.py PRVOrder.csv - The XML file will have the data merged into it and should be imported back to HealthShare.