Release Notes
Issues or Features to be resolved
- Repeating information displayed on some "Player" type default reports (e.g., "Player Profile") for the Basketball , volleyball and soccer templates. Additional Instructions field (Reports -> Edit Reports menu item) should read (was missing " GROUP BY p.ID":
WHERE s.Played='1' AND s.PlayerID = '#idx#' GROUP BY p.ID
What's New in 3.6.5 Release
- Fixed issus with HTML Tables no longer being sortable
What's New in 3.6.4 Release
- Fixed saving issue with older files
What's New in 3.6.3 Release
- Fixed printing issues for older files
What's New in 3.6.2 Release
- Fixed printing issues and more database errors.
What's New in 3.6.1 Release
- Fixed database issues
What's New in 3.6.0 Release
- Now compatible with macOS Catalina
What's New in 3.5.4b Release
- Fixed some random Database 19 errors which have come up for more than one user
- Fixed lack of content on stats lists when editing reports (Windows only)
What's New in 3.5.3 Release
- Fixed issues when duplicating a game (Order field values were not duplicating and related reports were not being displayed correctly)
What's New in 3.5.2 Release
- Fixed issue where updating the 'results' field when editing a report did not save in versions 3.5 and 3.5.1.
- Updated the search/replace for reports option (Field Name is now displayed for readability)
- Set a minimum height and width per Apple Human Interface Guidelines
What's New in 3.5.1 Release
- Fixed some report printing and web output problems with OS number formats that use a comma for the decimal seperator (e.g., some non-english languages use this)
What's New in 3.5 Release
- Added ability to Find and Replace on Report, Game or Roster information
- Added "Find" tool bar item and Edit -> Find menu item which takes you to the new Find/Replace page
- Added ability to quickly go through reports when in the editing report's page using Cmd-Arrow Up and Cmd-Arrow Down (Windows users, use Ctrl-Arrow Up and Down)
- Fixed bug where file path names contained an apostrophe (') caused file corruption in unique situations (one cause was when positions were saved using a NULL or empty character). [This prompted errors messages of: Error: unrecognized token: ";" and File could not be created/saved]
- If a report has the "Group With Next" option checked, the next report's "Show" field can be now be selected without issues. (e.g., the "next" report will not have a separate web report generated nor will this report show up in the web report's "Select Report" popup menu)
- Updated Default Reports (all sports) which fixed the Player links (Links to players were referring to 'PlayerStats.html' when it should have been 'PlayerProfile.html'). NOTE: To see this change in existing files you will need to use the "Add Default Report..." or "Restore Default Reports" menu items (Reports menu). You can also fix this using the new Find/Replace feature.
- Fixed issue with using "SELECT IN" along with "WHERE" when editing reports in the "Additional Instructions" field
- Fixed issue where the "Totals" row on web-generated reports became slightly misaligned with the rest of the report in certain cases. This could also be fixed by selecting the "Auto-Fit Column Widths" menu item on the selected report.
- Fixed some minor bugs and annoyances when on the editing reports page
- Re-organized some tool bar items
- Fixed Windows bug where the "Favorites" list lost ability to scroll in certain situations
What's New in 3.4.8 Release
- Baseball Default Reports: Fixed 3.4.7 issue of using an older version of the statistics (e.g., OBP), which were no longer valid
- Default Reports (All Sports Templates): Added Mobile reports, which show fewer statistics by default
- Default Reports (All Sports Templates): Added League-only Overall reports
NOTE: To see these changes, you will need to select "Restore Default Reports" from the "Report" menu or you can individually add default reports by choosing "Add Default Reports...".
- Added iPhone browser viewing compatibility to the Report Template. The following was added within the <head> html tag: <meta name = "viewport" content = "width = device-width">
NOTE: This is for new files created in version 3.4.8 or later. To add this to a file created in a previous version, select "Reports -> Edit Templates..." and either add this line yourself of reset the default template
- Added ability to Total columns/fields which have dashes (e.g., W-L or FG-Att). To use this format, edit a report and change the "Format" field to "#0-0". See the "Overall - Pitching" default reports for an example of using this feature.
What's New in 3.4.7 Release
- Changed initial sort direction for sortable tables in Web-generated reports (numeric values) from ascending to descending
- Added new preference to change the initial sort direction for sortable tables in Web-generated reports (Initial Sort is Descending for Numeric Values)
- Display bug fixes
- Fixed bug which wouldn't allow some PowerPC machines to launch Statbook
What's New in 3.4.6 Release
- Fixed bug which caused program to unexpectedly quit when changing sets (Games area)
What's New in 3.4.5 Release
- Added "Quick Themes" to the Modify Web Styles dialog (accessed by selecting the "Styles" button on the Reports page). This allows for color styles to be quickly applied to your reports.
What's New in 3.4.4 Release
- NOTE: Versions 3.4.2 and 3.4.3 were Mac App Store releases.
- Preferences are now stored in the Application Support folder under "Statbook" to align with Apple guidelines
- Added iOS Compatible Custom names when exporting an iOS (iPhone) file for syncing with iPhone/iPad App
- Fixed issue with Statbook not being able to create a new file on first run in certain situations
- Fixed crash when in selection list editing mode and selection is outside column range
- Changed the way a double click is handled on lists that are editable. No longer enters edit mode when selecting different rows but can not edit cell when in double-click mode
What's New in 3.4.1 Release
- Added new Volleyball Template. Like all Statbook templates, volleyball comes with numerous (70+) built-in statistics and plenty (20) of built-in reports to help get you started
- Moved some of the Report menu items around for more consistency with other menus
What's New in 3.4 Release
- Be sure to see What's New in Version 3.4 for important information on upgrading files
- Using the built-in MaxPreps report, you can now export a MaxPreps compatible boxscore file which allows you to import these statistics to your MaxPreps.com account (See the Help Videos section for information on how to save this type of report)
- Added new Football Template. Like all Statbook templates, football comes with numerous (70+) built-in statistics and plenty (20) of built-in reports to help get you started
- Added numerous built-in statistics to Basketball, Baseball and Soccer Templates
- Updated Default Reports for all sports
- Added new "Photo" field to roster which makes it easy to add Photos to reports (See built-in "Player Profile" report)
- Added "Add Default Report" menu item which allows you to restore default reports one at a time.
- Allows International sorting (decimal comma) for Web Created reports
- Can now have reports selected (i.e., checked) when report above has "Group with Next" option checked. (Duplicated report will not be created/printed anymore)
- Can now delete multiple fields at once when editing a report.
- Added new descriptive separator rows to "Favorites" listbox (when editing a report)
- Added option to change the default "Last Name, First Name" display when inputting statistics on the "Games" Input area (See Preferences -> Names For Stats Input option)
- Added option in Preferences to change the default Input Statistics Headings/iPhone Category Names on the "Games" input area
- Baseball Template: Fixed Slugging calculations on all default reports
- Changed "Add Report" to "Create New Report" (Report menu)
- Fixed display bug on "Do not show again" dialog
- Fixed bug when saving file off screen, file could not be seen on re-launch. (Might happen when you had a dual monitor and then re-launched on a single monitor)
- Fixed a problem for 'Boxscore' or 'Player' type reports and using MIN(,) or MAX(,) functions within the 'Result" field. (i.e., MIN and MAX can now be used)
- Fixed result area (Edit Reports) so that the text now wraps as it did in previous versions of Statbook
- Reorganized Preferences area
- Reorganized and Changed order of Report menu items
What's New in 3.3.1 Release
- Fixed Windows problem where changes were not being saved
- Fixed issue of Importing comma-delimited files which were not parsing correctly
What's New in 3.3 Release
- Support for importing/saving iPhone plist files (iPhone App currently in Beta testing)
- Fixed problem some users were having with Games Played/Pitched were not showing up in reports. Also affected boxscores or Player statistics reports where they did not show up.
- Fixed issues where Checkbox columns (i.e. Boolean types) could accept text which caused "Database Error 0" messages
- Added ability to allow for all defensive stats in pitching a
- Added text area in Registration window that allows copy/paste of Email text which automatically parses the Key/Serial number data
- Fixed Baseball formulas (AVG, OBP) to include Sacrifice Flies (This will only show up when creating new files. Files created in versions prior to 3.3 will need to manually update the reports)
What's New in 3.2.2 Release
- Added numerous "Favorites" (for IP, ERA, WHIP) to allow .1 and .2 for partial innings pitched (See the Help Videos page to learn how to use "dot notation" for stat inputs and on reports). The ability to use decimal values (i.e. .33 and .67) is still available and has remained the default.
- Updated links to point to statbook.pachysoft.com instead of baseballstatbook.com.
What's New in 3.2.1 Release
- Fixed known issues: File names (or files within folder names) containing a single quote (apostrophe) cause the application to unexpectedly quit.
- Fixed problem with saving selected reports to HTML (Mac OS X Only)
- Internal changes to Editfields and Text Areas.
What's New in 3.2 (FINAL) Release
- Added "Recent" feature where you can now select the File -> Open Recent menu item to select recently opened Statbook files.
- Combined Intel and PowerPC download application into one Universal application which will run on any Mac running Mac OS X.
- Fixed some printing issues on Windows
- Header/footer (Printing) information is now remembered after saving the file.
- Added "Downloads" link to the Help -> On The Web menu item
What's New in 3.2 (Beta 2) Release
- FTP Change: 'Upload Results' action no longer uploads a 'Statbook' folder and instead uploads the reports to the selected (or displayed) directory
- A report called by "Group With Next Report" will no longer be created (or Printed) if there is no data to display. This can be useful, for example, when creating player log reports and some players only have batting statistics and no pitching stats. The Pitching stats will not be created/printed anymore.
- Added ability to filter what is shown in the popup menu for reports of type sub-report (i.e. Boxscores, player stats)
- Fixed problem when trying to save a web file with html (or asp, php) extension setting
- HTML validation code fixes (e.g. 'width' tag no longer uses decimal percentages)
- Fixed problem which caused application to unexpectedly quit when trying to open a non-3.x Statbook file.
- Added ability to add Boolean (Checkbox) type fields to the Players and games list boxes (See "Modify <list>... " menu items)
- Added 'Active' boolean field to players roster. Can be useful to filter our non-active players on reports.
- Added "Enter License Key..." menu item (Apple menu for Mac users; Help menu for Windows users)
- When a game is selected, and adding a game, the game number is now one plus the selected game number
What's New in 3.2 (Beta 1) Release
- Added "Print All" capabilities where all "Checked" reports in the reports list will now be printed. Use Mac OS X's "Preview" feature to easily create PDFs of your reports
- Fixed printing reports problem and added more print functionality. Print report headings now are in sync with the Web report headings colors (See "Styles" button on Reports panel) as well as better support for printing, in general
- Printing reports now uses the "Group with Next" feature of a report (i.e., if Report has "Group With next" selected, then the next report will be printed on the same page (if enough room is available)
- Added two menu items to the Reports menu:
- Auto-Fit Column Widths: This will adjust the column widths of the selected report to be based on the largest string width for each column. Try it, you will like it!
- Change Column Width Mode: This allows you to change the way manually adjusting column widths works. If "Percentage" is used, and you change the column (from the report header area), all other columns move with it (Again, I think you will like this so give it a try). "Relative" width behavior is the same as in previous versions.
- Revamped the way you edit reports. You can now Edit and save changes for all reports without having to go back to the main reports panel. Useful for copy/paste of "Result" field formulas (Still is a work in progress so if you have ideas on how to improve please send us a feature request)
- Added "Go back" and "Save & Return" buttons to the Toolbar when editing reports. If you make changes to a report you do not want to save, select the "Go Back" button and all changes will be discarded (As long as you didn't hit the Save Report button (Green checkmark image) next to the Report Title)
- Fixed issue when adding a new Report and, if the report was saved with no fields added, a crash will occur when trying to reedit this report. Can no longer save these types of reports without adding a field first.
- Fixed Register button link on "About" window. Correct link is now: http://statbook.pachysoft.com/register.html
- Fixed Display Issue for Windows builds: Edit Lists field buttons were not visible in some situations (Roster, Games, Statistics lists)
- Fixed problem where "preview" of a report would sometimes come up blank.
- Fixed Registration warning dialog. It now pops up in front of any open windows.
- Updated some validation code when editing reports.
- When sorting reports, this now triggers a need to save the file, as expected.
- Added two new menu items: Players -> Modify Roster Fields...; Games -> Modify game Fields...
What's New in 3.1.3 Release
- Fixed problem when deleting certain columns from reports caused Statbook to unexpectedly quit
- Fixed problem Building Website where not all selected reports were being created (Arose in version 3.1.2)
- Fixed problem when adding a new game -- and another game is selected, thus copying checkbox fields -- these fields did not copy correctly. This caused adverse affects on reports. (i.e. Appear selected under "Games" panel but did not show up on the "Reports")
What's New in 3.1.2 Release
- ReportTemplate.htm and MasterStyles.css are now stored locally to the file instead of stored on the user's disk drive (Preferences Folder). This allows files to be easily transferred from Computer to computer (or cross-platform). Opening a file in 3.1.2 will attempt to bring in the disk-based versions of the templates.
- "Reports -> Restore Support Files" menu item has been renamed "Restore Templates".
- Added "reports -> Edit Templates..." menu item. This allows you to make changes to the templates either manually of a copy/paste from an HTML editor (or another Statbook file), for example.
- Added initial folder preference for Open/Save dialogs and made it a application-wide preference so that this folder is now remembered.
- Fixed the Window menu so it is now functioning properly.
- Changed the default reports so that "US Dates" are working correctly in all cases. To see this change, you will need to use the "Restore Default Reports" from the "report" menu. CAUTION: This will replace all your current reports changes back to their defaults. [ you can also replace the "Date" result fields to use: substr(g.GameDate,6,2) || "/" || substr(g.GameDate,9,2) || "/" || substr(g.GameDate,3,2) ]
What's New in 3.1.1 Release
- Re-added ability to save reports as Space and Tab-delimited text as well as Excel (Reports -> Save Contents As... menu item. Select the 'Format' popup menu from dialog)
What's New in 3.1 Release
- Added Basketball and Soccer stat keeping modules. When creating a new file a dialog prompts the user to choose one of the following options: Baseball, Basketball or Soccer
- Added "Reports -> Restore Support Files" menu item which allows you to revert any changes made to the ReportTemplate.htm or MasterStyles.css support files.
- Added ability to group editfield-type reports as well as added ability to group more than two reports (reference "Group with Next Report" checkbox when editing a report)
- For Input lists, when in "Select Mode" double-clicking on a cell now puts you temporarily in "Edit Mode"
- Changed the way "Sets" are saved (Games window). If a set is selected and changes are made to the statistics input options then the set is automatically saved. "Save As.." popup menu item has been changed to "Create Set..."
- Re-ordering of defensive statistics now works correctly
- Fixed problem when adding a new game and another game is selected, the new game did not use the last games order (NOTE: Duplicate the game if you want all the statistics to copy over)
What's New in 3.0.5 Release
- Fixed problem when trying import an existing Statbook 2.x file (Displayed: "Error occurred: PRIMARY KEY must be unique")
What's New in 3.0.4 Release
- Fixed problem with Statistics Input List where selecting the 'Played' column did not save unless the row is highlighted
- Added ability to Import 3.0 files; Changed file menu and import button for importing to now read 'Import Statbook File' (was 'Import Statbook 2.0 File')
- Added option to not erase file contents on import
- Added ability to renumber games based on current sort of Games List
- Added functionality to format and sort submenus (Popup menu) on Reports (This is for Player and Game (boxscore) type reports)
- Changed menu items 'Add or Edit...' to 'Modify...'
What's New in 3.0.3 Release
- Fixed problem with 'Adding Player to Selected Game' when it reported a 'Database Error 19: Stats.Batted May Not Be Null' message in certain situations
What's New in 3.0.2 Release
- Fixed printing reports issue where fields not checked were being printed
- Fixed problem with duplicating a game and stats were not updating on reports as expected
- Fixed problem with Selection mode (some fields like PG, Order, ID, Name should not have been selectable)
- Added ability to format added stats to Integer, Double or Text (default values are 0, 0.0 and ' '' respectively)
- Added ability to have report fields use fixed or percentage column widths
- Added functionality to Sort Roster and Game Input Lists (Click on List header to sort)
- Added 'Close' functionality to File menu; Removed Recent menu item since this was not implemented
- Changed sort routine on Game Number field so it sorts based on number instead of based on alphanumeric
- Added 'Plate Appearance' to Overall, Player and Boxscore default reports (Unchecked); Added 'AB' to Boxscore report
NOTE: To view changes to the reports you will need to select the "Restore Default Reports" menu item (Reports menu).
- Added functionality where double-clicking on a report field will not activate the Report Builder and auto-select the double-clicked field
- Fixed problem with 'Adding Player to Selected Game' when it reported a 'Database Error 19: Stats.Batted May Not Be Null' message in certain situations
- Added feedback message when player was added to a game successfully ( 'Adding Player to Selected Game' menu item)
- Release 3.0.1 was an internal release
What's New in 3.0 Initial Release
- Fixed crash when in Selection Mode (occurred in certain situations)
- Disallowed the use of duplicate field names when adding a new field to an Input List
- Fixed problem when moving files from Mac to Windows versions (and vice versa) which prevented ability to generate reports
- Fixed broken URL links in default reports (after building a website)
NOTE: To view changes to the reports you will need to select the "Restore Default Reports" menu item (Reports menu).
- Fixed Fielding Percentage (FP) statistic on Player and Game reports (apparent after "Restore Default Reports")
- Added ability to select multiple players in the Game Input area and "group" toggle whether they have played or pitched in a game
- Removed expiration date on application
- Numerous appearance and behavior improvements
What's New in Release 3.0 Final Candidate 5
- Changed beta expiration date to July 26, 2008
What's New in Release 3.0 Final Candidate 4
- Fixed problems where some reports were showing zero values for certain fields or calculations for some fields were incorrect in certain situations (e.g. AVG, SLG, AB, etc). This usually occurred after an import from 2.0 file.
- Fixed Splitter refresh issues on windows builds
- Minor appearance improvements
What's New in Release 3.0 Final Candidate 3
- Fixed problems where reports were not showing any information
- Fixed problem where reports were not showing correct values for Games Played (GP) or Appearance (APP)
- Fixed Unexpected Quit when trying to import 2.0 file (problem first occurred in FC2)
- Added new statistic 'Sacrifice Fly' so that the On-base Percentage (OBP) could account for this stat correctly [ i.e. OPB = (H + BB + HBP)/(AB + BB + HBP + SF) ]
NOTE: To view changes to the reports you will need to select the "Restore Default Reports" menu item (Reports menu).
- Added ability to auto-populate field attributes from selected game
- Added ability to duplicate games and associated statistics
- Added preference to show Edit dialog when adding a game. Default is now 'True' (i.e. Show the dialog)
- Added ability to add a player to a game (useful for adding players after games have been entered). See the "Add Players to Selected Games" menu item from the Games menu.
What's New in Release 3.0 Final Candidate 2
- Added new default report named "Game Results" which is an example of how to show W-L records, overall statistics by game, etc. To view the report you will need to select the "Restore Default Reports" menu item (Reports menu)
- Added built-in Fielder's Choice statistic as well as 6 position (Inn1... Inn6) stats. (NOTE: Users can add or remove statistics at any time)
- Updated Sample File from the Downloads section.
- Fixed ERA fields with correct calculations for all reports which use ERA. (ERA is calculated based on 6 inning but can easily be changed using the following procedure:
Select "Edit Report" from the reports menu (Or simply double-click on the report). Then select the "ERA" field. In the "Result" field you will see the number "6.0". Change this to your preferred setting.
To view changes to the reports you will need to select the "Restore Default Reports" menu item (Reports menu).
- Fixed bug which caused a crash when editing a report and de-selecting/selecting to show a field.
- Fixed where where a statistic could be removed even though it was used in a report. This caused a Database error and the application quit when selecting a report.
- Added more character options for Field names. In addition to letters and numbers, names can now contain: )(*&^%$#@!}{|\][:;<>,.?/+_-=~
What's New in Release 3.0 Final Candidate 1
- Added File Transport Protocol (FTP) capability which allows direct upload of reports to your remote server
- Added new "Sets" feature to batting and pitching statistics input. Sets allow you to save Batting and Pitching input field configurations. For example, you can now toggle between hitting and fielding statistics (download sample file for an example which also includes a 'Lineup" set)
- Added new menu items to the Games menu: Next Set; Previous Set. These allow you to "toggle" between saved sets
- Added menu functionality. All menu items should be working as intended.
- Fixed some user-submitted bugs and annoyances
- Changed location of support files (MasterStyles.css, ReportTemplate.htm) to the users preferences folder
- Added menu item "Show Support Files on Disk" to the Reports menu. This allows you to quickly find these files for editing in another program.
What's New in Release 3.0 Beta 2
- Added capability to print reports
- Added printing preferences
- Added preference to use arrow keys to move around Input Lists while in editing mode
- Added new "Select" mode for Input Lists. Allows selection of a range of cells.
- Added capability to "Fill Down/Fill Right" cell contents when in Select mode (See Edit menu)
- Added capability to clear selection when in Select mode for Input Lists (See Edit menu)
- Added ability to remove Input List columns (i.e. Stats). If any report uses a Stat then column can not be removed
- Added more default report fields such as Assists, Putouts, Fielding Pct., etc. They are not checked by default.
- Added "Restore Default Reports" menu item (Reports menu).
- Fixed numerous bugs.
- Did some internal restructuring.
What's New in Release 3.0 Beta 1
- Initial Release