file content conversion

[Former Member]

hello experts

I have a jdbc to file async scenario. I have an output csv file.

the problem occures when I have more then 1 row in the DB.

in the receiving file, I have the first element in a row, and the rest of the elements in the rows is in lower row

for example

this are my rows:

<row>

<first name>kfir</firstname>

<lastname>gold</lastname>

<number>1111</number>

</row>

<row>

<first name>kfir1</firstname>

<lastname>gold1</lastname>

<number>2222</number>

</row>

the output csv is:

kfir

gold 1111

kfir1 gold1 2222

I couldnt find any other attribute to add to the PI parameters.

I also add headers and the problems still occures.

Thanks

Kfir

[Former Member]

the problem seem to now be in the PI/ it looks like in the DB table there are some binary tags that we missed.

[Former Member]

Can you please provide the adapter parameters configured.

Thanks,

[Former Member]

Hi,

Can you double check your FCC with this sap help-

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

I guess you dont have to use add header,its not required in your case. just fieldSeperator parameter will do.

regards,

francis

[Former Member]

I will make some more double checks, but when I have only 1 row in the DB, I receive the CSV

file correctly with out any spaces or jumps between the cells.

the problem as I wrote happens only when I have more then 1 row.

kfir

[Former Member]

hi,

just try this in FCC

Recordset Structure row

row.fieldSeperator ,

row.endSeperator 'nl'

- do not need to mention field names there.

regards,

francis

Edited by: Francis Antony on Oct 14, 2010 10:47 AM

[Former Member]

Hi Anthony

thanks for your help, but I already tried it and still, I receive the same result but with out the titles.

I have in the first line attribute the data, and the rest of the line is received in the sencond line

in the 3rd line i receive the 2 row in the DB, etc.

Kfir

[Former Member]

well, can you also see if the transfer mode and File type are specified as "text" in the channel.

open the XML payload going to channel from RWB - message monitoring - adapter engine and verify if its in the format so that it can be converted by the channel. probably in case of multipe records the structure is not populated correctly after mapping?

<root_MT>

<row>

<first name>kfir</firstname>

<lastname>gold</lastname>

<number>1111</number>

</row>

<row>

<first name>kfir1</firstname>

<lastname>gold1</lastname>

<number>2222</number>

</row>

</root_MT>

regards,

francis

Edited by: Francis Antony on Oct 14, 2010 11:27 AM

[Former Member]

in the communication channel, I tried also file type as text with encoding UTF-8 or binary

but still the problem consist.

when i make a test to get the out file as xml, I receive the file ok.

only when I change to text/csv I receive this problem. weird

when I open the file as notepad, I see that the 1st row isnt written as the other row.

when I allign to the left, it become fixed and lined up as the other line.

could it be maybe a specific unicode or any other parameter in the Basic?

Hareenkumar - which parameters exactly do you want me to provide?

kfir

[Former Member]

Provide me the content conversion and the processing parameters.

Thanks,

[Former Member]

content conversion

row.fieldSeperator ,

row.endSeperator 'nl'

processing parameters:

file construction mode:add time stamp

write mode:directly

empty message handling: write empty file

max concurrencty:1

file type:text

encoding:UTF-8

*also tryed with file type binary

[Former Member]

Everything seems to look fine.

Remove UTF-8 in the Encoding and check.

[Former Member]

did that also before, but unfortunatly, no luck

kfir

[Former Member]

Hi Goldvase,

The content conversion parameters should be :

nameA.fieldnames first name,Last name,number

NameA.fieldSeparator ,

NameA.endSeparator 'nl'

If the lengths of the fields are fixed then use: nameA.fieldFixedLength

Check the link below:

http://help.sap.com/saphelp_srm40/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

Thanks,

[Former Member]

Hן

thats what I wrote. instead of title names, I wrote row.addHeader.... 2

any other suggestions?

Kfir