AmdConsortium
From Wiki
(Difference between revisions)
Line 22: | Line 22: | ||
* Jerusalem | * Jerusalem | ||
* London | * London | ||
+ | # I got the data from Andrew Webster as Ecel fiels corresponding to his Access database. | ||
+ | # I removed names and birthdates | ||
+ | # Guillaume created a local SQL database for these level2 data. | ||
+ | # 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) | ||
* Southampton | * Southampton | ||
# Angela sent the .xls file | # Angela sent the .xls file | ||
Line 30: | Line 35: | ||
# Save as .csv | # Save as .csv | ||
# Integrate it as csvt27 | # Integrate it as csvt27 | ||
- | # Modify birthday to keep only the year . | + | # Modify birthday to keep only the year. And some dates were written as dd.mm.yy |
Revision as of 10:23, 17 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
- 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)
- Integration of this file in the csvschema table csvt8
- Detection of errors with the Genoret Tcl program
- Corrections and updates of small errors
- Add ped to father_id and mother_id (not yet done)
- Bonn
- Direct connection to the Phenotyping Database in Tuebingen
- Save the display of all patients as .csv file
- Integration of this file in the csvschema table csvt16
- Keep only the year of birth (Genoret Tcl program)
- Keep only the centre Bonn or the FamStudy (not yet done)
- Creteil
- Paris CIC
- Jerusalem
- London
- I got the data from Andrew Webster as Ecel fiels corresponding to his Access database.
- I removed names and birthdates
- Guillaume created a local SQL database for these level2 data.
- 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)
- Southampton
- Angela sent the .xls file
- Raymond upload it in AmdConsortium Gallery
- Open Excel
- Delete the 'nearly empty' columns on the right
- Rename the duplicated column Project no.2
- Save as .csv
- Integrate it as csvt27
- Modify birthday to keep only the year. And some dates were written as dd.mm.yy