Changes between Version 5 and Version 6 of StoryConvertPhenoData
- Timestamp:
- 2011-11-29T14:25:09+01:00 (13 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
StoryConvertPhenoData
v5 v6 13 13 * Make an SSH tunnel using the command: ssh -L 2000:orawise01.target.rug.nl:15300 username@vm7.target.rug.nl 14 14 * Go to Add Connections, hit the + sign, Hostname = localhost, Port = 2000, Service Name = llpacc / llptest / llp, Username = molgenis, Password = <ask Joris, Robert or Erik> 15 * Connect to one of the databases (prod, acc, test), go to Other Users, go to LLPOPER User, go to Views, select them all and export them to CSV15 * Connect to one of the databases (prod, acc, test), go to Other Users, go to LLPOPER User, go to Views, select them all except VW_BEP_OMSCHR and VW_DICT_HULP, and export them to CSV (separate files) 16 16 * Now you have the CSV files that form the input of the convertor 17 17 * VW_DICT_DATA.csv contains all the protocols and measurements 18 18 * Convertor code is in molgenis_apps/Apps/lifelinespheno, build script is build_lifelines.xml (in project root) 19 * Change the path to the CSV files (first line of !ImportMapper.java in package lifelinespheno.org.molgenis.lifelines) 20 * Run the convertor 19 * Uncomment !ImportMapper.java and all four Java files in 'listeners' package. 20 * Change the path to the CSV files (line 46 of !ImportMapper.java in package lifelinespheno.org.molgenis.lifelines) 21 * Run the convertor as Java application 21 22 22 23 To-do's / issues:
