Changes between Version 2 and Version 3 of StoryConvertPhenoData

Timestamp:

2011-11-28T15:02:41+01:00 (13 years ago)

Author:

Erik Roos

Comment:

--

StoryConvertPhenoData

@@ -4 +4 @@
 Scrum: ticket:1067
 
+How to demo:
+
 Acceptance criteria:
 
-Status:
+Instructions:
+* Install Oracle SQL Developer using jorislops@gmail.com's account, or make your own
+* Adjust date settings (tools -> preferences -> database -> NLS) to YYYY-MM-DD and time settings to YYYY-MM-DD HH.MI.SSXFF AM TZR
+* Make an SSH tunnel using the command: ssh -L 2000:orawise01.target.rug.nl:15300 username@vm7.target.rug.nl
+* Go to Add Connections, hit the + sign, Hostname = localhost, Port = 2000, Service Name = llpacc / llptest / llp, Username = molgenis, Password = <ask Joris, Robert or Erik>
+* 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 CSV
+* Now you have the CSV files that form the input of the convertor
+* VW_DICT_DATA.csv contains all the protocols and measurements
+* Convertor code is in molgenis_apps/Apps/lifelinespheno, build script is build_lifelines.xml (in project root)
+* Change the path to the CSV files (first line of ImportMapper.java in package lifelinespheno.org.molgenis.lifelines)
+* Run the convertor
 
 To-do's:
@@ -29 +41 @@
  * Last but not least, Test if data is loaded correctly (Test from Anco).
  * We should make sure that the data is always loaded into the right format (this means that it always end up the right way in database).
- * We should make sure that the data is always loaded into the right format (this means that it always end up the right way in database).