|
A reasonable mapping between NeatClubs.COM registration fields and Clublink is show below. Note that the web-site account holder is assumed to be the principal guardian in our recommended configuration. (Clublink for historical reasons uses the database fields "MOTHF_NAME" and "MOTHL_NAME" to represent the principal guardian. This is true even through the role of the first guardian may have a role other than mother. This does make things a little confusing!)
Our template registration definition (available on request and importable into any NeatClubs.COM service instance to avoid the need to type this information) adheres to the approach shown below. This event definition is intentionally exhaustive. Most organizations will not want to capture all of these fields. Our logic in being complete is that it is easier to remove fields rather than add fields from scratch.
Note that NeatClubs.COM fields are configurable while Clublink fields (with a few exceptions) are static. This means it is possible to configure registration events where more data is gathered than can be accommodated in Clublink. In such examples registrations may also be exported to an Excel spreadsheet or CSV file.
Web-site Account Holder Field Mappings
Descriptive Text
|
|
Field Type
|
Choices (if applicable)
|
|
Clublink Field to Export to
|
Login
|
|
Text
|
|
|
-
|
Password
|
|
Text
|
|
|
-
|
First Name
|
|
Text
|
|
|
MOTHF_NAME
|
Last Name
|
|
Text
|
|
|
MOTHL_NAME
|
Phone Number
|
|
Phone
|
|
|
PHONE2
|
E-Mail
|
|
E-Mail
|
|
|
EMAIL
|
Event Level Data Collection Field Mappings
Descriptive Text
|
|
Field Type
|
Choices (if applicable)
|
|
Clublink Field to Export to
|
Information about Registrant
|
Heading
|
|
|
|
What is your relationship to the participant?
|
Multiple Choice
|
Mother,Father etc.
|
|
RELATION1
|
Click here if you are the primary guardian
|
Checkbox
|
|
|
CONTACT1
|
Participant Information
|
|
Heading
|
|
|
-
|
First Name
|
|
Text
|
|
|
FIRST_NAME
|
Last Name
|
|
Text
|
|
|
LAST_NAME
|
Birthdate
|
|
Date
|
|
|
BIRTHDATE
|
Age
|
|
Numeric
|
|
|
AGE
|
Gender
|
|
Radio / pick one
|
M,F
|
|
SEX
|
Home Phone
|
|
Phone
|
|
|
PHONE1
|
Alternate Phone
|
|
Business Phone
|
|
|
PHONE6
|
Participant Mailing Address
|
Heading
|
|
|
|
Street Address
|
|
Text
|
|
|
ADDRESS
|
Apt/Unit
|
|
Text
|
|
|
APT
|
Town or City
|
|
Text
|
|
|
CITY
|
Province
|
|
Multiple Choice
|
ON,BC,QC,AL,SK,MB ..
|
|
PROVINCE
|
Postal Code
|
|
Text
|
|
|
POST_CODE
|
Second Guardian
|
|
Heading
|
|
|
|
Last Name
|
|
Text
|
|
|
FATHL_NAME
|
First Name
|
|
Text
|
|
|
FATHF_NAME
|
Occupation
|
|
Text
|
|
|
FATHOCCUP
|
Phone Number
|
|
Phone
|
|
|
PHONE3
|
What is this persons relationship to the participant?
|
Multiple Choice
|
Mother,Father etc.
|
|
RELATION2
|
Click here if this is the primary guardian
|
Checkbox
|
|
|
CONTACT2
|
Medical Information
|
|
Heading
|
|
|
|
Medical Number
|
|
Text
|
|
|
MEDNUM
|
Medical Information
|
|
Free Format
|
|
|
MEDNOTE
|
Doctor
|
|
Heading
|
|
|
|
Last Name
|
|
Text
|
|
|
DOCL_NAME
|
First Name
|
|
Text
|
|
|
DOCF_NAME
|
Phone Number
|
|
Phone
|
|
|
PHONE5
|
Emerg Contact
|
|
Heading
|
|
|
|
Last Name
|
|
Text
|
|
|
EMERL_NAME
|
First Name
|
|
Text
|
|
|
EMERF_NAME
|
Phone Number
|
|
Phone
|
|
|
PHONE4
|
Additional Information
|
|
Heading
|
|
|
|
Other Information
|
Free Format
|
|
|
NOTES
|
|