Bughole Benchrest Scoring System

What's New in Bughole

Version	Comments
1.2.8	5/10/2023 Export now has separate fields for the Export Folder and Export File Name. The folder will default to a folder under the Bughole installation folder with a subfolder name using the shoot name. Clicking the ellipses (…) button allows browsing to select a different folder for export. Export File Name defaults to the shoot name and may be edited if desired. The export file extension changes to .bhl for Bughole Import Format and .csv for CSV Format. If the Export Folder doesn’t exist it will be created. Removed options for customizing the text file export delimiters. Single file CSV is now the only option for text file export. Radio button that was previously labeled Export in Text Format now reads Export in CSV format. Added radio button to allow emailing results to NBRSA. The target email address is nbrsamatchresults@bughole.net and is displayed in a box to the right of the radio button. The email option will generate both Bughole and CSV format files, attach them to the email and send to the displayed address. If required the email address can be edited by selecting Settings from the Edit menu. When you select the Email option, Bughole will check to make sure you have an active internet connection and will not allow that option without one. If you don’t have internet at the range, you can export a Bughole Format file to a thumb drive, then use Bughole on your home computer to import the file, followed by exporting again using the email option. Added Team Types for Super Shoot 49. Shoots already in your database that have teams set up will automatically be assigned to the 4 Man Team type during the database upgrade process. Several team types will be added to the TeamType table (4 Man Teams, First Time Shooters, Women Shooters, Father-Son, Father-Daughter, etc) during the upgrade process. When adding Teams, select the Team Type then click the Add Team button to add each team. Team Types such as First Time Shooters, etc should not be set up with multiple Teams per Team Type. For example, for First Time Shooters you should select the First Time Shooters team type then add a Team named First Time Shooters. Add all of the First Time Shooters to that team. In the Team Report, the shooters in each Team are sorted in descending order, so the highest ranking shooter in each team will be listed first. When printing the Team Report, a separate report must be printed for each Team Type. For each Team Type select the desired Combination Agg then print the report. For this version, text file export for teams is disabled because adding Team Types complicated the export process, and there just wasn’t enough time to complete the code before Super Shoot 49. Text file export for Teams will be re-introduced in a future version. Team Types are included in Bughole format exports and imports so transferring the data between computers will work fine. Modified Equipment List text file export so it will export to a single file rather than exporting to separate files for each combination agg. The file will still include equipment list for all combination aggs even if they don’t make sense (such as 2 gun, 4 gun etc). Whoever is using that file will need to delete the combination aggs that don’t make sense before publishing the data. Added a field to the Shooter table named NbrsaId.
1.2.7	In text file export, shoot name is the default folder name for the export files. Not all characters are legal in file names, so the following characters will no longer be usable in the shoot name field: / \ ? % * : \| " < > . , = These characters will not be displayed if typed into the shoot name field. If you need to use a date in the shoot name, use the dash (-) character to separate day-month-year values. The first and last character in filenames cannot be a space, so leading and trailing spaces are now removed from shoot names when they are saved. In the past this has caused errors when trying to save export files in text format when a space was inadvertently appended to the shoot name. Text file export now defaults to exporting a single CSV (comma separated values) file which is readable by Excel. This file is suitable for emailing to Precision Rifleman for reporting match results. By default the file will be saved in a folder under the Bughole installation folder (usually C:\Program Files (x86)\Bughole) with a filename matching the shoot name and .csv file extension. Clicking the ellipsis (…) button next to the Export Destination field allows the user to choose a different folder for the export destination. Corrected issue in Combination Agg by Competitor Number report where columns beyond the included aggs would display all zeros rather than being blank.
1.2.5	Equipment list is back, accessible through the Tools menu. Equipment list prints at the end of the Combination Agg by Rank report and will be exported using the text file export option. Layout has been modified to match current NBRSA standard layout. Reports have been modified to correct issues with headers being truncated. Team report is now included in text file export. Corrected some window sizing issues that were partially covering scroll bars.
1.2.4	Modified reports and exports to show names as first name first rather than last name first. Corrected some window sizing issues. Corrected an error when exporting in text format. Modified text format export to optionally include shoot name, range, date and agg/combo agg titles. Removed equipment list options since they weren’t working correctly…may reinstate later when problems are corrected.
1.2.0	Created new setup to install correctly on newer operating systems as well as fix report problems.
1.1.11	Added Cash Option, Teams and Cash Option Small Groups. Also corrected problem where you could not blank out a score on the scoring grid.
1.1.9	Corrected problem in new scoring window where pressing the enter key after entering a group would not correctly update the agg. Arrow keys were working fine, but enter key was not. Corrected problem where, during shoot creation, selecting a range with a zero bench count would prevent the shoot from being saved. Also added a check for valid values in the First Bench and Last Bench fields.
1.1.8	Automatic bench assignment now allows specifying starting and ending benches for shoots where match directors opt to only use some of the available benches. Replaced old scoring window with completely new version. The new scoring window works like a spreadsheet allowing entry of groups directly in the grid. Old code that automatically found the next group to be scored was eliminated. These changes were implemented to make it easier to find and correct data entry errors. This will also correct a sporadic problem where entry of a group value would sometimes propagate to multiple shooters and require considerable time to find and correct. Previously use of the decimal was required when entering groups. Groups may now be entered either with or without decimals. If you do not use a decimal, Bughole assumes three decimal places, so you must enter trailing zeros if the group size ends with a zero.
1.1.7	Report modifications. Agg Reports moved Agg column to left next to shooter names to make reading agg easier. Combination Agg reports moved Grand Agg column to left next to shooter names to make reading grand agg easier. Increased font size on all agg and combination agg reports.
1.1.6	Minor maintenance issues. Version not published.
1.1.5	Added Cash Option. A new Games menu item has been added to the main window menu bar. The Games menu contains (for now) only one item…Cash Option. Clicking Cash Option will display the Cash Option Shooters window. To enable Cash Option just add all cash option shooters using this window. The Agg report and Combination Agg by Rank report now indicate cash option shooters with a $ in the leftmost column of the report. The Agg report now includes a subreport (immediately underneath the Small Group winner) which lists the cash option small group winners for all matches. This new subreport will only appear if cash option shooters have been added to the list. Bughole 1.1.5 will automatically upgrade any Bughole database from version 1.1 or higher. Version 1.1.5 requires running the full setup so the option to download only Bughole.exe has been removed from the website.
1.1.4	Version 1.1.3 users who did not download the database that was pre-populated with shooter names will not be able to run Combination Agg reports. This was caused by a missing field in the CombinationAggReport table in the empty database. Version 1.1.4 corrects this problem by automatically adding the field if it is missing. If you already have version 1.1.3, you can get the update by downloading only the updated exe from the link above. After download you will need to unzip the file and copy it to your Bughole installation folder (normally C:\Program Files\Bughole), overwriting the existing Bughole.exe.
1.1.3	IMPORTANT! Starting with version 1.1.3, Bughole is no longer supported on Windows versions earlier than Windows XP. It also requires a minimum of 256 megabytes of ram. Don't try to run Bughole on a 10 year old computer running Windows 98 or Windows 2000! I just don't have time to deal with the problems .
1.1.3	IMPORTANT! Bughole database format has changed and Bughole 1.1.3 will not automatically upgrade a Bughole 1.0 database. There are a few folks with early copies of Bughole 1.1. Bughole 1.1.3 will automatically upgrade those databases. Bughole Setup will attempt to detect an existing Bughole installation. If an installation of Bughole 1.0 is detected, the installation folder of that older version will be renamed to Bughole_OLDVERSION before Bughole Setup installs version 1.1.3. If the existing installation is version 1.1.0001 or higher it will be upgraded in place. Your old shoot data will still be accessible by running the old version of Bughole directly from the Bughole_OLDVERSION folder (normally found under the Program Files folder). There is no way to convert Bughole 1.0 shoot data to Bughole 1.1 format.
1.1.3	Shoot data may now be exported and imported. The file extension for Bughole shoot data is “.bhl”. The old way of exporting shoot data to text files is still available, but the “Bughole Format” is now the default. Note that internally bhl files look sort of like XML, but they are not XML files (this is for you programmer types who might be tempted to import the files into an XML editor).
1.1.3	Report fonts have been changed and reports modified to fit more data on each page. The selected font, Estrangelo Edessa, is a standard font in Windows XP and Windows Vista. It is not shipped with Windows 2000 or Windows 98.
1.1.3	NBRSA tie breaking rules have been added for the following: - Agg Report - Small Group - Combination Agg Reports Ties are indicated by the letter T in the far right column along with a number indicating the results of the tie breaker calculation, for example if three shooters tie, the winner will be indicated by T1, second by T2 and third by T3. Ties for small group are determined by the shooter with the smallest agg, and the correct small group tie winner will be shown at the bottom of the agg report.
1.1.3	A new Flag Sharing window has been added to make assignment of shooters to flag sharing groups easier and less prone to error.
1.1.3	The Flag Sharing Signup list report now prints the shooters signed up for flag sharing. Previously it printed only a blank form for shooters to sign up.
1.1.3	Earlier versions of Bughole had a bug in the shooter pick list that would prevent some names from being visible when using progressive search. For example, in the shooter pick list you could type in the last name “Smith” and Howard Smith would not be in the list of displayed shooters. This bug has been fixed.
1.1.3	Alignment errors on the Mailing Label and Target Label reports have been corrected.
1.1.3	A new report has been added, Combination Agg By Competitor Number.

Match Results