This documentation supports the 18.05 version of Remedy IT Service Management Suite.

To view the latest version, select the version from the Product version menu.

Transactional data mapping

This section lists the mapping of transactional data from spreadsheets to target forms.

Note


The Dataload spreadsheet dependencies topic has more information about the order in which to load data.

Note

If you have installed Process Designer and there is transactional data in the system, do not upgrade ITSM or SRM. Contact BMC for further help.

Transactional data mapping for BMC Remedy ITSM

Spreadsheet

Tab

Staging form

Target form or forms

Transactional_
CI.xlsx

AST_ComputerSystem

Not applicable

BMC.CORE:BMC_Computer System
Note:
The following fields are hidden internal fields used to store reconciliation references:

  • Rel Lead Class Id
  • Rel Lead Instance IdThese fields should be left blank in the spreadsheet.

Transactional_
CI.xlsx

AST_ComputerSystem

AST:LoadAttributes

AST:Attributes

Note:
The following fields are hidden internal fields used to store reconciliation references:

  • Rel Lead Class Id
  • Rel Lead Instance Id
    These fields should be left blank in the spreadsheet.

Transactional_
CI.xlsx

AST_OperatingSystem

Not applicable

BMC.CORE:BMC_Operating
System

Transactional_
CI.xlsx

AST_OperatingSystem

AST:LoadAttributes

AST:Attributes

Transactional_
CI.xlsx

AST_Processor

Not applicable

BMC.CORE:BMC_Processor

Transactional_
CI.xlsx

AST_Processor

AST:LoadAttributes

AST:Attributes

Transactional_
CI.xlsx

AST_Product

Not applicable

BMC.CORE:BMC_Product

Transactional_
CI.xlsx

AST_Product

AST:LoadAttributes

AST:Attributes

Transactional_
CI.xlsx

AST_BusinessService

ATS:LoadAttributes

BMC.CORE:BMC_BusinessService

Transactional_
Asset.xlsx

AST_LoadWorkLog

AST:LoadWorkLog

AST:WorkLog

Transactional_
Asset.xlsx

AST_LoadBMC_BaseR
elationship

AST:LoadBMC_BaseRela
tionship

  • BMC.AM:BMC_APPLI
    CATIONSYSTEMSERV
    ICES
  • BMC.AM:BMC_COMP
    ONENT
  • BMC.AM:BMC_DEPE
    NDENCY
  • BMC.AM:BMC_ELEM
    ENTLOCATION
  • BMC.AM:BMC_HOST
    EDACCESSPOINT
  • BMC.AM:BMC_HOST
    EDSERVICE
  • BMC.AM:BMC_HOST
    EDSYSTEMCOMPONE
    NTS
  • BMC.AM:BMC_IMPA
    CT
  • BMC.AM:BMC_INIPS
    UBNET
  • BMC.AM:BMC_INSEG
    MENT
  • BMC.AM:BMC_IPSUB
    NETINCOLLECTION
  • BMC.AM:BMC_INVEN
    TORYBULKITEMS
  • BMC.AM:BMC_INVEN
    TORYCOMPUTERSYS
    TEMS
  • BMC.AM:BMC_INVEN
    TORYSYSTEMCOMPO
    NENTS
  • BMC.AM:BMC_INVEN
    TORYEQUIPMENT

Transactional_
Asset.xlsx

AST_LoadBMC_BaseR
elationship

AST:LoadBMC_BaseRela
tionship

  • BMC.AM:BMC_LNSIN
    COLLECTION
  • BMC.AM:BMC_MEMB
    EROFCOLLECTION
  • BMC.AM:BMC_SEGM
    ENTINCOLLECTION
  • BMC.AM:BMC_ACCO
    UNTONSYSTEM
  • BMC.AM:BMC_BASER
    ELATIONSHIP
  • BMC.AM:BMC_SETTI
    NGSOF

Transactional_
Asset.xlsx

AST_LoadAssetPeople

AST:LoadAssetPeople

AST:AssetPeople

Transactional_
Change.xlsx

CHG_LoadInfrastruct
ureChange

CHG:LoadInfrastructure
Change

CHG:InfrastructureChange

Transactional_
Change.xlsx

CHG_LoadWorkLog

CHG:LoadWorkLog

CHG:WorkLog

Transactional_
Change.xlsx

CHG_LoadImpactedA
reas

CHG:LoadImpactedAreas

CHG:Impacted Areas

Transactional_
Change.xlsx

APR_LoadSignature

APR:LoadSignature

  • AP:Signature
  • AP:Detail

