Filters

  • 18 Jul

    How to move a folder tree and files when the subfolder matches my criteria

    Q: How to move a folder tree and files when the subfolder matches my criteria. I want to move a folder tree (with his files) from « home » only when the level 2 subfolder match “pour_ftv_editorial”.  The source is FTP and destination is Windows folder.

    Limagito  check the source folder « home »

    Limagito move in the destination folder « home_out »

    • SOURCE (FTP)

    limagito file mover move a folder tree

    • Destination (Windows Folder)

    limagito file mover move a folder tree

    A: This should be possible using the following “Directory filter”:

    • Enable “Include Subdirectories to allow us to scan the subfolders of your Source.
    • Enable “Exclude Basedirectory” because we don’t want to pickup files from the Root Source folder.

    limagito file mover subdirectory filter

    • As Include Directory name filter we will use: */pour_ftv_editorial/*

    limagito filemover directory filter

    limagito file mover directory filter

    Feedback user: “it works! Great”

    #mft #filetransfer #filemanagement

    If you need any info about this question, please let us know.

    Best regards,

    Limagito Team

    By Limagito-Team Filters
  • 28 May

    Create an empty file named done.txt as all the files have been moved

    Q: We are using your software for some simple file moving automation. We find it very reliable and we would like to convert our existing CMD and ps scripts to Limagito rules. We have a script which performs the following steps:

    • Copy a directory and its contents from an FTP source only if the directory name matches a certain pattern (LQJ_yyyymmdd) > OK
    • Transfer the contents of the directory to an FTP destination in the folder /Replica/yyyymmdd/LQJ > OK
    • Create an empty file named done.txt as soon as all the files have been moved to the destination (step 2) in the FTP folder /Replica/yyymmdd

    Could you give me a hint about how to perform the last step?

    A: This is possible using some Pascal Script we created for you.

    Please open the Pascal Script setup:

    limagito file mover pascal script

    • Enable and Add the following ‘On Rule Begin’ Pascal Script. The result of psVSB will be used as parameter (%VSB) in the directory filter setup.
    Begin
      psExitCode:= 1;
      // ... add your code here
      psVSA := FormatDateTime('YYYYMMDD', Now);
      psVSB := '*_' + psVSA + ';' + '*\*_' + psVSA + '\*';
      //
      psLogWrite(1, '', psVSB);
    End.

    limagito file mover on rule begin pascal script

    • Enable and add the following ‘On Rule End’ Pascal Script. This script will create the Done.txt file ‘On Rule End’ when all files were transferred successfully. Don’t forget to adjust the ctDonePath ( must end with a \ ).
    Var
      tmpList: TStringList;
      tmpFile: String;
    Const
      ctDonePath = 'C:\Test\Pressor\Replica\';
    Begin
      psExitCode:= 0;
      tmpFile := ctDonePath + psVSA + '\Done.txt';
      // ... add your code here
      If (psCurrentFilesSrcError = 0) And (psCurrentFilesDstError = 0) Then
      Begin
        tmpList := TStringList.Create;
        Try
          tmpList.Text := 'Dummy Content';
          Try
            psCreatePath(ctDonePath + psVSA);
            tmpList.SaveToFile(tmpFile);
            // Debug
            psLogWrite(1, '', 'Save To File ' + tmpFile + ' Successful');
            // set ExitCode Successful
            psExitCode := 1;
          Except
            psLogWrite(1, '', 'Save To File ' + tmpFile + ' Error');
          End;
        Finally
          tmpList.Free;
        End;
      End
      Else
        psLogWrite(1, '', tmpFile + ' will not be created due to source or desitnation error(s)');
    End.

    limagito file mover on rule end pascal script

    • Directory setup, be sure to enable ‘Include Subdirectories’ and ‘Exclude Basedirectory’:

    limagito file mover directory setup

    • Set Dir Name include filter to:  %VSB

    The value of parameter %VSB will be set in the ‘On Rule Begin’ Pascal Script.

    limagit file mover directory name filter

    • Set Dir Name exclude filter to exclude certain unwanted subfolders:

    limagito file mover directory exclude filter

    • Be sure to allow the use of parameters in the Directory Name filter:

    limagito file mover directory filter

    • Destination setup:

    Limagito file mover destination setup

    limagito file mover win as destination

    limagito file mover windows folder as destination

    #filetransfer #mft #filemanagement

    If you need any info  about this ‘Create an empty file named done’ request, please let us know.

    Best regards,

    Limagito Team

    By Limagito-Team Filters Pascal Script ,
  • 29 Jan

    Download only certain date specific files

    Q: Download only certain date specific files from FTP
    I have an ftp account that has a file for each day of the month in it. I need to download a file each day for that particular Monday – Sunday. This will go into a rename job so for example file 01162023 (for Monday, January 16, 2023) would be renamed to SLMON. File 01172023 would rename to SLTUE, 01182023 SLWED, and so on until 01222023 for SLSUN.

    So once more, I would need to set a download each night to pull a file with that dates name and have it rename. So tonight would download file 01212023 and rename it to SLSAT. Then Sunday would pull a single file for that date. Is that doable?

    A: Yes this is possible, so you would trigger it every evening and it would pick up the file for tomorrow and rename it. This will also work for other source types than FTP.

    1. Please open the File Filter Setup

    – Enable ‘Allow parameters in File Name filter’ in the Advanced Tab:

    Limagito File Mover File Filter setup

    – Set the Filename Include Filter to:
    %TCD:[IncDay+1]mmddyyyy:.pdf

    In my example I’m looking for .pdf files but it could also be like (every type of file):
    %TCD:[IncDay+1]mmddyyyy:.*

    Notice the [IncDay+1] so it looks for the next day.
    Limagito File Mover Date specific files

    2. Open the Destination setup
    Limagito File Mover WIN as Destination

    – Rename Tab > Enable Rename Files > Setup Renaming:
    Limagito File Mover Destination renaming options

    – Add the following renaming expression:

    RegEx:   (.*)\.(.*)
    Replacement:   SL%TCD:[IncDay+1]ddd:.\2

    Limagito File Mover Destination renaming setup

    – Customer: Great thanks. What would I do if I pulled it at say 1am for the same day?
    – Limagito: Remove the   [IncDay+1]   in the File Filter AND the Renaming setup

    #FileTransfer #FTP #SFTP

    If you need any info about this post, please let us know.

    Best regards,

    Limagito Team

    By Limagito-Team Filters FTP
1 4 5 6 7 8 9 10
SEARCH