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 doesn't suit schools because:

  • The data needs to be manually cleansed before uploading to Hapara (e.g. Class name spelling mistakes corrected)
  • 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

These schools may still want to do an automatic daily sync of Students.

 

Using Manual Load for Classes and Sync for Students

The Hapara Data Loader supports the above case 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
  • Complete step 1. Select your preferred academic year suffix.
  • Complete step 2. 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.
  • Complete step 3. Choose "Same as ClassEmail", this simplifies the export.
  • Complete step 4. 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.
  • Complete step 5. 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"
  • Complete step 6. Choose your preferred Gmail setting.
  • Complete step 7 for 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
  • Continue to step 2, the 'SIS Provider' page.
  • Click on "Test Class Download"
  • A link will appear to "View Class Data Spreadsheet"
  • Click on this link to open the spreadsheet (The Spreadsheet may take a minute or two to populate with your Class information).
  • Bookmark the 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
  • Complete step 1. Select Google Sheet
  • Click next at step 2, you cannot edit this academic year suffix now this has been configured via Sync.
  • Complete step 3. 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.
  • Complete step 4. 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"
  • Complete step 5. 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