cancel
Showing results for 
Search instead for 
Did you mean: 

How to configure SFTP sender adapter Module parameters if file is .csv file

former_member197830
Participant
0 Kudos

Hi Experts,

I am trying to configure SFTP sender adapter Module parameters but is fails, below is the error screens .

My file looks below screen

Can you please suggest how to overcome this problem.

Thank you,

Regards,

Narasaiah T

Accepted Solutions (1)

Accepted Solutions (1)

former_member186851
Active Contributor
0 Kudos

Hello Narsaiah,

Please share the module parameters you configured

Former Member
0 Kudos

Is defaul module"CallSapAdapter" the last module in the list? if not move it to the last.

former_member197830
Participant
0 Kudos

Hi Sri,

Below is my module parameters

In my .csv file first line is column names and remaining lines are records.

Regards,

Narasaiah T

former_member197830
Participant
0 Kudos

Hi Jabri,

I didn't get that point.

Regards,

Narasaiah T.

former_member186851
Active Contributor
0 Kudos

Hello Narasaiah,

Change the processing sequence of the beans i.e Move callSap adapter bean to last and module transformation bean to first.

Hope it will work,Let me know if you face any issues.

former_member197830
Participant
0 Kudos

Hi Sri,

It's working but how to ignore first line(column) names from the file.

Thank you,

Regards,

Narasaiah T.

former_member197830
Participant
0 Kudos

Hi Sri,

It's working fine but how to remove first line(Columns names) from the payload.

Regards,

Narasaiah T.

former_member197830
Participant
0 Kudos

Hi Sri,

Can you please help me above issue.

Thank you,

Regards,

Narasaiah T.

former_member186851
Active Contributor
0 Kudos

Hello Narsaiah,

Try any of these parameters

documentSkipFirstRows

documentOffset

for both value shoule be set to 1

former_member197830
Participant
0 Kudos

Hi Sri,

It didn't work.

Regards,

Narasaiah T.

Former Member
0 Kudos

my point was change the sequence and bring "CallSapAdapter" module at the end, This module should be the last one always.....which u did and solved the issue.

Former Member
0 Kudos

If the first row contains the fields name then Use below parameter in your Message transformation Bean.

Parameter Name                                                   Parameter Value

xml.processFieldNames                                        fromFile

This will read the field information from the first row of the file and use them in the xml.

Note: The names in the file should be same as the field names that you defined in your data type.

Regards

Osman

engswee
Active Contributor
0 Kudos

xml.documentSkipFirstRows is only available for StructPlain2XML conversion, refer below

If this case, the normal approach would be to handle this in the message mapping, i.e. skip the first line when mapping from source to target.

Rgds

Eng Swee

former_member197830
Participant
0 Kudos

Hi Eng Swee Yeoh,

How to skip first line in message mapping level ?

Regards,

Narasaiah T.

Answers (0)