Difference between revisions of "Members.tsv"

From PC2wiki
Jump to: navigation, search
m (Team Member Line: update format)
m (Former Format: add header line, now uses wiki tables for field info)
Line 3: Line 3:
 
==Former Format==
 
==Former Format==
  
The file is only team member information
+
The file contains team member information.  Each file contains
 +
a single header line followed by one or more team member information
 +
lines.
  
===Team Member Line===
+
===Header line ===
  
Field 1 - Team Id (number)
+
{|border="1" cellpadding="2"
  
Field 2 - role (where role is one of the following: Attendee, Coach, Co-coach, Contestant)
+
! Field !! Description !! Example
 +
|-
 +
|1 ||File version label || File_Version
 +
|-
 +
|2|| Version Number || 1
 +
|-
 +
|}
  
Field 3 - Lsst Name
+
===Team Member Information line ===
  
Field 4 - First Name
+
{|border="1" cellpadding="2"
 
+
|+ members.tsv fields
Field 5 - Sex (M or F)
+
! Field !! Description !! Example
 +
|-
 +
|1 ||Team Id (number)|| 1
 +
|-
 +
|2|| role.  Allowed values: Attendee, Coach, Co-coach, Contestant || Coach
 +
|-
 +
|3|| Lsst Name || Doe
 +
|-
 +
|4|| First Name || Jane
 +
|-
 +
|5|| Sex (M or F) || M
 +
|-
 +
|}
  
 
==Former Format==
 
==Former Format==

Revision as of 22:24, 21 October 2017

The members.tsv file is a tab separated file that contains membership information about a team including: roles, university name, coach and other members of the team (like alternates)

Former Format

The file contains team member information. Each file contains a single header line followed by one or more team member information lines.

Header line

Field Description Example
1 File version label File_Version
2 Version Number 1

Team Member Information line

members.tsv fields
Field Description Example
1 Team Id (number) 1
2 role. Allowed values: Attendee, Coach, Co-coach, Contestant Coach
3 Lsst Name Doe
4 First Name Jane
5 Sex (M or F) M

Former Format

The file is composed of Team Info lines and team member lines. Each team starts with a single Team Info Line and is followed by one or more Team Member lines.

Team Info Line

Field 1 - external id

Field 2 - University Name

Team Member Line

Field 1 - Full Name (First Last)

Field 2 - role (where role is one of the following: Attendee, Coach, Contestant)

For example (where <tab> is a tab character)

8654<tab>California State University at Sacramento
John Clevenger<tab>Coach
Sam Ashoo<tab>Contestant
Troy Boudreau<tab>Contestant
Doug Lane<tab>Attendee