Skip to Content
0
Former Member
Jan 31, 2011 at 07:29 AM

Complex content conversion File sender

130 Views

RecordSet

>Header 1..1

hfield1 1..1

hfield2 1..1

>/Header

>Detail 1..n

Dfield1 1..1

Dfield2 1..1

> SubDetail 1..1

SDfield3 1..n

> /SubDetail

>/Detail

/RecordSet

My CSV File would be like.

1hfield1,hfield2

2Dfield1,Dfield2

3SDfield3

3SDfield3

2Dfield1,Dfield2

3SDfield3

3SDfield3

2Dfield1,Dfield2

3SDfield3

3SDfield3

I have Used following Conversion Parameter. Please check.

Recordset Structure : Header,1,Detail,,SubDetail,

Keyfieldname : key

Keyfieldtype: string

Header.fieldSeparator ,

Header.endSeparator u2018nlu2019

Header.fieldNames hfield1,hfield2

Header.keyFieldValue 1

Header.keyFieldInStructure ignore

Detail.fieldSeparator ,

Detail.endSeparator u2018nlu2019

Detail.fieldNames Dfield1,Dfield2,SubDetail

Detail.keyFieldValue 2

Detail.keyFieldInStructure ignore

SubDetail.fieldSeparator ,

SubDetail.endSeparator u2018nlu2019

SubDetail.fieldNames SDfield3

SubDetail.keyFieldValue 3

SubDetail.keyFieldInStructure ignore

Suggest , where I am wrong. And what is missing ?????????????????

So . I am not able to convert this SubDetail by using content conversion.

Upto Level Header and Detail , it is coming in xml file . but not for SUBDETAIL and SDfield3.

Please check above config and suggest.

Is there any way to perform such content conversion without using KEVALUE 1, 2, 3 in CC parameters,