Populating Job Type

Populating the 'Job Type' field for ActiveH Repairs

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 JobTypeID MISExchange.xml entry can be seen below...

<MISTask obj="CRQTask" target="JobTypeID" dtype="int" length="4" type="RD" KFparent="Repair" KFsource="../Nominal_Code" KFsourceType="MIS_REPAIR" sql="SELECT '[value]'" />

You can see this in more context 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.

Last updated