Example XML Extract File

This example shows you how to use TRN_FIELDS INI control group to map index data in Documaker. The example includes the following XML extract file plus the following setup files:

  • Example Trn_Fields INI Settings
  • Example TRNDFDFL.DFD
  • Example RCBDFDFL.DFD
  • Using DAL to Output to a Database Table

This example XML file supplies the input variable data to Documaker. This example contains two transactions, each of which generates one or more output documents. Each transaction is an XML document and each starts with the <?xml...> header record indicated in bold.

The XML is concatenated into a stream into Documaker. In this example, the italic text is mapped data which is used as metadata in the destination system.

<?xml version="1.0" encoding="UTF-8"?>

<InterfaceRequest>

<Header>

<Key1>DOCCDEMO</Key1>

<Key2>LIFE</Key2>

<KeyID>67-875747</KeyID>

<Run_Date>01-OCT-2008 04:12:58 PM</Run_Date>

<TRANCODE>NB</TRANCODE>

<DOCTYPE>LIFE</DOCTYPE>

<PRODUCT>Foundation Life</PRODUCT>

<SECGROUP>Archived</SECGROUP>

<AUTHOR>Steven Doe</AUTHOR>

<CABINET>CAB1</CABINET>

</Header>

   <SystemRequest>

       <MessageID>1236474</MessageID>

<Target>EPOLICY</Target>

<Target>

<GO>35235</GO>

<mode>print</mode>

</Target>

<CMD>Print</CMD>

</SystemRequest>

<Data>

<POLICY_NUMBER>67-875747</POLICY_NUMBER>

<POLICY_ISSUE_DATE>01-OCT-2008 04:12:58 PM</POLICY_ISSUE_DATE>

<EFFDATE>01-NOV-2018 12:00:00.00 AM</EFFDATE>

<EXPDATE>01-NOV-2018 12:00:00.00 AM</EXPDATE>

<CLASS_OF_RISK>A</CLASS_OF_RISK>

<STATE_CODE>TX</STATE_CODE>

<PAYEE>Carl Doe</PAYEE>

<CUSTID>cjd01</CUSTID>

<INSURED>

<PREFIX>Mr.</PREFIX>

<FNAME>Carl</FNAME>

<MNAME></MNAME>

<LNAME>Doe</LNAME>

<SEX>M</SEX>

<ADDRESS1>2727 Paces Ferry Road</ADDRESS1>

<ADDRESS2>Apartment 900</ADDRESS2>

<CITY>Atlanta</CITY>

<STATE>GA</STATE>

<ZIP>30339</ZIP>

<BIRTHDATE>15-JUL-1980</BIRTHDATE>

<INSSSAN>123456789</INSSSAN>

<DAYPHONE>2148762789778</DAYPHONE>

<NIGHTPHONE>2148974464</NIGHTPHONE>

<BIRTHCITY>Anaheim</BIRTHCITY>

<BIRTHSTATE>CA</BIRTHSTATE>

<DRIVERSTATE>FL</DRIVERSTATE>

<DRIVERLICENSE>987987YIU</DRIVERLICENSE>

</INSURED>

<AGENT>

<PREFIX>Mr.</PREFIX>

<FNAME>John</FNAME>

<LNAME>Doe</LNAME>

<ADDRESS1>1100 Abernathy Road</ADDRESS1>

<CITY>Atlanta</CITY>

<STATE>GA</STATE>

<ZIP>30328</ZIP>

<EMAIL>johndoe@example.com</EMAIL>

<PHONE>2148582200</PHONE>

<AgentNo>R98798</AgentNo>

<CustServPhone>8882637436</CustServPhone>

<CustServOpenTime>8:00</CustServOpenTime>

<CustServCloseTime>5:00</CustServCloseTime>

<CustServTimeZone>eastern</CustServTimeZone>

</AGENT>

<POLICY_DATA>

<PolicyValue>10000000</PolicyValue>

<PolicyIssueDate>01032005</PolicyIssueDate>

<PolicyEndDate>01032025</PolicyEndDate>

<IssueState>GA</IssueState>

<CostofInsurance>99200</CostofInsurance>

<CostofInsuranceRate>992</CostofInsuranceRate>

<CostofInsurance_Option>Level</CostofInsurance_Option>

<Smoker>N</Smoker>

<DeathBenefitType>Increasing</DeathBenefitType>

<AnnualPremium>101900</AnnualPremium>

<PremiumFrequency>Monthly</PremiumFrequency>

<PremiumAmount>8492</PremiumAmount>

<FlatExtra>0</FlatExtra>

<AdminCharges>2700</AdminCharges>

<MultipleExtra>0</MultipleExtra>

</POLICY_DATA>

