Knowledgebase: Clubs
New Club Importer Template: Fix all the cells which are highlighted yellow
Posted by Marney Shepherd on 29 August 2017 01:55 PM

Before you can create an upload file, you need to fix all the yellow cells highlighted in the template.  Please refer to the below table on how to fix these yellow cells:

Column Field Notes Why is the field yellow? (Can be one or more of these reasons)
B LastName Every row requires a last name.
  1. Missing information (this is a mandatory field)
  2. Has exceeded the character limit for last names (eg. Too long)
  3. Has a special character which needs to be removed (eg. # * : )
  4. Has blank space(s) before or after text which need to be removed
C FirstName Every row requires a last name.
  1. Missing information (this is a mandatory field)
  2. Has exceeded the character limit for first names (eg. Too long)
  3. Has a special character which needs to be removed (eg. # * ; : )
  4. Has blank space(s) before or after text which need to be removed
D MiddleName

Not mandatory - can leave blank.

Please do not write null, none, N/A, no or anything similar in this field if you do not have data.  This field can be left blank.

  1. Has exceeded the character limit for middle names (eg. Too long)
  2. Has a special character which needs to be removed (eg. # * ; : )
  3. Has blank space(s) before or after text which need to be removed
E Email

Every row requires a valid email address eg. example@gmail.com

Please do not write null, none, N/A, no or anything similar in this field if you do not have data.  This field can be left blank

  1. Missing information (this is a mandatory field)
  2. Not a valid email address (check it has a @)
  3. Has a special character which needs to be removed (eg. # * ; : )
  4. Has exceeded the character limit for email addresses (eg. Too long)
  5. Has blank space(s) before or after text which need to be removed
F BirthDate Birthdate needs to be in the past and in format DD/MM/YYYY
  1. Missing information (this is a mandatory field)
  2. Not in a valid format (eg. Needs to be DD/MM/YYYY)
  3. A date in the future (date after today)
  4. A date too far back in the past (date before 1 January 1930)
  5. Has a special character which needs to be removed (eg. # * ; : )
G StateAssociation Needs to be a selection from the drop down list
  1. Missing information (this is a mandatory field)
H Gender Needs to be a selection from the drop down list
  1. Missing information (this is a mandatory field)
I WorkPhone

Not a mandatory field but needs to be correct format for fixed lines and mobile numbers.

Please do not write null, none, N/A, no or anything similar in this field if you do not have data.  This field can be left blank

  1. Has a special character which needs to be removed (eg. # * ; : )
  2. Not in the correct format:
    1. fixed lines need to be in ## #### #### (eg. 07 8956 8958)
    2. mobile numbers need to be in #### #### #### (eg. 0423 858 858)
  3. Has blank space(s) before or after text which need to be removed
J HomePhone

This is a mandatory fields and needs to be in the correct format for fixed lines and mobile numbers

Please do not write null, none, N/A, no or anything similar in this field if you do not have data.  You must add a phone number.

  1. Missing information (this is a mandatory field)
  2. Has a special character which needs to be removed (eg. # * ; : )
  3. Not in the correct format:
    1. fixed lines need to be in ## #### #### (eg. 07 8956 8958)
    2. mobile numbers need to be in #### #### #### (eg. 0423 858 858)
  4. Has blank space(s) before or after text which need to be removed
K Fax

Not a mandatory field but needs to be correct format for fixed lines and mobile numbers.

Please do not write null, none, N/A, no or anything similar in this field if you do not have data.  This field can be left blank

  1. Has a special character which needs to be removed (eg. # * ; : )
  2. Not in the correct format:
    1. fixed lines need to be in ## #### #### (eg. 07 8956 8958)
    2. mobile numbers need to be in #### #### #### (eg. 0423 858 858)
  3. Has blank space(s) before or after text which need to be removed
L Mobile

Not a mandatory field but needs to be correct format for fixed lines and mobile numbers.

Please do not write null, none, N/A, no or anything similar in this field if you do not have data.  This field can be left blank

  1. Has a special character which needs to be removed (eg. # * ; : )
  2. Not in the correct format:
    1. fixed lines need to be in ## #### #### (eg. 07 8956 8958)
    2. mobile numbers need to be in #### #### #### (eg. 0423 858 858)
  3. Has blank space(s) before or after text which need to be removed
M Address1

Mandatory field. Do not put suburb in this field.

Please do not write null, none, N/A, no or anything similar in this field if you do not have data.  You must add a street address.

  1. Missing information (this is a mandatory field)
  2. Has exceeded the character limit for addresses (eg. Too long)
  3. Has a special character which needs to be removed (eg. # * ; : )
  4. Has blank space(s) before or after text which need to be removed
N Address2

Not mandatory - can leave blank. Do not put suburb in this field.

Please do not write null, none, N/A, no or anything similar in this field if you do not have data.  This field can be left blank.

  1. Has exceeded the character limit for addresses (eg. Too long)
  2. Has a special character which needs to be removed (eg. # * ; : )
  3. Has blank space(s) before or after text which need to be removed
O Address3

Not mandatory - can leave blank. Do not put suburb in this field.

Please do not write null, none, N/A, no or anything similar in this field if you do not have data.  This field can be left blank.

  1. Has exceeded the character limit for addresses (eg. Too long)
  2. Has a special character which needs to be removed (eg. # * ; : )
  3. Has blank space(s) before or after text which need to be removed
P City

Mandatory field.  This is where the athlete's suburb is entered.

Please do not write null, none, N/A, no or anything similar in this field if you do not have data.  You must add a suburb.

  1. Missing information (this is a mandatory field)
  2. Has exceeded the character limit for city field (eg. Too long)
  3. Has a special character which needs to be removed (eg. # * ; : )
  4. Has blank space(s) before or after text which need to be removed
Q State Needs to be a selection from the drop down list
  1. Missing information (this is a mandatory field)
R PostalCode Needs to be 4 numbers and for NT postcodes start with 08
  1. Missing information (this is a mandatory field)
S EmergencyContact

Not mandatory - can leave blank.  Please use real names.  

Please do not write mother, null, none, N/A, no or anything similar in this field if you do not have data. 

  1. Has exceeded the character limit for names (eg. Too long)
  2. Has a special character which needs to be removed (eg. # * ; : )
  3. Has blank space(s) before or after text which need to be removed
T EmergencyNumber

Not a mandatory field but needs to be correct format for fixed lines and mobile numbers.

Please do not write null, none, N/A, no or anything similar in this field if you do not have data.  

  1. Not in the correct format:
    1. fixed lines need to be in ## #### #### (eg. 07 8956 8958)
    2. mobile numbers need to be in #### #### #### (eg. 0423 858 858)
  2. Has blank space(s) before or after text which need to be removed
U GuardianAddress

Not mandatory - can leave blank.

Please do not write null, none, N/A, no or anything similar in this field if you do not have data.  This field can be left blank

  1. Has a special character which needs to be removed (eg. # * ; : )
  2. Has exceeded the character limit for addresses (eg. Too long)
  3. Has blank space(s) before or after text which need to be removed
V Gymsport Please select from the drop down list of correct codes. For more information about which code to select, please look at the Athlete Coding guide
  1. If this athlete has never been in the database, you will need to enter a gymsport
  2. If you do not select a gymsport, existing athletes will remain at the same gymsport as what is already in the database.
  3. Please refer to this page for more information.
W Level Please select from the drop down list of correct codes. For more information about which code to select, please look at the Athlete Coding guide
  1. Levels will only display once you have selected a gymsport (you will see an error message that the cell or chart you are trying to change is on a protected sheet if you select level before gymsport)
  2. If this athlete has never been in the database, you will need to enter a Level
  3. If you do not select a level, existing athletes will remain at the same level as what is already in the database
  4. Please refer to this page for more information.
X DateAchieved

Not mandatory - if left blank then it will populate today's date in the upload file

Please do not use 0/0/0001 as it creates bad data in the database.

  1. Not in a valid format (eg. Needs to be DD/MM/YYYY)
  2. A date in the future (date after today)
  3. A date too far back in the past (date before 1 January 1930)
  4. Has a special character which needs to be removed (eg. # * ; : )

 

Go back to Getting Started with New Club Importer Template page.

Need more help?  Please raise a support ticket.

(0 vote(s))
Helpful
Not helpful

Comments (0)