Accommodations Import

The following step by step instructions will inform you how to download Testing Accommodations from SER and import them into JCampus. Importing the accommodations file into JCampus will display the Testing Accommodations within the SPED window from wherever the SPED button can be seen.

1. After logging into SER, click on the Reports tab.
2. Click on the folder IEP Forms.
3. Click on Accommodations Detail.
   
   
   
   
4. On the Accommodation Report settings, select your district if not already selected.
5. Select the status of Official.
6. In the first date field, select a date in the prior year. Typically, this is exactly one year prior to today.The second date field is today's date.
7. Export format needs to be CSV (comma delimited).
   
   
   
   
8. Click Add to My Reports. You will be taken to My Reports automatically. Click Save when the file is ready.
9. Note: As of 08/01/2015, steps -- thru --- can be skipped. The file no longer needs to be convered to tab delimited.
10. At this point the file will need to be converted into a Tab Delimited file. You can do this by:
    • Locate the file and change the extension from "filename.csv" to "filename.txt".
    • Open MSExcel and browse to the location of the file. Click on the file to open in MSExcel.
    • Click "Yes" if you get the message that the file is in a different format that the specified extension. Do you want to open the file now?
    • The "Text Import Wizard" will appear. Select "Delimited" and then click "Next".
    • Unselect "Tab" and then select "Comma". Click "Next".
    • In are labeled "Data preview", scroll to the end, hold your Shift key down and click the last column labeled "General". Select "Text" at the top of the box under the heading "Column data format".
    • Click "Finish".
    • Click on the "Office Button" and click "Save As".
    • Select where to save the file and verify the name of the file.
    • In the drop down menu labeled "Save as Type", select "Text (Tab delimited) (*.txt)"
    • Click "Save"
    • A message will appear asking "Do you want to keep the workbook in this format?". Click "Yes".
11. Once the file is configured, log into JCampus and go to Special Education > Loaders > Accommodations Import.
12. On the setup box, verify that the Year and District are correct, then click Choose File to select the Accommodations file downloaded from SER.
13. Click OK to import the file.

---

Special Education