Registration Spreadsheet

All common spreadsheet programs can save a page as a 'Comma Separated Values' (.csv) text file. This file is read by the 'import registration' dialog that will establish a map from the spreadsheet data to the registration fields. This map will process the first 16 columns of data, and the first three rows as possible header information to initialize the field map. A sample spreadsheet is included in the sample files zip download.

External Data Identification Keywords

The following keywords are recognized as pointers to information in the C_Scor registration records. Data tagged with these names will be automatically mapped to the correct input field.

sailNum

Sail Number

altNum

bowNum

Alternate Sail Number or Bow Number

boatName

Boat Name

regFleet

Fleet Letter Code - Future program versions may provide a map from the name to the letter code

rptGroup

Report Group name

skipperName/dt>

crewName

Skipper and Crew Names

From

From Club Name

Address

Mailing Address - Multi line field

phoneNum

Phone Number

eMail

E-Mail Address

Comment

Scorers Comment

The Following fields are user for Handicap finish correction and User Defined fields

boatType

Boat Type Name or Description

PHRF

PHRF Handicap correction number

Napy

US-Sailing Portsmouth Handicap NAPY code

User1, User2" User3, User4, User5

User Defined Fields

Bar Code Registration

The support programs included with the C_Scor package provide support for use of QR-code to store the registration record string in the bar code image. The process operates in two phases, the first uses a web form to collect the information and set up a image of the QR-code. The resulting registration page is printed by the user and handed in to complete the registration. The 'QRregistration.js' script (in the Samples.zip package) handles the search for keyword field names in the form and generation of a valid registration record, and conversion to an image using a free on-line service.

The bar-code is read by a scanner program and the registration record string input to the c_scor program for possible edit and validation. My setup uses a simple webcam with a lens from a pair of reading glasses (+2.5D) to bring the focus to about 8 inches, where the bcwebcam program can easily process the image and append a tab character to force c_scor to process the record.