How to Exclude certain File Extensions in a File Transfer

[Legacy User]

A user wants to exclude files from a managed file transfer job (JOBF).

Currently, the job retrieves all files at a location with the wildcard character (*).

The user wants to be able to exclude a select set of files with a given extension. 

Example: 

Select all files (*) except for files ending in .xls (*.xls). 

Possible solution:
1.  A VARA file list object grabs a list of file names from a directory:
https://us.v-cdn.net/5019921/uploads/editor/de/ksj6adxj0fqg.jpg" width="835">

2. In the JOBF's process tab, create a script that gets the list of files from the VARA object and excludes files ending in .xls:

!Get files from file list VARA and exclude .xls :SET &HND#=PREP_PROCESS_VAR(VARA.FILELIST.REQ00138198) :PROCESS &HND# :  SET &FILE#=GET_PROCESS_LINE(&HND#,1) :  SET &CHECK#=STR_ENDS_WITH(&FILE#,".xls") :  IF &CHECK#="N" :  PRINT &FILE# :  ENDIF :ENDPROCESS

3. In the FileTransfer tab, refer to the &FILE# variable in the file path:

[Legacy User]

Hi Harriet_Kim_1764

The solution confuses me - this only prints the files that should be processed. To actually transfer them it would require the JOBF to run with every identified file (like by using ACTIVATE_UC_OBJECT).

Or is there a feature I'm not aware of?

Regards
Joel

[Legacy User]

Hi joel_wiesmann_automic,

The example puts a list of files from the source directory to a VARA object so that in the process tab, it will parse through that list and then exclude files that has .xls extensions.  
It was to provide an idea, a starting direction how to go about file exclusions.
Please feel free to add any input to improve it.  I'm open to all ideas.  :) 

[Anon Anon]

Hi Harriet_Kim_1764

Hmm I am afraid it was a bit misleading as you wrote: Solution:..

Was thinking "What the ****, I missed something" too..

cheers, Wolfgang

[Legacy User]

I see these possibilities:

#1 Multiple file transfers that transfer multiple endings (*.csv, *.txt, *.dat ...)

#2 Copy/move all files that must be transferred into separate directory ("outgoing" using a JOBS object), then transfer files (*) from that outgoing directory.

#3 V12+: create EXEC VARA that identifies files to send and transfer each file seperately using a FE workflow

#3.1: <V12: SCRI object processing filelistvara / PREP_PROCESS_FILENAME on source system, for files that must be considered use ACTIVATE_UC_OBJECT to dynamically transfer file-by-file

I personally would recommend#2as it's most transparent and uses least job executions to do it's job.

[Legacy User]

This is of course only one example on how to achieve something within the Automation Engine. I know there are several other approaches to do the same.

[Legacy User]

Yes, this post was just a possible solution and wanted to share it with others who may find it useful and point them to the right direction.  Thank you, joel_wiesmann_automic, for the additional input!