Jump to content

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


Recommended Posts

@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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...