query? Request Import - Bypass Priority/Team/Category/Service/Catalog/Status Mapping

[Martyn Houghton]

@Steve G @Victor

Is is possible to disable or bypass the Priority/Team/Category/Service/Catalog/Status Mapping on the Request Import tool? 

The reason for asking is that we do a loot of our mapping and data cleansing in the an interium database and already have the priority, service, status, catalog id mapped in the source data. However at the moment we have to add the values in the mapping to map the same to the same to get it to load.

 "StatusMapping": {
    "External Status": "Service Manager Status",
	"status.open": "status.open",
    "status.onHold": "status.onHold",
    "status.new": "status.new",
    "status.closed": "status.closed",
    "status.cancelled": "status.cancelled"
  }

We would like to bypass the mapping and insert the values in from the source query.

Cheers

Martyn

[Martyn Houghton]

For example my mapping section is large even before I have added in Team and Profile code mapping.

For larger migration from other tools, we use complex lookups in the interim database to determine the target Service and Catalog combinations, inserting the Hornbill Id's into that logic, so just need to pass them through without mapping.

 

  "PriorityMapping": {
    "External Priority": "Service Manager Priority",
	"1":"High",
	"3":"Low",
	"24":"Normal",
	"25":"Urgent"
  },
  "TeamMapping": {
    "External Team ID": "Service Manager Team Name"
  },
  "CategoryMapping": {
    "External Category": "Service Manager Category ID"
  },
  "ResolutionCategoryMapping": {
    "External Resolution Profile Code": "Service Manager Resolution Profile Code"
  },
  "ServiceMapping": {
    "External Service Name": "Service Manager Service Name",
	"844":"Idox Cloud Service Desk",
	"772":"Idox Cloud Building Control",
	"802":"Idox Cloud Care",
	"806":"Idox Cloud Dog Licensing (NI)",
	"810":"Idox Cloud HSE (ROI)",
	"794":"Idox Cloud Building Control and Fire Management (ROI)",
	"842":"Idox Cloud Online Portal",
	"796":"Idox Cloud Environmental Health (NI)",
	"846":"Idox Cloud Leisure Centre Management",
	"812":"Idox Cloud Licensing",
	"800":"Idox Cloud Public Protection",
	"808":"Idox Cloud Affordable Warmth",
	"814":"Idox Cloud Planning",
	"798":"Idox Cloud Home Safety"
  },
  "ServiceCatalogItemMapping": {
    "External Service Catalog Item Name":1,
"2465":2465,
"2469":2469,
"2611":2611,
"2615":2615,
"2617":2617,
"2619":2619,
"2621":2621,
"2623":2623,
"2625":2625,
"2627":2627,
"2629":2629,
"2631":2631,
"2633":2633,
"2635":2635,
"2637":2637,
"2645":2645,
"2647":2647,
"2649":2649,
"2651":2651,
"2653":2653,
"2655":2655,
"2675":2675,
"2677":2677,
"2679":2679,
"2681":2681,
"2683":2683,
"2685":2685,
"2687":2687,
"2689":2689,
"2691":2691,
"2693":2693,
"2695":2695,
"2697":2697,
"2753":2753,
"2755":2755,
"2757":2757,
"2759":2759,
"2761":2761,
"2763":2763,
"2771":2771,
"2773":2773,
"2775":2775,
"2777":2777,
"2779":2779,
"2781":2781,
"2787":2787,
"2789":2789,
"2791":2791,
"2793":2793,
"2795":2795,
"2797":2797,
"2799":2799,
"2801":2801,
"2803":2803
  },
  "StatusMapping": {
    "External Status": "Service Manager Status",
	"status.open": "status.open",
    "status.onHold": "status.onHold",
    "status.new": "status.new",
    "status.closed": "status.closed",
    "status.cancelled": "status.cancelled"
  }
}

Cheers

Martyn