Header , Item, Trailer flatfile/fixed length file conversion in groovy script in SAP CPI

 There is no option in the CVS to XML convertor in CPI for converting the flat file. We can customize using the groovy script to achieve this.

Input:

NHEDSAPPS220C
16 20190523045
16 20190523046
16 20190523047
16 20190523048
TRAR000712

Groovy Script:

import com.sap.gateway.ip.core.customdev.util.Message;
import java.util.HashMap;

def Message processData(Message message) {

//Body

def body = message.getBody(java.lang.String) as String;

def lines = body.split("\n");


// variable initialization

def lineArr;

def itemtypPre;

def irlflag="E";

def irflag="E";

def hflag="E";

def Fieldentry = "";

def itemtyp;

def i=0;


//XML and root element formation

Fieldentry += "<?xml version=\"1.0\" encoding=\"UTF-8\"?>";

Fieldentry += "<Root>";

for(i=0;i<lines.length;i++)

{

if(i>0)

{

//Item Type holder split from File i.e NH, 16, TR

itemtypPre = lines[i-1].substring(0,1);

}

//Item Type holder split from File i.e NH, 16, TR

itemtyp= lines[i].substring(0,2);


if(itemtyp.equals("NH"))

{

    Fieldentry += "<Header>";
    Fieldentry += "<ItemType>"+lines[i].substring(0,3)+"</ItemType>";
    Fieldentry += "<ISPID>"+lines[i].substring(4,5)+"</ISPID>";
    Fieldentry += "<Rate>"+lines[i].substring(6,7)+"</Rate>"
    Fieldentry += "</Header>";
}


if(itemtyp.equals("16")){


        if(irlflag.equals("O")) 

      {

        Fieldentry += "</Items>";

        irlflag="E";

      }
    Fieldentry += "<Items>";

    irlflag="O";

    // Fieldentry += "<ItemType>";
    Fieldentry += "<Type>"+lines[i].substring(0,2)+"</Type>"
    Fieldentry += "<FullClaimNumber>"+lines[i].substring(3,5)+"</FullClaimNumber>"
    Fieldentry += "<ClaimNumber>"+lines[i].substring(4,12)+"</ClaimNumber>"
    Fieldentry += "<AuthorizationCode>"+lines[i].substring(13,15)+"</AuthorizationCode>"
    // Fieldentry += "</ItemType>";
}


if(itemtyp.equals("TR")){

Fieldentry += "</Items><Trailer>";
Fieldentry += "<Type>"+lines[i].substring(0,4)+"</Type>"
Fieldentry += "<NumExtendedWarranty>"+lines[i].substring(5,8)+"</NumExtendedWarranty>"
Fieldentry += "<ElectroluxCustomerId>"+lines[i].substring(9,10)+"</ElectroluxCustomerId>"
Fieldentry += "</Trailer>";

} }

Fieldentry += "</Root>";

message.setBody(Fieldentry);

return message;

}

Output:

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

<Root>

    <Header>

        <ItemType>NHE</ItemType>

        <ISPID>S</ISPID>

        <Rate>P</Rate>

    </Header>

    <Items>

        <Type>16</Type>

        <FullClaimNumber> 2</FullClaimNumber>

        <ClaimNumber>20190523</ClaimNumber>

        <AuthorizationCode>45</AuthorizationCode>

    </Items>

    <Items>

        <Type>16</Type>

        <FullClaimNumber> 2</FullClaimNumber>

        <ClaimNumber>20190523</ClaimNumber>

        <AuthorizationCode>46</AuthorizationCode>

    </Items>

    <Items>

        <Type>16</Type>

        <FullClaimNumber> 2</FullClaimNumber>

        <ClaimNumber>20190523</ClaimNumber>

        <AuthorizationCode>47</AuthorizationCode>

    </Items>

    <Items>

        <Type>16</Type>

        <FullClaimNumber> 2</FullClaimNumber>

        <ClaimNumber>20190523</ClaimNumber>

        <AuthorizationCode>48</AuthorizationCode>

    </Items>

    <Trailer>

        <Type>TRAR</Type>

        <NumExtendedWarranty>007</NumExtendedWarranty>

        <ElectroluxCustomerId>2</ElectroluxCustomerId>

    </Trailer>

</Root>