Importing Exam Taker Data
Importing Exam Taker Data This is the first step in the process of importing an institutions’ data into the ExamSoft database CHP. Exam Taker (ET) data needs to be imported for ETs to have access to exams. 1.
Login to the CHP as an Administrator.
2.
Navigate to the
3.
Select the
4.
Download and review the ‘Data Import Overview’ and ‘Data Import Instructions’ to learn how to format the data files.
8.
When saving the file, ensure that the file name begins with the word students (i.e. Students File) in order for the importer to recognize the file.
9.
Save your file type as ‘Text (tab delimited)’ file.
Tab. button.
10. Click ‘Yes’ to confirm that you want to keep this spreadsheet in text tab delimited format.
11. Once you have saved the Student File, go back to the Import Data Files page on your CHP. 12. Next to the Students.txt field, click ‘Browse.’ 5.
Download and review the ‘Sample Students File’ to ensure you have the correct column headings and content in your spreadsheet.
6.
Create your student file database in a spreadsheet. a. StudentID: must be unique for each student Password: an asterisks (*) will generate a random one by the system for each ET b. Lab Equipment: 0=personal computer, 1=lab c. Accommodation Group #: (optional)
13. Browse through your files to find the Student File spreadsheet you just saved. Click on the saved file name and then click ‘Open.’ 14. Next, click the
button.
15. The name and size of your file will appear on the page as confirmation of upload.
If you need to create an accommodation group, please speak with your Account Manager. Each institution’s accommodations will be defined with a number. If known, place this number with the ET information during data import. If not, it can be added later. (Review: Managing Accommodations Rules)
7.
Before saving the spreadsheet file, confirm that the data is correct and in the proper format with the same column headings as the ones illustrated in the ‘Sample Students File’. a. StudentID b. Lname c. Fname d. Email e. Passwd f. LabEquip g. Accommodation Group #
support.examsoft.com
(866) 429-8889
16. If you have import email alerts enabled, you will also receive an email confirmation within ten minutes of your Student file uploading. If there were any errors during the import, they will be listed in this email. Common Data Upload Errors:
Use of commas in any field Invalid email Address Format Invalid StudentID (use of symbols or special characters) Invalid StudentID Length (preset by institution) Missing Information (complete all fields)
1 of 1
December 10, 2012
Login to the CHP as an Administrator.
2.
Navigate to the
3.
Select the
4.
Download and review the ‘Data Import Overview’ and ‘Data Import Instructions’ to learn how to format the data files.
8.
When saving the file, ensure that the file name begins with the word students (i.e. Students File) in order for the importer to recognize the file.
9.
Save your file type as ‘Text (tab delimited)’ file.
Tab. button.
10. Click ‘Yes’ to confirm that you want to keep this spreadsheet in text tab delimited format.
11. Once you have saved the Student File, go back to the Import Data Files page on your CHP. 12. Next to the Students.txt field, click ‘Browse.’ 5.
Download and review the ‘Sample Students File’ to ensure you have the correct column headings and content in your spreadsheet.
6.
Create your student file database in a spreadsheet. a. StudentID: must be unique for each student Password: an asterisks (*) will generate a random one by the system for each ET b. Lab Equipment: 0=personal computer, 1=lab c. Accommodation Group #: (optional)
13. Browse through your files to find the Student File spreadsheet you just saved. Click on the saved file name and then click ‘Open.’ 14. Next, click the
button.
15. The name and size of your file will appear on the page as confirmation of upload.
If you need to create an accommodation group, please speak with your Account Manager. Each institution’s accommodations will be defined with a number. If known, place this number with the ET information during data import. If not, it can be added later. (Review: Managing Accommodations Rules)
7.
Before saving the spreadsheet file, confirm that the data is correct and in the proper format with the same column headings as the ones illustrated in the ‘Sample Students File’. a. StudentID b. Lname c. Fname d. Email e. Passwd f. LabEquip g. Accommodation Group #
support.examsoft.com
(866) 429-8889
16. If you have import email alerts enabled, you will also receive an email confirmation within ten minutes of your Student file uploading. If there were any errors during the import, they will be listed in this email. Common Data Upload Errors:
Use of commas in any field Invalid email Address Format Invalid StudentID (use of symbols or special characters) Invalid StudentID Length (preset by institution) Missing Information (complete all fields)
1 of 1
December 10, 2012
