Completing these steps will export the course rosters (teacher sections) from PowerSchool to tab delimited text.  You can then adjust the file using Excel to match the import requirements of your MDM.  These directions are made to match the Mosyle MDM course import template requirements.  


TIP

It's best to preform this export after student movement between courses has mostly settled.

TO EXPORT COURSE ROSTERS FROM POWERSCHOOL

  1. Log in to PowerSchool and select all of your students
    • Once you select all of your students, the number of students will show up next to “Current Student Selection.”  This should isolate the selection to only current students.


  2. Go to 'System' -> 'Direct Database Export (DDE)'
  3. Use the pull down menu to select the 'CC (4)' Table
  4. Click 'Select all XXXXX records in this table'
  5. click 'Match Selection'
    • This will isolate the selection of sections begin offered for only the active students.


  6. Click 'Proceed to match Selection'


  7. Use the search function to filter out the term you want to export.  The expression should read 'TermID' = 'XXXX'

    • 2017-2018 Semester 1 = 2701

    • 2017-2018 Semester 2 = 2702

    • 2018-2019 Semester 1 = 2701

    • 2018-2019 Semester 2 = 2702

    • etc.


  8. Click 'Search within the current XXXXX records only'.

  9. Click 'Export Records'


  10. Paste the following code into the box

    [2]Course_Name
Expression
[39]Name
[5]Email_addr
[1]Student_Number
[1]Last_Name
[1]First_Name
[1]Grade_Level
TeacherID



  11. Click 'Submit'

  12. Your browser will download the exported text file.


MODIFY THE CSV TO MATCH MOSYLE (MDM) IMPORT TEMPLATE

  1. Open the file exported from PowerSchool in Excel or another spreadsheet app
  2. Modify the spread sheet to match the MDM import template
    • Use replace to replace expressions (example '5(A-E)' -> '5th Hour')


    • Sort data by teacher's email and then by subject followed by period


    • Delete unneeded columns
    • Insert a column for room # in column C
    • Paste header from Mosyle import template.


  3. Proof read the file to look for classes you may want to adjust or remove.

  4. Save your complete file as CSV (Comma Separated Value)


IMPORT THE CSV INTO MOSYLE (MDM)

  1. Login to Mosyle Manager
  2. Be sure you're on the iOS side of Mosyle Manager
  3. Click 'My School' from the bottom menu
  4. Click 'Spreadsheet' from the sidebar menu
  5. Under "Import classes" click 'Select file' and upload your CSV file


  6. Scroll to the bottom of the Preview window and decide to append or not to append.  Normally you want this box checked.

  7. Click 'Confirm'


RESOURCES