State ID Upload

Regulatory > ISBE > ISBE > State ID Upload

1. Save the file from the state in an easy to find directory (Desktop; My Documents; etc.)
2. Rename the file you got from the state to isbeupload.csv
3. Right click on the file and click "Open With" Notepad.  Make sure the file is comma delimited and readable. Save the file from the state in an easy to find directory (Desktop; My Documents; etc.).
4. Open eSchoolPlus and click Upload File (Administration > Utilities > Download & Upload > Upload File).
5. Click Browse and browse to the location of the isbeupload.csv file that you just verified is readable.
6. Highlight the file and click open to select the file.
7. Click Upload Records on the original upload screen – the processing window will display.
8. The Upload File page will appear with a message that it has successfully been uploaded.
9. Your file, isbeupload.csv, will display along with your list of other reports under Tasks/Reports.
10. Click on Regulatory > ISBE > ISBE > State ID Upload to load the state ids contained in the file.
11. Select Interface Id: ISBE (which is pre-defined by PowerSchool).  Leave the User's Report Directory selected (this is the directory we loaded the file into).
12. Click Run.
13. Upon completion, open the Interface Upload Log file and review any error information encountered during processing. Interface Upload Processing / Log file information:
    • If your student had a state id and the file is now trying to assign the student a new state id; it will move that original state id to the previous state id field and save the new state id in the state id field on the Personal Page.
    • If the state id that is trying to be assigned has already been assigned to another student in your district – it will not load that state id and it will log a message in the Interface Upload Log file.  The message will read: "Cannot Update State ID; State ID:xxxxxxx Already exists for another student ID."
    • If the student id in the file does not exist in registration it will log the following message in the Interface Upload Log file, "Cannot Update State ID; Student ID: xxxxxx does not exist in the Personal table."
    • If the student id has already been assigned that same state id you will get the following message in the log file: "Not Updating State ID;xxxxx Already exists for student ID xxxxxx being processed." (this message will only appear if it tries to upload the exact same state id number for the same student)
    • If you have blank lines in the file you will get the following message in the log file (one for each blank line): "Cannot Update State ID; Student ID: does not exist in the Personal table."  This error just means there were blank lines that were skipped, so you can ignore it.  You will also get a message about the Header row that will read: "Cannot Update State ID; Student ID:LocalIdent does not exist in the Personal table."  You may also ignore this error.
14. Check your students and verify they now have state ids on the Personal page.