|
Administering Oracle CRM On Demand > Data Management Tools > Import and Export Tools > Preparing for Data Importing > Book User Fields: Import Preparation
Book User Fields: Import Preparation
The following table contains specific information about setting up your CSV file before importing book users 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. For more information on using books in Oracle CRM On Demand, see Book Management.
Default Book Users Field Name
|
Data Type
|
Maximum Length
|
Comments
|
Access Profile
|
String
|
100
|
None
|
Book User Role
|
String
|
30
|
None
|
Users
|
String
|
50
|
This field is the value for the user alias.
|
Book Name
|
String
|
150
|
If you perform a new import, then it is recommended that you only specify a value for the Book Name field, or the Book Id, not both.
|
Book Id
|
String
|
15
|
If you perform a new import, then it is recommended that you only specify a value for the Book Name field, or the Book Id, not both.
If you update an existing record, then the Book Id field is mandatory.
|
User Identifier
|
String
|
15
|
If you update an existing record, then the User Identifier field is mandatory.
If you perform a new import, then it is recommended that you specify values for at least one of the following fields: User Sign In ID or User Identifier, or User External ID.
|
User External Id
|
String
|
30
|
If you perform a new import, then it is recommended that you specify values for at least one of the following fields: User Sign In ID or User Identifier, or User External Id.
|
User Sign In ID
|
String
|
50
|
If you perform a new import, then it is recommended that you specify values for at least one of the following fields: User Sign In ID or User Identifier, or User External Id.
|
|
