Home › PUMA Open Competitions › PUMA Open Competitions – Import Entrants from Excel

PUMA Open Competitions – Import Entrants from Excel

Posted on Posted in PUMA Open Competitions

It is now possible to import competition entrants from an Excel spreadsheet. The format of the spreadsheet used for importing competitor information must contain all of the following columns, the column names must be typed into the first row of the spreadsheet and must be typed exactly as shown below:-

  • Tee Time
  • Player 1 CDH ID
  • Player 1 Name
  • Player 1 Club
  • Player 2 CDH ID
  • Player 2 Name
  • Player 2 Club
  • Player 3 CDH ID
  • Player 3 Name
  • Player 3 Club
  • Player 4 CDH ID
  • Player 4 Name
  • Player 4 Club

an example spreadsheet is available from the downloads section of the website.

If you are running a singles or pairs competition then some of the columns can be left blank (e.g. player 3 and player 4 information) but the columns must exist in the spreadsheet. The system will import competitor information from a CDH number, or you can enter their name and club into the spreadsheet. If all the information is entered i.e. CDH number, name and club, the information from the CDH is checked against the name and club that you have entered into the spreadsheet. If you do not have the information, leave the column blank and the system will import what it can.

When run the import, the system first checks each tee time to see whether any information has been entered for player 1. If there is nothing currently in the startsheet for player 1, it then checks whether a CDH number has been entered for player 1 in the spreadsheet. If so, the CDH is queried to get the player’s name, club and handicap. If the player’s name and club information has also been entered into the spreadsheet (in addition to the CDH number) the system will check the data on the spreadsheet against the information from the CDH and display an error message if they are not the same. If no CDH number has been entered for player 1, the system just copies the name and club from the spreadsheet into the PUMA system. This process is then repeated for players 2, 3 and 4.