Difference between revisions of "Accommodations Import"

From EDgearWiki
Jump to navigationJump to search
Line 10: Line 10:
 
# Export format needs to be '''CSV (comma delimited).'''<br><br>[[File:Accommodations_detail_settings.png]]<br><br>
 
# Export format needs to be '''CSV (comma delimited).'''<br><br>[[File:Accommodations_detail_settings.png]]<br><br>
 
# Click '''Add to My Reports'''. You will be taken to '''My Reports''' automatically. Click '''Save''' when the file is ready.
 
# Click '''Add to My Reports'''. You will be taken to '''My Reports''' automatically. Click '''Save''' when the file is ready.
−
# '''Note:  As of 08/01/2015, steps -- thru --- can be skipped.  The file no longer needs to be convered to tab delimited.
+
#* Normally when "Save" is clicked, the file is placed in the user's "Download" folder.   
−
# At this point the file will need to be converted into a Tab Delimited file.  You can do this by:
+
# Log into JCampus and go to '''Special Education''' > '''Loaders''' > '''Accommodations Import'''.
−
#* Locate the file and change the extension from "filename.csv" to "filename.txt".
+
# On the setup box, verify that the '''Year''' and '''District''' are correct, then click '''Choose File'''.
−
#* Open MSExcel and browse to the location of the file.  Click on the file to open in MSExcel.
+
# Browse to the "Downloads" folder, then select the Accommodations file downloaded from SER.
−
#* 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".
 
−
# Once the file is configured, log into JCampus and go to '''Special Education''' > '''Loaders''' > '''Accommodations Import'''.
 
−
# On the setup box, verify that the '''Year''' and '''District''' are correct, then click '''Choose File''' to select the Accommodations file downloaded from SER.
 
 
# Click '''OK''' to import the file.
 
# Click '''OK''' to import the file.
 +
# A progress message will appear.  When done, the accommodations imported for each student will be listed.
 +
# If an error box pops up indicating accommodations that could not be imported, the usual causes are:
 +
#* Student no longer is in the current year student master.  Often these can be ignored.  When the SER file is created, it creates accommodations going back a calendar year.  In many cases, the accommodations don't match up because the student is no longer in the current year student master.
 +
#* Student does not have a State Assigned ID (eScholar).  These should not be ignored.  The student needs a state id per normal state reporting flow.
  
  

Revision as of 12:45, 18 November 2015

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.

    Accommodations Detail.png

  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).

    Accommodations detail settings.png

  8. Click Add to My Reports. You will be taken to My Reports automatically. Click Save when the file is ready.
    • Normally when "Save" is clicked, the file is placed in the user's "Download" folder.
  9. Log into JCampus and go to Special Education > Loaders > Accommodations Import.
  10. On the setup box, verify that the Year and District are correct, then click Choose File.
  11. Browse to the "Downloads" folder, then select the Accommodations file downloaded from SER.
  12. Click OK to import the file.
  13. A progress message will appear. When done, the accommodations imported for each student will be listed.
  14. If an error box pops up indicating accommodations that could not be imported, the usual causes are:
    • Student no longer is in the current year student master. Often these can be ignored. When the SER file is created, it creates accommodations going back a calendar year. In many cases, the accommodations don't match up because the student is no longer in the current year student master.
    • Student does not have a State Assigned ID (eScholar). These should not be ignored. The student needs a state id per normal state reporting flow.



Special Education

Retrieved from EDgear Wiki