JRaceman Users Guide

Jim McBeath

JRaceman Version 1.2.2, October 4, 2014

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 2 of June 1991 and no other version, the same license as is used for the JRaceman software. A copy of the license is included in the appendix titled "Software License". The GPL is also available on-line.

Abstract

A Free Meet/Race/Regatta Management Program


Table of Contents

How To Use This Guide
I. Overview
1. Introduction
1.1. Features
1.2. Goals
2. Key Concepts
2.1. Definitions
2.2. The Database
2.2.1. Relational Database
2.2.2. Schema
2.2.3. ID Fields
2.3. Progressions
2.4. Scoring
3. Managing JRaceman
3.1. System Requirements
3.2. Installing Java
3.3. Installing JRaceman
3.4. Unpacking the JRaceman Source
3.5. Running JRaceman
3.5.1. On Windows
3.5.2. On Unix
3.6. Upgrading JRaceman
3.7. Client/Server
3.8. Username and Password
II. Using JRaceman
4. Preparing for a Meet
4.1. Creating a New Database
4.2. Entering Meet Data
4.3. Creating a Schedule
4.4. Entering Teams and People
4.5. Entering Registrations
4.6. Entering Entries
4.7. Assigning Lanes
4.8. Scratch Meeting
4.9. Printing Lane Sheets
5. Running a Meet
5.1. Handling Scratches
5.2. Entering Race Results
5.3. Managing Progressions
5.4. Generating Scores and Awards
5.5. Generating Web Reports
6. Producing Reports
6.1. Report Format
6.2. Web Reports Directory
7. Managing the Database
7.1. Creating Backups
7.2. Checking Your Data
7.3. Sharing Data by Import and Export
8. Web Registration
8.1. Overview
8.2. Set Up
8.2.1. Webapp Configuration
8.2.2. Web Registration Options
8.3. Using the Web Interface
8.4. Managing the Web data
III. User Interface
9. Main Window
9.1. Input Tabs
9.2. Separator Bar
9.3. Output Tabs
9.4. Status Line
10. User Interface Elements
10.1. Terms
10.2. Tool Tips and Tool Prompts
10.3. Using Menus
10.4. Using Tabs
10.5. Choice Lists
10.6. Scroll Bars
10.7. Split Panes and Separator Bars
10.8. Tables
10.9. Sheets
10.9.1. Function Keys
11. Menus
11.1. The File Menu
11.2. The Database Menu
11.3. The Tabs Menu
11.4. The Query Results Menu
11.5. The Report Menu
11.6. The Help Menu
12. Batch Mode
13. Top Level Input Tabs
13.1. By Event
13.1.1. Selecting an Event
13.1.2. By Race SQL
13.1.3. Tasks
13.2. Database
13.3. Debug
13.4. Meet Setup
13.5. Plan Setup
13.6. Reports
13.7. Site Setup
13.8. Sport Setup
13.9. Team Setup
14. Input Tabs
14.1. Areas
14.1.1. Query and Edit Tabs
14.1.2. Table
14.2. Awards
14.3. Backup
14.3.1. Creating Backups
14.3.2. The Quick Backup Button
14.3.3. Recovering A Backup
14.4. Challenges
14.4.1. Query and Edit Tabs
14.4.2. Table
14.5. Checks
14.6. Competitions
14.6.1. Query and Edit Tabs
14.6.2. Export
14.6.3. Table
14.7. ComplanRules
14.7.1. Query and Edit Tabs
14.7.2. Table
14.8. Complans
14.8.1. Query and Edit Tabs
14.8.2. Export
14.8.3. Table
14.9. ComplanStages
14.9.1. Query and Edit Tabs
14.9.2. Table
14.10. ContextOptions
14.10.1. Query and Edit Tabs
14.10.2. Available Options
14.10.3. Table
14.11. Debug Change ID
14.12. Debug EditField
14.13. Debug ForeignKeys
14.14. Debug Generate
14.15. Debug Properties
14.16. Debug SQL
14.16.1. Buttons
14.16.2. Commands
14.17. Entries
14.17.1. Query and Edit Tabs
14.17.2. Sheet
14.17.3. Person Entries
14.17.4. Table
14.18. Events
14.18.1. Query and Edit Tabs
14.18.2. Sheet
14.18.3. Table
14.19. Exceptions
14.19.1. Query and Edit Tabs
14.19.2. Table
14.20. Finish
14.20.1. Editing Results
14.20.2. Data Entry Options
14.20.3. Enter Places By Lane
14.20.4. Reports
14.20.5. Table
14.21. Genders
14.21.1. Query and Edit Tabs
14.21.2. Table
14.22. LaneOrder
14.22.1. Query and Edit Tabs
14.22.2. Sheet
14.22.3. Table
14.23. Lanes
14.23.1. Query and Edit Tabs
14.23.2. Sheet
14.23.3. Table
14.24. Levels
14.24.1. Query and Edit Tabs
14.24.2. Table
14.25. Meets
14.25.1. Query and Edit Tabs
14.25.2. Export
14.25.3. Table
14.26. Options
14.26.1. Editing Options
14.26.2. Options
14.26.3. Table
14.27. People
14.27.1. Query and Edit Tabs
14.27.2. Sheet
14.27.3. Table
14.28. Progressions
14.28.1. Query and Edit Tabs
14.28.2. Available Progressions
14.28.3. Table
14.29. Progress
14.29.1. Automatic or Manual Progression
14.29.2. Automatic Progressions
14.29.3. The Auto Progress Action Buttons
14.29.4. Manual Progressions
14.29.5. Table
14.30. Races
14.30.1. Query and Edit Tabs
14.30.2. Sheet
14.30.3. Table
14.31. Registration Fees
14.31.1. Query and Edit Tabs
14.31.2. Sheet
14.31.3. Table
14.32. Registrations
14.32.1. Query and Edit Tabs
14.32.2. Sheet
14.32.3. Table
14.33. Reports.General
14.33.1. Format Choices
14.33.2. Selection Choices
14.33.3. Report Styles
14.34. Schedule
14.34.1. Creating Races
14.34.2. Adding Special Items
14.34.3. Sheet
14.34.4. Using Auto-Increment
14.34.5. Creating a Report
14.34.6. Table
14.35. Score
14.35.1. Reports
14.35.2. Table
14.36. Scoring
14.36.1. Systems Sheet
14.36.2. Query and Edit Tabs
14.36.3. Sheet
14.36.4. Table
14.37. Seeding Lists
14.37.1. Query and Edit Tabs
14.37.2. Sheet
14.37.3. Table
14.38. Seeding Plans
14.38.1. Query and Edit Tabs
14.38.2. Sheet
14.38.3. Table
14.39. SimplanRules
14.39.1. Query and Edit Tabs
14.39.2. Table
14.40. Simplans
14.40.1. Query and Edit Tabs
14.40.2. Export
14.40.3. Table
14.41. SimplanStages
14.41.1. Query and Edit Tabs
14.41.2. Table
14.42. Sites
14.42.1. Query and Edit Tabs
14.42.2. Table
14.43. Stages
14.43.1. Query and Edit Tabs
14.43.2. Table
14.44. Teams
14.44.1. Query and Edit Tabs
14.44.2. Sheet
14.44.3. Export
14.44.4. Table
14.45. Transfer
14.45.1. Sending Data
14.45.2. Receiving Data
14.45.3. Customizing the File Format
15. Output Tabs
15.1. Help
15.1.1. The Help Tab
15.1.2. The Help Menu
15.1.3. Help File Navigation
15.2. Messages
15.3. Query Results
15.4. Report
IV. Appendices
A. Software License
A.1. GNU General Public License
B. Debugging and SQL
B.1. SQL Primer
C. Mckoi Database
D. Index