Transactional_
Contract.xlsx

CTR_LoadContractBase

CTR:LoadContractBase

CTR:ContractBase and
AST:AssetLease_

Transactional_
Contract.xlsx

CTR_LoadContractBase

CTR:LoadContractBase

CTR:ContractBase and
AST:AssetMaintenance_

Transactional_
Contract.xlsx

CTR_LoadContractBase

CTR:LoadContractBase

CTR:ContractBase and
AST:AssetSoftware_

Transactional_
Contract.xlsx

CTR_LoadContractBase

CTR:LoadContractBase

CTR:ContractBase and
AST:AssetSupport_

Transactional_
Contract.xlsx

CTR_LoadContractBase

CTR:LoadContractBase

CTR:ContractBase and
AST:AssetWarranty_

Transactional_
Contract.xlsx

CTR_LoadContractBase

CTR:LoadContractBase

CTR:ContractBase and
CTR:GenericContract_

Transactional_
Contract.xlsx

CTR_LoadContractBase

CTR:LoadContractBase

CTR:ContractBase and
CTR:MasterContract_

Transactional_
Contract.xlsx

CTR_LoadWorkLog

CTR:LoadWorkLog

CTR:WorkLog

Transactional_
Contract.xlsx

AST_LoadLicenseCerti
ficates

AST:LoadLicenseCertific
ates

  • AST:LicenseCertificates
  • AST:Connection_Basic
    Questions
  • AST:Compliance_Basic
    Questions

Transactional_
Contract.xlsx

AST_LoadLicenseCerti
ficateProductAssociati
on

AST:LoadLicenseCertific
ateProductAssociation

AST:LoadLicenseCertificate
ProductAssociation

Transactional_
Contract.xlsx

CTR_LoadContract_Re
lationship

CTR:LoadContract_Relat
ionship

CTR:Contract_Realtionship

Transactional_
Incident.xlsx

HPD_LoadHelpDesk

HPD:LoadHelpDesk

  • HPD:HelpDesk
  • SRM:Request

Transactional_
Incident.xlsx

HPD_LoadWorkLog

HPD:LoadWorkLog

  • HPD:WorkLog
  • SRM:WorkInfo

Transactional_
Incident.xlsx

HPD_LoadImpactedA
reas

HPD:LoadImpactedAreas

HPD:Impacted Areas

Transactional_
Problem.xlsx

PBM_LoadProblemInv
estigation

PBM:LoadProblemInvest
igation

PBM:Problem
Investigation

Transactional_
Problem.xlsx

PBM_LoadInvestigatio
nWorkLog

PBM:LoadInvestigation
WorkLog

PBM:Investigation
WorkLog

Transactional_
Problem.xlsx

PBM_LoadImpactedAr
eas

PBM:LoadImpactedAreas

PBM:ImpactedAreas

Transactional_
Problem.xlsx

PBM_LoadKnownError

PBM:LoadKnownError

PBM:Known Error

Transactional_
Problem.xlsx

PBM_LoadKnownErro
rWorkLog

PBM:LoadKnownErrorW
orkLog

PBM:Known Error
WorkLog

Transactional_
Problem.xlsx

PBM_LoadSolutionDat
abase

PBM:LoadSolutionDatab
ase

PBM:SolutionDatabase

Transactional_
Problem.xlsx

PBM_LoadSolutionDB
Alias

PBM:LoadSolutionDBAli
as

PBM:SolutionDBAlias

Transactional_
Problem.xlsx

PBM_LoadSolutionWo
rkLog

PBM:LoadSolutionWork
Log

PBM:SolutionWorkLog

Transactional_
Problem.xlsx

PBM_SolutionDBAddi
tionalMappings

PBM:SolutionDBAdditio
nalMappings

  • CFG:Group Event
    Mapping
  • CFG:GroupEventMapK
    DBAssoc

Transactional_
Shared
Components.xlsx

SHR_LoadAssociations

SHR:LoadAssociations

  • HPD:Associations
  • AST:CMDB
    Associations
  • PBM:Investigation
    Associations
  • CHG:Associations

Transactional_
Shared
Components.xlsx

CFG_LoadReminders

CFG:LoadReminders

CFG:Reminders

Transactional_
Shared
Components.xlsx

FIN_LoadCosts

FIN:LoadCosts

FIN:Costs

Transactional_
Shared
Components.xlsx

FIN_LoadPayments

FIN:LoadPayments

FIN:Payments

Transactional_
Shared
Components.xlsx

CFG_LoadBroadcast

