Changes between Version 11 and Version 12 of DespoinaLog/2010/12/09

Timestamp:

2010-12-09T15:49:01+01:00 (13 years ago)

Author:

antonak

Comment:

--

DespoinaLog/2010/12/09

@@ -7 +7 @@
  * create new table biobank from pheno project as follows:
 
-  mysql> create  table biobank_new select Acronym, Category, Type, Size, !LastUpdate       , Description, id from biobank ;
+  mysql> create  table biobank_new select Acronym, Category, Type, Size, !LastUpdate        , Description, id from biobank ;
 
   (only fields that exist in biobank in gcc project)
@@ -28 +28 @@
 '''!ObservationElement''' ON (Biobank.id = !ObservationElement.id) LEFT JOIN
 
-  '''    Investigation'''     AS xref_Investigation  ON xref_Investigation.id = !ObservationElement    .Investigation LEFT JOIN
+  '''     Investigation'''      AS xref_Investigation  ON xref_Investigation.id = !ObservationElement     .Investigation LEFT JOIN
 
 '''!OntologyTerm''' AS xref_ontologyReference  ON xref_ontologyReference.id = !ObservationElement.ontologyReference LEFT JOIN
@@ -44 +44 @@
 Name    Type    Acronym category_term   topics_term     institutes_name contacts_lastName       size    materials_term  GWA data n =    GWA platform    GWA comments    description
 }}}
-try to import as it is : 
+try to import as it is :
 
-Need to removes characters like , ( ) ; + . Comma and parenthesis  was replaced by or ; by some spaces and plus by plus. OntologyTerm term was replaced by name .
+Need to removes characters like , ( ) ; + . Comma and parenthesis  was replaced by or ; by some spaces and plus by plus. OntologyTerm term was replaced by name .
 
-After uploading : error  : '''Column '!PanelType' cannot be null'''
+After uploading : error  : '''Column '!PanelType' cannot be null'''
 
 two new columns added :
@@ -55 +55 @@
 || !OntologyTerm || PanelType ||
 
+still error with '''Column '!PanelType' cannot be null'''
 
+=== `After these changes import worked :  ===
+Added new tabs: !ObservationElement (column name), investigation (column name), New columns at !ObservedValue : investigation_name      feature_name    target_name, and new columns at !ObservedFeature : investigation_name   feature_name    target_name
 
-still error with '''Column '!PanelType' cannot be null'''
+name    name    name, Biobank also needed new columns : paneltype_name  category_name   investigation_name
 
- 
+less that 50 year       less that 50 year       name . 
+
+The xls could not be imported with characters like comma (,) , parenthesis ( ()) , + ,