Importing Data

To load data, choose File|Open, then select your import file. The file needs to be a text/CSV file - the kind of file that you might export from a spreadsheet - but which can also be produced by many database and pedigree programs.

You are then taken through a series of windows that let you set options to control the way PedScope processes the import file. Note that in many cases there will be few if any of these settings that you need to change, because PedScope inspects the data file and chooses sensible defaults for the file format and its contents.

NOTE: To see some examples of acceptable import data see: Import Examples.

Character Encoding

The Character Encoding window selects the character set encoding and line ending format. If the options presented here don't mean anything to you, don't worry because in practice you are very unlikely to need to change these settings. If in doubt simply click Next (Mac: click Continue) to proceed.

The character set defines how the bytes in the file are encoded, such as UTF or ISO-8859-1. The line ending format says whether input lines are terminated by carriage return, line feed, or both.

Column Formatting

The Column Formatting window controls the way that the columns are formatted in the file. This is where you choose whether the file is comma or TAB separated, whether there is a header line, and whether column values are quoted. Again, it is unlikely you will need to change anything here. Typically you just need to click Next (Mac: click Continue) to proceed.

Columns

The Columns window is where you define the meaning of each import column - i.e. where the name, sex, sire etc. are to be found in the input data. It is more likely that you will need to alter the settings here than in the previous windows.

However, in many cases again PedScope is still able to deduce the correct meaning of columns in your data file. Before it displays the Columns window, it will inspect the first few lines of the input file and attempt to make a reasonable guess as to which columns contain the main pedigree data - name/id, sire, dam, sex and date of birth.

To make changes, click the Customize checkbox. It can help at this stage to make the window wider and deeper. The rows shown are as follows:

Row Purpose
Field

The meaning of the data in this column.

Type

The type of the data, such as Text, Integer, Date, etc.

For some fields, e.g. date of birth, the type is implicit and you cannot change it.

Label

The label that is to be used for the field once the data has been imported into PedScope.

This is only meaningful for fields that will become user fields in the main table.

Input Header

This will be shown in blue and shows the text from any header line that was found in the input data file.

This is displayed purely for your convenience when checking that the Field and Type have been set correctly.

Input Data

Up to 4 lines of data, again shown in blue, taken from the input data file, for reference.

You should review the Field, Type and Label settings for each input column to be sure they are correct for the particular input data. Ensure that the date format and male/female sex values are consistent for the input data file, then click Finish (Mac: click Done) to proceed with the import.

Fields

The full list of fields is given in the table below.

NOTE: Several of these fields are related to each other and need to be consistent within the input file in order to successfully import data. These are the Name and ID fields.

Each input record (i.e., each animal) must have an ID field, a Sire ID field and a Dam ID field. These are used by PedScope to construct the ancestral linkages - i.e. they are how it works out which parents any given animal is descended from. The ID fields can be numeric or text. Numeric IDs are generally record numbers/keys as generated by whatever software created the import file.

Optionally, the import data may also contain a Name field.

If you are importing data that contains just the name of each animal, its sire and dam, without any kind of record number/key, you should import these columns as the Animal ID, Sire ID and Dam ID (and not as 'Name' fields).

Obviously the Sire/Dam ID/Name fields need to contain consistent data so that PedScope can work out the ancestral links correctly.

Field Description
Animal ID

A unique number or key for this animal. The Animal ID is mandatory if the Name is not given, otherwise optional.

Sire ID

Sire key/number. If present, the Animal ID field must also be included.

Dam ID

Dam key/number. If present, the Animal ID field must also be included.

Name

Animal name.

Sex

Gender. The allowed values for male/female are given in boxes beneath the import definition table.

Date of Birth

The date format is set using a dropdown menu beneath the import definition table.

Date of Death

The date of death uses the same date format as date of birth.

Sire Name

Name of the sire. If present, the Animal Name field must also be included.

Dam Name

Name of the dam. If present, the Animal Name field must also be included.

User Field

A user defined column. Such columns will be loaded and tabulated within the main record display.

If you also specify a numeric type for such columns then PedScope will sort them appropriately, and can report statistics for such columns. E.g. if your data has a column that is some kind of sample measurement for each animal (say, weight), then if you set the column to be a user field with a numeric data type (see below) then PedScope will compute statistics such as the average weight (both for any tagged set of animals, but also for date period stats). You can also have it plotted in graphs, e.g. to correlate it against other input columns or computed values (such as inbreeding), etc.

Alive?

Living status - whether or not the animal is known to be living. If used, column values "TRUE", "T", "YES", "Y" or "1" are interpreted as meaning 'this animal is alive'.

Dead?

Dead status - whether or not the animal is known to be not living. If used, column values "TRUE", "T", "YES", "Y" or "1" are interpreted as meaning 'this animal is not alive'.

Ignore

A column to be completely ignored in the input file.

Data Types

The full list of data types is as follows:

Type Description
Text

Simple text column.

Date

Date value.

The date format is set using a dropdown menu beneath the import definition table.

Integer

An integer value (i.e. no decimal point).

Number

A number that may include a decimal point.

Examples

See Import Examples.


PedScope is a product of Tenset Technologies Ltd, © 2011-14 All Rights Reserved. v2.4.01, June 2014
Apple, Mac and Macintosh are trademarks of Apple Inc., registered in the U.S. and other countries. Microsoft and Windows are registered trademarks of Microsoft Corporation in the U.S. and/or other countries. Lytebox image popup software (www.lytebox.com) © Markus Hay, used with permission under the terms of the Creative Commons Attribution-Share Attribution 3.0 license. Siberian Tiger image by S. Taheri, used with permission under the terms of the Creative Commons Attribution-Share Alike 2.5 Generic license. Privacy Policy