How to populate Accounts Collection in ODM using CSV file? (4370955)

To create one or more collections with a CSV file:

This is a two-step process as described below:

Step 1: Prepare the CSV file

You can choose one of two formats to prepare the CSV file:

Format 1: Use the ObjectId to identify accounts

• ObjectId - Column header for the globally unique identifier that represents a discovered account. The following variations of ObjectId are supported: ObjectId, objectid, objectId, OBJECTID
• Collection - Column header for the collection name

Format 2: Use the UserPrincipalName to identify accounts

• UserPrincipalName - Column header for the login name of an account based on the Internet standard RFC 822. Do not use a mail nickname or proxy address. The following variations of UserPrincipalName are supported: UserPrincipalName, userprincipalname, USERPRINCIPALNAME
• Collection - Column header for the collection name

Step 2: Import the CSV file

1. Log in to Quest On Demand and choose an organization if you have multiple organizations.
2. From the navigation pane, click Migration to open the My Projects list.
3. Create a new project or open an existing project.
4. Click the Accounts tile, or click Open from the Accounts tile to open the Accounts and User Data workspace.
5. Select the Accounts tab and select List View if not already selected.
6. From the actions toolbar, click More Actions and then click Import Collections. The Import Collections from File dialog opens.
7. Click the Provide accounts as a list of drop-down and select either ObjectIds or UserPrincipalNames depending on the format of the CSV file that you have prepared.
8. Click Browse and select the CSV file. The selected CSV file name appears.
9. Click Import.