How do I populate the account with staff and pupil details from my MIS?

Updated by Matt Besant

Whether you are a new customer looking to populate your account for the first time, or an existing user looking to update with new staff and pupils. Then the easiest way to do this is via the MIS sync wizard.

We have partnered with Groupcall- Integration and GDPR experts whose Xporter-on-Demand (XoD) tool allows you to update DotCom in just a few clicks. Not only is this the quickest way of populating DotCom, it negates the need for CSV files and therefore safer if GDPR is a concern for you.

This service comes at no extra cost to you so to set up, please follow the instructions below:

You must be a DotCom admin to set up Groupcall XoD

Setting up Groupcall XoD

This only needs to be done once but we cannot run the MIS sync wizard without first setting up XoD and authorising the relevant data to be shared with DotCom.

  1. Log into DotCom and head to Manage Users.
  1. Once in 2Lasso, you will see a "tools" option at the top. If you select tools and then select "MIS Sync Wizard" you will see this pop-out. Where you will be asked to choose which data areas from the MIS you wish for DotCom to see. Read this information carefully and you can also see more details about what data DotCom requires here: What MIS data does 2Simple require?
  1. Confirm you have chosen the data you wish DotCom to extract and click "Set up Groupcall Xporter". This will generate an email to you from Groupcall asking you to consent the data share. Follow the instructions on this email carefully and be sure to enter the details of the person with authority to share data if this is not you. You can find a useful video to talk you through this here: How do I authorise the data share with my MIS?
If this is the first time setting up Groupcall Xod, at the end of the authorisiation process you will be asked to book a time to install the software. Please follow the instructions to book a time with Groupcall to do this. If you are already using Groupcall XoD with another app in your school you will be able to go straight back to DotCom and complete the MIS sync wizard.
  1. Once authorised and installed, you're now ready for the MIS sync wizard and won't have to repeat any of the above steps again!

Running the MIS sync wizard

  1. Again, you will need to log into DotCom and head to 2Lasso (create and manage users) from the admin area and select "MIS Sync Wizard" from the tools section.
  1. This time you will see step 1 of the wizard, asking you to choose the user name format of your pupils and staff.
We recommend setting up pupils in the format "forename + surname initial (e.g. John Smith would have the username JohnS) as children tend to learn their first name before their last name, but you can choose whatever you wish.
For staff, we would recommend "sync only teachers" as generally speaking all staff do not require an account (and its easier to manually add the odd staff member who does later, than it is to remove all the staff who do not need an account). We recommend setting staff usernames to the format "forename initial + surname" (e.g. John Smith would have the username JSmith).

  1. Click next to move onto step 2 which is selecting the password formats. You can select by year group as a text-typed password may not suitable for your EYFS pupils but perfectly suitable for your KS2 children.
If you already have some users set up in DotCom, the settings chosen in the first 2 steps of the wizard will only apply to new users being created and therefore the existing users will be able to use the same login details as before
  1. Again, click next to move onto the next step- mapping year groups. This step only needs doing once, but is very important. Depending on what MIS you use, you may have a different naming format for each year group. For example, "Year 6" could be known in your MIS as "Y6", "Year Six", "6", "Yr6" etc but DotCom will only recognize "Year 6". Therefore simply map your year groups to the DotCom format.
  1. Once you have hit next you will be shown a summary of the information you are importing. Check this is what you were expecting to see and hit "finish" to create the user accounts. Any new staff accounts will be sent an activation email.

If you have some "users who will not be imported due to errors" then this is most likely staff members who do not have an email address in the MIS. Don't worry, you can still complete the sync and either manually add any missing staff afterwards, or add the emails to the MIS and run the wizard again.


How did we do?


Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)