File content conversion tab delimited

[Former Member]

Hi Experts,

I am trying to do scenario file to JDBC.

the source file is tab delimited file the file as

sno empname empno country

1 ETY 1246 IN

2 EPS 1247 IN

I need to transfer the data into Data base table

source structure as follows

<?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_PRY

xmlns:ns0="http://product.com/prvsoup">

<DT_PRY>

<ID>1</ID>

<empname>ETY</empname>

<empno>1246</empno>

<contry>in</contry>

</DT_PRY>

</ns0:MT_PRY>

I don't want to update the first row i.e field names.

Can any one give the Content conversion parameter in Comunication channel.

Regards

ramu

[Former Member · Accepted solution]

Hello Ramu,

<a href="/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter Adapter TAB delimited file</a>

+

Content Conversion Parameters:

Document Offset = 1

Regards,

[santhosh_kumarv]

Hi,

The FCC...

Document Name : MT_PRY

Document Namespace : http://product.com/prvsoup

Recordset Name : recordset

Recordset structure = DT_PRY,*

DT_PRY.fieldnames = ID,empname,empno,country

DT_PRY.fieldSeparator = '0x09'

DT_PRY.endSeparator = 'nl'

ignoreRecordsetName = true

http://help.sap.com/saphelp_nw04/helpdata/en/14/80243b4a66ae0ce10000000a11402f/frameset.htm

Regards

San

there is a Way.

[Former Member]

specify value for Document Offset as 1 to skip the header row (1st row)

[Former Member]

content conversion parameters

Recordset structure = DT_PRY,*

DT_PRY.fieldnames = ID,empname,empno,country

DT_PRY.fieldSeparator = '0x09' (tab delimited)

DT_PRY.endSeparator = 'nl'