Support Planner:  Importing students


Site Index



Learning about
How it Works
User Group
Shared Resources
New Users
Extending users
Lift Off!!
Database Contents
Keeping things tidy
Some conventions
Importing students
What it does

See also...





Importing student data from SACS

This is can be technically challenging since it requires being able to process data and work between

  • SACS
  • Excel and the
  • Planner

Recommendation: this should only be attempted by who is confident with SACS and Excel and familiar with the Planner


Firstly, extract the data from  SACS 

1. From SACS go Reports / Student Reports / Lists and choose Students by Selected Characteristics PP1 041

  • One for boys
  • One for girls


2. Output the reports into Excel

  • merge the two reports
  • add a column for Gender
  • Use Fill Down to add M for males and F for females in the Gender column


Next,  organize the data in Excel


3. Check that you have all the data that you need

  • Student ID (for most current users) or ED ID (for new or recent users)*
  • Given Name
  • Surname
  • Date of birth
  • Year or Grade 
  • Roll Class  
  • Gender (this may be a good opportunity to add and edite

    * Existing users should check which of these identifiers you need


4. Remove unwanted columns such as which ever of StudentID and ED ID is not required from your Planner

5. Tidy the data by removing header and summary rows so that you only have actual student details


6. Split the Name into surname and given name in Excel 

  • select the Name column 
  • insert say four blank columns to the right of the Name column
  • in the Main toolbar go Data then choose Text to Columns and follow the wizard
  • use space as the delimiter

    Watch out for names like van der Molen (they will use 4 columns and overwrite any data in the columns) - you may need to do some editing to get such surnames into the correct column 


7. Make a back up copy of your existing Planner !!!


Now open the Support Planner and 

  • click the Add/Place Students button on the Main Menu. This will take you to the Placements form.

Moving the data from Excel to the Planner

8. Sort the columns in Excel to exactly match the columns in the Placements form. Blank columns count so include these in your matching
    NB If you are just starting afresh or already use Ed ID in the Planner  just match ED ID into the StudentID column

9. In Excel copy all the cells you want to paste from Excel

10. In the Placement form in the Planner

  • scroll down and select the first empty row (click in the grey box to the left of the row)
  • In the Main toolbar go Edit -> Paste Append to transfer the cells into the table in the Bulk Placement form
  • If you are adding records to an existing Planner you will get a warning message
  • Click 'Yes' in the next dialogue box


At last !!

The data should now be in the Planner. If not

  • send a zipped copy of your back-up version
  • together with your data from SACS
  • attached to an email to Ivan Webb



Ivan Webb Pty Ltd 2001 onwards