File Mover Blog

  • 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

  • 15 Jan

    SQL output trailing delimiter at end of row

    Trailing delimiter at end of each row

    Q: We are using Limagito File Mover, SQL as source, database is MSSQL.

    SQL statement (Source)

    select

      person_last_name as last_name

      , person_first_name as first_name

    from
    my_table

    Common Options

    Limagito File Mover SQL Common options

    Issue

    The value for the delimiter is appended at the end of each row. Is there a way to prevent this from happening? The output file is being automatically imported into a system, and that system does not like that extra delimiter at the end of the file. To explain what I’m talking about, the output to the file is currently like this:

    last_name,first_name,

    Doe,John,

    Smith,Mary,

    What we would like to see is this:

    last_name,first_name

    Doe,John

    Smith,Mary

    Thank you for any assistance you can give.

    A: In version v2021.1.15.0 we added some extra options:

    • SQL Common options (default Enabled):
      • Trailing Line Break: Determines whether to add a line Break after the last line or not.
      • Trailing Line Delimiter: When enabled the value for the delimiter is appended at the end of each row

    Please disable ‘Trailing Line Delimiter’. This will remove the delimiter at the end of each row.

    Limagito File Mover SQL Common options

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

    Best regards,

    Limagito Team

    By Limagito SQL , ,
  • 09 Jan

    Handle multiple items like email addresses and source folders

    On request we added an option to handle multiple items like email addresses and source folders (version v2022.1.9.0).

    Double click on ‘To’, ‘Cc’ or ‘Bcc’ email addresses to open the new multiple items setup option:

    Limagito File Mover multiple email addresses

    Also available for the WIN as Source setup. Double click on the ‘select Directory’ edit field:

    Limagito File Mover multiple source folders

    If you need any info about the ‘handle multiple items’ option, please let us know.

    Best regards,

    Limagito Team

1 4 5 6 7 8 9 10 90