| | 1 | = Import DM+D Data |
| | 2 | |
| | 3 | 1. Download DM+D File from the [https://isd.hscic.gov.uk/trud3/user/guest/group/0/pack/6 HSCIC]. |
| | 4 | 1. Copy the zip file into {{{V:\IT projects\DataLoads\DMD\History}}} folder. |
| | 5 | 1. Unzip the files and replace the files in {{{V:\IT projects\DataLoads\DMD\Data}}} with the ones from the extracted zip. The files will need renaming: |
| | 6 | a. f_vtm2_{date}.xml -> vtm_drugs.xml |
| | 7 | a. f_vmp2_{date}.xml -> vmp_virtual_products.xml |
| | 8 | a. f_vmpp2_{date}.xml -> vmpp_virtual_packs.xml |
| | 9 | a. f_amp2_{date}.xml -> amp_actual_products.xml |
| | 10 | a. f_ampp2_{date}.xml -> ampp_actual_packs.xml |
| | 11 | 1. Open the i2b2ClinicalDataLoad application in visual studio. |
| | 12 | 1. Run the package DMDLoad.dtsx. |
| | 13 | 1. The package loads the into the {{{DM+D}}} database on the BRICCSDB server. |
| | 14 | |
| | 15 | Things to note: |
| | 16 | |
| | 17 | * The package cannot be copied to the server and scheduled as it cannot then see the network drive to load the data. Hopefully this can be sorted out. |
| | 18 | * The XSDs for the XML files are stored in the {{{V:\IT projects\DataLoads\DMD\Definitions}}} directory. These are the same as the ones provided in the ZIP file downloaded from HSCIC, but with the ID fields converted from a data type of {{{xs:integer}}} to {{{xs:unsignedLong}}} |
| | 19 | |
