This documentation supports the 20.08 version of BMC Helix Platform.  To view an earlier version, select 20.02 from the Product version menu.

Loading the region and site group data in bulk for existing users


The Foundation data model differs between Remedy IT Service Management (Remedy ITSM) and BMC Helix Platform. The following table lists the differences in Location data model between Remedy ITSM and BMC Helix Platform:

Location data in Remedy ITSM

Location data in BMC Helix Platform

Region

Parent Region

Site Group

Region

Site

Site


Site Area

As an administrator, when you load the Foundation data from Remedy ITSM to BMC Helix Platform for the first time, the differences in Location data are loaded to BMC Helix Platform and will adapt to the BMC Helix Platform Foundation data model.

Important

To load the Foundation data to BMC Helix Platform, you must have an administrator or the appropriate Foundation Write permission.

If you have already loaded the Foundation for the first time to BMC Helix Platform, and you modify the Region, Site Group, and Site data in Remedy ITSM, you must manually load the updated Location data to BMC Helix Platform by completing the tasks listed in this topic.

For more information about region, site, and site group data that is loaded and synchronized from Remedy ITSM to BMC Helix Platform, see Supported Remedy ITSM Foundation data for data load and synchronization.

Task 1: To export the region and site group data to an Excel spreadsheet

  1. Log in to BMC Remedy IT Service Management Console as an ITSM administrator.
  2. To access the Site Association Information UI, enter the following URL: 
    http://<serverName>/arsys/forms/<serverName>/ISS%3ASiteAssociationInformation/Default+Administrator+View
  3. To search for all the site data, in the Site Name field, enter %, and click Search
  4. To select all the data that you want to export, click Select All, and then click Report.
  5. To create a new report, on the Report Console - ISS:SiteAssociationInformation page, click Support_Group_New_Report_Button.png and enter the following details:

    Field

    Sample Value

    Type

    Web

    Form

    ISS:SiteAssociationInformation

    Name

    Site Information

  6. Click OK.
  7. In the Report Definition section, on the Columns tab, add Site NameSite IDInstanceIDCompanyRegionSiteGroup, and Site Group Type to the Column list. 
  8. Click Save.
  9. Click Back, and then click Run
  10. To export the report as an Excel spreadsheet, click Support_Group_Export_Report_Button.png.
    The Excel file is downloaded with the same name as the report (for example, Site Information).

Task 2: To download and update the template Excel spreadsheet with the exported region and site group data

  1. Open the Site Information.xlsx spreadsheet that you downloaded in Task 1
  2. Download the Site - Region and Site Group data template.
  3. Perform the following actions:

    Copy from the Site Information spreadsheet

    Paste in the Site - Region and Site Group Data spreadsheet

    Data from InstanceID column

    Object GUID column

    Data from Region column

    Associated Region column

    Data from Site Group column

    Associated Site Group column

    Data from Site Group Type column

    Site Group Type column

  4. Update all the remaining columns in Site- Region and Site Group spreadsheet as displayed in the following image:
    Site- Region and Site Group example spreadsheet.png
  5. Save the updated template.

Task 3: To upload the exported region and site group data to BMC Helix Innovation Studio

Upload the updated Site- Region and Site Group spreadsheet to BMC Helix Platform so that the region and site group data is available for processing.

For more information about uploading the spreadsheet, see Uploading-the-Foundation-data-spreadsheets. Make sure you select the Site- Region and Site Group spreadsheet as the attachment. 

The updated spreadsheet with the region and site group data is uploaded to BMC Helix Platform. You must then run the load process to import the Foundation data from the spreadsheet to BMC Helix Platform.

Task 4: To view the transaction audits and verify the processed Region and Site Group data

When the region and site group data are processed successfully after the 30 minutes escalation, it is updated in BMC Helix Innovation Studio and you can verify the processed region and site group data from Transaction Audits

  1. Log in to BMC Helix Innovation Studio and navigate to the Administration tab.
  2. Select Foundation Data > ITSM Foundation Data SYNC > Transaction Audits.
  3. On the ITSM Synchronized Foundation Data UI, you can view the processed region and site group data updates.

Where to go from here

Viewing-the-synchronized-Foundation-data

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*