Submit Student File for Missing State IDs

Submit Student File for Missing State IDs

To receive State IDs for students without one, follow this procedure.
  1. Export Report from PowerSchool
    1. Go to SQL5 Reports\Sys Admin\
    2. Missing State IDs in AOE Format
    3. Save as CSV Name with the file name 01_0_Student_Match in this location in Google Drive.
    4. If a student has a suffix (II, IV, Sr., Jr.) delete the suffix.
  2. Upload file to EdFusion.
    1. Go to: https://slds.education.vermont.gov/edFusion/Web/Login.aspx
    2. Log in using the credentials in Zoho labeled EdFusion 
    3. Once logged in, go to Integrate and select Submission Upload.
    4. Under Domain select Match Submissions
    5. Click on Choose File and select your file from wherever you stored it.
    6. Click the Upload button.
    7. On the right side click Schedule Now.
    8. Once processed you will see a View Details link. Click that link.
    9. Click on the number underneath the Total column. Save the file in this location in Google Drive. Name the file "01_0_Student_Match - Results."
    10. The file will contain state IDs for those that match the AOE's master file. There may be others that did not match. Usually Glenn Bouchard sends an email shortly after with the state IDs that were not found. If you do not get an email from him, send him an bouchard@vermont.gov" target="_blank">email with the batch number and the number of records with missing IDs. He does not like to send detailed information about students. You can use initials.
  3. Update the students' records in PowerSchool.
    1. If you have many records to update, you can import the file by following these steps.
      1. Rename the columns to match the field names in PowerSchool ( i.e., student_number, state_student_number, etc.)
      2. Go to Special Functions, Importing and Exporting,  and QuickImport
      3. Select the Students table
      4. Leave mapping checked.
      5. Check "Exclude 1st row"
      6. Check "Update Student's record with info."
    2. More likely there are just a few records in which case you can update the student record manually by looking up the student record and entering the ID on the Administrative Info page.   import, follow these steps. 



    • Related Articles

    • Create a Course Section (Includes SLDS Information)

      A section indicates when a class will occur. This is determined by periods. There can be multiple sections for one course. When setting up a section, you indicate the following: What period is the course offered? What term is the course offered? (Can ...

    • Create a Class for a PreK Program/School (Includes SLDS Information)

      For SLDS reporting purposes, each of the CPP schools are assigned a PKID from the AOE.  They release a new list each year which can be found on the EFT site. Each Prek program is set up as a class using the PKID as the Class Number. In addition, as ...

    • Direct Cert Step 1: Submitting Files to EdFusion

      There are several steps involved in submitting files to the AOE. There are SLDS submissions due at various times throughout the year.  There is also a nightly submission that is called DC#03 Nightly Submission. This can be run at any time and is used ...

    • Direct Cert Step 2: Download the DC File From AOE Edfusion Website

      Previous Steps Required Direct Cert Data - Procedure Overview Step 1: Submitting Updated SLDS Data To review, at this point you have run the DC#03 SLDS reports in PowerSchool, formatted them correctly and uploaded them to Edfusion. If there were a ...

    • Direct Cert Step 5: Create the File for Cafe Enterprise

      Previous Steps Required: To get an idea of this complex process, please read Direct Cert - Procedure Overview if you haven't already. Step 1: Upload SLDS Files Step 2: Download the DC File From AOE Edfusion Website Step 3: Format the AOE DC File Step ...