How to Install PedigreePoint

Follow these instructions to install PedigreePoint on your web server. Note we do offer to install it for you - cost is US$110 - see Prices for details.

(1) Web site To install PedigreePoint you need a web site that has PHP and MySQL. There are many WPPs/ISPs that provide web hosting with these facilities. Just use www.google.com with a search string of "Web hosting PHP MySQL". When purchasing a hosting package ensure that you do have these facilities and that you have at least one MySQL database. Please note that even if you do have one database you can still host multiple breed databases as each of these is a "table" within the one database.
(2) Installation package Email us at support@NO_SPAM_PLEASEbreedmate.com (remove the NO_SPAM_PLEASE) and supply your name and address and we will email you the download links for the installation packages for PedPoint Lite and PedPoint Pro (PedPoint Lite is the simpler package).
(3) Customise Run the installer file. Its called InstallPedPointLite.exe or InstallPedPointPro.exe. Both installers will copy files to the C:\Program Files\PedPoint folder. They will create a sub folder called Lite or Pro which contains all the scripts. In a later step all these files will be FTP'ed to your web site, but at this stage you need to modify one of the PHP scripts. The pp_config.php file needs to be modified to suit your web site. In particular you need to set the following:

$DatabaseName = "pedpoint";
$DatabaseAccount = "web";
$DatabasePassword = "web";
$DatabaseHost = "localhost";

These four parameters should be supplied to you by your ISP/WPP. Additional parameters which you can set are:

$nMaxSearchResults = 100; #Number of search results returned per page
$szDateFormat = "%d %b %Y"; # see How To Set Date Formats
$szSearchPage = "../pp_search.htm";# URL for the search page lik at the bottom of reports
$szLoginPage = "../pp_login.htm";# URL for the lgoin page - displayed on invalid login
$nPictureGens = 2;# set to the number of generations (startring from parents) to include photo
$szPhotoPath = "../images/"; # this is prefixed to all photo paths
$nPhotoWidth = 150;# Pixel width of photo displayed in Pedigree
$szSuccessLoginPage = "../pp_search.htm";# page which is displayed after succesful login
$szFailLoginPage = "../pp_fail_login.htm";# page which is displayed after failed login
$szLoaderPassword = "set this";# Used for direct data upload from BreedMate
(4) Install tables You will need to login to your phpMyAdmin console, go to the SQL page and execute the script called "Create_Management_Tables.sql". How do I get to this page? Here is a typical screen shot:

Please note that this step will also create an default account guest with password guest123. After you get your accounts setup you should delete this account.
(5) Transfer scripts to web site FTP the .php and .htm files to the Lite or Pro folder on your web site. You may need to chmod the .php files so they have execute permission. The .css files should be FTPed to your main web site folder. The web site software is now installed. You will not need to repeat these steps again. To upload your data see the following section.
(6) Checking the installation Two of the PHP scripts, pp_test1.php and pp_test2.php can be used to check that you have correctly installed PedPoint.

First run pp_test1.php by simply typing the complete URL into a browser. If your web site is "www.mydomain.com" then the URL you need to type is "www.mydomain.com/Lite/pp_test1.php". If this is test is succesful it will return "PedPoint Test1 successful". This indicates that you can run a PHP script on this site and that the Lite/Pro and this file has the appropriate execute permission (set using chmod command in the FTP program).

Next run pp_test2.php. If this is successful it will return something like "PedPoint Test2 successful - there were 9346 rows in the pedigree table". As you may not have uploaded any data this will probably be 0. If successful it indicates that 
- the database name, host, account and password are correct
- you have MySQL installed correctly
- you have the pedigree table installed correctly

To find out how to transfer you files click here.

New - we now have a PDF file describing installation