Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The workflow template is the area where the workflow is designed. The workflow template outline one or several workflows.

...


ItemDescription

Enable Sort Order

Determines if the service will be utilized or not. If enabled, the sort order that you select also applies to subfolders if you have selected the Include Subfolders check box for the FTP, SFTP and Disk collection agents. For further information, see the section for the relevant agent in 9. Appendix 2 - Batch and Real-Time Workflow Agents.

Modification Time

Select to enable file collection order according to the modification time stamp. If Sort Direction is set to Ascending , the oldest files are collected first. The time resolution depends on the server and protocol.

Note
titleNote!

Most FTP and SCP servers follow the Unix modification date format for file time stamps. The modification date resolution is one minute for files that are time stamped during the last six months. After six months a resolution of one day is applied.


Value Pattern

The method used to locate the item (part of the file name) to be the target for the sorting. This could be either Position that indicates that the item is located at a fixed position in the file name or Regular Expression indicating that the item will be fetched using a regular expression.

Position

If Position is enabled, the files are sorted based on the part of the filename indicated by Position plus Length. The Start Position value states the offset in the file name where the sorting item starts. The first character has offset 0 (zero).

The Length value states the length of the sorting item (part of the file name) if it has a static length. For sorting items with a dynamic length, use the value zero (0) will be used.

Note
titleNote!

Files with a name which is shorter than Position plus Length are ignored.


Regular Expression

If enabled, the sorting item is extracted from the file name using the regular expression. If the file name does not end with a digit, this is the correct option.
 


Info
titleExample - Sorting using regular expression

\d+ locates the first digit sequence in a file name.

Sort the following files in an alphabetical or numerical order:

Code Block
languagetext
themeEclipse
 FILEA_1354.log
 FILEB_23.log
 FILEC_1254.log,

Use \d+ in the regular expression. Depending on the selected Sort Direction, the files are sorted in the following order:

Code Block
languagetext
themeEclipse
FILEC_1254.log
FILEA_1354.log
FILEB_23.log



Sort Type

Type of sorting. Could be either Alphanumeric or Numeric .

Ignore Case

If enabled, the sorting is not case sensitive.

Sort Direction

Indicates if the sort order will be Ascending or Descending .


Note
titleSFTP Sorting Limitations

Currently, there are several limitations when using the sorting functionality for the SFTP agents and the Include Subfolders option is selected: 

1. Sorting works only when the following options are selected: the Modification Time and and Value patternoptions are selected  when the Start Position and Length values are set to “0” with the Sort Type set to “Alphanumeric”“Alphanumeric"

2. Regular Expression sorting is not supported at the moment.

3. Value Patterns with values other than “0” are not supported at the moment. 


...