How to move files to different destinations based on the file extension

Q: Since we are dealing with Pharma equipment where we are pulling data off. We would like to be able to split the data into ‘readable’ (ie Txt, excel) and permanent (ie PDF, Image) and place the file types in different subdirectories on the target. At this time, my only solution would be to create two separate rules to accomplish this. Given that there are so many features hidden in your tool that I keep learning about, I was wondering if that was a feature that is in the Mover that I have not found.

A: Yes this is possible using our Script option.

• We used a Windows Folder as Source:

• We added the following Filename Include Filters. These are the file extensions we want to split to different destinations.

• In this example we added 4 destinations. Each Destination has a unique ID:
  • ID1
  • ID2
  • ID3
  • ID4

We’ll use this Destination ID in our script.

• Next, please open our Pascal Script option:

• Enable and add the following ‘On Destinations’ Pascal Script:

Var
  tmpFileExt: String;
Begin
  psExitCode:= -1;
  // ... add your code here
  tmpFileExt := ExtractFileExt(psFilename);
  // psLogWrite(1, '', 'Check File Extension ' + tmpFileExt + ' from ' + psFilename);
  // Check If Destination ID is ID1 AND do we have a .txt file?
  If (psDestinationID = 'ID1') Then 
    If SameText(tmpFileExt, '.txt') Then
      psExitCode := 1; 
  // Check If Destination ID is ID2 AND do we have .xls/.xlsx files?
  If (psDestinationID = 'ID2') Then
    If SameText(tmpFileExt, '.xls') OR SameText(tmpFileExt, '.xlsx') Then
      psExitCode := 1; 
  // Check If Destination ID is ID3 AND do we have a .pdf file?
  If (psDestinationID = 'ID3') Then 
    If SameText(tmpFileExt, '.pdf') Then
      psExitCode := 1;  
  // Check If Destination ID is ID4 AND do we have .png/.jpg/.bmp files?
  If (psDestinationID = 'ID4') Then
    If SameText(tmpFileExt, '.png') OR SameText(tmpFileExt, '.jpg') OR SameText(tmpFileExt, '.bmp') Then
      psExitCode := 1;       
End.

• RunTime Log Result:

This is is just an example of what is possible. If you need any help with this ‘different destinations based on the file extension’, please let us know.

Best Regards,

Limagito Team

#managedfiletransfer #filetransfer #filemanagement