AmdConsortium

From Wiki

(Difference between revisions)
Jump to: navigation, search
Line 5: Line 5:
See the [http://www-genoret.u-strasbg.fr/genoret/AmdConsortium AMD Consortium Welcome Page]
See the [http://www-genoret.u-strasbg.fr/genoret/AmdConsortium AMD Consortium Welcome Page]
==Integration of the Phenotyping Data by Raymond 2007/12/12==
==Integration of the Phenotyping Data by Raymond 2007/12/12==
-
* Baltimore January version
+
 
 +
* '''Baltimore''' January version
# Betsy Campochiaro sent several Excel files corresponding to an Access database
# Betsy Campochiaro sent several Excel files corresponding to an Access database
# Creation of a ;csv file containing neaarby all fields pointed as secondary tables (Genoret Tcl program)
# Creation of a ;csv file containing neaarby all fields pointed as secondary tables (Genoret Tcl program)
Line 12: Line 13:
# Corrections and updates of small errors
# Corrections and updates of small errors
# Add ped to father_id and mother_id (not yet done)
# Add ped to father_id and mother_id (not yet done)
-
* Bonn
+
 
 +
* '''Bonn'''
# Direct connection to the Phenotyping Database in Tuebingen (2007-11)
# Direct connection to the Phenotyping Database in Tuebingen (2007-11)
# Save the display of all patients as .csv file
# Save the display of all patients as .csv file
Line 21: Line 23:
# Keep only the centre Bonn or the FamStudy (ok)
# Keep only the centre Bonn or the FamStudy (ok)
# Some values were stored as boolean and couldn't be displayed correctly (a small square). I replaced nul by NO and not null by YES
# Some values were stored as boolean and couldn't be displayed correctly (a small square). I replaced nul by NO and not null by YES
-
* Creteil
+
 
 +
* '''Creteil'''
# Eric Souied sent an Excel file
# Eric Souied sent an Excel file
# I removed birthdays and created a csvt table
# I removed birthdays and created a csvt table
* Paris CIC
* Paris CIC
# Isabelle Audo sent an Excel file
# Isabelle Audo sent an Excel file
-
* Jerusalem
+
 
 +
* '''Jerusalem'''
# Itay Chowers sent a new file 2007/12/24 and a .doc file db_codes
# Itay Chowers sent a new file 2007/12/24 and a .doc file db_codes
## I deleted all empty rows especially at the end
## I deleted all empty rows especially at the end
Line 37: Line 41:
## Obsolete It seems that only the 209 rows are meaningfull ???
## Obsolete It seems that only the 209 rows are meaningfull ???
## Obsolete what is the correspondance with the Quality Control ?
## Obsolete what is the correspondance with the Quality Control ?
-
* London
+
 
 +
* '''London'''
# I got the data from Andrew Webster as Excel file corresponding to his Access database.
# I got the data from Andrew Webster as Excel file corresponding to his Access database.
# I removed names and birthdates
# I removed names and birthdates
Line 43: Line 48:
# He created also a level1 database (as defiened by Tuebingen) with the data from Montpellier and Tuebingen.
# He created also a level1 database (as defiened by Tuebingen) with the data from Montpellier and Tuebingen.
# I'll extract the London data to create a csvt table (not yet done)
# I'll extract the London data to create a csvt table (not yet done)
-
* Southampton
+
 
 +
* '''Southampton'''
# Angela sent the .xls file
# Angela sent the .xls file
# Raymond upload it in AmdConsortium Gallery
# Raymond upload it in AmdConsortium Gallery

Revision as of 15:28, 29 December 2007

The AMD Consortium within EVI-Genoret Database

The Genoret Database aims to host all data for the Amd Consortium.

See the AMD Consortium Welcome Page

Integration of the Phenotyping Data by Raymond 2007/12/12

  • Baltimore January version
  1. Betsy Campochiaro sent several Excel files corresponding to an Access database
  2. Creation of a ;csv file containing neaarby all fields pointed as secondary tables (Genoret Tcl program)
  3. Integration of this file in the csvschema table csvt8
  4. Detection of errors with the Genoret Tcl program
  5. Corrections and updates of small errors
  6. Add ped to father_id and mother_id (not yet done)
  • Bonn
  1. Direct connection to the Phenotyping Database in Tuebingen (2007-11)
  2. Save the display of all patients as .csv file
  3. Integration of this file in the csvschema table csvt16
  4. They are 3 sub_table in our table ... the 3rd oe should be ok
  5. It seems that now a connection to Tuebingen gives only the 3rd table ...
  6. Keep only the year of birth (Genoret Tcl program)
  7. Keep only the centre Bonn or the FamStudy (ok)
  8. Some values were stored as boolean and couldn't be displayed correctly (a small square). I replaced nul by NO and not null by YES
  • Creteil
  1. Eric Souied sent an Excel file
  2. I removed birthdays and created a csvt table
  • Paris CIC
  1. Isabelle Audo sent an Excel file
  • Jerusalem
  1. Itay Chowers sent a new file 2007/12/24 and a .doc file db_codes
    1. I deleted all empty rows especially at the end
    2. and I added the missing empty columns in the rows at the end
    3. I got the db_codes and I'll introduce them very soon.
  2. Following lines are obsolete
    1. Obsolete Itay Chowers uploaded an Excel file
    2. Obsolete I created csvt with it but
    3. Obsolete a region of 55 rows in the Excel file was not at the right place ???
    4. Obsolete It seems that only the 209 rows are meaningfull ???
    5. Obsolete what is the correspondance with the Quality Control ?
  • London
  1. I got the data from Andrew Webster as Excel file corresponding to his Access database.
  2. I removed names and birthdates
  3. Guillaume created a local SQL database for these level2 data.
  4. He created also a level1 database (as defiened by Tuebingen) with the data from Montpellier and Tuebingen.
  5. I'll extract the London data to create a csvt table (not yet done)
  • Southampton
  1. Angela sent the .xls file
  2. Raymond upload it in AmdConsortium Gallery
  3. Open Excel
  4. Delete the 'nearly empty' columns on the right
  5. Rename the duplicated column Project no.2
  6. Save as .csv
  7. Integrate it as csvt27
  8. Modify birthday to keep only the year. And some dates were written as dd.mm.yy
Personal tools