Import and Export
Export a pedigree as a CSV file
1. Enter the pedigree that will be exported
The following pedigree shall be exported as a CSV file:
Pre-requisites
Launch PED.
- Adjust colors: Input Window -> Colors -> ...
- Edit Input Labels: Window -> Edit Input Labels
- You don't have to - just to give you an idea: In Edit Window (Ctrl+W), open
the phenotypes template, and edit the symbol labels (for details
see the how-to resources). Save as PED file.
In Windows Explorer, rename PED to PHN, and import these
phenotypes (Switch to input mode, menu Phenotype -> New Symbols ... )
By now you should know how to draw the pedigree at top of this page. In short: In Input window (Ctrl+Q), start a new pedigree (Input Window - Clear), press the Son, Daughter, and Ancestor button, and select the appropriate symbols from the Phenotype menu. Right click at the male consultand, and enter the values displayed in the pedigree above.
2. Export the pedigree from above
Press the Export button, select CSV, and press Save:
In the dialog that opens, edit the fields in the group panes numbered 1 to 6:
- Enter a family name or ID:
Not recommended, but still in use: Write family ID and personal ID, separated by "-", in a single column. If you want to, check the second box. - The next columns are not editable:
- Do you want the number of the phenotype (= symbol) in the phenotype menu ?
In a linkage file, only 0, 1, and 2 are allowed. For a CSV file, you can use all numbers from the phenotype menu.
- If you right click on a symbol, you can add some decoration, like an arrow, or draw a line across a symbol
(deceased). You can export this as a number, where "1" means "has an arrow", "2" is "deceased",
and so on. If you later re-import this CSV file, all decoration will be restored.
- You can have up to four labels surrounding the symbol. These will be the contents of the next columns:
- There are also up to 18 rows /1 - 2 columns of text below the symbol. Normally your pedigree
should not have more than 4 - 6 rows of text below the symbol. More important: Did you always
use a single column of text below the symbol ? For CSV files a single column is recommended.
- Should the columns have headers (that is, column names)? If you want to export each pedigree in an
extra file, this would probably be the best. Use comma or tab as column separator, and better do not
use text identifiers, until you really need them.
- You can restore the defaults for a CSV file output:
If you accepted the defaults (as you usually should do), press OK, and save the output:
3. Test your results
A double click at the file may open it in MS Excel:
You can open it in OpenOffice.org Calc:
In OpenOffice.org Calc there is a one page import wizard:
This will give you the same result:
