Importing BMC Remedyforce configuration data from another Salesforce organization
You can import data from one Salesforce organization to another. The Salesforce organization can be a sandbox or a production organization. For example, say that you added some real configuration data to a sandbox while testing BMC Remedyforce. You can import this data to your production organization by using Pentaho packages.
The following topics are provided:
Overview of Pentaho packages
Pentaho packages, provided on the BMC Communities website, enable you to import the following data:
- Basic configurations that include status, impact, urgency, priority
- Categories
- Templates
- Business Services and Service offerings
- Request definitions
- Service Level Agreements (SLAs)
QuickViews
The following table lists folders included in the zip file on the BMC Communities website, the KJB file available in each folder, and the objects that are imported during data import.
BMC recommends that you import individual KJB files in a specified order. Another KJB file, CombinedJobs.kjb (not listed in the preceding table), is provided to import data in the correct order for all possible configurations. This file is at the same level as the folders. For information about the order in which to import KJB files, see To import data from another Salesforce organization.
Before you begin
Before importing data, perform the following actions:
To import data from another Salesforce organization
Before importing data from another Salesforce organization, perform all of the actions in Before you begin.
Download the Pentaho job files from the BMC Communities page: https://communities.bmc.com/docs/DOC-33778.
- To launch the Pentaho Data Integration tool, in the \pdi-ce-5.0.1.A-stable\data-integration folder, double-click the Spoon.bat file.
Open the KJB file for the package that you want to import.
For example, to import categories, open the CategoryMigrationJob.kjb file from the Category folder.- In the KJB file, select Edit > Settings.
In the Job Properties window, enter the username and password for the source and destination Salesforce organizations.
- Click
.
The following XLS files are created in the folder where you have unzipped the Pentaho packages downloaded from the BMC Communities website:
- <Object name>Collision: Lists the records that already exist in the destination Salesforce organization.
- <Object name>Success: Lists the records that were successfully imported.
- <Object name>Error: Lists the records that were not imported successfully.
When you run the Pentaho package again, already imported records are not imported (even if the imported records are updated in the source organization). However, if you update the Name field of an already imported record, the record is imported again when you run the Pentaho package.