Advanced SIS Integration + Manual loading Follow

The Data Loader Sync method allows automated daily synchronization between Hapara and Clever, PowerSchool, or RIC One for students and classes. 

Often no manual editing of files is required - the whole process is automated. But in some cases the automatic daily sync of Classes might not suit a school's requirements because:

  • The data needs to be edited before uploading to Hapara (e.g. custom data edits)
  • Complicated rules need to be applied to the data to calculate Class Names and/or Folder names ( e.g using lookups to "translate" class names)
  • A subset of Classes need to be deleted from the data before uploading to Hapara
  • Classes need to be merged before loading to Hapara

These schools may still want to do an automatic daily sync of Students, which is possible using Manual Load for Classes and SIS Sync for Students

The Hapara Data Loader supports this scenario by combining two load methods:

  • The Classes are loaded via the Manual Load method when required
  • The Students are automatically loaded daily via Sync

    Some schools may even just want the option to manually load data when a quick fix or change is required, and not an entire sync.

The next section describes in detail how to configure the Data Loader to accept both Sync and Manual loads. It describes how to:

  1. Set up the Sync Configuration page
  2. Download the Class data from your SIS
  3. Manually make the changes you want to the Class spreadsheet
  4. Set up the Manual Configuration page
  5. Use the Manual Load page to load your edited Class information
  6. Use the Sync page to do an initial load of the Student information
  7. Use the Sync page to turn on the daily sync of the Student information

 

Configuring Data Loader to Manually Load Classes and Sync Students

Step 1. Set up the Sync Configuration page:

  • Browse to the Data Loader Sync Configuration page
  • Ensure that the "Load Classes" checkbox is not checked. Only "Load Students" checkbox should be checked. This will sync your students daily and allow you to load classes manually.
  • Choose "Same as ClassEmail", this simplifies the export.
  • Choose your preferred Student Folder option, this determines what information will be extracted from your SIS as the student folder name; and your preferred Folder Name Suffix option.
  • Select your blogs, sites and calendar preferences. Many schools default to: "Show teacher all student blogs", "Show teacher all student sites" and "Teacher and students use a calendar named ClassName_YearSuffix"
  • Select your preferred Gmail setting.
  • Select your preferred email notifications, and save the changes.

 

Step 2. Download the Class data from your SIS:

  • Browse back to the beginning of the Sync Configuration page
  • Click 'Begin SIS configuration' to navigate to 'SIS Provider' page.
  • Click on "Test Class Download"
  • A link will appear to "View Class Data Spreadsheet"
    • Click on this link to open the Class spreadsheet (The Spreadsheet may take a minute or two to populate with your extracted Class information).
  • Bookmark this Class spreadsheet, or save this spreadsheet somewhere safe. If you are choosing to load classes manually, this will become your 'Master Class spreadsheet

 

Step 3. Manually make the changes you want to the Class spreadsheet

  • Note: Don't change the Class mailbox. The Class mailbox is used in the Student sync to specify what classes the student is in. If you change the Class mailbox the Student load will fail to link students to classes.

 

Step 4. Set up the Manual Configuration page
These settings should default to match your configuration specified in Sync, but it is always good to double check.

  • Browse to the Data Loader Manual Configuration page
  • Select Google Sheet
  • Select 'Each student has subject folder(s) named in the Class spreadsheet column titled Subject Folders'. The Folder Name Suffix is not editable while Sync is enabled.
  • Select your blogs, sites and calendar preferences. This ideally would match what is listed in the Sync configuration. Many schools default to: "Show teacher all student blogs", "Show teacher all student sites" and "Teacher and students use a calendar named ClassName_YearSuffix"
  • Choose your preferred Gmail setting, this ideally would match what is listed in the Sync configuration.

 

Step 5. Use the Manual Load page to load your edited Class information:

  • Browse to the Data Loader Manual Load page
  • Confirm your Configuration Setting Summary is correct and click next.
  • Specify the name of the Class spreadsheet created above and click Verify.
  • If the sheet verifies successfully, click Start Load.
  • If the sheet does not verify successfully, double check the Class spreadsheet is shared with your school.apps.owner account

    Monitor the load of the Classes using the Data Loader Status page
    Errors will display at the bottom of the page. when 'View Details' is clicked


Step 6. Use the Sync page to do an initial load of the Student information:

  • Browse to the Data Loader Sync page.
  • Check that the following configuration options are correct: Academic Year Suffix, Source Type To Sychronize, Type Of Data to Sychronize and Email Notification List (the other configuration items are ignored)
  • Double-check that the "Type Of Data to Sychronize" setting is "Students" (and is not set to "Students and Classes").
  • Click "Synchronize students now"

    Monitor the load of the Classes using the Data Loader Status page
    Errors will display at the bottom of the page. when 'View Details' is clicked 


Step 7. Use the Sync page to turn on the daily sync of the Student information:

  • Browse to the Data Loader Sync page.
  • Double-check that the "Type Of Data to Sychronize" setting is "Students" (and is not set to "Students and Classes").
  • Select the "Sychronize daily" checkbox
  • Click Save
  • The next day, check status of the latest student load using the Data Loader Status page

    Errors will display at the bottom of the page. when 'View Details' is clicked

 

Well, that was quite the setup process! But you're now ready to sync your students daily, and load classes manually when needed.

If you have any further questions, please submit a support request.

 

 

 

Have more questions? Submit a request