Hallways School Counseling Software | Importing Student Data

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

Hallways⁴ > Support > Getting Started > Importing Student PEIMS Data

Importing Student Data: Step 1

Hallways Modules

Quick Links
Import Utility Sample Excel File Importing Student Data: Step 2
Module Components
Getting Started Installation Starting Hallways Importing Student Data Importing PEIMS Data Importing PEIMS Data: Step 2 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

Download the Sample Excel file here.

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
R	ETH	General	Ethnicity
S	DIS	General	Economically Disadvantaged
T	TII	General	TII Status
U	MIG	General	Migrant
V	BIL	General	Bilingual
W	ESL	General	English Second Language
X	SPECD	General	Special Ed
Y	GT	General	Gifted/Talented
Z	SEX	General	Gender
AA	ADA	General	ADA Eligibility
AB	LEP	General	Limited English Proficiency
AC	PP	General	Parental Permission
AD	Risk	General	At Risk
AE	TECH	General	Technological Program
AF	IMM	General	Immigrant
AG	HL	General	Home Language

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 >>