CFG:LoadBroadcast

CFG:Broadcast

Transactional_
Shared
Components.xlsx

CFG_LoadBroadcastSP
GAssoc

CFG:LoadBroadcastSPG
Assoc

CFG:BroadcastSPGAssociation

Transactional_
Task.xlsx

TMS_LoadTaskGroup

TMS:LoadTaskGroup

TMS:TaskGroup

Transactional_
Task.xlsx

TMS_LoadTask

TMS:LoadTask

TMS:Task

Transactional_
Task.xlsx

TMS_LoadWorkInfo

TMS:LoadWorkInfo

TMS:WorkInfo

Transactional data mapping for BMC Knowledge Management

Spreadsheet

Tab

Staging form

Target form or forms

Transactional-
Additional
Category.xlsx

RKM_Load
MultipleOper_Cat

RKM:Load
MultipleOper_Cat

RKM:KAMOperationalCat

Transactional-
Additional
Category.xlsx

RKM_Load
MultipleProdCategory

RKM:LoadMultiple
ProdCategory

RKM:KAMProductCat

Transactional-
Additional
Category.xlsx

RKM_LoadMulti
_Reg_SiteGrp_Site

RKM:LoadMulti_
Reg_SiteGrp_Site

RKM:KAMSite

Transactional-
Additional
Category.xlsx

RKM_LoadMultiple
BusinessSrvc

RKM:LoadMultiple
BusinessSrvc

RKM:KAMBusinessService

Transactional-
Additional
Category.xlsx

RKM_LoadMultiple
Org_Dept

RKM:LoadMultiple
Org_Dept

RKM:KAMOrganization

Transactional-
Additional
Category.xlsx

RKM_LoadMultiple
Company

RKM:LoadMultiple
Company

RKM:KAMCompany

Transactional-
Knowledge.xlsx

RKM_LoadHowTo
Template_Join

RKM:LoadHowTo
Template_Join

  • RKM:HowToTemplate
  • RKM:KnowleddgeArticle
    Manager

Transactional-
Knowledge.xlsx

RKM_LoadReference
Template_Join

RKM:LoadReference
Template_Join

  • RKM:ReferenceTemplate
  • RKM:KnowleddgeArticle
    Manager

Transactional-
Knowledge.xlsx

RKM_LoadPrblm
SolnTemplate_Join

RKM:LoadPrblmSoln
Template_Join

  • RKM:ProblemSolution
    Template
  • RKM:KnowleddgeArticle
    Manager

Transactional-
Knowledge.xlsx

RKM_LoadKnown
ErrTemplate_Join

RKM:LoadKnown
ErrTemplate_Join

  • RKM:KnownErrorTemplate
  • RKM:KnowleddgeArticle
    Manager

Transactional-
Knowledge.xlsx

RKM_LoadKCSTemplate_Join

RKM:LoadKCSTemplate
RKM:LoadKCSTemplate_Join

  • RKM:LoadKCSTemplate 
  • RKM:KnowledgeArticleManagr

Transactional-
Knowledge.xlsx

RKM_Load
Associations

RKM:Load
Associations

RKM:Association

Transactional-
Knowledge.xlsx

RKM_LoadFeedback

Note: For BMC remedy IT Service Management 9.1.03, if the Backward Compatibility mode for Pentaho version 6 is set to Off, then you must provide an integer value between 1-5 for the Rating column on the RKM_LoadFeedback tab instead of a string value.

RKM:LoadFeedback

RKM:Feedback

Transactional-
Knowledge.xlsx

RKM_Load
UpdateRequests

RKM:LoadUpdate
Requests

RKM:UpdateRequests

Transactional-
Knowledge.xlsx

RKM_LoadWatchList

RKM:LoadWatchList

RKM:WatchList

Transactional-
Knowledge.xlsx

RKM_LoadArticle
History

RKM:LoadArticle
History

RKM:ArticleHistory

Transactional-
Knowledge.xlsx

RKM_LoadVisibility
GrpNCmpArt

RKM:LoadVisibility
GrpNCmpArt

RKM:VisibilityGroup
AndCompany_Article

Note

 

The data you load via Transactional_Asset.xlsm for AST_LoadBMC_BaseRelationship data and AST_LoadAssetPeople should be for CIs that are already in Production dataset. Loading the Asset data through the Transactional_Asset.xlsm is possible only after reconciliation. For details, For details, see Normalization and reconciliation: recommended procedure for ITSM CI data Loaded through Data Management.

Was this page helpful? Yes No Submitting... Thank you

Comments