Statbook Changelog

What's new in Statbook 3.5.4b

Sep 23, 2012
  • Fixed some random Database 19 errors which have come up for more than one user

New in Statbook 3.5.3 (Jun 30, 2011)

  • Fixed issues when duplicating a game (Order field values were not duplicating and related reports were not being displayed correctly)

New in Statbook 3.5.2 (Jun 2, 2011)

  • 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

New in Statbook 3.5.1 (May 30, 2011)

  • 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).

New in Statbook 3.5.0 (May 23, 2011)

  • 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

New in Statbook 3.4.8 (Apr 25, 2011)

  • 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 html tag:
  • 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.

New in Statbook 3.4.7 (Apr 4, 2011)

  • 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

New in Statbook 3.4.6 (Mar 25, 2011)

  • Fixed bug which caused program to unexpectedly quit when changing sets (Games area)

New in Statbook 3.4.5 (Feb 26, 2011)

  • Added some "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.

New in Statbook 3.4.4 (Feb 14, 2011)

  • 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 alighn 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

New in Statbook 3.4.1 (Aug 27, 2010)

  • 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

New in Statbook 3.4 (Jul 17, 2010)

  • 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

New in Statbook 3.3.1 (May 6, 2010)

  • Fixed Windows problem where changes were not being saved
  • Fixed issue of Importing comma-delimited files which were not parsing correctly

New in Statbook 3.3 (Apr 29, 2010)

  • New features:
  • iPhone App Import/Save support
  • Built-in FTP access to upload files directly from Statbook
  • Statbook is now built from a SQL Lite database engine which allows for faster data access and better scalability. Added user benefits include unlimited addition of custom stats, reports and input data.
  • Report generation is now instantaneous as it gets its information directly from a database. (i.e. no progress bar when going to reports)
  • Add input fields to Roster and Games sections (Click on the "Columns" button)
  • Customize Input interfaces
  • Customize reports interface where you can add, edit, remove fields.
  • Custom fields can now be a function of input stats. (e.g. create a field called Total Pitches which adds input fields of Balls and Strikes)
  • Can now Import/Export reports to a file to share with others or import into another application (e.g. Excel or Numbers)
  • Statbook now offers free templates for Basketball and Soccer.
  • List of differences:
  • Editing report fields is now done from the Reports -> Edit Reports... menu item
  • No longer have preference for "Sets" of overall statistics. However, you can create an endless number of "Sets" with the new report interface.

New in Statbook 3.2.2 (Nov 23, 2009)

  • 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.

New in Statbook 3.2.1 (Sep 27, 2009)

  • 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 (MacOS X Only)
  • Internal changes to Editfields and Text Areas.

New in Statbook 3.2 (Apr 17, 2009)

  • Added "Recents" feature where you can now select the File -> Open Recents menu item to select recently opned Statbook files.
  • Combined Intel and PowerPC dowload application into one Universal application which will run on any Mac running MacOS 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.

New in Statbook 3.2 Beta 2 (Mar 31, 2009)

  • 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 applicaiton 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 ... " 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.

New in Statbook 3.2 Beta 1 (Mar 31, 2009)

  • Added "Print All" capabilities where all "Checked" reports in the reports list will now be printed. Use MacOS 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...

New in Statbook 3.1.3 (Mar 2, 2009)

  • 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")

New in Statbook 3.1.2 (Feb 27, 2009)

  • 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) ]

New in Statbook 3.1.1 (Nov 24, 2008)

  • 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)

New in Statbook 3.1 (Oct 17, 2008)

  • Added Basketball and Soccer statkeeping 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).

New in Statbook 3.0.5 (Jul 27, 2008)

  • Fixed problem when trying import an existing Statbook 2.x file (Displayed: "Error occured: PRIMARY KEY must be unique")

New in Statbook 3.0.4 (Jul 21, 2008)

  • 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...'

New in Statbook 3.0.3 (Jul 8, 2008)

  • 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

New in Statbook 3.0.2 (Jul 7, 2008)

  • 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 (Un-checked); Added 'AB' to Boxscore report
  • 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

New in Statbook 3.0 (Jul 2, 2008)

  • Built-in FTP access to upload files directly from Baseball Statbook
  • Statbook is now built from a SQL Lite database engine which allows for faster data access and better scalability. Added user benefits include unlimited addition of custom stats, reports and input data.
  • Report generation is now instantaneous as it gets its information directly from a database. (i.e. no progress bar when going to reports)
  • Add input fields to Roster and Games sections (Click on the "Columns" button)
  • Customize Input interfaces
  • Customize reports interface where you can add, edit, remove fields.
  • Custom fields can now be a function of input stats. (e.g. create a field called Total Pitches which adds input fields of Balls and Strikes)
  • Can now Import/Export reports to a file to share with others or import into another application (e.g. Excel or Numbers)
  • Editing report fields is now done from the Reports -> Edit Reports... menu item
  • No longer have preference for "Sets" of overall statistics. However, you can create an endless number of "Sets" with the new report interface

New in Statbook 3.0 FC 5 (Jun 27, 2008)

  • Changed beta expiration date to July 26, 2008

New in Statbook 3.0 FC 4 (Jun 19, 2008)

  • 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 occured after an import from 2.0 file.
  • Fixed Splitter refresh issues on windows builds
  • Minor appearance improvements

New in Statbook 3.0 FC 3 (Jun 16, 2008)

  • 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) ]
  • 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.

New in Statbook 3.0 FC 2 (Jun 13, 2008)

  • 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.
  • 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 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:
  • 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: )(*&^%$#@!}{|][:;,.?/ _-=~

New in Statbook 3.0 Beta 2 (Jun 9, 2008)

  • Statbook is now built from a SQL Lite database engine which allows for faster data access and better scalability. Added user benefits include unlimited addition of custom stats, reports and input data.
  • Report generation is now instantaneous as it gets its information directly from a database. (i.e. no progress bar when going to reports)
  • Add input fields to Roster and Games sections (Click on the "Columns" button)
  • Customize Input interfaces
  • Customize reports interface where you can add, edit, remove fields.
  • Fields can now be a function of input stats. (e.g. create a field called Total Pitches which adds input fields of Balls and Strikes)
  • Can now Import/Export reports to a file to share with others or import into another application (e.g. Excel or Numbers)
  • Built-in FTP access to upload files directly from Baseball Statbook
  • List of differences
  • Re-ordering, editing and adding fields is now done from the Reports -> Edit Reports... menu item
  • No longer have preference for "Sets" of overall statistics. You can create an endless number of "Sets", however, with the new report interface.