File Content Conversion

[Former Member]

Hi,

I am doing a flat file to webservice scenario where I need to use file content conversion.There are L1,L2 and L3 by which I need to identify them.Can you help me how do I declare the parameters for content conversion in adapter.Sample file as below.

L1PO#,Line#,Text,StDate,EndDate,Vendor,POValue,ExpectedValue,Plant,OrderType

L2PO#,Line#,WO#,Desc,StDate,EndDate,Plant,Priority,Status,ActStTime,ActEndTime,FuncLoc,FuncDesc,OrderType

L3PO#,Line#,WO#,OP#,OPDesc,StDate,EndDate,ActStDate,ActEndDate,WorkCenter,OrderType

L1PO#,Line#,Text,StDate,EndDate,Vendor,POValue,ExpectedValue,Plant,OrderType

L2PO#,Line#,WO#,Desc,StDate,EndDate,Plant,Priority,Status,ActStTime,ActEndTime,FuncLoc,FuncDesc,OrderType

L1PO#,Line#,Text,StDate,EndDate,Vendor,POValue,ExpectedValue,Plant,OrderType

L2PO#,Line#,WO#,Desc,StDate,EndDate,Plant,Priority,Status,ActStTime,ActEndTime,FuncLoc,FuncDesc,OrderType

L3PO#,Line#,WO#,OP#,OPDesc,StDate,EndDate,ActStDate,ActEndDate,WorkCenter,OrderType

L3PO#,Line#,WO#,OP#,OPDesc,StDate,EndDate,ActStDate,ActEndDate,WorkCenter,OrderType

L3PO#,Line#,WO#,OP#,OPDesc,StDate,EndDate,ActStDate,ActEndDate,WorkCenter,OrderType

L1PO#,Line#,Text,StDate,EndDate,Vendor,POValue,ExpectedValue,Plant,OrderType

L1PO#,Line#,Text,StDate,EndDate,Vendor,POValue,ExpectedValue,Plant,OrderType

L1<None>

L2PO#,Line#,WO#,Desc,StDate,EndDate,Plant,Priority,Status,ActStTime,ActEndTime,FuncLoc,FuncDesc,OrderType

L3PO#,Line#,WO#,OP#,OPDesc,StDate,EndDate,ActStDate,ActEndDate,WorkCenter,OrderType

L3PO#,Line#,WO#,OP#,OPDesc,StDate,EndDate,ActStDate,ActEndDate,WorkCenter,OrderType

-

---

The ouput data type I am expecting is :

CostObjects

Level1

POnUMBER

POLineNo

ShortText

StDate

-

-

-

-

OrderType

Level2

Level1LineNo

Level2ID

Level2Desc

-

-

-

L2OrderType

Level3

Level1ID

Level1LineNo

Level2ID

Level3ID

-

-

-

L3OrderType

[Former Member]

Hi,

You can not have

Level2

Level1LineNo

Level2ID

Level2Desc

The structure of xml should be

<documentName>...

<recordset>

<NameA>

<field-nameA1>field-value</field-nameA1>

<field-nameA2>field-value</field-nameA2>

<field-nameA3>field-value</field-nameA3>

</NameA>

<NameB>

<field-nameB1>column-value</field-nameB1>

<field-nameB2>column-value</field-nameB2>

<field-nameB3>column-value</field-nameB3>

</NameB>

</recordset>

...

<recordset>

...

</recordset>

</documentName>...

where documentName = CostObjects

NameA = Level1

NameB = Level2

NameC = Level3

Refer thsi link:

[http://help.sap.com/saphelp_nw70/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm]

Thanks,

Beena

[Former Member]

Hi Guest, Can you write the output as an XML ? It will easy to figure out the parameters for the content conversion.

[Former Member]

This is my xml structure,can I have this structure?

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

<ns0:CostObjects xmlns:ns0="http://*******.com/CostObjectsUpload">

<Level1>

<PONumber/>

<POLineNo/>

<ShortText/>

<StDate/>

<EndDate/>

<Vendor/>

<POValue/>

<ExpectedValue/>

<Plant/>

<Status/>

<OrderType/>

<Level2>

<Level1ID/>

<Level1LineNo/>

<Level2ID/>

<Level2Desc/>

<L2StDate/>

<L2EndDate/>

<L2Plant/>

<L2Priority/>

<L2SAPStatus/>

<L2ActStDate/>

<L2ActEndDate/>

<L2FuncLoc/>

<L2FuncDesc/>

<L2Status/>

<L2OrderType/>

<Level3>

<Level1ID/>

<Level1LineNo/>

<Level2ID/>

<Level3ID/>

<Level3Desc/>

<L3StDate/>

<L3EndDate/>

<L3ActStDate/>

<L3ActEndDate/>

<L3WorkCenter/>

<L3OrderType/>

</Level3>

</Level2>

</Level1>

</ns0:CostObjects>

Edited by: guest xi on Feb 7, 2008 11:03 PM

[Former Member]

Hi,

You can not use File Content Conversion for 3 -level nested structure.

Your structure can be

<ns0:CostObjects xmlns:ns0="http://tsocorp.com/ContractorMngt/CostObjectsUpload">

<Level1>

<Level2>

</Level2>

<Level3>

</Level3>

</Level1>

</CostObjects>

You can not have Level3 nested.

Thanks,

Beena.

[Former Member]

Here Level2 is chile node if Level1 and Level3 is child of Level2,please note this.When I paste it here they all aligns up

[Former Member]

Recordset Name: Input

Recordset Structure: Level1,,Level2,,Level3,*

Key Field Name: key

Key Field type: String

Level1.fieldSeparator: ,

Level2.fieldSeparator: ,

Level3.fieldSeparator: ,

Level1.keyfieldValue: L1

Level2.keyfieldValue: L2

Level3.keyfieldValue: L3

Level1.keyfieldInStructure: Ignore

Level2.keyfieldInStructure: Ignore

Level3.keyfieldInStructure: Ignore

Level1.filedNames: PONumber, POLineNo, ....

Level2.filedNames: Level1ID, Level1LineNo, ....

Level3.filedNames: Level1ID, Level1LineNo,Level2ID ....