Skip to Content
0
Former Member
Dec 20, 2006 at 10:46 AM

Sender File Adapter content conversion problem

16 Views

Hi all,

is it possible to do content conversion like this:

Key;Field1;Field2;Field3

PO00H;0482000000;20061102;PL61

PO01I;00010;0A720;Material 1;100.000

PO02D;20061102;100.000;

PO00H;0482000001;20061102;PL63

PO01I;00010;0A730;Material 2;40.000

PO02D;20061102;40.000;

PO01I;00010;0A740;Material 3;140.000

PO02D;20061102;30.000;

PO02D;20061103;110.000;

convert to

<?xml version="1.0" encoding="utf-8" ?> 
<MT_PO>
    <DT_PO>
        <DocumentHeader>
            <PONumber>0482000000</PONumber>
            <PODate>20061102</PODate>
            <CompanyCode>PL61</CompanyCode>
        </DocumentHeader>
        <Item>
            <ItemHeader>
                <ItemNumber>00010</ItemNumber>
                <MaterialCode>0A720</MaterialCode>
                <MaterialDescription>Material 1</MaterialDescription>
                <Quantity>100.000</Quantity>
            </ItemHeader>
            <ItemDetail>
                <DeliveryDate>20061102</DeliveryDate>
                <Quantity>100.000</Quantity>
            </ItemDetail>
        </Item>
    </DT_PO>
    <DT_PO>
        <DocumentHeader>
            <PONumber>0482000001</PONumber>
            <PODate>20061102</PODate>
            <CompanyCode>PL63</CompanyCode>
        </DocumentHeader>
        <Item>
            <ItemHeader>
                <ItemNumber>00010</ItemNumber>
                <MaterialCode>0A730</MaterialCode>
                <MaterialDescription>Material 2</MaterialDescription>
                <Quantity>40.000</Quantity>
            </ItemHeader>
            <ItemDetail>
                <DeliveryDate>20061102</DeliveryDate>
                <Quantity>40.000</Quantity>
            </ItemDetail>
        </Item>
        <Item>
            <ItemHeader>
                <ItemNumber>00010</ItemNumber>
                <MaterialCode>0A740</MaterialCode>
                <MaterialDescription>Material 3</MaterialDescription>
                <Quantity>140.000</Quantity>
            </ItemHeader>
            <ItemDetail>
                <DeliveryDate>20061102</DeliveryDate>
                <Quantity>30.000</Quantity>
            </ItemDetail>
            <ItemDetail>
                <DeliveryDate>20061103</DeliveryDate>
                <Quantity>110.000</Quantity>
            </ItemDetail>
        </Item>
    </DT_PO>
</MT_PO>