Commands available to include in a bulk import file

When you update the template for a bulk import, you must use the correct commands for creating users, disabling users, assigning roles, and removing roles.

To learn more about working with the template, see Guidelines for updating the bulk import file.

The following command are available for you to apply updates using a bulk import file.

Task	Command name	Command to use in a text file
Create an Oracle Life Sciences single sign-on (SSO)	`create`	`create,<organization id>,<user login>,<email id>,<middle name>,<first name>,<last name>`
Assign a role to a user	`authorize`	`authorize,<organizatoin id>,<user login>,<role name>`
Remove a role from a user	`deauthorize`	`deauthorize,<organizatoin id>,<user login>,<role name>`
Disable a user's Oracle Life Sciences SSO	`disable`	`disable,<organization id>,<user login>`

Command variables

This table describes all the variables used in the commands available for bulk import.

Value	Description
`<email id>`	Enter the user's email address.
`<first name>`	Enter the user's first name.
`<last name>`	Enter the user's surname or family name.
`<middle name>`	(Optional) Enter the user's middle name. If the user doesn't have a middle name: When using a spreadsheet tool, leave the cell empty. When using a text editor, omit the value leaving two consecutive commas.
`<organization id>`	Enter your company's `ShortOrgId`. Need help finding your company's ShortOrgId?
`<role name>`	Enter the role you are granting or removing, including the `ShortOrgId` as a prefix. For example: `mypharma.Approver` Need help figuring out the roles to assign?
`<user login>`	Enter the user's email address.

Examples

Example 3-1 Commands added to a bulk import file using a text editor

create,Oracle,john.smith@example.com,john.smith@example.com,,john.smith
authorize,Oracle,john.smith@example.com,ClinicalOne_Production
deauthorize,Oracle,john.smith@example.com,ClinicalOne_Production
disable,Oracle,john.smith@example.com

Example 3-2 Same commands added to a bulk import file using a spreadsheet tool

You use the same commands in the same order when using a spreadsheet tool (such as Microsoft Excel), but each value must be in its own cell, as shown in the following example.

Sample commands to use for bulk import in a Microsoft Excel sheet