XI - File Content Conversion

By Punit J, YASH PI Competency Team, Yash Technologies

Description: File Content Conversion is used to convert non-XML file (flat file) to XML file and vice-versa. In this blog, we will see how to convert flat file to XML file when file structure is bit complex. For example, when same columns shows different information in different rows.  

Business Case: Let’s take an example with file shown below. The file contains employee details. First row contains Header information of Employee (Employee ID and Name), Second and Third row contains his weekly details (Week No, Working Hours in the Week and Wage for the Week), there can be n number of rows for weekly details and Last row contains Employee Monthly Summary (Total hours worked and Total Wage).  

Screen shot

Find below the step-by-step procedure to achieve this scenario: 

Development on Integration Repository side.

1.  Create Data Type.

Here I have added a filed Key in all the records, we will discuss about this field while configuring Sender File Adapter. 

2. Create Message Type. 

3) Create Message Interface for Sender and Receiver. In this scenario I am using same Message Type for both Sender and Receiver as we are converting flat file to XML file. 

4) Create Message Mapping. 

Here we don’t have to map the field ‘Key’. 

5. Create Interface Mapping. 

Click here to continue...