Exportation of data from ESIS to Excel
Exporting data from esis to file form- not print (xls)
lock school
reports->at the bottom, select export/ad hoc file
select the parameters for export (the following fields are for an active directory request to Bob Swipes)
first name
legal name
pupil number
grade (alter this after export to reflect students' first year of high school for Mr. Swipes)
grade 9 entry date is currently an empty field and not useful
Home school
HR1 should be used if needed: HomeRoom # is currently empty
Use the up and down arrows to move a selection up or down the list: list order becomes column order on export
Click create file: using the tab delimiter makes it easy to open the file in Excel and check the export Field Titles first check box to place headers on your exported columns
Click go to extract, and the school tab to select the right school (if you locked your school, you can just pick current school
Click run extract
Click go back when the extract has finished running
Use the exit door to return to the save window
Click save as to name the file (use an xls extension) and choose a save location
Click create export