recordsetStructure for nested xml structure

[babji2286]

Hello experts,

We are receiving an invoice(.csv) file which should be converted to below structure which has 3 levels.

In Content Conversion, i set the parameter 'recordsetStructure = Header,1,Item*,SplitItem,*'. The problem with this is after 1st line item, the system is trying to create another header record.

Expected:

<Invoice>

     <Header>

          <Item>

               <Split Item>

               </Split Item>

          </Item>

          <Item>

               <Split Item>

               </Split Item>

          </Item>

          <Item>

               <Split Item>

               </Split Item>

          </Item>

     </Header>

<Invoice>

Actual:

<Invoice>

     <Header>

          <Item>

               <Split Item>

               </Split Item>

          </Item>

     </Header>

</Invoice>

<Invoice>

     <Item>

          <Split Item>

          </Split Item>

     </Item>

</Invoice>

<Invoice>

     <Item>

          <Split Item>

          </Split Item>

     </Item>

</Invoice>

How should i build the parameters to get the expected XML structure?

Regards,

Vishnu

[former_member187587]

No sure if this is a typo but if so , you have a configuration error:

you are missing the comma between the Item and the *.

Should be ,Item,*

[engswee]

Vishnu

You might want to share an example of your CSV content as well as the current FCC configuration.

Regards

Eng Swee

[babji2286]

Hi Eng Swee,

Below is how CSV file looks like.

LEVEL	INVOICE ID	LINE ITEM ID
Header	20029		HEADER DATA	HEADER DATA	HEADER DATA
Line	20029	40982	LINE ITEM DATA	LINE ITEM DATA	LINE ITEM DATA
Line Split	20029	40982	LINE SPLIT DATA	LINE SPLIT DATA	LINE SPLIT DATA
Line Split	20029	40982	LINE SPLIT DATA	LINE SPLIT DATA	LINE SPLIT DATA
Line	20029	40983	LINE ITEM DATA	LINE ITEM DATA	LINE ITEM DATA
Line Split	20029	40983	LINE SPLIT DATA	LINE SPLIT DATA	LINE SPLIT DATA
Line Split	20029	40983	LINE SPLIT DATA	LINE SPLIT DATA	LINE SPLIT DATA

Thanks,

Vishnu Sangati