cancel
Showing results for 
Search instead for 
Did you mean: 

Complex content conversion File sender

Former Member
0 Kudos

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,

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Thanks Hareenkumar for reply ..

The Blog which you have Given , in that all the substructure is in same hierarchy , But in my case subDetail in Under Detail .

What Can i do for such structure ???.

And Thank You for pointing me on using key under fieldNames .But It was my mistake . I was forgot to write "key" under fieldNames , as i am already using Using it.

Former Member
0 Kudos

Hi Prabhat,

Only 2 level of Hierarchy conversion is possible through field content conversion. In your case Item text is 3rd level hierarchy so it is not possible.

You can convert a flat file into deep nested structure (more than 2 levels) in mapping program or in sender file adapter by writing a module.

Thanks,

Answers (2)

Answers (2)

former_member463616
Contributor
0 Kudos

Hi Prabhat,

Please see the below blog, it might be helpful to you.

/people/riyaz.sayyad/blog/2008/05/20/xipi-convert-flat-file-to-deeply-nested-xml-structures-using-only-graphical-mapping

Regards,

Rajesh

Former Member
0 Kudos

Hi Prabhat,

In the fieldnames, you are missing the keyfield in it.

You would understand what is the mistake you are doing. Ref: /people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

There is no other alternative without using the keyfield.

Thanks,