...
- 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.Export the Lookup as an XML file
- Use https://bitbucket.renalregistry.nhs.uk/projects/UKRDC/repos/ukrdc-scripts/browse/scripts/ImportData.py to update it with values contained in a CSV file.
- Ensure you are in the correct Namespace (this is usually PV)
- Go to Ensemble → Configure → Data Lookup Tables
- Click Import then select "Local Computer"
- Click Browse and select the XML file
- Click Open
See Enabling New Test Results for details of PV schema changes