FTP Communication channel :Sender

[vijayabaskaranj]

We are using PI to connect to 3rd party FTP server to get files. This

3rd party is a EDI data exchange company. For security and standards

reason,they create file names with sequential number and the orginal

name of the file is embedded in the file name.

In PI,we need to send it to different directories based on the file

name.So,we need the orignal name to do the above process.

The 3rd party has given us a command to execute to get the orginal file

name. The command is "quote side filename". This needs to be executed

in the directory where the file is.

We have written a batch file for the above command and executing it in

PI communication channel from run OS command before message processing

(also tried from after processing). It is not working and always PI

picks up the file with number file name. The same batch file is

working if we execute it from PI server command prompt. It seems like

PI picks up the file even before executing the BEFORE MESSAGE

PROCESSING COMMAND.

Is there way we can get the orignal file name using some options in the

communication channel? or will it be possible to execute batch file

before PI picks up the file. Any help will be appreciated

[Former Member · Accepted solution]

You can try this way..

call the shell script located in PI server from OS command before adapter calls.

That shell script should call a perl script which can connect to other ftp folder and do what ever you want.

Regards

Prabhakar

[vijayabaskaranj]

before command processing will not help in this case. As the quote command works only in the logged session. Once the bacth file close the session the file name will go back to the old name. We will be using different mail boxes (directory) to over come the problem.

thanks for your help

[bhavesh_kantilal]

Hello,

That is how the File adapter works.

What PI file adapter means by Command Line process before file to be processed is, that the file content will be read by the adapter but before passing the file to the pipeline for further processing, the command line will be executed.

Likewise Command Line Processing after does the opposite that after file is sent to pipeline, the command line will be called.

In your case, scheduling this script outside of PI makes more sense.

PS : As this quote command, this seems to be a VAN connectivity to me, are you sure file adapter can do this functionality?

Regards

Bhavesh