Changes between Version 2 and Version 3 of i2b2 HowTo Create a Project

Timestamp:

07/16/13 09:37:11 (12 years ago)

Author:

Richard Bramley

Comment:

--

i2b2 HowTo Create a Project

@@ -72 +72 @@
   * import.projectID
 
-iii. In the same directory, edit the file defaults.sh.
+iii. Edit the file config/defaults.sh.
 
 The following values need amending:
@@ -86 +86 @@
   * JAVA_HOME
 
+iiii. Edit the following SQL scripts in the following ways:
+
+  * sql/sqlserver/meta/tables/create_sqlserver_metadata_tables.sql
+   * Remove the creation of BIRN table.
+   * Rename the ONYX table to something appropriate to the new project's ontology. [1]
+
+  * sql/sqlserver/meta/inserts/schemes_insert_data.sql
+   * Edit the values for C_KEY, C_NAME and C_DESCRIPTION [2]
+
+  * sql/sqlserver/meta/inserts/table_access_insert_data.sql
+   * Use the ontology table name (from [1]) for C_TABLE_CD and C_TABLE_NAME.
+   * Give the ontology a root node name and use it for C_HLEVEL and C_DIMCODE. [3]
+   * Use the ontology description (from [2] C_DESCRIPTION) for the C_FULLNAME and C_TOOLTIP.
+
+  * sql/sqlserver/work/inserts/workplace_access_insert_data.sql
+   * Change the C_TABLE_CD for both records to the project name.