Skip to Content
author's profile photo Former Member
0
Former Member
Apr 21, 2008 at 08:13 PM

File content conversion (file to file)

32 Views

Hi Guys,

Sender File

@! is the delimiter

LEVEL1@!227833338@!08710@!REPAIR@!20080101@!99990909@!0000212897@!0000000001000@!0000000500000@!R400@!A@!Assigned

LEVEL2@!227833338@!08710@!000099071608@!Blind@!20020115@!20020115@!R400@!1@!3@!20020430@!99990909@!SLC-@!VESSELLS@!A@!Assigned

LEVEL3@!227833338@!08710@!000099071608@!0010@!Blind@!20020115@!20020115@!20020430@!20020430@!10000414@!Assigned

LEVEL1@!4501065777@!00010@!SUPERHEAT@!20071206@!99990909@!0000219169@!00000001000@!0000002000000@!R020@!A@!Assigned

LEVEL2@!4501065777@!00010@!000009416742@!Alky@!20080107@!99990909@!R020@!E@!2@!20080101@!99990909@!LAT@!COKE@!A@!Assigned

LEVEL3@!4501065777@!00010@!000009416742@!0010@!v-895@!20080107@!99990909@!20080101@!99990909@!10001577@!Assigned

-

-

-

Sender Structure

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

<ns0:CostObjects xmlns:ns0="http://*****************">

<LEVEL1>

<LevelID/>

<PONumber>35435454</PONumber>

<POLineNo>545</POLineNo>

<ShortText>AAAAAAA</ShortText>

<StDate>20080101</StDate>

<EndDate>20080101</EndDate>

<Vendor/>

<POValue/>

<ExpectedValue>4343</ExpectedValue>

<Plant/>

<Status>A</Status>

<OrderType>Assigned</OrderType>

</LEVEL1>

<LEVEL2>

<LevelID/>

<PONumber>35435454</PONumber>

<POLineNo>545</POLineNo>

<Level2ID>457899</Level2ID>

<Level2Desc>bbbbbbbbb</Level2Desc>

<L2StDate>20080101</L2StDate>

<L2EndDate>20080101</L2EndDate>

<L2Plant>y001</L2Plant>

<L2Priority>3</L2Priority>

<L2SAPStatus>a</L2SAPStatus>

<L2ActStDate>20080101</L2ActStDate>

<L2ActEndDate>20080101</L2ActEndDate>

<L2FuncLoc>LAR</L2FuncLoc>

<L2FuncDesc>LOS ANGLES</L2FuncDesc>

<L2Status>1</L2Status>

<L2OrderType>Assigned</L2OrderType>

</LEVEL2>

<LEVEL3>

<LevelID/>

<PONumber>35435454</PONumber>

<POLineNo>545</POLineNo>

<Level2ID>457899</Level2ID>

<Level3ID>10</Level3ID>

<Level3Desc>cccccccc</Level3Desc>

<L3StDate>20080101</L3StDate>

<L3EndDate>20080101</L3EndDate>

<L3ActStDate>20080101</L3ActStDate>

<L3ActEndDate>20080101</L3ActEndDate>

<L3WorkCenter>los</L3WorkCenter>

<L3OrderType>Assigned</L3OrderType>

</LEVEL3>

</ns0:CostObjects>

Receiver Structure

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

<ns0:TCostObject xmlns:ns0="http://**************">

<LEVEL1>

<L1RecordIndicator>&lt;L1&gt;</L1RecordIndicator>

<L1ID>35435454545</L1ID>

<L1Desc>AAAAAAA</L1Desc>

<L1StartDate>20080101</L1StartDate>

<L1EndDate>20080101</L1EndDate>

<L1Hours>0</L1Hours>

<L1Costs>4343</L1Costs>

<L1Status>A</L1Status>

<L1OrderType>Assigned</L1OrderType>

</LEVEL1>

<LEVEL2>

<L2RecordIndicator>&lt;L2&gt;</L2RecordIndicator>

<L1ID>35435454545</L1ID>

<L2ID>457899</L2ID>

<L2Desc>bbbbbbbbb</L2Desc>

