You are here: Job and Form Set Rules Reference > JDT Rules Reference > UseXMLExtract > Mapping Fields

Mapping Fields

You can map TRN_Fields fields using the Ext2GVM rule or by using XPath.

Using Ext2GVM

When you use the Ext2GVM rule to get key information, make sure you only include the Key1, Key2, and KeyID options it the TRN_Fields control group. Set these options to dummy data, because the GVM variables are set to the data values during GenData processing.

To re-map these values from the global variables you get using Ext2GVM rule to the RPS structures (GroupName1, GroupName2, and GroupName3), include this rule in the AFGJOB.JDT file:

ResetDocsetNames;;ConvertBeforeReset;

The ConvertBeforeReset parameter gets the GroupName values from global memory and converts them to the long values using the Key1Table and Key2Table control groups.

Here is an example of the INI options:

< TRN_File >

Company = 3,3,N

LOB = 3,3,N

PolicyNum = 3,3,N

Here is an excerpt from the AFGJOB.JDT file:

;Ext2GVM;;!/Forms/Key1 1,10,Company;

;Ext2GVM;;!/Forms/Key2 1,15,LOB;

;Ext2GVM;;!/Forms/PolicyNum 1,12,PolicyNum;

;ResetDocsetNames;;ConvertBeforeReset ;

Using XPath

When you use XPath to map to the fields in the TRN_Fields control group, be sure to place an exclamation mark (!) in front of the XPath. Here is example:

< TRN_Fields >

Company = !/Forms/Key1

LOB = !/Forms/Key2

PolicyNum = !/Forms/PolicyNum

RunDate = !/Forms/RunDate;DM-4;D4

The format for the options in the TRN_Fields control group is:

(Field in the transaction DFD file) = XPath;Field Format

Although the exclamation mark (!) is not part of the actual search routine, the XML path search must begin with an exclamation mark. Do not specify whether a field is a key. The system does not support a multiple (search) keys with the XML implementation.

To selectively exclude transactions, place the XPath with a leading exclamation mark of what you want to exclude in your exclude file. Here is an example:

!/Forms[PolicyType="OLD"]