on 01-31-2011 7:29 AM
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,
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.