Pascal Script

  • 19 Mar

    Move a file and send email with filename and line count

    Q: Move a file and send email with filename and line count.

    Can you help me with the following question.

    I want to move a file and in an email state the file name (always a text file .csv, .txt) and a line count
    Test.txt – 12 lines

    Can this be done?

    A: Yes this is possible. We have created a Pascal Script for you to achieve this.

    1. It is important that you’ll only handle txt and csv files (text based files). We added a File Name Include File Filter, just to be sure:

    Limagito File Mover Filename Filter

    2. Open our ‘Pascal Script’ option:

    Limagito File Mover Pascal Script option

    Add and enable the following ‘On Destination’ Pascal Script. This script will load the txt/csv file and will put the line count information into our %VSA parameter which can be use within our notification email.

    Var
      tmpCount: Integer;
      tmpList: TStringList;
    Begin
      psExitCode:= 0;
      // ... add your code here
      tmpList := TStringList.Create;
      Try
        Try
          // Load Source File
          tmpList.LoadFromFile(psFilePath + psFileName);
          // Count Lines
          tmpCount := tmpList.Count;
          // Info to be used in email
          psVSA := psFileName + ' - ' + IntToStr(tmpCount) + ' lines';
          psLogWrite(1, '', 'Information: ' + psVSA);    
          // Set Result OK
          psExitCode := 1;
        Except
          psLogWrite(1, '', 'Error loading: ' + psFilePath + psFileName);
        End;
      Finally
        tmpList.Free;
      End;  
    End.

    Limagito File Mover Pascal Script option

    3. Now you can use the %VSA as parameter within the email setup:

    Limagito File Mover Email Notification Setup

    Limagito File Mover Email setup

    4. Email Result:

    Limagito File Mover Email result

     

    #Filetransfer

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

    Best regards,

    Limagito Team

    By Limagito-Team Email Pascal Script
  • 10 Feb

    Send different on success or failure notifications based on file type

    Q: Is it possible in the same moving rule to have it send different on success or failure notifications based on file type. For example I only want it to send a notification if it is a pdf file extension. Other files in the job would still copy but only notify on the pdfs. I am working on a group wide project and it would help out a lot. The PDF file extension was just an example and would be other file formats.

    A: We added a new option ‘Use Pascal Script as event Precondition’ in Version v2022.2.9.0

    – Open Rule Events Setup

    Limagito File Mover Pascal Script Setup

    – Select the Event you want to setup (in our example this is the ‘On Success’ event) > Options Tab > Enable ‘Use Pascal Script as event Precondition’

    Limagito File Mover Pascal Script Use Pascal Script As Precondition

    – Switch to ‘Pascal Script’ Tab and Enable Pascal Script.
    – Add the following script to include only .pdf files for the ‘On Success’ event. This is just a simple example but can be extended to meet all your needs.

    Begin
      // ... add your code here
      If SameText(ExtractFileExt(psFileName), '.pdf') Then
        psExitCode := 1
      Else
        psExitCode := 0;
    End.

    Limagito File Mover Rule Events Pascal Script

    #Filetransfer

    If you need any info about this ‘notifications based on file type’ option, please let us know.

    Best regards,

    Limagito Team

  • 06 Feb

    Maximum number of files in Destination folder

    Q: Maximum number of files in Destination folder. I have a short question. Very nice if You have an answer 🙂

    One Source Windows folder: “IN”.
    One Destination Windows folder: “OUT”
    The number of files in the folder “OUT” should never exceed 3 files.

    (The files will be processed and deleted from the “OUT” folder by other software. When the number of remaining files is 0, 1 or 2, Limagito should send one more file).

    Is there an solution/function for this in Limagito File Mover?

    A: Yes this is possible using a small Pascal Script.

    This script will only work with WIN as Destination. Enable and add ‘On Rule Begin’ Pascal Script. Don’t forget to adjust the ‘ctFilter, ctOutputPath and ctSubDirs’ Const.

    Limagito File Mover Pascal Script option

    Var
      tmpCount: Integer;
    Const
      ctFilter = '*.pdf';
      ctOutputPath = 'C:\Test\Out\Sub1\';
      ctSubDirs = True; // True or False
    Begin
      psExitCode := 1;
      // ... add your code here
      tmpCount := psCountFiles(ctOutputPath, ctFilter, ctSubDirs);
      // Check
      If tmpCount >= 3 Then
      Begin
        psExitCode := 0;
        psLogWrite(1, '', 'QTY Files >= 3 (Count: ' + IntToStr(tmpCount) + ')');
      End;  
    End.

    Limagito File Mover Maximum Files in Destination

    Feedback customer:

    Fantastic! I´ve did some simple tests and it seems to work exactly as we wanted.

    #Filetransfer

    If you need any info about this ‘Maximum number of files’ request, please let us know.

    Best regards,

    Limagito Team

    By Limagito-Team Pascal Script WIN , ,
1 13 14 15 16 17 18 19 26
SEARCH