Bulk prepare test sessions using CSV import

Created by Matthew Russell, Modified on Sun, 16 Jun at 2:59 AM by Matthew Russell

This feature requires a Motif Advanced Testing Tools subscription. To get a quote for the subscription, reach out to us at [email protected], or create a ticket in this service desk.

You can prepare a large number of test sessions in advance using our CSV upload tool. Once you have organised an Advanced Tools subscription, Group Admins can access the import from the Groups screen. There are no limits to how many time you use the tools. You could do 8 imports of 100, or 1 import of 800, it's up to you.

This tool has the following features:

Prepare many hundreds of tests in one CSV
Prepare multiple types of tests in one CSV
Prepare tests for multiple group members in one CSV

Prepare many hundreds of tests in a single CSV

With a single CSV, you can prepare hundreds of tests. The simplest form of upload is a single type of test (e.g. the CC2), with the required fields for the test session. In the CC2's case, norms were created with date of birth, and a subject code is stored to allow you to map back to the subject's personal data like name.

Download one of the CC2, or LeST examples under the Help panel to get an example of the format required.

To complete the upload, follow the instructions in the 3 step process. Create your CSV and start by selecting the file.

Once selected, the file will be checked to confirm it's in the right format, and we'll display the set of tests we will create if you proceed. We'll also check the member IDs match your members, and display the member that will be allocated each test. Double check your columns look right, that tests are allocated to the correct members (if you have done this), and that test rows match up with your CSV

When you click upload and validate we check whether you have enough results sheets for each type of test to complete the process. You'll be prompted with how many results sheets will be consumed by the action, how many will be left in your balance, or in the case of falling short, how many extra results sheets you need to purchase to complete the action.

Once you hit Go, all tests are created, and your results sheets are "consumed" by preparing all of the tests. This action can't be reversed, so if you're doing a big upload, please be careful at this final stage.

Prepare multiple types of tests in one CSV

You can create multiple different types of tests, like the LeST, and CC2 in the same CSV. Where the test requires date of birth or grade, include the data, and where it does not, you can leave it blank (it will be ignored). As tests are added over time, the list of available strings to put in the test column will increase.

Prepare tests for multiple group members in one CSV

It's possible to use the CSV import to allocate prepared tests to different members of your group. To do this, each test needs the member column, with a member ID. You can get the member ID of each member in the table of members on the Group page.

CSV file column data specification

"test"	The simple tag-name of the test.
Format:	Text
Range:	"cc2", "lest", "terc", "disti", "dists"
Requirement:	Mandatory field

"subject_code"	The codename of the subject to be tested. Should be a unique identifier, but not include any personally identifiable information.
Format:	Number or short text.
Range:	max 200 characters. e.g. "Student 001" or "347", or "School XYZ, Class B, Year 4, Student 001"
Requirement:	Mandatory field

"subject_dob"	Data of birth of the child/person being tested. Used for tests which use Date of Birth to band the subjects age (e.g. CC2).
Format:	Text Date - "YYYY-MM-DD"
Range:	Date range depends on the norms for the test, consult the documentation for each test. The range will be validated and rejected if the subject falls outside the supported age or banding range. e.g. "2018-01-31" for Jan 31st 2018
Requirement:	Required for relevant tests. Omit column entirely if not required, or leave this field blank for Grade test rows in a mixed-test file.

"subject_grade"	Current school grade of the child being tested. For tests which use Grade to band the subjects (e.g. LeST).
Format:	Number
Range:	Like DOB, Grade range depends on the norms for the test. Usually 0,1,2,3 or 0-12 where 0 is Kindergarten.
Requirement:	Required for relevant tests. Omit column entirely if not required, or leave this field blank for DOB test rows in a mixed-test file.

"member"	Group Admins can create test sessions for other members in their group, by entering the Member's index number here. You can find the member index numbers from the member listing "Your Group". Note these index numbers never change nor are reused, so if you remove a member their index number cannot be used anymore.
Format:	Text
Range:	Any Member index number from the current group.
Requirement:	Optional. Omit this column to default all tests to be owned by the logged in person. If the column header is present, you should enter member indexes for the rows to be owned by the specified group-member. You may leave this field blank in some rows to create tests owned by the currently logged in person (i.e. you do not need to specify your own index, as group admin).