AmdConsortium

From Wiki

Revision as of 08:45, 14 December 2007 (edit) Ripp (Talk | contribs) ← Previous diff		Revision as of 10:23, 17 December 2007 (edit) (undo) Ripp (Talk | contribs) Next diff →
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 .. they are some unstandard dates	+	# 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

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

1. I got the data from Andrew Webster as Ecel fiels 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