The following is an extract from the MISExchange.xml file. This extract contains the modified lines (highlighted in blue) that are required to populate the Job type in ActiveH Response Repairs:
Configuration settings are published for information purposes only. Unless express consent has been granted, changes to configuration settings must only be made by Omfax Systems/Touch-Base Ltd technicians or their representatives.
The example JobTypeIDMISExchange.xml entry can be seen below...
<MISTask obj="CRQTask" target="EstimatedCost" dtype="money" length="8" type="RD" KFparent="Repair" KFsource="RepairCode" KFsourceType="MIS_REPAIR" sql="SELECT Unit_Price_DC FROM Shared_SORs_T WITH (nolock) WHERE SOR_Code_VC = '[value]'" />
<MISTask obj="CRQTask" target="PriorityID" dtype="int" length="4" type="RD" KFparent="Repair" KFsource="Priority" KFsourceType="MIS_REPAIR" sql="" />
<MISTask obj="CRQTask" target="SpecialInstructions" dtype="varchar" length="500" type="RD" KFparent="Repair" KFsource="../Special_Instructions" KFsourceType="MIS_REPAIR" sql="" />
<MISTask obj="CRQTask" target="TenantRecharge" dtype="bit" length="1" type="RD" KFparent="Fault" KFsource="Recharge" KFsourceType="MIS_REPAIR" sql="" />
<MISTask obj="CRQTask" target="CITScope" dtype="bit" length="1" type="RD" KFparent="Repair" KFsource="RepairCode" KFsourceType="MIS_REPAIR" sql="SELECT CISApplicable_BT FROM Shared_SORs_T WITH (nolock) WHERE SOR_Code_VC = '[value]'" />
<MISTask obj="CRQTask" target="TradeCodeIDEx" dtype="int" length="4" type="RD" KFparent="Repair" KFsource="RepairCode" KFsourceType="MIS_REPAIR" sql="SELECT ISNULL(sstt.Trade_ID,0) FROM Shared_SORs_T ss WITH (nolock) INNER JOIN Shared_SOR_Table_Sections_T ssts WITH (nolock) ON ss.Table_Section_ID = ssts.Table_Section_ID INNER JOIN Shared_SOR_Table_Trades_T sstt WITH (nolock) ON ssts.Table_Trade_ID = sstt.Table_Trade_ID WHERE ss.SOR_Code_VC = '[value]'" />
<MISTask obj="CRQTask" target="JobTypeID" dtype="int" length="4" type="RD" KFparent="Repair" KFsource="../Nominal_Code" KFsourceType="MIS_REPAIR" sql="SELECT '[value]'" />
In order to populate, the selection of a Job Type needs to be manually scripted.
Getting a list of Job Type Code_ID's
To pass back the Job Type to MIS ActiveH Response Repairs, in this example you will need export the value to the ‘Nominal_Code' node of Keyfax's export XML.
The relevant fault in Keyfax is then scripted to export the Code_ID value to the Nominal Code field.
Use a "Fixed Text" and an "Export" Databox:
The Job Type in MIS ActiveH Response Repairs will now populate for this particular script.
