CommRequest.dll

The CommRequest.dll is used to facilitate the transfer of files for the WIC systems. The CommRequest.dll will send and receive files between locations using one of the following communication processes, the File Transfer Protocol or Dialup processing.

The COMMREQUEST table will contain the information needed by the CommRequest.dll to automatically send and receive files.

The information in the COMMREQUEST table will be static in content and will not need a user interface to maintain the information (system table).

COMMREQUEST Table

The COMMREQUEST table contains the following information:

The information in the COMMREQUEST table will be used to connect and process the file transfers. It will also control the file transfer process based on the PROCESSNAME and SYSTEMNAME columns. If the CommRequest.dll is called with only the PROCESSNAME property set then all file transfers for the PROCESSNAME will be processed. If the PROCESSNAME and SYSTEMNAME property are both set then only the SYSTEMNAME file transfer will be processed. This will provide some flexibility on what files get transferred when the CommRequest.dll is called and will allow multiple file transfers per process. It will also allow the CommRequest.dll to be called only once for a process if desired. For example, the End of Day Process will need to transfer both the Bank files and well as the CDC files but only one call to the CommRequest process will be needed.

The following is a definition for each column:

• PROCESSNAME - Name of the calling process Example - "WICEOD".

• SYSTEMNAME - Name of the System within the Process needing a file transfer.

• SERVERNAME - Name of the FTP server.

• COMMUSERID - UserID for the FTP server.

• COMMPASSWORD - Password for the FTP server.

• RECEIVEFROMDIRECTORY - Directory on client machine where files will be retrieved.

• SENDTODIRECTORY - Directory on client machine where files will be placed.

• OUTBOUNDFOLDER - Local directory where files needing to be sent reside.

• OUTBOUNDERRORFOLDER - Local directory where files that had an error reside.

• OUTBOUNDPOSTFOLDER - Local directory where files from the OUTBOUNDFOLDER are placed after being transferred.

• INBOUNDFOLDER - Local directory where files being received will reside.

• INBOUNDPOSTFOLDER - Local directory where files from the INBOUNDFOLDER are placed after being processed.

• LOGFILENAME - Name of the communication log file.

• SENDEMAIL - Y/N value indicating the need to send an e-mail notification of the file transfer.

• SENDFILEMASK

• RECEIVEFILEMASK

• DESTINATIONURL

• FROMEMAILADDRESS

PROCESSNAME - SYSTEMNAME Combinations

The following PROCESSNAME - SYSTEMNAME combinations are used in SPIRIT:

To use the CommRequest.dll make sure that the COMMREQUEST table entry exists for each PROCESSNAME and SYSTEMNAME that need to do file transfers. From the calling program set the PROCESSNAME property to process all file transfers for the PROCESSNAME and then call the CommRequest.dll. To process only one Systems file transfer set the PROCESSNAME and SYSTEMNAME properties and then call the CommRequest.dll.

If any standard error messages occur during the CommRequest process a standard error message will be displayed to the user and the return code from the CommRequest.dll will be set to false. If the CommRequest was processed successfully, then the return code will be set to true.