ScoreKeeper (tm) software / Version 6.5 or later "Clubhouse" package Notes for website developers -by- Mark II Systems P O Box 366, Long Valley, NJ, USA, 07853 908-850-5252 ---------------------------------------------------------------------------- Who should read these notes? ScoreKeeper "Clubhouse" software packages include a "Web-based Score Entry" feature which enables score posting by golfers through a user-provided website, with subsequent download of those scores into ScoreKeeper. Web pages needed on the user's website for this purpose are provided free of charge at www.scorekeeper.com. For users who prefer to develop their own web pages, the specifications below must be followed in creating the file of scores to be downloaded into ScoreKeeper. If you plan to use the web pages provided at www.scorekeeper.com, you do NOT need these notes; those web pages already provide the needed format for download into ScoreKeeper. Use these notes only if you plan to develop your own web pages "from scratch". These notes describe the file format which must be followed when creating the file of scores to be downloaded from the user's website into ScoreKeeper. This file format applies to ScoreKeeper version 6.5, build #1050 or later. The file of scores for download is a comma-delimited ASCII text file. Each line of the file (record) reports a single score and must contain at least 11 and at most 29 fields, each enclosed in quotation marks and separated by commas. The first 10 fields of each record report total (non-hole-by-hole) scores. Following these 10 fields, an additional 9 or 18 fields may be included in each record, these containing the golfer's hole-by-hole scores for 9 or 18 holes of play. Finally, each record ends with a field containing the date the score was posted on the web. All of these fields are described in detail below. A file of scores may contain a mix of records of different lengths, some containing 11 fields (for reporting total scores, not hole-by-hole scores), some containing 20 fields (for 9-hole, hole-by-hole scores), and some containing 29 fields (for 18-hole, hole-by-hole scores). Description of first 10 fields of each record: ---------------------------------------------- Every record in the file of scores must begin with these 10 fields. Golfers ID: This field must contain the golfer's ID code as recorded in ScoreKeeper. This field is case-insensitive, e.g. entries such as "JONES" and "jones" are treated identically. Golfer's last name: This field must contain the golfer's last name as recorded in ScoreKeeper. It is case-insensitive. Golfer's first name: This field must contain the golfer's first name as recorded in ScoreKeeper. It is case-insensitive. (Note: when scores are downloaded into ScoreKeeper, consistency checks are performed to assure that the ID and name reported by the golfer match those on file in ScoreKeeper. If a mismatch is found, ScoreKeeper will report that the reported score is unusable. These consistency checks allow for some variation between the name as recorded by the golfer and the name on file in Scorekeeper. For example, "Smith, William" would be an acceptable match for "Smith, Bill".) Date of play: This field must contain the date on which play occurred. It must contain 8 characters, in MM/DD/YY format. Number of holes played: For non-hole-by-hole scores, this field must contain either "18" or "9". For hole-by-hole scores, this field may be left blank (""), and any characters contained in it are ignored. Golf course identifier: This field may contain "home", "away", or the name of any on-file golf course as recorded in ScoreKeeper. This field is case- insensitive. Any of the identifiers may be used when reporting total score, but the identifiers "home" and "away" may not be used with hole-by-hole scores; an on-file course name must be used in that case. When an on-file course name is used, the reported number of holes played (9 or 18, see above) or the number of individual hole scores reported must match the number of holes in the golf course (9 or 18). Otherwise, ScoreKeeper will report that the reported score is unusable. Course Rating: If the golf course identifier field (see above) contains "away", the value reported in this field will be recorded with the score; otherwise it is ignored. If the golf course identifier field contains "home", the course rating of the home course designated in the golfer's profile in ScoreKeeper is recorded with the score. (One half of the on-file Course Rating value is used if the golfer reports 9 holes of play, but his/her home course is 18 holes.) If the golf course identifier contains the name of an on-file golf course, the Course Rating of that on-file course as recorded with the score. Slope Rating: This field is handled in the same way as the Course Rating field above, except that there is no correction needed for 9 vs. 18 holes of play; the Slope Rating is the same in both cases. Total score: For non-hole-by-hole scores, this field must contain the golfer's total score, adjusted for Equitable Stroke Control (i.e. the golfer's posted score). For hole-by-hole scores, this field may be left blank (""), and any characters contained in it are ignored. Tournament score indicator: This field may contain the character "T" to indicate a tournament score, or may be left blank (""). This field is case-insensitive. Description of optional hole-by-hole fields of each record: ----------------------------------------------------------- If hole-by-hole scores are included in a record, there must be exactly 9 or 18 fields appended to the 10 fields described above. If any other number of fields is appended, ScoreKeeper will report that the recorded score is unusable. Each of the hole-by-hole fields must contain a 1- or 2-character numerical entry with a value ranging from 1 to 10 for par-3 holes, and ranging from 2 to 11 for other holes. As with all fields, these fields must be enclosed in quotation marks and must be separated by commas. Description of Date-of-posting field: -------------------------------------- For all score records (total score or hole-by-hole scores) the final field in each score record must contain the date on which the score was posted by the golfer on the uers's website. This field must be in MM/DD/YY format, enclosed in qoutation marks. Sample file of scores: ----------------------- Shown below is an example of the needed file format. It includes examples of: - total-score records - 9-hole, hole-by-hole score records - 18-hole, hole-by-hole score records. Your website must create a file named ScoreKeeperWebScores.TXT which matches this format. ScoreKeeper "Clubhouse" software (V6.5, build #1050 or later) will then be able to download and read the scores contained in that file. Example records follow ... "IDID","LastName","FirstName","05/11/03","18","home","","","88","t","06/13/03" "IDID","Last","First","06/01/03","18","away","67.5","111","89","","06/13/03" "IDID","Last","First","06/11/03","9","away","36.5","111","45","","06/13/03" "IDID","Last","First","06/12/03","9","OnFile9HoleCourseName","","","44","","0 6/13/03" "IDID","Last","First","06/13/03","","OnFile9HoleCourseName","","","","","5"," 4","3","5","4","3","5","4","3","06/13/03" "IDID","Last","First","06/15/03","","OnFile18HoleCourseName","","","","T","5" ,"4","3","5","4","3","5","4","3","6","4","3","6","4","3","6","4","3","06/13/03" "IDID","Last","First","06/16/03","","OnFile18HoleCourseName","","","","","11" ,"10","9","8","7","6","5","4","3","2","1","11","10","9","8","7","6","5","06/13 /03"