ARTICLE: Loading Student Data Manually

ARTICLE: Loading Student Data Manually

We are able to automatically pull in data from most major Student Information Systems. Please contact us for details.

Download the Data Template

  1. Navigate to Data Management > Import Data .
  2. Click Download Data Importer Template File on the left.


Data Entry

Do not change any of the headings in the .csv file. It will cause the data load to fail. 

COLUMN
HEADER
DESCRIPTION
A
BOARDER PK
If you are using an external database, you can enter the student's primary key here for easier mapping. If you are not using a database, you still MUST enter a unique identifier for the boarder here.
B
FIRST NAME
Enter the student's first name as it should appear in the portal.
C
LAST NAME
Enter the student's last name as it should appear in the portal.
D
PREFERRED NAME
You can assign a preferred name that replaces or appears beside the student's name in the portal.
E
ADDRESS 1
Enter the first line of the student's home address.
F
ADDRESS 2
Enter the second line of the student's home address.
G
SUBURB
Enter the town or suburb of the student's home address.
H
STATE
Enter the state or province of the student's home address.
I
POSTCODE/ZIP
Enter the postcode or zip code of the student's home address.
J
COUNTRY
Enter the country of the student's home address.
K
HOME PHONE
Enter the student's home phone number.
L
WORK PHONE
Enter the student's work phone number.
M
MOBILE/CELL
Enter the student's mobile phone number.
N
EMAIL
Enter the student's email address.
O
GENDER
You may enter Male, Female or Unspecified.
P
DOB
Use the format YYYY-MM-DD
Q
YEAR/GRADE
Enter the year or grade the student is in. Refer to System Configuration > Lookups for the list of years and grades already built into your portal.  If you enter a year or grade that is not listed, REACH will automatically create it for you.
R
HOUSE
Enter the dorm the student is in. Refer to System Configuration > Lookups for the list of dorms already built into your portal.  If you enter a dorm that is not listed, REACH will automatically create it for you.
S
ROOM NUMBER
Enter the student's room number.
T
GROUPS
Enter any groups the student is part of; separated by commas. Refer to System Configuration > Groups for the list of groups already built into your portal.  If you enter a group that is not listed, REACH will automatically create it for you.
U
CONTACT PK
If you are using an external database, you can enter the parent or guardian's primary key here for easier mapping. If you are not using a database, you still MUST enter a unique identifier for the contact here.
V
RELATIONSHIP
Enter the contact's relationship to the boarder.  You can enter any string into this field.
W
FIRST NAME
Enter the contact's first name as it should appear in the portal.
X
LAST NAME
Enter the contact's last name as it should appear in the portal.
Y
ADDRESS 1
Enter the first line of the contact's home address.
Z
ADDRESS 2
Enter the second line of the contact's home address.
AA
SUBURB
Enter the town or suburb of the contact's home address.
AB
STATE
Enter the state or province of the contact's home address.
AC
POSTCODE/ZIP
Enter the postcode or zip code of the contact's home address.
AD
COUNTRY
Enter the country of the contact's home address.
AE
HOME PHONE
Enter the contact's home phone number.
AF
WORK PHONE
Enter the  contact's  work phone number.
AG
MOBILE/CELL
Enter the contact's mobile phone number.
AH
EMAIL
Enter the  contact's  email address.
AI
BOARDER USERNAME
Enter the username that the student will use to log into the portal.
AJ
BOARDER PASSWORD
Enter the password that the student will use to log into the portal. You can leave this field blank and send a Welcome Wizard Email to allow the student to set their password themselves.
AK
CONTACT USERNAME
Enter the username that the contact will use to log into the portal. Leave this field blank if you do not want this contact to be able to log into your portal.
AL
CONTACT PASSWORD
Enter the password that the contact will use to log into the portal. Leave this field blank if you do not want this contact to be able to log into your portal.

If multiple contacts need to be associated to a boarder, duplicate ALL boarder details to a new line and ONLY change the contact details from column U to AH

Uploading Data

Do NOT send sensitive data to us via email
You can upload your data to your REACH portal in one of two ways:
  1. Upload your spreadsheet at  securedrop.reach.cloud  and we will load your data for you.
  2. You can also upload your data yourself by navigating to Data Management > Import Data and follow the on-screen instructions.

    • Related Articles

    • ARTICLE: Loading Staff Data Manually

      We are able to automatically pull in data from most major Student Information Systems. Please contact us for details. Download the Data Template Navigate to Data Management > Export Data . Click Download Staff Data Importer Template File near the ...

    • ARTICLE: Bulk Photo Upload

      You can upload student and staff contact images in bulk using the Bulk Image Importer. Requirements of Image Files File Type Preference = JPG or PNG is preferable Image Dimensions = Aspect Ratio of 1:1 (size 300px x 300px) File Size limit = <2MB File ...

    • ARTICLE: Instant Reports – Contact Data Integrity Report

      The Contact Integrity Report automatically generates data based on the items missing from the imported user contact details, as Reach requires a minimum amount of data to use that contact profile throughout your schools Reach Portal. Go To: Reporting ...

    • ARTICLE: Contact Bulk Data Management

      Contact Bulk Data Management allows for an efficient way to view and manage the following associations as they relate to users: UDFs Groups Contact Flags Groups Managed Restrictions Medical Conditions Identifiers Medications For example, to remove ...

    • ARTICLE: How to setup Emergency Contacts

      The emergency contact details for any Reach user can be setup view their individual profile. Main Menu >>People Management >> View Contacts >> Profile View Contacts The People Management page presents current/active contact profiles via a table view, ...