Skip to Content
avatar image
Former Member

file conten conversion

Hello Folks,

I am trying to setup the fcc parameters of the following xml message:

<TLDoc>

<Record>20081234||Company1|Address1|Dept1</Record>

<Record>20085678||Company2|Address2|Dept2</Record>

<Record>20085009||||</Record>

</TLDoc>

Is this possible to convert this kind of xml structure to a flat file? My data type looks like this..

DT_TLDoc

Record - Element - xsd:string - 1..unbounded

And below are my content conversion parameters:

Recordset Structure * : Record

Name

Record:Record.fieldSeparator - 'nl'

The file is created but it is empty. Basically the data inside <Record> is considered as a single set of string.

Any advise on this please?

Thanks!

Regards,

Lex

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 30, 2008 at 06:39 AM

    Hi,

    Use these as Refferences to do Content Conversion at Receiver End

    File Adapter (Receiver) - Are we "really" sure about the concepts?

    File Receiver with Content Conversion

    Regards

    Seshagiri

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Gaurav,

      Ive set the following parameters,

      Record.endSeparator 'nl'

      Record.processFieldNames fromConfiguration

      But the file still looks empty though.

  • avatar image
    Former Member
    Sep 30, 2008 at 06:42 AM

    HI Lex

    Please provide more info how you want the target Flat file look like.

    Thanks

    Gaurav

    Edited by: Gaurav Bhargava on Sep 30, 2008 12:13 PM

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      As you said it is a mirror of your xml messge then whatever you have done is correct. But rather using endSeparator as 'nl' use the hexadecimal value and then try again.

      Recordset Structure - Record

      Record.endSeparator '0x0D''0x0A'

      I am not very sure, but there could also be a problem of hierarchy in your structure.

      Generally the structure should be like this..

      <Root>

      -


      <Item>

      -


      <Field1>hello</Field1>

      -


      <Field2>and</Field2>

      -


      <Field3>welcome</Field3>

      -


      </Item>

      </Root>

      Check if your structure is something like this.

      Regards,

      Sarvesh