<BENEFICIARY>

<Name>Mary Doe</Name>

<Relationship>Wife</Relationship>

</BENEFICIARY>

<BENEFICIARY>

<Name>Holly Doe</Name>

<Relationship>Daughter</Relationship>

</BENEFICIARY>

</Data>

</InterfaceRequest>

<?xml version="1.0" encoding="UTF-8"?>

<InterfaceRequest>

<Header>

<Key1>DOCCDEMO</Key1>

<Key2>LIFE</Key2>

<KeyID>99-456789</KeyID>

<Run_Date>12-OCT-2008 10:31:12.01 AM</Run_Date>

<TRANCODE>NB</TRANCODE>

<DOCTYPE>LIFE</DOCTYPE>

<PRODUCT>Foundation Life</PRODUCT>

<SECGROUP>Archived</SECGROUP>

<AUTHOR>Carl Doe</AUTHOR>

<CABINET>CAB1</CABINET>

</Header>

<SystemRequest>

<MessageID>1236474</MessageID>

<Target>EPOLICY</Target>

<Target>

<GO>35235</GO>

<mode>print</mode>

</Target>

<CMD>Print</CMD>

</SystemRequest>

<Data>

<POLICY_NUMBER>99-456789</POLICY_NUMBER>

<POLICY_ISSUE_DATE>10-OCT-2008 10:31:12.01 AM</POLICY_ISSUE_DATE>

<EFFDATE>01-NOV-2017 12:00:00.01 AM</EFFDATE>

<EXPDATE>01-NOV-2018 12:00:00.01 AM</EXPDATE>

<CLASS_OF_RISK>A</CLASS_OF_RISK>

<STATE_CODE>GA</STATE_CODE>

<PAYEE>Steven Doe</PAYEE>

<CUSTID>ssdoe</CUSTID>

<INSURED>

<PREFIX>Mr.</PREFIX>

<FNAME>Steven</FNAME>

<MNAME>S</MNAME>

<LNAME>Doe</LNAME>

<SEX>M</SEX>

<ADDRESS1>2727 Paces Ferry Road</ADDRESS1>

<ADDRESS2>Apartment 900</ADDRESS2>

<CITY>Atlanta</CITY>

<STATE>GA</STATE>

<ZIP>30339</ZIP>

<BIRTHDATE>14-FEB-1970</BIRTHDATE>

<INSSSAN>012345678</INSSSAN>

<DAYPHONE>2148762789778</DAYPHONE>

<NIGHTPHONE>2148974464</NIGHTPHONE>

<BIRTHCITY>Pittsburg</BIRTHCITY>

<BIRTHSTATE>PN</BIRTHSTATE>

<DRIVERSTATE>GA</DRIVERSTATE>

<DRIVERLICENSE>987987YIU</DRIVERLICENSE>

</INSURED>

<AGENT>

<PREFIX>Mr.</PREFIX>

<FNAME>John</FNAME>

<LNAME>Doe</LNAME>

<ADDRESS1>1100 Abernathy Road</ADDRESS1>

<CITY>Atlanta</CITY>

<STATE>GA</STATE>

<ZIP>30328</ZIP>

<EMAIL>johndoe@example.com</EMAIL>

<PHONE>2148582200</PHONE>

<AgentNo>R98798</AgentNo>

<CustServPhone>8882637436</CustServPhone>

<CustServOpenTime>8:00</CustServOpenTime>

<CustServCloseTime>5:00</CustServCloseTime>

<CustServTimeZone>eastern</CustServTimeZone>

</AGENT>

<POLICY_DATA>

<PolicyValue>10000000</PolicyValue>

<PolicyIssueDate>01032005</PolicyIssueDate>

<PolicyEndDate>01032025</PolicyEndDate>

<IssueState>GA</IssueState>

<CostofInsurance>99200</CostofInsurance>

<CostofInsuranceRate>992</CostofInsuranceRate>

<CostofInsurance_Option>Level</CostofInsurance_Option>

<Smoker>N</Smoker>

<DeathBenefitType>Increasing</DeathBenefitType>

<AnnualPremium>101900</AnnualPremium>

<PremiumFrequency>Monthly</PremiumFrequency>

<PremiumAmount>8492</PremiumAmount>

<FlatExtra>0</FlatExtra>

<AdminCharges>2700</AdminCharges>

<MultipleExtra>0</MultipleExtra>

</POLICY_DATA>

<BENEFICIARY>

<Name>Mary Doe</Name>

<Relationship>Wife</Relationship>

</BENEFICIARY>

<BENEFICIARY>

<Name>Anna Doe</Name>

<Relationship>Daughter</Relationship>

</BENEFICIARY>

</Data>

</InterfaceRequest>