ServiceChannel - MoreCore Integration

Get CMMS Site ID

• Utilise the CMMS interface by retrieving the Site ID from the site settings/dashboard URL; or
• Utilise SSMS to retrieve the Site ID.
• Note the CMMS Site Name as well, although this is used just for visual reference and not as part of the matching process.

Get ServiceChannel Site ID

• Utilise the API Dog ServiceChannel project to collect data: https://app.apidog.com/project/441958 (opens in a new tab)
• Navigate to the 'Reference Data Collection' test, in the Tests menu.
• Run the Locations List calls.
• Find the store in the returned data.
• The following data fields are needed:
  • SC.StoreId
  • SC.Store.Name
  • SC.Id
  • SC.Store.Lat
  • SC.Store.Long

Update Boomi

• The Cross Reference table to be updated is 'SC-CMMS.XR-03.[SC]StoreId>[CMMS]Site_ID'. As the processes are deployed and the table is extended, the data must be added to the Prod Atom Environment Extensions.
• Navigate to the Runtime Management page: https://platform.boomi.com/AtomSphere.html#atom;accountId=cbcfacilitiesmaintenances-Y6QPI4 (opens in a new tab)
• Click the 'Prod' Atom in the left list.
• Click 'Environment Extenstions'
• Click 'Cross Reference'
• Select the 'SC-CMMS.XR-03.[SC]StoreId>[CMMS]Site_ID' table.
• Add a new row, and add in the appropriate data collected from CMMS and ServiceChannel.
• Click 'OK' to save changes.