Skip to Content
author's profile photo Former Member
Former Member

How to do Content Conversion for this structure?

Hi,

Urgent required. I have the following structure as below. There is a headerData, itemData and textData. The data that wll come into headerData could be more than one, and the same applies to the itemData and textData. The File adapter is not able to pick this file structure. It is a fixed length file at the receiver end. Could any one tell me how to do the File Content Conversion (FCC) for the structure without using the FCC module. Points to be awarded to best answer. Thaanks in advance.

The structure :

<headerData>

aaaaa

bbbb

cccc

</headerData>

<headerData>

aaaaa

bbbb

cccc

</headerData>

<headerData>

aaaaa

bbbb

cccc

</headerData>

<itemData>

fff

ggg

hhh

</itemData>

<itemData>

fff

ggg

hhh

</itemData>

<itemData>

fff

ggg

hhh

</itemData>

<textData>

fff

ggg

hhh

</textData>

<textData>

fff

ggg

hhh

</textData>

<textData>

fff

ggg

hhh

</textData>

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 02, 2007 at 08:44 AM

    HI,

    Use the following content conversion:

    I assume the data coming in the file is of below format:

    Here the key field name is K for 01,02 and 03

    01,aa,bb,cc

    01,aa,bb,cc

    02,ff,gg,hh

    02,ff,gg,hh

    03,hh,ff,hh

    03,hh,ff,hh

    If you data in the file is coming in the above way then your FCC will be

    Recordse strucutre: headerData,,temData,,textData,*

    Keyfield Name: K

    headerData.fieldNames: a,b,c

    headerData.fieldSeparator: ,

    headerData.endSeparator: 'nl'

    headerData.keyFieldValue: 01

    Similarly for itemData and text Data

    Refer the below weblog for the same:

    /people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

    Thnx

    Chirag Gohil

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.