How to Upload PedigreePoint data -

indirect transfer using phpMyAdmin console

There is also a direct transfer mode available in PedX V5.4.JD and later versions. Click here for details.

(1) Create data files To transfer your pedigree data to the web site, start Pedigree Explorer then use the Tools-Export PedigreePoint command.

If you have a database of 80,000 records then with a Section size of 10,000 records you will get approx 8 files with the name you set followed by a number in parentheses. So in the example above you would get langdon(1).gz, langdon(2).gz langdon(3).gz etc.

This command exports the current table. If you want to upload your Account table then you need to select that first before executing this command.

The "Generate CGzip'ed file" option when ticked will create a compressed file which is about 25% the size of a normal file. The phpMyAdmin console knows how to upload and decompress these files so this is the recommended option as it greatly reduces upload times. Probably the only reason you would want to turn this option of is if you want to see what the files contain without manually having to unzip them.

 
(2) Notes on export expression The "expression" used in the PedPoint export dialog is a standard PedigreeExplorer expression for exporting. It is by default set correctly for the normal PedigreePoint, pedigree table schema. You can add more fields but you need to update the schema so the expression matches it.

The expression consists of normal characters (which are output as is) and special escape characters that begin with a percent, and field identifiers which are simple the name of a field in square brackets [ ]. The escape characters are as follows:

  • %2 - the bookmark (an integer number) for this record
  • %3 - the bookmark for the sire of this record
  • %4 - the bookmark for the dam of this record

The fields in the normal "pedigree" table in MySQL are as follows with the field size in parens:

`PedigreeId`
`Name` (64)
`SireId`
`DamId`
`Sex` (1)
`DOB` 
`PreTitle` (32)
`PostTitle` (32)
`RegNo` (64)
`Color` (64)
`Photo` (64)

The expression must match these 11 fields which means it must have 11 expressions separated by commas. Text fields must be enclosed in single quotes. The size of the exported field, if its a string (Ids DOB are not strings), should not exceed the field sizes mentioned in the list above in parens.

You can include multiple fields from your database into a single MySQL field. Lets say that part of my expression was '[Field1]'. I could replace this with '[Field1] [Field2]', which would have the effect of combining those two fields.
(3) Transfer data The data files now need to be sent to the MySQL database server on your web site. This will need to be done each time you want to update your web site. The web files must be uploaded strictly in the order of their sequence number. Hence in the example above you must upload langdon(1).gz first. To upload login to your MySQL phpMyAdmin console, click on the SQL tab and click on the Browse button and select each file in sequence. How do I get to this page?