Please use ALL the Column Names below in your import file as ALL the Column headers are required. If you do not have information to place in a column just leave that column blank with the correct header. You can use User ID, Student ID, OR Host ID to import these Scores.
As long as the main Test Description is the SAME for each Subtest (same Spelling and Capitalization) and grouped by Student vs Test, then the Subtests will all display within that main Test Name.
For example in my Excel File if I have John Smith with 1 row for a PSAT subtest and then the next row is his SAT for a Subtest and my main Test name is Test, they will both nestle under "Test" on the Test Score Screen. If in my Excel File I have all Students listed who have a PSAT Test Score, and then All Students listed who have a SAT Score, then there will be a seperate instance for each test Score meaning each Student will have Test with Subtest PSAT and then Test with SAT and they will not be nestled under the main Test name.
Note:This import can not be used to update existing test score records, nor will it prevent the insertion of duplicate test score records. Please review your file prior to submission.
|Column Name||Required||Data Type||Max Length||Description|
|student_id||TRUE||INT||N/A||Unique number assigned to a Student in Core|
|host_id||TRUE||int||N/A||Users Host ID which is unique to each user and usually is assigned from another system|
|user_id||TRUE||int||N/A||Blackbaud assigned unique ID for the candidate/student|
|test_date_time||TRUE||datetime||Date/time associated with test. Must be in MM/DD/YYYY or MM-DD-YYYY format such as 10/6/2017 12:00:00 AM|
|registered_date||FALSE||DATE||8||Date User Registered for Test such as 9/6/2017|
|registered_location||FALSE||Location of Test such as City, State, or School Name|
|rescheduled||FALSE||FALSE for not rescheduled TRUE for rescheduled|
|no_show||FALSE||FALSE for showing up TRUE for not showing up|
|proctor_id||FALSE||INT||N/A||User ID of the User who gave the Test|
|proctor_other||FALSE||N/A||Role/Title of Proctor such as Principal|
|test_description||TRUE||varchar||50||Test name - exact match to Test name as set-up in onBoard > Settings > Tests.|
|overall_score||FALSE||real||4||Test Overall Score|
|subtest_description||TRUE||varchar||50||Subtest descriptive name - exact match to sub Test Description as set-up in onBoard > Settings > Tests > Subtest.|