Pedigree Point

Created by Wild Systems Installation Instructions

Pedigree Point Contents & Requirements

Breedmate Explorer V.5.4.1FE (released 20th June 2005) or higher (or equivalent software to export in a standard MySQL bulk insert format) Web site with PERL, PHP and MySQL

Requirements:

PedPoint 1.1.5.exe - pack includes

pp_licence.txt Create_Management_Tables.sql pp_admin.htm pp_fail_login.htm pp_login.htm pp_recover.htm pp_register.htm pp_search.htm pp_terms_of_use.htm cgi-bin pp_admin.pl pp_breeding.pl pp_config.htm pp_login.pl pp_pedigree.pl pp_recover.pl pp_register.pl pp_search.pl pp_session.pl uninstall.exe

PedigreePoint shortcut to homepage, latest information and instructions HINT 1 It is strongly suggested that you read through ALL the instructions on the website and in this manual BEFORE starting. HINT 2 Make sure you have the latest versions of Pedigree Explorer and Pedigree Point before you start as Pedigree Point is still being developed and new features are added frequently the latest versions covered by these instructions are mentioned above. (the full version number of Pedigree Point shows up when you install it)

Install Instructions
Execute the PedPoint1.0.exe file this will create a file at C:\Program Files\PedPoint1.0 to save all your Pedigree Point files into. Open pp_config.pl and change as required
$DatabaseName = "pedpoint"; $DatabaseAccount = "web"; $DatabasePassword = "web"; $DatabaseHost = "localhost"; $nMaxSearchResults = 100; $RequireLogin = 1; Replace pedpoint with the database name supplied by your ISP Replace web with the database account supplied by your ISP Replace web with the password supplied by your ISP Replace localhost with the path to your MySql User Option recommend 100 Require login = 1 No login required = 0 Options: (but suggest you leave as is to start with) "%d %b %Y" = 04 May 2005 '%e/%c/%Y' = 21/5/2005 '%c/%e/%Y' = 5/21/2005 '%d/%m/%Y' = 21/05/2005 '%m/%d/%Y' = 05/21/2005 '%D %b %Y' = 21st May 2005 %b %e %Y' = May 21 2005 defines your search page you can leave as is defines login page you can leave as is Sets the number of generations (starting from parents) to include photo this is prefixed to all photo paths (or store all your photos in a folder called images) Recommended pixel width for photos Sets page to return to after successful login you can leave as is Sets page to go to after unsuccessful login you can leave as is Sets No. of days to keep logfiles Path to Sendmail Replace support\@Breedmate come with your email address. You must include \ before the @

$szDateFormat = "%d %b %Y";

$szSearchPage = "../pp_search.htm"; $szLoginPage = "../pp_login.htm"; $nPictureGens = 2;

$szPhotoPath = "../images/";

$nPhotoWidth = 150; $szSuccessLoginPage = "../pp_search.htm"; $szFailLoginPage = "../pp_fail_login.htm"; $nDaysToKeepLogs = 60; $szMailProg = "/usr/sbin/sendmail": $szMailRecipient = "support\@breedmate.com" ;

HINT
(Unless instructed otherwise, with updates check new pp_config.pl file and copy new features into your existing pp_config.pl so that you can keep your existing settings)

None of the other .pl files need to be changed.

Now FTP these .pl files to the cgi-bin on your website

pp_admin.pl pp_breeding.pl pp_config.pl pp_login.pl pp_pedigree.pl pp_recover.pl pp_register.pl pp_search.pl pp_session.pl

Copy Database
Prepare your database for copying (ie include/omit any particular dogs etc) using Breedmate Pedigree Explorer Select: Tools then Export PedigreePoint

If you use the GZiped option the file(s) will be exported to your C:\Program Files\PedPoint1.0 folder. In this instance they would be ped(1).gz and if you have more than 10,000 records you will have ped(2).gz etc.

MySql MyAdmin
Open your MyAdmin page which will look similar to this: Select Databases

Then click on Database name in this instance pedigree as shown on the left hand side. Next click on SQL in the tabs at the top, which gives a view similar to the picture below, this is where you will upload the Create_Management_Tables.sql

Select Browse and navigate to the file on your computer where you have stored your Pedigree Point files. Select Autodetect Select Go A successful upload will result in a message Your SQL Query has been executed successfully and there will be four additional files showing in the side bar account activity pedigree session

Now select pedigree and the resulting lower half of your page will resemble the view below:

To upload your pedigree table from your computer Select Browse (note: MySql will vary in the size of uploads permitted) Navigate to the pedigree files you prepared earlier which will be named, for example ped(1).gz, ped(2).gz. You must upload them in order the correct -order ped(1).gz first, followed by ped(2).gz etc. Select gzipped (if you zipped your files when preparing them this was the recommended setting). Select Go you will see the number of rows increase increase in the Row Statistics

Repeat this if you have more than one file

Managing Accounts
Pedigree Explorer has a new table (click on Database drop down icon) Account that will contain all the accounts, usernames and passwords etc if you require control over logins. HINT It is strongly suggested that you save this into a different database from your pedigree data and back it up regularly (as you do your pedigree data ). Create a new blank Database using the File, New Database command it does not matter whether you use cat or dog as you will only be using the Account table. Save Database recommend you call it Accounts. Once it is created switch to the Account table by clicking on the Database drop down icon.

