file conten conversion

[Former Member]

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

[Former Member]

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

[Former Member]

Hey,

The flat file will look like

20081234||Company1|Address1|Dept1

20085678||Company2|Address2|Dept2

20080009||||

Basically a mirror of the xml message but with no tags in it.

[Former Member]

Hi,

You can Implemet my reply Very Well for ur Requirement

Regards

Seshagiri

[Former Member]

Hi Seshagiri,

I followed your advise (similar with ).

But are you suggesting that I need to modify the Datatype?

Thanks!

[Former Member]

Hi,

Why do you Reffer that thread....that is related to Field Fixed Lengths

Are you implementing the same concept here???

If Yes Folow the replies in that thread Else Follow this Reply

Regards

Seshagiri

[former_member192295]

Hi,

I think field separator we can use one either || or | at a time, we can't use more then one at a time, once can use both i think can't use according to ur requirement.

Follow below structure at receiver end it will work.

row mean record set structure

row.fieldFixedLengths X,X,X

row.fieldNames X,X,X

row.fieldSeparator || or |

row.endSeparator nl

ignoreRecordsetname true

[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

[Former Member]

Hi,

Use these as Refferences to do Content Conversion at Receiver End

Regards

Seshagiri

[Former Member]

HI

Use configuration as follows

Recordset Structure - Record

Record.endSeperator 'nl'

Record.processFieldNames fromConfiguration

Thanks

Gaurav

[Former Member]

Hi Gaurav,

Ive set the following parameters,

Record.endSeparator 'nl'

Record.processFieldNames fromConfiguration

But the file still looks empty though.