|
Optional fields can be left off the spread sheet. Required fields have to have a column heading with the same name as the field name.
|
| No. |
Field name |
Description |
Notes to upload excel file |
| 1. |
Adult1First |
Required |
|
| 2. |
Adult1Middle |
Optional |
|
| 3. |
Adult1Last |
Required |
|
| 4. |
Adult2First |
Optional |
|
| 5. |
Adult2Middle |
Optional |
|
| 6. |
Adult2Last |
Optional |
|
| 7. |
Street |
Required |
|
| 8. |
City |
Required |
|
| 9. |
State |
Required |
|
| 10. |
Zip |
Required |
|
| 11. |
Country |
Optional |
Leave blank for USA |
| 12. |
PrimaryEmail |
Optional |
|
| 13. |
SecondaryEmail |
Optional |
|
| 14. |
Adult1Dob |
Optional |
Must be in MM/DD/YYYY |
| 15. |
Adult1Gender |
Optional |
M-Male,F-Female |
| 16. |
Adult2DOB |
Optional |
Must be in MM/DD/YYYY |
| 17. |
Adult2Gender |
Optional |
M-Male,F-Female |
| 18. |
PlayerFirst |
Required |
|
| 19. |
PlayerMiddle |
Optional |
|
| 20. |
PlayerLast |
Required |
|
| 21. |
PlayerGender |
Required |
M-Male,F-Female,B-Boy,G-Girl |
| 22. |
PlayerDOB |
Required |
Must be in MM/DD/YYYY |
| 23. |
PlayerEmail |
Optional |
Levae blank if not exists we will use parent emaild address |
| 24. |
JerseyNumber |
Optional |
|
| 25. |
MedicalCondition |
Optional |
Leave this blank if there is no medical condition |
| 26. |
EmergencyContact |
Optional |
|
| 27. |
EmergencyPhone |
Optional |
|
| 28. |
School |
Optional |
|
| 29. |
Grade |
Optional |
|
| 30. |
MembershipNumber |
Optional |
|
| 31. |
SeasonName |
Required for team import |
|
| 32. |
LeagueName |
Required for team import |
|
| 33. |
TeamName |
Required for team import |
|
| 34. |
AssignmentDate |
Optional |
Must be in MM/DD/YYYY |
| 35. |
Rating |
Optional |
|
| 36. |
WorkPhone |
Optional |
|
| 37. |
CellPhone |
Optional |
|
| 38. |
HomePhone |
Optional |
|
| 39. |
Insurance |
Optional |
|
| 40. |
InsuranceID |
Optional |
|
| 41. |
DoctorName |
Optional |
|
| 42. |
DoctorPhone |
Optional |
|
| 43. |
Adult1TeamJob |
Required for coach import |
Must be same as in the SportsManager |
| 44. |
Adult2TeamJob |
Required for coach import |
Must be same as in the SportsManager |
| 45. |
PlayerPhCell |
Optional |
Levae blank if not exists we will use parent cell phone |