Update History Log

	B	C	D	E	F
1	Update Log for the Paw Tap Barn Hunt Secretarial Software
2	Date	Version		Problem	Fix

3	7/21/18	1		Icon Not Showing	Mac: Recompiled, had to fix Packages and add icon into Resources
4	7/24/18	1.1	1	Enter All Runs didn't Enter All Runs	The SQL pulling the number of Trials was not being converted to a Number. Converted to Number to end loop.
5			2	Person Details Secretary/Judge Radio Boxes labeled incorrectly	Switched the boxes so they are labelled correctly.
6			3	Person Details not calculating Fees Owed Correctly	Added Fees Owed Calculation Script when Adding New Person and Changing Person with Drop-Down Menu.
7			4	Version Number	Added Version Number to Home Page.
8	8/18/18	1.2.01	1	BHA Rule Change - Accepting xlsx with Pass/Fail/ABS	Added the ability to export Pass/Fail/ABS runs to BHA Exports. Also added an Omit to not include Wait List Entries if they happen to have a score (should not happen)
9			2	Canceling out of Enter Multiple Runs doesn't cancel	Modified script so that cancel does not open the next window, just closes the selection dialog.
10			3	When chosing Not Entered on the Runs Drop Downs, the A/B showed up again.	Hide the A/B for Not Entered runs.
11			4	The page "Entry List for Individual Dogs" is awkwardly named	Changed the name to "View Dog's Runs"
12			5	Run-INVISIBLE-GetRunInfo showed unnecessary fields	Removed fields from the layout
13			6	Request for more Trials per Event	Added the ability to run 14 Trials per Event
14			7	Payments were not calculating correctly based on DOS/Late entries and Dates	Was assigning variables to the Event table fields and it was taking the first record in the Event Table. Had to SQL the correct value using certain criteria to get the right value from the field.
15	8/22/18	1.2.02	1	Not Provided for Dam/Sire/Breed is confusing	Changed to Not Required when adding a new dog.
16	8/23/18		2	When changing the Armband Num for an Individual dog, it wasn't being changed for all the runs for that dog for the Current Event.	Added an OnExit script to the Armband Number Field on the Manage Armband Numbers page to change Armband Numbers for all the runs for that dog for the Current Event.
17			3	A User had an issue with the Number of Days on the Event Page not Calculating Correctly	Added an OnExist script to the Beginning Date and End Date fields to recalculate the Number of Days. This is needed anyway for if the dates are changed.
18			4	Some extra spaces and semicolon in the Initial Confirmation Email for Multiple Dogs	Removed those so it looks cleaner.
19	8/24/18		5	eMail Not working correctly for SMTP.	Changed the SMTP settings for Final Confirmation and Results emails to actually pull the values from the database (had some values hard-coded ooops).
20			6	New Event Not Creating Properly	This was becuase, on Importing the tables, the EmailText table index field was not being sorted property on both Windows and Mac, so the key field was not setting properly. Fixed the sort so it works.
21	8/28/18	1.2.03	1	NA was still showing for the Drop Downs in the View Dog's Run Page	Changed so only A and B will show.
22	9/8/18	1.2.05	1	On the View Runs page, for trials higher than 7, the portals were not filtering right.	Changed the filter so the appropriate runs are showing for each trial in the portal filters
23			2	On the View Runs page, eeping all the boxes with multiple trials could be a little confusing.	Added the Trial Date to each box.
24	9/12/18	1.2.07	1	The BHA Export Spreadsheets had Absent instead of ABS, and blank time fields	Changed so the spreadsheet will export as ABS and have 0:0.0 for the time.
25			2	When changing judges on the Trial details screen, it was confusing that they didn't change when tabbing through	Changed the Script to fire OnExit instead of OnModify. This is not consistent with the Adding Runs window.
26
27	11/3/18	1.2.23	1	Instinct does not have placements so they should not be on the labels.	Remove placements on instict Labels
28			2	Request to have the judge listed on the lables.	Added Judge to Labels
29			3	Print all levels of placements on one page	All levels of Placements can now be printed on one page.
30			4	Request to delete the Demo Event and all associated Trials and Runs	Added button to Delete Demo Event - Runs/Trials/Event
31			5	Couldn't scroll the text boxes on the email windows	Put in a scroll bar.
32			6	Could not print Summary Counts, no print button	Added a print button to the Summary Counts layout
33			7	Menu Bar can disappear in Windows	Added a Show Menu Bar button in the Maintenance Layout
34			8	Request to remove lines on scribe sheets	Removed from regular classes. Left on C8 Scribe Sheets
35
36	11/9/18	1.3.18	1	The Maintenance Scripts were throwing odd information.	Cleaned up and fixed the Maintenance Scripts
37			2	Changing the date of a trial does not change the runs.	Updated the Maintenance Scripts so this now when a trial's date is changed, this script will update the associated RunDates Dates.
38			3	Changing the owner of a dog doesn't work.	Changing the Owner of a Dog now works.
39	11/10/18		4	Request to have the Pass/Fail on C8 runs be calculated based on criteria	Pressing the Calculate button now determines if the run is a Pass or a Fail.
40			5	The Change Judge on the Enter Scores Page sometimes not bringing up correct level.	Was pulling the Dog Level from the Dog Table not the Run Table. Changed so it's showing the Dog Level from the Run Table.
41				-- Added Fields --	ADDED FIELDS -
42			6	Added ChangeJudge field so it's unique and used only for Changing Judges	Run Table: l_ChangeJudge
43			7	Added a RunFee field to the Run table to be used to calc fees per run	Run Table: l_RunFee
44			8	Added a Label Offset field so it's uniqe and used only for label offsets	GlobalFields: G_LabelOffset
45			9	Added a EnterMultipleRuns field so it's uniqe and used only for entering runs	GlobalFields: G_EnterMultipleRuns
46			10	Added a SystemID Field to identify the system the application is installed on	GlobalFields: G_SystemID
47			11	When adding multiple runs, the judge coming up was the Event Judge, not the judge assigned to the level that the dog is assigned to.	Changed the script so that the judge will be queried based on what the Dog Level is. Still for trial 1, but the appropriate class.
48			12	Added an identifying table for PawTap Purposes	ADDED TABLE: PawTapInfo
49			13	Request to have the BH- already in the BHA Number Field when adding a new dog	Pre filled the BHA Number Field to include "BH-" when adding a new dog.
50	11/11/18		14	Cannot use SMTP to send a Final Confirmation email to one person.	Changed so that you can send a Final email confirmation to one person using SMTP
51			15	Trial Numbers of over 10, when doing a BHA XLSX export, are assigned 0 for the Export.	DATABASE CHANGE: This was a calculated field in the DB. Changed to a Number field and put the calc in the script instead. Also created a TrialNumForXLS field in the Trial Table
52	11/17/18	1.3.20	1	Selecting a dog for Scribe Sheets - The scroll on Windows was slow with an arrow.	Changed the pop-up menu to a Drop-Down menu. Also modified the associated script because these two menu types handle the keys differently.
53			2	Home Page Current Event Summary doesn't always reflect days accurately.	Changed the Run Count Summary on the first page, as there are not always 2 trials per day.
54		1.5.10	1	Changing Judge for an Individual Dog/Run was not showing the correct changes in the pop-up window.	The Judge Change Layout was based on the Trial Table, and would only bring up Runs related to one trial at a time. Changed that Layout to a LIST so it can show the records from the Run Table and show all the change records at the same time. Also added script to make sure it goes back to the Trial the person was looking at when the button was pressed. Also made sure it clears out the selected dogs on Save. it does not clear out the selected dogs on Cancel.
55			2	Question of if Absent runs are included in the Report Summaries.	They were included, I removed them. These two reports do not include Wait List runs or runs scored as Absent.
56			3	Changing Run Date was not working all the time.	If a person had two dogs, the run date for the first dog was appearing in the Change Entry Date window. Updated this so that will show and update the correct dog.
57	2/6/19	1.5.21	1	Not all emails need to have wait list information at the bottom.	Removed Wait List text from bottom of initial email confirmations.
58			2	SMTP Error message not displaying error code.	Added error code to display message.
59				Smart Running Order must use a valid Handler.	Adding scripting in the Dog Details to require a valid Hanlder
60					Added a Maintenance button to assign Handler IDs to the run table.
61	2/11/19		3	Wait List Menu would be easier to read if sorted by Trial/Class/DateEntered	Changed to sort order for the Wait List Menu.
62			4	Smart Running Order	Had to update Dog Table and Run Table to include Handler ID.
63	2/12/19		5	Smart Running Order	Have to Export to an external XLS file and import into the RunOrderBuild Table
64			6	Smart Running Order	Updated the Import and Export scripts to add in the new RunOrderBuild Table
65	9/11/19	2.1.38	1	Modifying Payment System	Added Payment Fields by Run - They don't really do anything yet.
66			2	If A/B is lower case the reports will not work correctly	Added script when opening application to force all to Upper
67	9/12/19	2.1.39	1	When viewing Run Payments from the Dog Runs window, all runs show.	Changed this so that only the dog's runs show.
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100