Importing Course Student Data
Importing Course Student Data Importing Course Student Data assigns the Exam Taker (ET) accounts that you already have created to your courses. This gives ETs access the posted exams allowing them to download them for exam day. It is important the data files for ETs and courses are uploaded in the ordered displayed on the Import Data Files page. This will prevent errors when assigning ETs to courses, and ensures that exam postings are accurate. (Review: Importing Exam Taker Data & Importing Course Data)
8.
Click ‘Yes’ to confirm that you want to keep the spreadsheet in text tab delimited format.
9.
Once you have saved the Course Student Data File, go back to the Import Data Files page on your CHP and click ‘Browse.’
10. Next to the CourseStudent.txt field, click ‘Browse’.
1.
Login to the CHP as an Administrator.
2.
Navigate to the
3.
Select the
4.
Download and review ‘Sample CourseStudent File’ to ensure you have the correct column headings and content in your spreadsheet.
Tab.
11. Browse through your files to find the Course Student Data spreadsheet you just saved. Click on the saved file name and then click ‘Open.’
button. 12. Next click the
5.
button.
13. The name and size of your file will appear on the page as confirmation of upload.
Create your course student database in a spreadsheet. a. Column headings: same as the ones in the first row of the sample b. Requires Only CourseID to match StudentID c. CourseID is ALWAYS listed in the first column d. StudentID is then listed in the second column
14. If you have import email alerts enabled, you will also receive an email confirmation within ten minutes of your Course Student Data file uploading. If there were any errors during the import, they will be listed in this email. Common Data Upload Errors:
Caution: When updating a course, DO NOT add individual ETs using this method. You will remove all ETs already enrolled in the course.
6.
When saving the file, ensure that the file name begins with the combined words coursestudent (i.e. CourseStudent Data) in order for the importer to recognize the file.
Use of Commas in any field Invalid CourseID (course should already exist) Missing Information (complete all fields)
15. To add ETs to a course without losing those who are already enrolled, choose one of the following methods: a.
Manually search for and select Exam Takers to add to individual courses (Review: Assigning Exam Takers to Courses)
7.
Save your file type as ‘Text (tab delimited)’ file.
b.
Re-import a CourseStudent.txt file with EVERYONE currently enrolled in course along with those being added (Review: Importing Course Student Data)
support.examsoft.com
(866) 429-8889
1 of 1
December 10, 2012
8.
Click ‘Yes’ to confirm that you want to keep the spreadsheet in text tab delimited format.
9.
Once you have saved the Course Student Data File, go back to the Import Data Files page on your CHP and click ‘Browse.’
10. Next to the CourseStudent.txt field, click ‘Browse’.
1.
Login to the CHP as an Administrator.
2.
Navigate to the
3.
Select the
4.
Download and review ‘Sample CourseStudent File’ to ensure you have the correct column headings and content in your spreadsheet.
Tab.
11. Browse through your files to find the Course Student Data spreadsheet you just saved. Click on the saved file name and then click ‘Open.’
button. 12. Next click the
5.
button.
13. The name and size of your file will appear on the page as confirmation of upload.
Create your course student database in a spreadsheet. a. Column headings: same as the ones in the first row of the sample b. Requires Only CourseID to match StudentID c. CourseID is ALWAYS listed in the first column d. StudentID is then listed in the second column
14. If you have import email alerts enabled, you will also receive an email confirmation within ten minutes of your Course Student Data file uploading. If there were any errors during the import, they will be listed in this email. Common Data Upload Errors:
Caution: When updating a course, DO NOT add individual ETs using this method. You will remove all ETs already enrolled in the course.
6.
When saving the file, ensure that the file name begins with the combined words coursestudent (i.e. CourseStudent Data) in order for the importer to recognize the file.
Use of Commas in any field Invalid CourseID (course should already exist) Missing Information (complete all fields)
15. To add ETs to a course without losing those who are already enrolled, choose one of the following methods: a.
Manually search for and select Exam Takers to add to individual courses (Review: Assigning Exam Takers to Courses)
7.
Save your file type as ‘Text (tab delimited)’ file.
b.
Re-import a CourseStudent.txt file with EVERYONE currently enrolled in course along with those being added (Review: Importing Course Student Data)
support.examsoft.com
(866) 429-8889
1 of 1
December 10, 2012
