AmdConsortium
From Wiki
(Difference between revisions)
Line 27: | Line 27: | ||
# 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 | ||
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
- 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 (2007-11)
- Save the display of all patients as .csv file
- Integration of this file in the csvschema table csvt16
- They are 3 sub_table in our table ... the 3rd oe should be ok
- It seems that now a connection to Tuebingen gives only the 3rd table ...
- Keep only the year of birth (Genoret Tcl program)
- 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
- Creteil
- Eric Souied sent an Excel file
- I removed birthdays and created a csvt table
- Paris CIC
- Isabelle Audo sent an Excel file
- Jerusalem
- Itay Chowers sent a new file 2007/12/24 and a .doc file db_codes
- I deleted all empty rows especially at the end
- and I added the missing empty columns in the rows at the end
- I got the db_codes and I'll introduce them very soon.
- Following lines are obsolete
- Obsolete Itay Chowers uploaded an Excel file
- Obsolete I created csvt with it but
- Obsolete a region of 55 rows in the Excel file was not at the right place ???
- Obsolete It seems that only the 209 rows are meaningfull ???
- Obsolete what is the correspondance with the Quality Control ?
- London
- I got the data from Andrew Webster as Excel file 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