Follow these instructions to install PedigreePoint on your web server. Note we do offer to install it for you - cost is US$80 - see Prices for details.
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.
Email us at firstname.lastname@example.org and supply your name and address and we will email you the download links for the installation package for PedPoint.
Unzip the installer file, "PedPoint Lite 4.2.zip" into an empty folder on your computer. In a later step all these files will be FTP'ed to your web site, but at this stage you only need to modify one of the PHP script files - namely pp_config.php which 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" $szEncryptionKey = "XXXXXXXXX"; // It is used when creating a URL for "Pedigree w/o Links" //A typical URL would look like http://www.pedigreepoint.com/Lite/pp_externalped.php //enc=e78be3db41b6b7c9946495216bf5bb&db=shetland&gens=5 // Such links can be emailed or placed on web pages so tohers can view a pedigree without logging in. $szMailRecipient = "email@example.com";// set to your email address!! $szLoaderPassword = "set this"// it will be used from Pedigree Explorer to single click update $TableNames = "";// e.g. pedigree:Pedigree"; // list of tables for Search, AdvancedSearch and Trial Pedigrees // Each table in the list must be separated by a semicolon and should consist of: tableName:tableDescription. // E.g. "shetland:Shetland Sheepdog;nova:Novascotia Duck Tolling Retriever" // Leave blank if you want the list of table names and descriptions to come from your 'dbtables' table. $szPhotoPath = "/Images/"; # this is prefixed to all photo paths $nDaysToKeepLogs = 60;// activity older than this many days is deleted from the logs // OPTIONS - USER ACCESS $bUsersMustLogin = true;// set this true if you want to force users to login with an account and password $bRecordActivity = true;// set this true if you want to record user activity in the activity table, e.g. what reports they run // and search strings they use $bLimitNumberOfReports = false;// set true if you want to limit the number of reports a user can run per day
The first four parameters should be supplied to you by your ISP/WPP. Additional parameters which affect the appearance of your web site or the reports are as follows:
// OPTIONS - WEB PAGE APPEARANCE $szWebSiteName = "Web Site Name"; $szWebSiteOwner = "Data Owner"; //(Data Owner) $szWebSiteBreeds = "breed"; // THIS MUST BE SET $szMailRecipient = "emailaddress"; // change this to your email so you can receive emails $szLocation = "the USA, State of TX"; // CKW- location for legal proceedings $szCRYears = '2013 -' . date('Y'); // CKW - Start year through current year for copyright notices $szTimezone = "America/Indiana/Knox";// see http://www.php.net/manual/en/timezones.php $szSponsorCredits = "This online database hosted by $szWebSiteName. Copyright $szCRYears "; // OPTIONS - REPORT APPEARANCE $nPhotoHeight = 150;// Pixel width of photo displayed in Pedigree $nPictureGens = 2;// set to the number of generations (starting from parents) to include photos $szDateFormat = "%d %b %Y"; $nMaxSearchResults = 100; // Number of search results returned per page $bShowSireDam = false;// Set this to 1 show sire and dam in the search results. $szVerticalPedField = ', dob, color';// change this to one or more fields which you want to display // at the end of a name in the Full siblings part of a vertical pedigree, e.g. // to show three fields change this to ',pretitle, posttitle, regno' (note there must be // one comma before each field name). $bColorizeRepeatedAncestor=true;// set true/false - true to show a unique background color for repeated ancestors
You will need to login to your phpMyAdmin console, go to the SQL page and execute the script called "Create_Management_Tables.txt". 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.
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 web site software is now installed. You will not need to repeat these steps again. To upload your data see the following section.
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 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
- the database name, host, account and password are correct
- you have MySQL installed correctly
- you have the pedigree table installed correctly