File-Sender: Probl. with Content conversion - Read whole line in singleTag

[Former Member]

Hello,

I have a flat file that i read with the sender file adapter.

After content conversion I get not the result i wished to have...

The source flat file looks for example like this:

ABC;DEF;GHIJ

KLM;NOP;Q

RSTU;VW

After the Content Conversion I would like to have this result:

<Recordset>

<Data>

<Row>ABC;DEF;GHIJ

<Row>KLM;NOP;Q

<Row>RSTU;VW

<……>

What sounds very similar but didn’t work for me yesterday….

I defined a data type that looked like this:

DT_TEST (Complex Type)

Recordset (0..unbounded)

Data (1)

Row (type string / 0..unbounded)

During the file content conversion I just did this:

Recordsetname: Recordset

…

Recordset structure: Data, 1

…

Data.fieldNames = Row

Data.fieldSeparator = ‘nl’

This was also described in blog:

/people/sravya.talanki2/blog/2005/08/16/configuring-generic-sender-file-cc-adapter

But my result is always like this:

<Recordset>

<Data>

<Row>ABC;DEF;GHIJ

</Data>

</Recordset>

<Recordset>

<Data>

<Row> KLM;NOP;Q

</Data>

</Recordset>

<Recordset>

<Data>

<Row> RSTU;VW

</Data>

</Recordset>

….And not like I wished….

Can anybody help me…?

Greetings

Tobias

[manish_bhalla2]

Hi Tobias,

Remove the entry "Data.fieldSeparator = ‘nl’" and then try again.

Cheers

Manish

[former_member206604]

Hi,

Under Content conversion parameters leave <b>RecordSets per message</b> as blank or give "*". I think you have given it as 1.

Also try with this parameters

Data.fieldNames = Row

Data.fieldSeparator = ‘nl’

Data.endSeparator = ‘nl’

Thanks,

Prakash

[Former Member]

Hello,

first of all thanks a lot for your answers.

>Remove the entry "Data.fieldSeparator = ‘nl’" and then >try again.

This is a mandatory parameter. If I would remove this I would need the paramters fieldFixedLength instead....

I tried this once but i got the same result.

Greetings,

Tobias

[Former Member]

Hello,

the RecordSets per message is already blank.

I posted all parameters that I filled.

I alsow tried to use the parameter endSeparator once. But the result was the same.

May it be that it is not possible to get the result i want....

Greetings

Tobias

[former_member206604]

Hi,

I just gone thru the blog and as per the structure defined I have no idea how this works this way.

But if you modify the structure to

RecordSet - occurs 0-1

Data - occurs 0-n

Row - occurs 0-1

And in the Content conversion mentions Data,* instead of Data,1.

In this case you will be getting a output like

<Data>
  <Row>ddf,sdfsd,sdf</Row>
</Data>
<Data>
  <Row>fff,sdfsd,sdf</Row>
</Data>

You can achieve this but I don't have any idea how to generate that kind of output with the Structure and the conversion parameter mentioned in the blog.

Thanks,

Prakash