Administering Oracle CRM On Demand > Data Management Tools > Import and Export Tools > Preparing for Data Importing > Exam Fields: Import Preparation
Exam Fields: Import Preparation
The following table contains specific information about setting up your CSV file before importing exam data into Oracle CRM On Demand. This information supplements the guidelines given in the topic Field Type Guidelines for Importing Data. First, you must review the following import information before performing an import.
NOTE: The Default Field column in this table contains only the initial (default) name for each field. It does not contain any names that have been changed for your company in Oracle CRM On Demand. Therefore, if you do not see a specific field when you try to import your data, check with your administrator to determine the new name for the field.
Default Exam Field Name
|
Field Type
|
Maximum Length
|
Comments
|
Available From
|
Date
|
7
|
None.
|
Available To
|
Date
|
7
|
None.
|
Company
|
Text
|
100
|
None.
|
Contact
|
Picklist
|
15
|
Use this field if the exam contact is already present in Oracle CRM On Demand.
|
Description
|
Text
|
255
|
None.
|
Email
|
Text
|
100
|
The email address for the exam contact.
|
Exam Fee
|
Currency
|
22
|
None.
|
Exam ID
|
Text
|
100
|
It is recommended that the internal identifier for the course be unique.
|
First Name
|
Text
|
50
|
Use this field to enter the exam contact's first name only if the contact is not present in Oracle CRM On Demand.
|
Format
|
Picklist
|
30
|
The default valid values are as follows: Multiple Choice, Q&A, and Blended.
|
Grading Method
|
Picklist
|
30
|
The default valid values are as follows: Grades, Points, and Scores.
|
Last Name
|
Text
|
50
|
Use this field to enter the exam contact's last name only if the contact is not present in Oracle CRM On Demand.
|
Maximum Score
|
Number
|
22
|
None.
|
Medium
|
Picklist
|
30
|
The default valid values are as follows: Computer-Based, Paper-Based, and Blended.
|
Name
|
Text
|
100
|
It is recommended that the exam name be unique.
|
Number of Questions
|
Number
|
22
|
None.
|
Objective
|
Picklist
|
15
|
None.
|
Owner
|
Picklist
|
15
|
None.
|
Passing Score
|
Number
|
22
|
None.
|
Payment Options
|
Picklist
|
30
|
The default valid values are as follows: Cheque, Credit Card, Cash, and Earned Funds.
|
Phone
|
Phone
|
40
|
The phone number for the exam contact.
|
Primary Product
|
Picklist
|
15
|
None.
|
Primary Product Category
|
Picklist
|
15
|
None.
|
Status
|
Picklist
|
30
|
The default valid values are as follows: Draft, Planned, Available, Obsolete, and Inactive.
|
Time Allowed (Minutes)
|
Number
|
22
|
None.
|
Type
|
Picklist
|
30
|
The default valid values are as follows: Proctored and Online. An exam is considered to be proctored when the candidates are supervised during the exam.
|
Validity (Months)
|
Number
|
22
|
None.
|
Website
|
Text
|
100
|
The URL to a page that contains additional exam information.
|
Related Topics
See the following topics for related information:
|