Skip to Content
avatar image
Former Member

Reoccurring Nodes with IDOC to Flat File

Hi there

I am trying to create a comma seperated file from idoc to flat file with FCC.

My structure looks like this:

StructureNode - (1TO1)

--SubNode1 - (1TO1)

-


Element1

--Subnode2 - (1ToMany)

-


ElementA

-


ElementB

-


ElementC

-


ElementD

My FCC is as follows:

Recordset Structure = StructureNode

StructureNode.fieldNames = SubNode1, SubNode2

StructureNode.fieldSeparator = ,

SubNode1.fieldSeparator = ,

SubNode2.fieldSeparator = ,

My problem is the flafile only has the ElementA for each occurence.

Ex. if my sample source file looks like this:

<StructureNode>

<SubNode1>

<Element1>Test</Element1>

</SubNode1>

<Subnode2>

<ElementA>A001

<ElementB>B002

<ElementC>C003

<ElementD>D004

</Subnode2>

<Subnode2>

<ElementA>A005

<ElementB>B006

<ElementC>C007

<ElementD>D008

</Subnode2>

<Subnode2>

<ElementA>A009

<ElementB>B010

<ElementC>C011

<ElementD>D012

</Subnode2>

</StructureNode>

My output will look like this:

Test,A001,A005,A009

Its missing B, C and D?

Does anyone know how to fix this?

Regards,

Jan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Feb 24, 2009 at 11:01 AM

    I got it working, I had to remove my StructureNode.. But had to redo my mapping. Don't know if there is an easier way or maybe how to tweak my FCC for this.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 24, 2009 at 11:02 AM

    Your content conversion should look like

    Recordset Structure = SubNode1,Subnode2

    SubNode1.fieldSeparator = ,

    SubNode2.fieldSeparator = ,

    As this is receiver content conversion, no need to mention fieldNames.

    Also deault endSeparator is newline. If it is anything else, mention it explicitly

    Add comment
    10|10000 characters needed characters exceeded