Changes between Version 6 and Version 7 of i2b2 HowTo Create a Project

Timestamp:

08/04/15 14:34:52 (9 years ago)

Author:

Richard Bramley

Comment:

--

i2b2 HowTo Create a Project

@@ -1 +1 @@
 = i2b2 - Create Project
+
+Tags: [[i2b2]] [[HowTo]]
 
 This is the procedure to create a new project in i2b2.  Most of the process is carried out by Jeff's create project scripts, but there is some preparation work that could perhaps be incorporated into the scripts at some point.
@@ -123 +125 @@
 === 4. Create the ontology
 
-Creating the ontology is beyond the scope of this page.  However, if you want to create the minimum required to stop an error when clicking the top-level node of the ontology, run the following SQL script:
+See: [[i2b2 HowTo Create an Ontology]]
 
-  {{{
-  #!sql
-
-  INSERT INTO {MetaData database name from [1]}.dbo.{Ontology table name from [2]}
-           ([C_HLEVEL]
-           ,[C_FULLNAME]
-           ,[C_NAME]
-           ,[C_SYNONYM_CD]
-           ,[C_VISUALATTRIBUTES]
-           ,[C_TOTALNUM]
-           ,[C_BASECODE]
-           ,[C_METADATAXML]
-           ,[C_FACTTABLECOLUMN]
-           ,[C_TABLENAME]
-           ,[C_COLUMNNAME]
-           ,[C_COLUMNDATATYPE]
-           ,[C_OPERATOR]
-           ,[C_DIMCODE]
-           ,[C_COMMENT]
-           ,[C_TOOLTIP]
-           ,[UPDATE_DATE]
-           ,[DOWNLOAD_DATE]
-           ,[IMPORT_DATE]
-           ,[SOURCESYSTEM_CD]
-           ,[VALUETYPE_CD])
-     VALUES
-           (0
-           ,'{Ontology root node name from [4]}'
-           ,'{Ontology description from [3]}'
-           ,'N'
-           ,'CA'
-           ,NULL
-           ,NULL
-           ,NULL
-           ,'concept_cd'
-           ,'concept_dimension'
-           ,'concept_path'
-           ,'N'
-           ,'LIKE'
-           ,'{Ontology root node name from [4]}'
-           ,NULL
-           ,'{Ontology description from [3]}'
-           ,GETDATE()
-           ,NULL
-           ,NULL
-           ,'{A suitable source perhaps Ontology description from [3]}'
-           ,NULL)
-GO
-
-  }}}
+[[BackLinks]]