Print      Open PDF Version of Online Help


Previous Topic

Next Topic

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 company 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.


Published 5/4/2012 Copyright © 2005, 2012, Oracle. All rights reserved. Legal Notices.