Use the reference table below to help you correctly format exam data you want to import via the Exam Data Loader.
Use the reference table below to help you correctly format exam data you want to import via the Exam Data Loader.
Administrators with read-only or unrestricted access to the Exam and Question Manager feature, unrestricted access to Exams, and unrestricted access to the Data Loader feature in System Roles (Manage Features > Exam Manager Features) can import exam data.
To import exam data and review previous imports, go to Manage Center > Learning > Exam Utilities > Exam CSV Loader.
(Table: Exam Data Loader Field Reference)
| Field | Content | Data Handling | Default |
| ExamID | Unique Identifier for the exam | A Unique ID That Conforms to PeopleFluent LMS ID constraints (maximum 85 characters) | None |
| AutoGrade | Automatically Grade? | "Y" or "N" | Y |
| AttemptLimit | Maximum Number of Attempts for Each Participant | Any Positive Whole Number | 1 if system license is Exam only, otherwise 9999 |
| Participant Review | Allow participant review | Must be one of: Y - Always P - If Passed N - Never | Y |
| AllowHints | Allow hints? | "Y" or "N" | N |
| DateEntered | Date and time record is created | Must be in the format yyyy-MM-dd HH:mm:ss, e.g., 2010-08-25 13:00:00 denotes August 25, 2010, 1:00 p.m. | System Date |
| RequiredPoints | Required Number of Points | Any Positive Whole Number | System Configuration - Default Passing Grade |
| Description | Description | Any Text (Max field length:None) | None |
| Stylesheet | Colors and Fonts | Existing style sheet name | Test Default |
| ExamType | Exam type | Must be one of: 0 - Standard Exam 1 - Survey 5 - Skills Exam | 0 |
| MaxTimeAllowed | Maximum Time Allowed | Must be in the format HH:mm, e.g., 10:10 denotes 10 hour and 10 minutes. Applicable for gradeable exam types only (i.e. Standard Exam, Certification, Skills Exam) | None |
| ValidFrom | Not available before | Must be in the format yyyy-MM-dd HH:mm (mm is at intervals of 30mins), e.g., 2010-08-25 13:00 denotes August 25, 2010, 1:00 p.m. | None |
| ValidTo | Not available after | Must be in the format yyyy-MM-dd HH:mm (mm is at intervals of 30mins), e.g., 2010-08-25 13:00 denotes August 25, 2010, 1:00 p.m. | None |
| AllowPrint | Allow candidates to print exams | "Y" or "N" | N |
| AllowResume | Allow candidates to resume incomplete attempts | "Y" or "N" | Y |
| MinimumRetakeIntervalAmount | Participants cannot retake exam within(amount field) | Any Positive Whole Number Applicable when system license is not Exam only | 0 |
| MinimumRetakeIntervalUnit | Participants cannot retake exam within(unit field) | Must be one of: D - Day W - Week M - Month Y - Year Applicable when system license is not Exam only | D |
| AllowScoreDisplay | Display score | "Y" or "N" | Y |
| AllowNavigation | Allow Section/Question Navigation | "Y" or "N" | N |
| AllowQuestionIdDisplay | Display question ID | "Y" or "N" | N |
| DisallowAbandon | Disallow abandonment of a resumed exam? | "Y" or "N" | N |
| IsTemplate | Is a Template? | "Y" or "N" | N |
| ReviewQuestion | After each page of questions | Must be one of: NOREVIEW - Just continue to the next page ANSWERCORRECT - Mark answers | NOREVIEW |
| MarkType | Marking type | Must be one of: M - Point | P |
| ShowMark | Show number of marks for each question | "Y" or "N" | Y |
| ReviewType | Participant can review | Must be one of : C - Correct answers I - Incorrect answers O - Incorrect answers only | O |
| MaxTimePerQuestion | Maximum Time per Question (seconds) | Any Positive Whole Number | 0 |
| PoolSummaryLevel | Pool Summary Level | 0-7 | 0 |
| AllowDownload | Allow download | "Y" or "N" | N |
| DisableMouseRightClick | Disable mouse right click | "Y" or "N" | N |
| LastUpdated | Last Updated | Must be in the format yyyy-MM-dd- HH:mm:ss, e.g., 2010-08-25 13:00:00 denotes August 25, 2010, 1:00 p.m. | System Date |
| ExamPool | Assigns the exam to an exam pool. If the exam pool does not already exist, it will automatically be created. | A complete exam pool path, forward slash-delimited("/") | Default Test Pool |
| RecordPostCompletionAttempts | Enable recording the attempts | "Y" or "N" | N |
| RecordPostCompletionHigherScore | Allow the exam score to be updated if the post-completion attempt has a higher score, but would not update if the attempt has a lower score. (While this setting could be enabled without the RecordPostCompletionAttempts setting, a higher score cannot be recorded if the attempt itself is not recorded.) | "Y" or "N" | N |
| PostExamInfo | Post exam information, which will be presented to learners when they complete an exam | Any Text (Max field length:None) | None |