Picking the abc.B file if abc.A file is present in source location.

[Former Member]

Hi All,

I need to pick a file using SFTP adapter.

In the source location two files abc.A and abc.B are placed.

abc.A is placed only after abc.B is fully processed and complete.

I need to pick and process the file abc.B ,only after finding abc.A in source location.

only abc.B should be picked ,as abc.A file is just a indicator that abc.B is fully loaded and ready to be processed.

How this can be done in SFTP adapter?Please help.

Thanks,

Akkasali.

[Former Member]

Hi Shekar/Pragati,

In SFTP there is no option to give OS command.

@Shekar: Am new to UNIX scripting,.Can you please direct me to any links related to unix scripting so that i can write in FTP.

[Former Member]

Hi,

Run a OS level command to check the existence of abc.A file and in the filename parameter in channel mention abc.B file name.

I think there is no need to create a new directory to copy the abc.B file.

Regards,

Pragati

[former_member192079]

Hi,

The " OS level command " can only help, if you are using protocol as NFS, not FTP.

-> An Custom adapter module at the sender file adapter , which read the file name as if FLAG file (abc.A) is there, read the abc.B from the directory from the directory.

Regards

AR

[rajasekhar_reddy14]

Best way to handle this is write some Unix Sxripting program at OS level copy the file B wheneve A file present in Folder,and create one more folder on FTP to store only B file,and connect to new folder using SFTP adapter .

it will avoide burden on implementing logic in PI side.it is bit simple too,as per my exp.

no standard feature available to acieve this type of requirement i think .

Regards,

Raj