AmdConsortium

From Wiki

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
2. Save the display of all patients as .csv file
3. Integration of this file in the csvschema table csvt16
4. Keep only the year of birth (Genoret Tcl program)
5. Keep only the centre Bonn or the FamStudy (not yet done)

• Creteil
• Paris CIC
• Jerusalem
• London
• 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 .. they are some unstandard dates