Sender SFTP FCC(csv) Configuration

[Former Member]

Hi Experts,

I am working on SFTP FCC - CSV to JDBC scenario in PO 7.4.

Please help me to configure sender CC.

File Format :

Input:  Some fields are not enclosed in double quotes. Eg: Date

           And in 4th row "CH" we are getting field titles.

"RH",2016/09/22 04:59:06 +0100,"R","SKQPFRT3T6UGY",010,

"FH",01

"SH",2016/09/21 00:00:00 +0100,2016/09/21 23:59:59 +0100,"SKQPFRT3T6UGY",""

"CH","Transaction ID","Invoice ID","Reference ID","Transaction Date","Status","Amount","currency","Code"

"SB","64K75561V34090gdg","1501544645","T1300",2016/09/21 00:10:44 +0100,2016/09/21 00:10:44 +0100,"CR",3395,"GBP",""

"SB","64K75561V34090gdg","1501544645","T1300",2016/09/21 00:10:44 +0100,2016/09/21 00:10:44 +0100,"CR",3395,"GBP",""

"SF",222

"SC",222

"RF",222

"RC",222

"FF",222

My Configuration:

ReportHeader.fieldSeparator	,
ReportHeader.fieldNames	ColumnType,ReportGenerationDate,ReportingWindow,AccountID,ReportVersion
ReportHeader.keyFieldValue	"RH"
ReportHeader.enclosureSign	"
ReportHeader.enclosureSignEnd	"
ReportHeader.endSeparator	'nl'

....

FileFooter.fieldNames	ColumnType,RowCount
FileFooter.keyFieldValue	FF
FileFooter.enclosureSign	"
FileFooter.enclosureSignEnd	"
FileFooter.endSeparator	'nl'
ignoreRecordsetName	true

1. How to ignore 4th Row "CH" ( Column headers)

2. How to Handle double quotes, few fields are not enclosed in double quotes.

With my configuration, I am ending up with the below errors (ReportRecordCount comes in the middle of the structure)

Exception received: com.sap.aii.adapter.sftp.ra.rar.conversion.exception.ParserException: Record: ReportRecordCount expected at line: 1

or

Exception received: com.sap.aii.adapter.sftp.ra.rar.conversion.exception.ParserException: Record: ReportRecordCount expected at line: 1480

Many Thanks

[former_member182412 · Accepted solution]

Hi TS,

Your current configuration will be file for your second question.

Regards,

Praveen.

[Former Member · Accepted solution]

Thanks Praveen

My Configuration is working perfectly, when I am picking the file from local drive.

I am ending up with below error, when I am using SFTP

Exception received: com.sap.aii.adapter.sftp.ra.rar.conversion.exception.ParserException: Record type: ReportRecordCount missing in the end of the file

In file adapter, there is a option to select FileType as text.

I didn't see any option for that in SFTP. I think by default, it is considering File as Binary in SFTP.

I have used below module for conversation. But no luck

[former_member182412 · Accepted solution]

Hi TS,

I think there is a bug in SFTP adapter content conversion, use message transform bean in SFTP adapter to convert this flat file to XML because MessageTransformBean will work exactly like file adapter FCC and you tested and it is working.

How To...Content conversion module with J2EE JMS adapter - Process Integration - SCN Wiki

Regards,

Praveen.

[vicky20691]

1. ColumnHeader.fieldFixedLength = 0

    ColumnHeader.fixedLengthTooShortHandling = Cut

The above will remove the 4th row.

2. add paramter NameA.enclosureConversion = No

this will handle double quotes.

Regards,

Vikas