Files Received

Description

This File rule (also referred to as AsFile) allows configuration to translate incoming data and insert it directly into the database. AsFile can also be configured to selectively insert records into the database based upon the data in the inbound SOAP message.  

The configuration for each File has two sections: XMLData and XSLT. The XMLData section assigns values to attributes prior to the transformation process. The XSLT defines how the information will be transformed.    

The XMLData section can be configured using the elements and attributes described below. The XSLT section transforms data according to a stylesheet. Each Attribute defined in the XMLData section that will be needed in the XSLT stylesheet must first be declared as a parameter in the XSLT.   

Refer to the Administration Overview | Files Overview section in the Rules Palette help system for additional information on configuring File and the XSLT section.

Parameter, Attribute and Variable are interchangeable terms depending on which section you are working with. An attribute in the XMLData section is called a parameter in the XSLT section.  

If a policy number is not provided in the Soap input XML, then a plan level AutomaticPolicyNumber rule override can trigger automatic generation of the number.

Files Received Elements/Attributes Table

Element/Tag

Definition

Attribute

Element/Attribute Value and Description

<File>

The opening and closing tag for the rule.

 

 

<AssignAttributes>    

Required element

 

 

<Attribute>     

 

 

 

 

 

 

 

 

 

 

Required element

 

 

 

 

 

 

 

 

 

 

 

 

NAME

Note: NAME=ImportName and NAME=ClassName are both required attributes.

The import name is the text of the root XML node of the AsXML.

The ClassName attribute should be defined as one of the objects that AsXML mapping is going to create.

GUID

 

XPATH

 

VALUE

 

SQL

 

SYSTEMDATE

 

SEQUENCE

 

XPATHSTRINGLIST

 

XPATHNUMBERLIST

 

SQLMAP

 

<PreInsert>     

Optional element;

PreInsert allows for functionally to be exercised prior to records being inserted into the database. Only used when there is a need to call other functionality in the application. 

 

 

<Object>          

Used to define the name of the Java class being called.

CLASS

 

<Parameters>                

Allows for passing parameters to the class.

NAME

 

<PostInsert>    

 

Optional element;

PostInsert allows for functionally after the records are being inserted into the database. Only used when there is a need to call other functionality in the application. 

 

 

<Object>            

Used to define the name of the Java class being called.

CLASS

 

<Parameters>                 

Allows for passing parameters to the class.

NAME

 

XML Examples

<File>
<AssignAttributes>     
<Attribute NAME="ImportMapName" TYPE="VALUE">AsXml</Attribute>            
<Attribute NAME="ClassName" TYPE="VALUE">com.adminserver.utl.JibxListUtl</Attribute>             
</AssignAttributes>     
<PreInsert>     
<Object CLASS="com.adminserver.pas.webservice.bll.AsFilePostInsertIndividualActivityProcessorBll">            
<Parameters>                  
<Parameter NAME="ActivityClientNumber">ActivityClientNumber</Parameter>                         
</Parameters>                  
</Object>           
</PreInsert>      
</File>
 
<File>
<AssignAttributes>
<!-- Required in all AsFile interfaces -->
<Attribute NAME="ImportMapName" TYPE="VALUE">AsXml</Attribute>
<Attribute NAME="ClassName" TYPE="VALUE">com.adminserver.utl.JibxListUtl</Attribute>
<!-- Additional AsFile -->
<Attribute NAME="PlanGUID" TYPE="XPATH">/TXLife/TXLifeRequest/OLifE/Holding/Policy/ProductCode</Attribute>
<Attribute NAME="FundGUID" TYPE="XPATH">/TXLife/TXLifeRequest/OlifE/Holding/Investment/SubAccount/ProductCode</Attribute>
<Attribute NAME="PolicyGUID" TYPE="GUID"/>
<Attribute NAME="ParentCompanyGUID" TYPE="SQL">SELECT CompanyGUID FROM AsCompany WHERE CompanyName='Prototype Child Company'</Attribute>
<Attribute NAME="ChildCompanyGUID" TYPE="SQL">SELECT CompanyGUID FROM AsCompany WHERE CompanyName='Primary Company 1'</Attribute>
<Attribute NAME="TransactionGUID" TYPE="SQL">SELECT TransactionGUID FROM AsTransaction WHERE PlanGUID = '[PlanGUID]' AND TransactionName = 'CoverageCalculation'</Attribute>
<Attribute NAME="ProcessingOrder" TYPE="SQL">SELECT ProcessingOrder FROM AsTransaction WHERE TransactionGUID = '[TransactionGUID]'</Attribute>
<Attribute NAME="ActivityClientNumber" TYPE="VALUE">devikar</Attribute>
<Attribute NAME="ComputationID" TYPE="VALUE">IllustrationReturn</Attribute>
<!--Attribute NAME="PolicyNumber" TYPE="POLICYNUMBER" PLANGUID="PlanGUID" POLICYGUID="PolicyGUID" COMPANYGUID="CompanyGUID">PolicyNumber</Attribute-->
<Attribute NAME="PolicyNumber" TYPE="SEQUENCE">PolicyNumber</Attribute>
</AssignAttributes>
<PostInsert>
<Object CLASS="com.adminserver.pas.webservice.bll.AsFilePostInsertIndividualActivityProcessorBll">
<Parameters>
<Parameter NAME="ActivityClientNumber">ActivityClientNumber</Parameter>
</Parameters>
</Object>
</PostInsert>
</File>