How Genesis Integration Works

Using Genesis, a file containing student demographic information is created. 

That file is then sent to EDS using a method called SFTP (Secure File Transfer Protocol).

After the file is successfully transferred to the EDS server, the student data from that file will auto-populate within EDS’s various modules (HIBster, HIBsterVention, aSAP, etc.).

The student data file must be formatted in a specific manner. If is isn't, the student data will be processed incorrectly or not at all, resulting in student data that is missing, incomplete or corrupted.

Please follow the below instructions to make sure all student data is transferred without incident.

Format the file

The first step in the process is properly formatting the student data file.

The file must be saved in the proper format. In this case, it must be saved as a comma-delimited .csv file.

The file must also include the student information requested by EDS; the particular requirements are listed in the following section.

Required Fields

The following fields must be included in the file — and in the exact order shown.

Each field below must be used as column headers on the file. Otherwise, when the file is processed, the first student listed will be processed as the column header and that student will not be included in the database..

If no data is available for a given field, that field must still be accounted for by using a blank space. If a field is skipped entirely, the data will not import into the database correctly, causing errors (most notably, data will be imported into the wrong fields; for example: ethnicity will display as gender, etc.).

Please include all the following headers:

Student ID
First Name
Middle Initial
Last Name
Date Of Birth
Grade Level
Ethnicity Primary
Gender Code
G1Phone
G1Address
G1City
G1State
G1Zip
Student State ID
SIS_School_ID
primary_language
guardian_fn
guardian_ln
guardian_mn
guardian_relationship_code
guardianship
guardian_day_phone
guardian_email
father_first_name
father_last_name
father_home_phone
father_email_address
father_day_phone
mother_first_name
mother_last_name
mother_home_phone
mother_day_phone
mother_email_address 
County
Excused Absences int
Unexcused Absences int
sped indicator Y/N
number suspension int
MTSS indicator Y/N
MTSS Plan if available string
disciplinary hearing referrals int
on track for grad Y/N 504 indicator Y/N
el status Y/N
economically disadvantaged Y/N
Home primary language String
GPA Double





Most of the above fields are self-explanatory, but the ethnicity and grade level fields require their data to be formatted a special way. Please consult those links for the acceptable data format.

An example of what a properly formatted student’s data would look like:

123456,John,A,Doe,3/10/1997,12,H,M,201-555-3975,1234 Washington Street Apt. A1,Hoboken,NJ,07030

789123,Jane,M,Doe,10/7/1994,12,H,F,201-555-4386,5678 Willow Avenue Apt. A1,Hoboken,NJ,07030

Transfer the student data file

Once the file is properly formatted, it should be transferred to EDS using the following instructions: