Hallways School Counseling Software | Importing Student Data

HALLWAYS HOME | SUPPORT HOME | REGISTER | REPORT A BUG |CONTACT US

Hallways⁴ > Support > Getting Started > Importing Student Data

Importing Student Data: Step 1

Hallways Modules

Quick Links
Student Records Importing Student Data: Step 2
Module Components
Getting Started Installation Starting Hallways Importing Student Data Step 1: Organizing Data Step 2: Importing Data Importing PEIMS Data Changing Counselor Information Password Navigation Setting Hallways Defaults

Hallways 4 comes with the ability to import student data directly into Hallways from Excel.

Organizing Student Data

In Microsoft Excel, open the Hallways Import Data.xls file that came with your CD. It should be in the C:\Program Files\Hallways\ folder. If not, copy the file from your CD to a location on your computer.

The student data should be organized as follows:

COL.	Field Name	Data Type	Explanation
A	ID	General	Student's unique Local ID number
B	LastName	General	Last Name
C	FirstName	General	First Name
D	Initial	General	Middle Initial
E	Address	General	Street Address
F	City	General	City
G	State	General	State
H	PostalCode	General	Zip Code
I	HomePhone	General	10 digit phone number: numbers only, no dashes
J	Gender	General	Student Gender: M or F
K	Birthdate	Date/Time	Birthdate: must be in MM/DD/YY format
L	Parent/Guardian	General	Parent/Guardian Name
M	Grade	General	Student’s Grade: See Below
N	Age	General	Student’s Age
O	Intake	Date/Time	Date first seen: must be in MM/DD/YY format
P	Discharge	Date/Time	Date discharged: must be in MM/DD/YY format
Q	Status	General	Student's counseling status

Student ID numbers must be unique to each student. The numbers 0, 1, 2, and 3 are reserved by Hallways. If you don’t have Student ID numbers assigned, use the Excel Column Fill function to assign numbers.

Student Grades should be in the format: PK, K, 01, 02, 03 etc. up to 11, 12

Be sure to set the student’s Status (Column Q) as current if you are currently providing services to the student.

When you have finished organizing the data, save the file and close it. Be sure to keep it as an Excel 97-2003 (.xls) file or Hallways will not be able to read it.

Importing Student Data: Step 2 >>