Google Classroom Integration

Importing Student Google IDs into School Loop for Google Classroom Integration


Overview


In order to import scores for an assignment in School Loop from Google Classroom, district administrators need to import student Google IDs into the School Loop System. 


Prerequisites

  • You are a district administrator and you have configured data import via Sloopy.
  • The Sloopy version required is 4.5 or higher.
  • You need to have a text file (.txt) with all student permanent IDs (from SIS) and their Google email accounts provided by the School/District in the following format:
    123456	student1@schooldomain.com
    123457	student2@schooldomain.com
    123458	student3@schooldomain.com
    Note: Make sure you use Tab as a delimiter.


Solution

    1. On the machine (server) where Sloopy runs, navigate to the folder of the Sloopy application.
    2. Open the folder that you use for import.
      There are folders for various versions of SIS applications. In this example, we will use the Generic folder.

      mceclip11.png

    3. Open the config.txt file in a text editor.

      mceclip0.png
    4. Add the following line to the file under the data.ss variable:
      data.google_ids=google.txt

      mceclip1.png

    5. Save the updated file.
    6. From the folder where you left, open the data directory folder. 
      By default, the name of the folder is data. You can check if it is different in the config.txt file.

      mceclip2.png

      mceclip3.png
    7. Copy the file with Student IDs to the data folder.
    8. Name the file google.txt.
    9. Make sure that the file follows the correct format described in Prerequisites and uses Tab as a delimiter.

      mceclip4.png

    10. Run the import process manually or wait for the next scheduled import task.
      To run it manually:
      1. Go back to the previous folder. 
        In this example, it is sloopy > Generic.
      2. In the address field, type cmd and press Enter.

        mceclip6.png

      3. In the command prompt, type sloopy.bat and press Enter.

        mceclip5.png

 

Note: You will need to add IDs (to the google.txt file) for the new students who start studying in your district schools during the year and run the import again (step 10). Otherwise, grades for them will not be imported from Google Classroom.


Confirmation


If you executed the import manually, check the messages generated in the command prompt. You should see a Success message at the end, and there should be no error messages before and after the Loading Google ID message (Using Tab File Generator is a normal system message).

mceclip10.png

If there are Skipping messages after Loading GoogleID, it means that the format of the file or the delimiter used is incorrect.

mceclip9.png

 

Back to top

Related articles