Importing client records by using the Data Loader
When you want to insert or update many client records, you can use the Data Loader to perform a bulk import of client data from a CSV file. When you insert or update client records, the client records are temporarily stored in the Client User Imports object. When the client records are inserted into the Client User Imports object, a trigger is executed. This trigger updates the Contact and User objects with the client records in the Client User Imports object. The new client records are the Portal users who log on to Self Service and use Self Service.
If you are inserting new client records, these client records are created in the Contact and User objects. If you are updating existing client records with new values, these values are updated in the User object only, and not in the Contact object. In the User object, BMC Remedyforce has added the Unique User ID in Source field to track existing client records. BMC Remedyforce checks if the value of this field is present in the User object, and creates a new client record if the value of this field is not present in the User object.
If the imported client records do not have account and profile information, the default account and profile, configured on the User Settings page (Remedyforce Administration > Manage Users > User Settings), are added to the records. If the account or profile information in the imported client records does not match an existing account and profile in the Salesforce organization, these records are not imported and an error occurs. If the account or profile information in the imported client records matches an existing account and profile, the client records are successfully imported.
For more information, see https://na11.salesforce.com/help/doc/user_ed.jsp?section=help&target=inserting_updating_or_deleting_data.htm&loc=help&hash=topic-title.
The following figure illustrates the process of importing data by using the Data Loader.
Importing data by using the Data Loader process flow
The Data Loader is available for download at Setup > Data Management > Data Loader. After you install the Data Loader, you must ensure that your source CSV file contains the following mandatory fields:
- Last Name
- Email ID
- Client User Name
The domain name, configured on the User Settings page (Remedyforce Administration > Manage Users > User Settings), is appended to the Client User Name to form the User Name that a client uses to log on to Self Service. If the client record is imported as an active client, an email is sent to the client's email address. This email contains the temporary password of the client. When the client logs on with the temporary password, the client is directed to a page where the client can change the password. If you use an email address as the Client User Name, BMC Remedyforce takes the user name of the email address and appends the domain name to it.
Additionally, you can add the optional fields (listed in the table above) to the CSV file:
The following table lists the field name, data type, and length of the mandatory and optional fields in the Client User Imports object.
The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.
The following video (6:27) shows procedure to export / import data using Data Loader.
To import client data by using the Data Loader
- Click Start > Programs > salesforce.com > Apex Data Loader 20.0 > Apex Data Loader 20.
- Click Insert.
- In Step 1: Salesforce Settings, type your Salesforce.com User Name and Password.
- Click Log in.
- When the Login completed successfully message appears, click Next.
- In Step 2: Select data objects, select the Client User Imports object.
- In the Choose CSV file field, click Browse, and navigate to your source CSV file.
Click Next.
The following confirmation message appears:Initialization succeeded.
Your operation will contain _<number of records being inserted and updated>_records.- Click OK.
- In Step 3: Mapping, click Create or Edit a map.
In the Mapping Dialog window, drag the Salesforce fields to the appropriate field from the CSV file to create the required mapping.
For example, drag the BMCServiceDesk_Last_Name_c Salesforce field to the LAST_NAME_C field in the CSV fie.- Click OK.
The mapping you have created appears in the Current Field Mapping section. - Click Next.
- In Step 4: Finish, click Browse, and navigate to the directory where you want to store the success and error log files.
The Data Loader generates two unique CSV success and error log files for every operation you perform with Data Loader. - Click Finish.
- In the confirmation dialog box, click Yes.
- (Optional) In the Operation Finished dialog box, click View Successes to view the successful inserts and updates in the CSV Viewer.
- (Optional) To view the failures in the CSV Viewer, click View Errors.
- Click OK.