Import scantron data from Remark

This article explains how to import remark test results.

Importing remark test results #

To import results, the following conditions must be fulfilled:

1. The test must be manually created.
2. The test can only contain single choice, multiple-choice, or true/false question types.
3. The test must have an external ID.
4. Each user must have an external ID.
5. The users must be assigned to the test and have a “Not attempted” status.

Note: If the file contains different test results from a single user in the same test, only the first results will be imported, and the others will be skipped.

It’s necessary to define the following information in the file that will be uploaded.

User ID #

User ID represents the external ID of a candidate. If the external ID can’t find the candidate, the system will find the candidate by the systems ID. If the system can’t find the candidate by the systems ID, the candidate will be skipped to import.

Test external ID #

If the system can’t find the test by the external ID, the candidate will be skipped to import.

Responses to all questions #

Responses to all questions in the test started from c4.

The test results won’t be imported if the user’s external ID or test doesn’t exist in the system. If the answer is, for example, AB, the student chooses the first and the second answer for the question.

The prepared file can be imported into the application in two ways.

The first way is to import the file manually.

Hower to the Tests main menu item and select the Manage tests menu. Click the Import data button and choose Import Remark results to import test results.

The pop-up window will appear. Next, click on the Select file button and choose the file. Finally, click on the Upload button.

The test result is imported. The status has changed to Report complete when clicking on the test and navigating to the Candidates tab. Their score and results appeared for the first two candidates.

The other way to import results is to use “Jobs scheduler“.

To import the test results through the “Jobs scheduler“, do the following:

1. Navigate to the System menu.
2. Select the System and customization sub-menu.
3. Navigate to the Job scheduler tab.
4. Click on the Create new button.

To create a new job, do the following:

1. In the pop-up window, choose the job type and choose Remark result import.
2. Enter the name.
3. Optionally add a job description.
4. Set the start time the first execution should happen.
5. If the Repeat option is checked, the job will repeat at the same time in intervals.
6. Define the repeat interval.
   
7. In location choose SFTP server.
8. Enter the host SFTP server address.
9. Enter the port of the SFT protocol.
10. Enter the username of the SFTP server user.
11. Enter the password.
12. Click the Test connection button to check if SFTP parameters are working.
13. Import the absolute path to the folder to import data from.
14. Enter the file names.
15. Click the save button to create a job.

When the job is created, it will be inserted at the top of the table.

For each job in the table, the following actions can be performed:

1. First, click the three vertical dots adn choose one of the actions
2. Execute job – the job is executed immediately.
3. Preview complete execution history and logs of the job.
4. Edit job.
5. Copy job.
6. Delete job.

To preview the complete execution history and logs for all jobs in the system, navigate to the Execution history and logs tab to see details of the executed jobs. There can be seen job type, when the job was executed, the number of errors during the execution, and preview a log.

Conclusion #

Now you know how to handle Remark import both manually and automatically. If you want to learn more, we suggest you to watch How to Import Testing Sessions via Job Scheduler.