XML to flat file conversion

[Former Member]

Hi,

Iam working on Idoc to file scenatio.Using java mapping I have mapped the Idoc to an XML format. Now I have a problem in converting the XML format to flat file format.

My XML is as follows:--

<Record_Idoc>

<Record>

<Header>

<Order_no>10000398</Order_no>

<Order_Type>ZSTQ</Order_Type>

<Material_Head_no>1800406</Material_Head_no>

<Material_Head_Desc>MARC MOL MEZ R16 FY02.</Material_Head_Desc>

<Production_version>0003</Production_version>

<Test_Order/>

<Quantity_planned>801.00</Quantity_planned>

<unit>PCE</unit>

</Header>

<operations>

<operation_number>0010</operation_number>

<Work_center>P_SIG</Work_center>

<setup_start_date>20020619</setup_start_date>

<Setup_start_time>060000</Setup_start_time>

<Processing_start_date>20020619</Processing_start_date>

<Processing_Start_Time>060000</Processing_Start_Time>

<End_date>20020619</End_date>

<End_Time>061600</End_Time>

</operations>

<operations>

<operation_number>0020</operation_number>

<Work_center>P_BFB</Work_center>

<setup_start_date>20020619</setup_start_date>

<Setup_start_time>060000</Setup_start_time>

<Processing_start_date>20020619</Processing_start_date>

<Processing_Start_Time>060000</Processing_Start_Time>

<End_date>20020619</End_date>

<End_Time>074926</End_Time>

</operations>

</Record>

</Record_Idoc>

My output flat file should be as follows:--

Each record contains the following lines

Header.........

Operations......

Operations......

I have used File content Conversion in message Protocol

These are my setting:--

Header.addHeaderLine nl

Header.fieldSeparator ,

Header.endSeparator nl

operations.addHeaderLine nl

operations.fieldSeparator ,

operations.endSeparator nl

But seems that these settings does not work.

Could some one help in solving this issue.

regards

Praveen

[Shabarish_Nair · Accepted solution]

try,

Recordset Structure - Header,operations

Header.fieldSeparator ,

Header.endSeparator nl

Header.addHeaderLine X *****

operations.fieldSeparator ,

operations.endSeparator nl

and in case it doesnt work try removing the Record_Idoc node from the XML in mapping and then try the Cont. Conv.

******

X can be

0 – No header line

1 – Header line with column names from the XML document

2 – As for 1, followed by a blank line

3 – Header line is stored as NameA.headerLine in the configuration and is applied

4 – As for 3, followed by a blank line

[Former Member]

Hi praveen..

check these weblogs for content conversion....

Content Conversion (Pattern/Random content in input file)

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

File Content Conversion for Unequal Number of Columns

/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns

How to send a flat file with fixed lengths to XI 3.0 using a Central File Adapter

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter

Content Conversion ( The Key Field Problem )

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

Solution to the problem encountered using Variable Substitution with XI-SP12

/people/sravya.talanki2/blog/2005/08/11/solution-to-the-problem-encountered-using-variable-substitution-with-xi-sp12

Cheers,

raghavesh