When you initially uploaded the Create_Management_Tables.sql one account will have been created so that you can test your database this will be Account Name guest, Password guest123. It is recommended that you ensure your database working before you create new Account files. When you are ready, create an account for yourself called admin using the Account database in Breedmate as shown above and choose your own password, this will enable you to use the Admin feature described later in these instructions. Your visitors can register via the pp_register.htm page that you will load on your site Visitors will automatically be directed to pp_login.htm if they try to do a search without logging in, if they do not yet have an Account there is the option to click on a link which takes them to the pp_register.htm page. Once they have agreed to the terms of use and clicked on the Register button you will, if you have correctly formatted the $szMailRecipient = "support\@breedmate.com" ; in your pp_config.pl receive an email.

HINT
$szMailRecipient = "your\@email address.com" ; do not forget the \ before the @

You will then receive an email resembling the following:

You can either retype the information from this form into your PedX Account table OR you can use this quick method: first wipe across the message text after "All Fields: " as shown above, then use Ctrl+C, then switch over the PedX and use Ctrl+R to insert that record. This avoids having to do any retyping. Note that if the account name already exists then PedX will not allow that record to be added. You should then change the account name or email the user to ask them for a different name. There is also a column headed QueriesPerDay include a number in this column if you wish to limit your visitors to a certain number of queries (each click to follow a link is counted as a query) then put a low number ie 40, if you have someone with who you share data and would like to allow them more queries put a higher number. If you are not worried about how many times one visitor queries your database put a number over 500 HINT Remember to save and backup this data. HINT You may find it useful at some point to know when you added your visitors. Just add an extra column to the account table and put in the date you subscribed them.

You can now use Tools Export PedigreePoint in the same manner you did for your pedigrees. The export string is automatically set for accounts rather than pedigrees.

Now return to your MyAdmin page and upload the account file created by Pedigree Explorer to your Account file in your MySql database. This time instead of clicking on Pedigree (on the left hand side of the screen) to upload the file click on Account

Use Browse to navigate to the file on your computer where you have saved your files, select gzipped and click Go

Now reply to your new user, confirm their Account (user) name and password and remind them of the address of your database. If your users forget their password there is an option on the login page for them to click the link to go to pp_recover.htm where they can request that Pedigree Point automatically mails them their password.

Your HTM Pages

HINT ftp your pp_search.htm and other htm pages to your website as you receive them in the Pedigree Point
pack to make sure everything is working as it should, before you change them to suit your particular breed and details. Then you can also delete the guest/guest 123 account. Edit your pp_search.htm page to reflect your particular breed and details. FTP to your main site folder pp_admin.htm pp_fail_login.htm pp_login.htm pp_recover.htm pp_register.htm pp_search.htm pp_terms_of_use.htm

Pedigree Point is now ready for you and your guests to use.

To Host Multiple Databases

1. Create your second database. In Pedigree Explorer, create another database file (.BMX). When you export data using the Tools-Export PedigreePoint command make sure that the "Table Name:" field is set to the name of your newly created PedigreePoint table. Replace secondbreed with your breed:

2. Open Create_Management_Tables.sql on your computer and copy the following, having replaced pedigree with the name of your second breed CREATE TABLE `secondbreed` ( `PedigreeId` int(11) NOT NULL auto_increment, `Name` varchar(64) default NULL, `SireId` int(11) default NULL, `DamId` int(11) default NULL, `Sex` varchar(10) default NULL, `DOB` date default NULL, `PreTitle` varchar(32) default NULL, `PostTitle` varchar(32) default NULL, `RegNo` varchar(32) default NULL, `Color` varchar(32) default NULL, `Photo` varchar(64) default NULL, PRIMARY KEY (`PedigreeId`)

);

Open your MyAdmin, select the database, click on SQL and paste the above into the Window as shown

Upload your secondbreed files to their file as you did with the first breed database files.

3. Modify your pp_search.htm page to include the second search option/breed

How you do this will depend upon the web editor you use but the raw html will look like this <td> Select which database to use: <select name="db" size="1"> <option selected value="pedigree" selected>Shetland Sheepdogs</option> <option value="secondbreed">Novascotia Duck Tolling Retriever</option> </select></td>

HINT
If you only have one MySql database take some time before you open it to the public to learn more about it, try the different buttons and permutations to see what they can do (ie exporting data to sql, csv etc). Then as Pedigree Point develops and gains new features you will have a better idea how to make the most of them. If you muck it up then just reload everything and start again.

Using Admin Feature

This is a facility so you can see who is using your database, when and what they researched. Go to: http://www.yourwebsite.com/pp_admin.htm Period: You have a choice to look up searches within the past day to the last six months Account: <all> will show everyones searches or you can look up a particular visitor by typing in their login/account name

FAQS / Troubleshooting Problem

If all your pedigree/account data disappears from your MySql database

Possible Answer
Did you reinstall Create_Management_Tables.sql ? Reinstalling these overwrites the data and you will need to reupload your data files If the changes to the Create Management Tables is minor you can just upload the specific sections by copying/pasting into the relevant table (HINT practice this before you incorporate all your data) If that table, ie Account or Pedigree, contains data you will need to reupload your data files ~~~~~~~~~~~~~~~~ The photo path in your pp_config.pl is incorrect or you have your photos stored in another folder than "images" or Examine your files via MyAdmin / Pedigree / Browse /and scroll though the photo column to see if it contains any data. If you have been using BreedMate for a long time and have changed your column positions it may be that a different column to the one you have chosen is being exported. The easy fix is to swop the contents of the columns over using copy and paste, change file headings to suit new contents. ~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~ Photos do not show up in your Pedigree Point online database.

~~~~~~~~~~~~~~~~

File last updated 2nd August 2005 (to include information on Admin feature) Breedmate , Pedigree Explorer , Pedigree Point Wild Systems Pty Ltd ABN 85 065 845 927, an Australian company. 10