FTP Event

An FTP Event enables you to specify when and how frequently a process flow should be executed based on either creation of a new file or existence of a file(s) on an FTP Server or upon its modification.

Steps to create a FTP Event

  1. Click Configure > EVENTS > FTP Event.
  2. Click Create FTP Event.


  3. On the Create FTP Event window, type the name and description of the new FTP event in the Name and Description fields respectively.
  4. Type the Host name and Port on which FTP Server is running.
  5. Type the username and password required to access FTP Server in the User ID and Password
  6. Re-enter the password in the textbox Confirm Password.
  7. Select the transfer type (ACTIVE or PASSIVE) from the Transfer Type.
    1. ACTIVE transfer is more secure since the client only initiates communication to the server on one port.
    2.  PASSIVE transfer the client initiates communication with the server over two ports. PASSIVE mode is useful when you are behind a firewall or a proxy.
  8. Select the trigger from the Trigger Type drop-down list. 

    On FileModified

    To configure the FTP event to check for any modification in the file(s).

    On FileExists

    To configure the FTP event to check for the existence of the file(s).

    On FileCreated

    To configure the FTP event to check for the creation of a new file(s).

    Trigger Name
    Description
  9. Select Run Initial Load checkbox to process the files created when the event is not active. This option is enabled only if On FileCreated option is selected in the Trigger Type.

    After the activation of the event, for the first time, the system processes all the files that exist in the base folder location, irrespective whether they were processed earlier or not. However, for subsequent activation, only the unprocessed files are processed each time
  10. Select Don't Process Duplicate Files checkbox if you don't want to process the same file again. This option is enabled only if On FileCreated option is selected in the Trigger Type
  11. Select SFTP checkbox if the FTP Server specified in the Host Name is an FTP Server over SSL.
    1. Select the key manager from the Key Manager drop-down list.
  12. Select FTPS checkbox if the FTP Server specified in the Host Name is an FTP Server over TLS/SSL.  

    1. Select the mode from the FTPS Mode drop-down list. It can be Explicit or Implicit depending on FTP Server you are accessing. 

    2. Select the protection level supported by the FTP Server from the Protection Level drop-down list. 

    3. Select Validate Server checkbox to validate the certificate sent by the FTPS Server against the certificate imported in Keystore.

    4. Select the activity from the Keystore Name drop-down list. This option is applicable only if you have selected Validate Server

  13. Type the name of the file(s) that the FTP event needs to verify in the File Include Criteria. To select the file(s), click Define List. The File Include Criteria List window appears.

    1. Type the name of the file or any criteria in the File Include Criteria, for example, .txt. a*, and so on, and then click Add to List
    2. Click Save



  14. Type the name of the file that the FTP event does not need to verify in the File Exclude Criteria. For example, you have typed *.txt as a value in the File Include Criteria, and you want following two files Gdata.txt and Gdata1.txt file not to be verified by the FTP Event. Then Gdata.txt and Gdata1.txt file name need to be entered separated by a comma in the File Exclude Criteria. You can also use regular expressions to specify more than one file in the File Include Criteria and File Exclude Criteria.

    If more than one file is specified in the File Include Criteria, the process flow will trigger for each file.
  15. Type the path of the file from where FTP events verify the file in the File Base Location field.  

    In File Include Criteria and File Exclude Criteria, you can also give the folder name along with the file name. For example, suppose you have typed C:\Gmdata in the File Base Location field. There are two sub-folders - Purchase and Purchase1 in the Gmdata folder. Now, you don't know whether the file is in Purchase or Purchase1 folder. To handle this scenario, you can define File Include Criteria as defined below:
    Purchase/.txt,Purchase1/.txt


    You can also use regular expression in the folder name as given below:
    Pur*/*.txt

    This path includes both the folders - Purchase and Purchase1.

  16. Provide the date from which FTP event will start triggering in the Event Start Date. The date must be in MM/dd/yyyy format. Click the Calendar icon to select the required date.
  17. Select the start time when the event will start triggering from the Time field.
  18. Provide the date on which FTP event will stop triggering in the Event Expiry Date. The date must be in MM/dd/yyyy format. Click the Calendar icon to select the required date.
  19. Select the expiry time when the event will stop triggering from the Time field.
  20. Select the trigger from the Trigger drop-down list. You can select Simple or Cron from the list.

    By default, Simple is selected as a Trigger type.
  21. Provide the time interval for which FTP event will check for the arrival of any file or modification of existing file in the Polling Frequency. Type the digit in the Frequency and select the unit of time (seconds, minutes, hours, day, etc.) from the Duration.

    We recommended minimum Polling Frequency to be more than 60 seconds.
  22. If you have selected Cron as a Trigger type then define the specific time schedule to trigger. For more information on how to define Cron Expression, click here.



  23. Type the time in the File Stable Time for which trigger will wait for the file to become stable and select the duration from the Duration. This is applicable for OnFileCreated and On FileModified Trigger Type. Type 0 to pick up the file without checking its stability (not running MDTM and size commands).  
  24. Expand Advanced Properties to view the advanced properties of an FTP Event.



  25. Select the Option you want to send email notification for. You would view Duplicate file in this box only if you have clicked the option Don't Process Duplicate Files (Step 11).
  26. Type the email id in the Notification Receiver Email-ID(s) (comma separated) to receive error emails related to this FTP event.
  27. Select Trigger in Sequence check box to trigger the associated process flow in a sequential manner. If you do not select the Trigger in Sequence check box then the associated process flow will trigger concurrently.

  28. The Connector lists the APIs to connect to the FTP Server.

    For any new service, by default Apache Camel is selected. 

    The options of the Connector drop-down list changes as per your selection of the protocols to use to establish the FTP connection. 

    FTP

    Apache Camel
    NATIVE
    Secured Inet Factory (Deprecated)

    SFTP

    Apache Camel
    J2SCH (VFS)
    Secured Inet Factory (Deprecated)
    J2SSH

    FTPS

    Apache Camel
    J2SCH (VFS)
    Secured Inet Factory (Deprecated)

    Protocol

    Options

  29. Enter the additional configuration details in the Add On Configurations text box. This field is available only if you have selected Apache Camel connector.

  30. Select Verbose check box to create a log file of your FTP service.

    You can enable the Verbose check box only if you have selected the Secure Inet Factory or Apache Camel option from the Connector field. When you select the Verbose check box using Secure Inet Factory option, the log file is created within …ConnectServerInstallFolder>\AdeptiaServer\ServerKernel\logs\ftplogs folder. Whenever you execute this activity, a separate log file is created with the name <ActivityName_MM-dd-yyyy hh-mm-ss.S>. Where, ActivityName is the name of the FTP activity for which the log file is created.

    When you select the Verbose check box using Apache Camel option, the log files are generated on the basis of the FTP protocols. For example, if a user runs FTP activity named FTP Source (connecting with FTP protocol only), the verbose log file path for this activity will be ...\logs\ftpLogs\ftpcomponent.log. If the user runs this activity more than once, all the generated logs will be appended to this ftpcomponent.log file.

    Log file will be generated on the basis of FTP protocols (FTP/FTPS/SFTP) at the different location as explained below:

    • For FTP protocol:  ...<ConnectServerInstallFolder>\AdeptiaServer\ServerKernel\logs\ftpLogs\ftpcomponent.log
    • For FTPS protocol:  …<ConnectServerInstallFolder>\AdeptiaServer\ServerKernel\logs\ftpLogs\ftpscomponent.log
    • For SFTP protocol:  …<ConnectServerInstallFolder>\AdeptiaServer\ServerKernel\logs\ftpLogs\sftpcomponent.log
  31. Select the Project from drop-down list of Project.

  32. Click Save.