On a regular basis, the student roster file will need to be rebuilt in order to synchronize SIMS with SIS. The following directions are how to create a new roster table in SIMS.
- Log into SIS
- Select EZ Query
- Select Reports
- Change the Building to Newton Falls EX Vill SD
- Select SIS Student Search
- Select All Buildings
- Click Next
- Click Next on Filter
- On the Field Select, Select the Following:
- Students – Select All
- Enrollment – Select All
- Address & Contacts – Select All (Then remove – Primary Contact Relationship Comments, Family Group Name, Family Group Description)
- Under EMIS – Select State Student ID
- Transportation – Select None
- Click NEXT
- Select File Download Type – CSV
- Select A Download Method – Download
- Click Finish
- Save the download file to your desktop as “roster_student_demo.csv”
- Open Up Navicat
- Browse to District -> ext
- Rename (or remove) the roster_student_demo table
- Make sure you do not have a table selected, and click on Import Wizard
- Text File
- Next
- Browse to select the new file you created (You may have to change file type to csv)
- Next
- Select Comma Delimited
- Next
- Next
- Check to create Target Table roster_student_demo
- Next
- It should show the field names under Target Field, and Types, Length etc. as Navicat will create the table form the data. If you are seeing mapping at this point to go to F1, F2, etc… you did something wrong. Start over at step number 15.
- Next
- Append
- Next
- Start
- Should of processed ~ 1376 records. If way off… there is a problem with the data file.
- If all is fine, open up the new table and delete the first record. This is the header line.
- All of the SIU utilities should now work with the new roster file.