State ID Upload Utility
Processing
- Save the file from the state in an easy to find directory (Desktop; My Documents; etc.)
- Rename the file you got from the state to SIDupload.csv
- Right click on the file & click "Open With" Notepad. Make sure the file is comma delimited & readable.
- NOTE: If the file is not readable (full of funny characters) then open the file in Excel by double clicking on it & click File_Save As_ and make sure the file type is CSV (Comma delimited) (*.csv) and save again. Try re-opening by right clicking & opening with Notepad.
- Open eSchoolPlus and click Upload File on the menu bar.
- Click Browse & browse to the location of the SIDupload.csv file that you just verified is readable.
- Highlight the file and click to open the selected file.
- Click Upload on the original upload screen – the processing window will display.
- The Upload File page will appear with a message that it has successfully been uploaded.
- If you go to "My Home", your file, SIDupload.csv, will display along with your list of other reports.
- Click on _State Center State Id Upload_ to load the state ids contained in the file.
- Select Interface Id: NJSID (which is pre-defined by PowerSchool). Leave the User's Report Directory selected (this is the directory we loaded the file into).
- Click Run.
- 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 & 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 & 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.
- Check your students and verify they now have state ids on the Personal page.