View source for NEW! Import Files for Early Childhood Service Location

The purpose of this new import is to allow districts and cooperatives the ability to edit student approval data in an alternate setting for the new Early Childhood Service Location collection in I-Star. 

# Login to I-Star go to the [[Searching for Students|Student Approval Search page]].

[[File:ECimport.png|none|thumb|467x467px]]


2. From the search page, filter to grade = Preschool.
[[File:Ecimport2.png|none|thumb|377x377px]] 
 


3. Click the "Export using Import Function" button to create an Excel file. 
[[File:Ecimport3.png|none|thumb|458x458px]]



4. When Excel file populates, click "Enable Editing" at the top of the screen.
[[File:Ecimport4.png|none|thumb|482x482px]] 
 
5. From Excel, remove Fund N and U records from the Fund Code column (column Q) as those records are not required to have Special Education Service Location information and click "OK". 
[[File:Ecimport5.png|none|thumb]]




6. From Excel, filter by Serving School (Column N).
[[File:Ecimport6.png|none|thumb]]



7. For each serving school listed on the Excel spreadsheet, update all columns regarding Special Education Service Location (Column BS - Column BZ)
[[File:Ecimport7.png|none|thumb|1040x1040px]]



8. Column BS is required for all preschool students. Column BS must contain a number 1-7. See description of each number below:

# Head Start
# PFA/PFAE (School-Based)
# PFA/PFAE (Community-Based)
# Child Care
# Private Preschool
# Public School District
# Special Ed Cooperative

[[File:Ecimport8.png|none|thumb]]


9. Column BT = Receive Majority of Services Box

Column BU = Is Service Location Different Box

[[File:Ecimport9.png|none|thumb|367x367px]]



BT = 0 for receiving Majority Of Special Ed services at another location.

BT = 1 for receiving Majority of Special Ed services at this location.

BU = 0 if Special Ed Service Location is the Serving School.

BU = 1 for Special Ed Service Location is different than the Serving School.



10. If BU = 1, then fill in the BV through BZ columns with name and address of serving location. 
[[File:Ecimport10.png|none|thumb|709x709px]]
[[File:Ecimport11.png|none|thumb|762x762px]]   

11. Save spreadsheet once appropriate columns are filled in. 
[[File:Ecimport12.png|none|thumb|773x773px]] 
 
12. From I-Star, click on the "Upload Files" tab. 
[[File:Ecimport13.png|none|thumb|403x403px]] 
 
13. Click the "add" button. 
[[File:Ecimport14.png|none|thumb|464x464px]]



14. Click "choose file" to attach the previously edited Excel document. 
[[File:Ecimport15.png|none|thumb|477x477px]]

15. Make sure the "Skip First Row" box is checked. 
[[File:Ecimport17.png|none|thumb|541x541px]]



16. Verify all information is correct and click "submit". 
[[File:Ecimport16.png|none|thumb|447x447px]]



17. If the upload was completed successfully, the user will receive a confirmation email once the upload is complete. The confirmation will come to the email that is on file with IWAS. 
[[File:ECIMPORT20.png|none|thumb|730x730px]]