How it works…
Google provides a Sheets API which enables applications to access and manipulate Google Sheets. Given a valid URL (website link) and appropriate privileges, the CourtHive Cloud Server uses this API to pull data out of sheets and return data to TMX clients. Data being returned to TMX is organized by Column Names, which means that in order for data to be useable within TMX it must be recognized and mapped to appropriate attributes.
Enabling Access
By default Google Sheets may only be viewed and edited by their creator or owner. In order for the CourtHive Cloud Server to access the data in a Google Sheet, you must Share the sheet.
The first step to share a google sheet is to press the blue Share button in the upper right hand corner of a sheet:
The easiest way to share a google sheet is to click Generate Shareable Link in the dialogue that appears:
Accepted Column Names
Spreadsheet data can only be recognized by TMX if columns have appropriate headings. The table below outlines accepted column names which enable data to be appropriately mapped as player attributes.
Attribute | Accepted Columns | Description |
---|---|---|
ID | ID, UUID, Unique ID, Unique Identifier | Player Unique Identifier |
Name | Name | Parsed into First/Last Names |
Last Name | Last, Last Name | Player Last Name |
First Name | First, First Name | Player First Name |
Gender | Gender, Sex | Player Gender |
Profile | Profile, UTR Profile, UTR Player Profile Link | Link to player on MyUTR.com |
Email, E-Mail | Player E-mail | |
Phone | Phone, Phone Number | Player Phone Number |
Location | Location | City and State |
Rank | Rank, Ranking | Player Ranking |
Rating | Rating | Player Rating |
Birthdate | Birth, Birthdate, Birth Date, Date of Birth | Player’s Birthdate |
Country | Country | Full Country Name |
School | School | Player School Name |
School Abbreviation | School Code, School Abbr, School Abbreviation | Abbreviation for School |
JotForm Example
JotForm is a great way to automate the creation of Google Sheets which can serve as data stores for tournament registrations.
See the JotForm Example for step-by-step instructions.