= i2b2 HowTo Import DM+D Data

Tags: [[i2b2]] [[HowTo]]

1. Download DM+D File from the [https://isd.hscic.gov.uk/trud3/user/guest/group/0/pack/6 HSCIC].
1. Copy the zip file into {{{V:\IT projects\DataLoads\DMD\History}}} folder.
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:
 a. f_vtm2_{date}.xml -> vtm_drugs.xml
 a. f_vmp2_{date}.xml -> vmp_virtual_products.xml
 a. f_vmpp2_{date}.xml -> vmpp_virtual_packs.xml
 a. f_amp2_{date}.xml -> amp_actual_products.xml
 a. f_ampp2_{date}.xml -> ampp_actual_packs.xml
1. Open the i2b2ClinicalDataLoad application in visual studio.
1. Run the package DMDLoad.dtsx.
1. The package loads the into the {{{DM+D}}} database on the UHLSQLPRIME01\UHLBRICCSDB server.

Things to note:

* 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.
* 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}}}
 
[[BackLinks]]