Using EFT Context Variables

EFT uses context variables to pull data from the database. The variable contains specific information about an Event. You can use the variables below in Event Rules, email notifications, and Advanced Workflows. (Refer also to topics on specific Event Triggers.)

How to Use the Variables

In the Variables box, click a property that you want to insert.

  • If you just want the information contained to the variable, click the variable in the right column of the Variables box.

  • If you want the information and a label, click the text in the left column of the Variables box.

For example, if you click Event Time in the left column the label "Event Time" and the time are displayed. If you select %EVENT.TIME% in the right column, the time will be displayed without a text label.

For example, when you create an Event Rule, you can configure an email to be sent when the Event occurs. In the Edit Mail Template dialog box, you can send the default email or you can add one or more variables listed in the Variables box at the bottom of the email. Each of the variables defined in EFT is described in Connection Variables; however, not all of the variables described below are available in the email notification. In the email notification, you can specify to display the text along with the value of the variable (e.g., File Creation Date: 8/28/2022), or just the value of the variable (e.g., 8/28/2022).

Suppose you configured this email notification:

You then uploaded a file on August 28, 2007 at 10:01:56. The email would appear similar to the following:

This message was sent to you automatically by EFT on the
following Event: File Uploaded.

Event Time: 28 Aug 22 10:01:56

File Creation Date: 8/28/20202

File Creation Time: 10:01:56

Event Date Stamp: 20200828

Event Time Stamp: 100156

NOTE: In Event Rules and Commands with a defined path or file name, do not use variables that add invalid file name characters, such as a slash, colon, parenthesis, etc.

For example, you cannot use %FS.FILE_CREATE_DATE% and %FS.FILE_CREATE_TIME% for file naming, because the output of these variables is DD/MM/YYYY and HH:MM:SS and the forward slash (/) and colon (:) are not valid characters for filenames.

In most cases, the file created date and time is the same as the Event triggered time, therefore you can use %EVENT.DATESTAMP% (YYYYMMDD) and %EVENT.TIMESTAMP% (HHMMSS) when renaming files (because they do not use invalid characters), and %FS.FILE_CREATE_DATE% and %FS.FILE_CREATE_TIME% for email notifications.

For example, suppose an OnUpload Event Rule causes an Offload Action that moves myfile.txt to the following path:

C:/Inetpub/EFTRoot/Site1/Usr/jsmith/%EVENT.DATESTAMP%_%FS.FILE_NAME%


The resulting path is:

C:/Inetpub/EFTRoot/Site1/Usr/jsmith/20070728_myfile.txt