content of text

  • 23 May

    Get content of text file and use this as body for email

    Q: If I use Filemover to move or copy a txt file, is it possible to get the contents of that file, and then maybe include it in a Rule Event e-mail? I would like it as the e-mail body please.

    A: Yes this is possible. We’ll use some Pascal Script to read the content of the text file into a variable (%VSA). This variable will be used in the email setup of the SMTP destination.

    In our example we’ll scan for text files in a local Windows folder.

    Limagito File Mover get content of text file

    The ‘Include File Name’ filter is set to *.txt because we only want to pick up text files.

    Limagito File Mover Filename Include Filter

    Important, set the Function > Destination Option to ‘Exit Cyclus on Error’. The reason is that we are going to use two destinations. The first destination which is a Pascal Script will read the content of the text file in to the %VSA variable. If this doesn’t succeed then we should not go to the second ‘SMTP’ destination. We only want to sent the email (SMTP) if the read content of the source text file is successful.

    Limagito File Mover Function Setup

    As previously described, we are going to use two destinations. Important, the first one must be the ‘Pascal Script’ destination.

    Limagito File Mover Destination Setup

    Var
      tmpFile: String;
      tmpList: TStringList;
    Begin
      psExitCode:= 0;
      // ... add your code here
      tmpFile := psFilePath + psFileName;
      tmpList := TStringList.Create;
      Try
        Try
          tmpList.LoadFromFile(tmpFile);
          psVSA := tmpList.Text;
          psExitCode := 1;    
        Except
          psLogWrite(1, '', 'Error loading ' + tmpFile); 
        End;  
      Finally
        tmpList.Free;
      End;  
    End.

    Limagito File Mover get content of text file

    The second destination is SMTP. Some screenshots of the setup we used. We added the %VSA varaible in the Body of the email.

    Limagito File Mover get content of text file

    Limagito File Mover SMTP as Destination

    Limagito File Mover SMTP as Destination

    RunTime log result:

    Limagito File Mover RunTime Log

    Received email with the content of the text file in the body of the email:

    Limagito File Mover text content as body of email

     

    #Filetransfer #Filemanagement

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

    Best regards,

    Limagito Team

SEARCH