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:
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
Notes
- This package must be used only for inserting data in a blank Salesforce Organization. It must not be used to update the configuration.
- If you have different default status in your Salesforce organization and migrated organization, after migration, the default status of the migrated organization is retained. If you do not want the default status of the migrated organization, perform one of the following actions:
- Before migrating the data, remove the mapping of the BMCServiceDesk__defaultStatus__c field.
- After migrating the data, open the default status of the migrated organization (Remedyforce Administration > Configure Application > Status) and clear the Default Status check box.
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 importing data, perform the following actions:
Before importing data from another Salesforce organization, perform all of the actions in Before you begin.
Best practice
We recommend that you import individual KJB files in the following order:
- Any custom status, urgency, priority, or impact, objects
- Category
- Templates
- Business Services and Service Offerings
- Request Definitions
- Service Level Agreements
- QuickViews
If you import data in the specified order, you ensure that the data required to create templates, request definitions, service level agreements, and QuickViews is already present in your organization. For example, you will be able to import all request definitions successfully if you have all the categories for which you created these request definitions.
Alternatively, you can use another KJB file, CombinedJobs.kjb (not listed in the preceding table), to import data in the correct order for all possible configurations. This file is at the same level as the folders.
If you had imported the configurations earlier and you want to import them again, ensure that you delete the previously imported configurations. If you do not delete the previous configurations, the already existing configurations do not get migrated.
To check the configurations that were not migrated, lookup the collision files. For example, to check the SRDs that were not migrated, refer the ServiceRequestCollision.csv file. Similarly, to check the configurations that were migrated, lookup the log files. For example, for SRDs that were migrated, refer the SRDMigrationSuccessLog.log file.
- The Pentaho package for Configuration Migration does not support migration of lookup filters for the input fields. You will have to create the lookup filters manually.
- With the 20.18.02 or later releases of Remedyforce, you must use the Configuration Migration Pentaho 20.18.02 package. For earlier versions of Remedyforce, use the earlier versions of Pentaho package.
- Import data to a new organization by using the Pentaho package for Configuration Migration only once. Users should not use this Pentaho package to import data in their organizations multiple times.
- Download the Pentaho job files from https://sourceforge.net/projects/pentaho/files/Data%20Integration/.
For more information on Pentaho Data Integration Tool support versions, see Supported-browsers-mobile-devices-and-integrations. - To launch the Pentaho Data Integration tool 8.2 in the \pdi-ce-8.2.0.0-342.zip 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.
Note
In the Job properties window of the QuickViews KJB file (QuickViewMigration.kjb), do not change the API versions in the values of the SF_DESTINATION_ORG_APIURL and SF_SOURCE_ORG_APIURL parameters. The package does not work for other API versions.
- In the KJB file, select Edit > Settings.
In the Combined Job Properties window, perform the following actions:
- Right-click on the screen.
- Select Properties.
- Click the Parameters tab.
Enter the values for the required parameters.
Notes
- After you enter the credentials for the combined job (top-most parent), the credentials are inherited by all the subsequent jobs or transformations.
- Click
.
The following XLS files are created in the folder where you have extracted 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.
Note
- If you had mapped templates to profiles, the mapping is not imported. After importing data to the new Salesforce organization, you must map the templates and profiles again.
- If you had mapped QuickViews to profiles, the mapping is not imported. After importing data to the new Salesforce organization, you must map the QuickViews and profiles again.
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.
Known-and-corrected-issues-for-Pentaho-packages