French WHS Customer can export event results to a CSV file to submit scores to the French Golf Federation (Fédération Française de Golf).
In this article, we will discuss the content of the file and how to download it.
How to Export Tournament Results
To export tournament results to a CSV file, follow these directions:
Navigate to the Golfers Tab.
Click "Export Results for WHS."
Select the Tournament for which to export scores in a CSV format (as shown below). Note: The list contains only Stroke Individual Tournaments (both single and multi-round).
Click "Export."
Click "Download CSV" and the file will be downloaded to your computer.
CSV File Content
The generated CSV file is structured according to the template provided by the French Golf Federation. The following columns are present and populated in the downloaded CSV. Each row represents the score of a player in one of the included rounds from the selected tournament when exporting the scores:
Tournament Local UID: Local tournament ID in Golf Genius. Persistent ID if multi-round (ID of over_tournament).
Player Local UID: Member card ID in Golf Genius
Organizing Golf ID: Always default ID to 8023 for FFG federal tournaments
Tournament Name: Local tournament name in Golf Genius
Round Date: Round date set in Golf Genius for the exported score in YMD format.
Round Number: Round index within the Golf Genius event. Eg. 1,2,3,4
Score Format: Single, always 1
Score Formula: Strokeplay, always 01. Not supported: Stableford, 02
Nb Holes Played: 1, 2, or 3. 1: 9 Holes Out 2: 9 Holes In 3: 18 holes (always 3 for our tournaments, so can be omitted). We support all values, though.
License Number: Specific FFG Custom Field Numéro de licence ffgolf
Gender: Member gender
Last Name: Member's last name
First Name: Member's first name
Nationality: ISO3 code computed from Country Custom Field (France - FRA)
Result Status: Player disposition. 00 : Normal 10: W/D 30 : DSQ 50 : NoReturn 60 : Miss Cut
Score: Example: 060305040405040504050302040404030305.
For 9 holes, the part not played is filled with zeros.
Missing scores marked as 0.
X scores marked as 0.
Inside that variable we store all 18 holes (VARCHAR2(36)).
If score value < 10 - add leading 0, Otherwise keep it as it is.
Competition HCP: Competition HCP (example -1), aka playing handicap.
Handicap Index: Handicap Index (example -0,6)
The following columns are present in the download but must be populated by the manager:
Host Golf ID
Course ID
Tee ID