File Sender adapter , FCC Multiple levels

[Former Member]

Hi Experts,

I have gone thru forum, but I could not find exact information.

Scenaio: Outbound, XI receives flat file and has to convert flat file to XMl file.

Below is the structure of flat file created in XI.

<MT>
    -----<FileHeader>
    -----</FileHeader>
    -----<QuotationHeader>    1 - Unbounded
                          <ItemHeader>
                                     <ConditionHeader>
                                      </ConditionHeader>
                           </ItemHeader>
            </QuotationHeader>
           <QuotationHeader>
               .
               .
               .
          </QuotationHeader> 
          <FileFooter>
          </FileFooter>
</MT>

FileHeader and QuotationHeader and FileFooter are at the same level.

Sender file adapter will suport this FCC ? as I have heard it supports at max 3 levels.

How this can be achieved?

Thanks,

Div

[Former Member]

FCC will not support this level nesting.

But you can try reading source in simple structure..may be line by line and then apply levels of mapping to get to desired structure

[Former Member]

Hi

Check this link

/people/karthiknarayan.kesavan2/blog/2007/08/22/file-content-conversion-for-multi-hierarchical-structure

Regards

Ramesh

[Former Member]

Hi,

The structure cant be directly parsed using FCC as it cant handle the file hierarchy greater than 3 levels.

The below specified method is one of the procedure to do that.

Modify the source structure to the below structure and parse it using FCC

<MT>

<FileHeader>

</FileHeader>

<QuotationHeader>

<ConditionHeader>

</ConditionHeader>

</QuotationHeader>

<QuotationHeader>

.

.

.

</QuotationHeader>

<FileFooter>

</FileFooter>

</MT>

Now use an intermediate mapping in which you map the modified structure to the actual structure.

Thanks,

Ramkiran

[sunilchandra007]

Hi Divyesh,

Such a nested structure cannot be created using FCC directly. You should either change the strcture or look for a workaround as explained in the blog /people/riyaz.sayyad/blog/2008/05/20/xipi-convert-flat-file-to-deeply-nested-xml-structures-using-only-graphical-mapping

Regards,

Sunil Chandra