<L2StartDate>20080101</L2StartDate>

<L2EndDate>20080101</L2EndDate>

<L2Hours>0</L2Hours>

<L2Costs>0</L2Costs>

<L2OrderType>Assigned</L2OrderType>

<L2Plant>y001</L2Plant>

<L2Priority>3</L2Priority>

<L2SAPStatus>a</L2SAPStatus>

<L2CostObject/>

<L2CostObjectDesc/>

<L2ActStartDate>20080101</L2ActStartDate>

<L2ActEndDate>20080101</L2ActEndDate>

<L2AreaID>01</L2AreaID>

<L2FuncLoc>LAR</L2FuncLoc>

<L2FuncLocDesc>LOS ANGLES</L2FuncLocDesc>

<L2UnitName/>

<L2MaintCatCode/>

<L2MiscInfo1/>

<L2MiscInfo2/>

<L2SAPExempt/>

<L2ShortWorkOrderID/>

<L2Status_AorI>1</L2Status_AorI>

<L2LaborTaxFlag/>

<L2EquipTaxFlag/>

<L2MaintTaxFlag/>

</LEVEL2>

<LEVEL3>

<L3RecordIndicator>&lt;L3&gt;</L3RecordIndicator>

<L1ID>35435454545</L1ID>

<L2ID>457899</L2ID>

<L3ID>10</L3ID>

<L3Desc>cccccccc</L3Desc>

<L3PlanStartDate>20080101</L3PlanStartDate>

<L3PlanEndDate>20080101</L3PlanEndDate>

<L3ActStartDate>20080101</L3ActStartDate>

<L3ActEndDate>20080101</L3ActEndDate>

<L3OrderType>Assigned</L3OrderType>

<L3WorkCenter>los</L3WorkCenter>

<L3WorkAmtScheduled/>

<L3UnitofWork/>

<L3DurationScheduled/>

<L3UnitofDuration/>

<L3NoofEmp/>

</LEVEL3>

</ns0:TCostObject>

The receiver file look more or less the same as sender file but with delimiter @# and the fields are different

<L1>@#...........

<L2>@#..........

<L3>@#............

<L1>@#...........

<L2>@#..........

<L3>@#............

-

-

-

Sender file adapter content conversion:

LEVEL1.fieldNames LevelID,PONumber,POLineNo,ShortText,StDate,EndDate,Vendor,POValue,ExpectedValue,Plant,Status,OrderType

LEVEL1.fieldSeparator @!

LEVEL1.endSeparator 'nl'

LEVEL1.processFieldNames fromConfiguration

LEVEL1.keyFieldValue LEVEL1

LEVEL2.fieldNames LevelID,PONumber,POLineNo,Level2ID,Level2Desc,L2StDate,L2EndDate,L2Plant,L2Priority,L2SAPStatus,L2ActStDate,L2ActEndDate,L2FuncLoc,L2FuncDesc,L2Status,L2OrderType

LEVEL2.fieldSeparator @!

LEVEL2.endSeparator 'nl'

LEVEL2.processFieldNames fromConfiguration

LEVEL2.keyFieldValue LEVEL2

LEVEL3.fieldNames LevelID,PONumber,POLineNo,Level2ID,Level3ID,Level3Desc,L3StDate,L3EndDate,L3ActStDate,L3ActEndDate,L3WorkCenter,L3OrderType

LEVEL3.fieldSeparator @!

LEVEL3.endSeparator 'nl'

LEVEL3.processFieldNames fromConfiguration

LEVEL3.keyFieldValue LEVEL3

ignoreRecordsetName true

Receiver Adapter content conversion:

LEVEL1.fieldSeparator @#

LEVEL2.fieldSeparator @#

LEVEL3.fieldSeparator @#

LEVEL1.endSeparator 'nl'

LEVEL2.endSeparator 'nl'

LEVEL3.endSeparator 'nl'

The file is not being picked up.I am sure sender file adapter is correct as I have used this for (file to soap) and the scenario works file.I am not sure of receiver file adapter,do we have to use adavanced mode in receiver file adapter?Can you guys plz help me.Let me know if you have any questions

Thanks