Q&A

  • 14 Jul

    Q&A 44: How-To Backup your Limagito File Mover Settings manually

    Backup your Limagito File Mover Settings. We tried to make this as simple as possible because we understand when a system crashes you need to be up and running asap. That’s why we store all our settings default within the following single folder: ‘C:\ProgramData\LimagitoX’.  The main settings file is the SQLite file called ‘LimagitoX.sqlite’.

    Besides that when using the File Mover as Service you need to remember the ‘Logon As’ account which you used. Don’t forget to keep a copy of the installer. We don’t need any .net or Java version.

    To be on the safe side:
    – Create a backup of your settings regularly (manually or automatic)
    – Remember the ‘Logon As’ account of the File Mover Service
    – Keep a backup of the ‘Limagito File Mover’ installer you used

    1.To create a backup of your settings open the ‘Tools’ menu and select ‘Options’.

    Limagito File Mover Backup Settings

    2.Click ‘Backup Settings Database Now’.

    Limagito File Mover Backup Settings

    3. Check your freshly created backup. Open the ‘Tools’ menu and select ‘Settings Directory’.

    Limagito File Mover Backup Settings

    4. Now you are in the subfolder ‘Bak’ of our default ‘Settings’ folder. There should be a subfolder with the current date as folder name. In our case this is ‘20210714180640’, we use ‘YYYYMMDDHHNNSS’ as format.

    Limagito File Mover Backup Settings

    5. The subfolder contains all the settings files you need in case your system would crash. Place a copy of this folder on a different (storage) system.

    FYI, be sure to create a backup of any ‘non default’ files you are using together with our file mover (private key files, public key files, ..).

    >> Now your backup is ready <<

    Limagito File Mover Backup Settings

    6. In case of a system crash you’ll first need to run the installer on the new system. The installer will create our default Settings folder: ‘C:\ProgramData\LimagitoX’. Copy & paste all files from a previous backup folder into our default settings folder so it looks like the following screenshot again. You need to do this before you start any File Mover Application or Service.

    Next, use the LimagitoXC.exe (Config Tool) to install the File Mover Service. Before you start the Service, first change the default ‘Logon As’ user of the File Mover Service to the one you were using before.

    Limagito File Mover Backup Settings

     

    #FileTransfer

    If you need any info about howto ‘Backup your Limagito File Mover Settings’, please let us know.

    Best regards,

    Limagito Team

  • 07 May

    Q&A 43: Read first line of a file and move to a specific folder

    Q: Read first line of a file and move to a specific folder. I have some files that sit on a server and I would like to move them off to archive. Each file has a code in the first line that tells me where the file came from. The files are regular text (.txt) files. How can I set up Limagito to move the file based on that code? If the code contains B01, move to a folder named Branch1. If the code contains B02, move to a folder named Branch2. The code will usually have more letters surrounding the B01 and B02, so I need the logic to pick up on B01 and B02 being in the code.
    A: Yes this is possible. All you need a simple Pascal Script. We’ve added some screenshots to get you started.

    As a start we added a new Moving Rule with WIN as Source. In the windows source folder we added some txt files. We’ll read the first line and check if certain codes exists (B01, B02, ..). Depending on the code found we’ll use a different subfolder of the Destination folder. If this subfolder doesn’t exist then we’ll create it.

    1.Please open the Pascal Script option:

    LimagitoX File Mover Pascal Script

    2. Enable and add the following ‘On Destination’ Pascal Script:

    var
      tmpLine: String;
      tmpList: TStringList;
    Begin
      psExitCode:= 0;
      psVSA := 'Unknown'
      // ... add your code here
      tmpList := TStringList.Create;
      Try
        try
          tmpList.LoadFromFile(psFilePath + psFileName);
          // Check First Line
          If tmpList.Count <> 0 Then
          Begin
            tmpLine := UpperCase(tmpList.Strings[0]);
            psLogWrite(1, '', 'First Line: ' + tmpLine);
            // check
            If Pos('B01', tmpLine) <> 0 Then psVSA := 'Alabama';
            If Pos('B02', tmpLine) <> 0 Then psVSA := 'Alaska';
            If Pos('B03', tmpLine) <> 0 Then psVSA := 'Arizona';
            If Pos('B04', tmpLine) <> 0 Then psVSA := 'Arkansas';
            If Pos('B05', tmpLine) <> 0 Then psVSA := 'California';
            If Pos('B06', tmpLine) <> 0 Then psVSA := 'Colorado';
            If Pos('B07', tmpLine) <> 0 Then psVSA := 'Connecticut';
            If Pos('B08', tmpLine) <> 0 Then psVSA := 'Delaware';
            If Pos('B09', tmpLine) <> 0 Then psVSA := 'Florida';
            If Pos('B10', tmpLine) <> 0 Then psVSA := 'Georgia';
            // Set ExitCode
            psLogWrite(1, '', 'Subfolder which will be used ' + psVSA);
            psExitCode := 1;
          End
          Else
            psLogWrite(1, '', 'Error no lines in ' + psFilePath + psFileName);
        Except
          psLogWrite(1, '', 'Error when loading ' + psFilePath + psFileName);
        End;
      Finally
        tmpList.Free;
      End;
    End.

    Limagito File Mover Pascal Script On Destination

    3. Destination Setup, Create Subdir, option:  %VSA

    XFM Limagito File Mover Destination SubDir option

    4. RunTime Log Result

    Limagito File Mover RunTime Log

    5. Destination SubFolder Structure, if subfolder doesn’t exist then it will be create by our File Mover:

    #FileTransfer

    If you need any help with this ‘Read first line of a file’ request, please let us know.

    Happy Easter,

    Limagito Team

  • 04 Apr

    Q&A 42: Remove quotation marks around the data in a csv file

    Q: Remove quotation marks around the data in a csv file. An Excel file is saved that has quotation marks around the data in the file. Which can be removed by opening Excel and re-saving as the CSV, but this is a manual step at this time. Would we be able to setup a Limagito rule to be able to do something similar for us?
    A: Yes this is possible using our XLS as Destination option. XLS as Destination also handles CSV files. Just be sure that the source files have .csv as extention so we know we need to handle them differently.

    Some screenshots to get you started:

    1.  Since we only want csv files, be sure the set the ‘Filename Include’ filter to *.csv in the ‘File Filter Setup’.

    Limagito File Mover filename inlcude filter

    2. We added XLS as Destination, XLS as Destination also handles CSV files. Just be sure that the source files have .csv as extention.

    Limagito File Mover XLS/CSV as Destination

    3. XLS.CSV as Destination setup. The Output File Format will be ‘Text, Delimiter separated values – with CRLF as End Of Line’.

    Limagito File Mover CSV Remove Quotation Marks

    Also ‘Text, Delimiter separated values – with LF as End Of Line’ which was added in version v2021.4.4.0

    This way you also can convert:

    • CSV with CRLF as Source to CSV with LF as end Of Line Destination
    • CSV with LF as Source to CSV with CRLF as end Of Line Destination

    Limagito File Mover CSV Remove Quotation Marks

    To remove the quotation marks you need to enable ‘Import full csv file as text’ option (Common Tab).

    Limagito File Mover import full csv file as text

    #FileTransfer

    If you need any help with this ‘Remove quotation marks’ request, please let us know.

    Happy Easter,

    Limagito Team

1 2 3 4 16