• 04 Sep

    How to when files arrive, copy files from an other source directory

    How to when files arrive, copy files from an other source directory

    Q: I need some help on a Limagito rule I need to write :

    • Check files into a source directory.
    • When these files arrive, copy files from an other source directory with same filename but different extension.

    ie :

    Check files named 123456.pregen from c:\Test\Search\

    Then copy file c:\Test\In\123456.pdf to c:\dest\

    A: Please have a look at the following screenshots:

    • We are using a Windows folder as source. The goal is to copy files from here to a destination. Which files will depend on the script we are going to add.

    limagito file mover windows folder as source

    • File Filter Setup:
      • Add  %VSA  as include Filename Filter (%VSA = Variable String A)
      • The %VSA will contain the filenames we want to copy. Our Pascal script will add the filenames to this Var.

    limagito file mover file filter setup

    • Enable ‘Allow parameters in File Name filter’ (File Filter Setup – Advanced Tab):

    limagito file mover file filter advanced setup

    • Open our Pascal Script option

    limagito file mover pascal script option

    • Add and enable the following ‘On Rule Begin’ Pascal Script:
      • Do not forget to adjust the CtSearchPath (ctSearchFilter and ctSearchSubFolders) Const

     

    Var
      iList: Integer;
      tmpFilename: String;
      tmpList: TstringList;
    Const
      ctSearchPath = 'C:\Test\Search\'; // Must end with a \
      ctSearchFilter = '*.pregen';
      ctSearchSubFolders = False; // False or True
    Begin
      psExitCode:= 0;
      psVSA := '';
      // ... add your code here
      tmpList := psListFiles(ctSearchPath, ctSearchFilter, ctSearchSubFolders);
      Try
        For iList := 0 to (tmpList.Count-1) Do
        Begin
          tmpFilename := tmpList.Strings[iList];
          tmpFilename := ChangeFileExt(tmpFilename, '.pdf');
          psVSA := psVSA + tmpFilename + ';';    
        End;           
      Finally
        tmpList.Free;
      End;    
      // Debug
      psLogWrite(1, '', 'Filename filter as psVSA: ' + psVSA);
      // Set psExitCode
      If psVSA <> '' Then
        psExitCode := 1;
    End.

    limagito file mover copy files from an other source directory

    • We used a Windows folder as Destination:

    limagito file mover windows folder as destination

    • Function is set to Copy in our example but also Move is possible

    limagito file mover function setup

    • If function is set to Copy and you only want to copy the same files once, then please enable our File Memory option:

    limagito file mover file memory option

    • RunTime log result:

    limagito file mover runtime log

    I forgot on line. If I want to delete my pregen file after copy/move, where can I add it on code ?

    In this case some adjustments to the pascal script are needed:

    limagito file mover pascal script option

    limagito file mover pascal script option

    If you need any help with this question, please let us know.

    Best Regards,

    Limagito Team

    #managedfiletransfer #filetransfer #filemanagement

  • 03 Sep

    How to use the database log exclude filter

    How to use the database log exclude filter

    Q: I’m looking to exclude lines that contain SFTPCheckConnected in this Limagito report by using the Log Exclude Filter in the window below. If this is possible, can you provide an example of the syntax that can be used to accomplish this, please?

    limagito file mover database log filter options

    limagito file mover dabase log report

    A: Double click on the ‘Log Exclude Filter’ field and you are able to add different filter items. This filter setup form is available for include and exclude filter on the RunTime, File and Database log setup tab.

    limagito file mover log exclude filter

    If you need any help with this ‘log exclude filter’ question, please let us know.

    Best Regards,

    Limagito Team

    #managedfiletransfer #filetransfer #filemanagement

    By Limagito-Team Logging
  • 03 Sep

    Can’t open data connection for ftp transfer

    Can’t open data connection for ftp transfer

    Q: I’m using the attached FTP source that I have set to get files, but I’m getting an error when reading the directory. I’m able to access the folder using Cyberduck fine with the same settings. Below is the log showing the response I get.  I’m using v2024.2.24.0. Please let me know if you need anything else to troubleshoot.

    A: It looked like the system was not able to open a data connection to the FTP server (425 Can’t open data connection for transfer) and we asked the user to switch be to ‘Active’ mode. FTP is using two channels, a command and a data channel. So if you are able to connect, then you know at least the command channel is working. If you are not able to receive directory listings, then you know something is wrong with the data channel. The data channel can be used in active and passive mode (passive mode = default).

    Reply user: “That seemed to work. Thank you.”

    Connecting to ftp_useast.xxxxxxxx.com:22

    Connection successful

    Server System: 220-Xxxxx Secure FTP

    220 **Authorized Access Only**

    Request Path: /PAX_Test_Xpance

    Response Path: /PAX_Test_Xpance

    List Directory: /PAX_Test_Xpance/

    List Directory /PAX_Test_Xpance/ Error

    Disconnected from ftp_useast.xxxxxxxx.com:22

    8/20/2024 4:14:07 PM FTPSCheckConnected, CK Login Reply: 220-Xxxxxx Secure FTP
    220 **Authorized Access Only**
    8/20/2024 4:14:07 PM FTPSCheckConnected, CK Request Path after Login: /
    8/20/2024 4:14:07 PM FTPSCheckConnected, CK Change Path to /PAX_Test_Xpance
    8/20/2024 4:14:07 PM FTPSCheckConnected, CK Request Path after Change: /PAX_Test_Xpance/
    8/20/2024 4:14:17 PM FTPListDirectory, CK GetDirCount Error: ChilkatLog:
    GetDirCount:
    DllDate: Jan 27 2024
    ChilkatVersion: 9.5.0.97
    UnlockPrefix: CPSFBE
    UnlockStatus: 2
    Architecture: Little Endian; 64-bit
    Language: Delphi DLL
    VerboseLogging: 0
    listPattern: *
    fetchDirListing:
    pattern: *
    supportsMLSD: 1
    fetchDirListing2:
    setupDataConnection:
    active transfer mode
    setupActiveDataSocket:
    Created data listen socket
    Using ephemeral port range for Active data connection.
    dataPort: 51222
    portIpAddress: 192.168.xxx.xxx
    MyIPv4: 192,168,xxx,xxx,200,22
    sendCommand:
    sendingCommand: PORT 192,168,xxx,xxx,200,22
    –sendCommand
    readCommandResponse:
    replyLineQP: 200 Port command successful
    –readCommandResponse
    –setupActiveDataSocket
    –setupDataConnection
    sendCommand:
    sendingCommand: MLSD
    –sendCommand
    completeDataConnection:
    acceptDataConnection:
    controlChannelReply:
    Reading intermediate response..
    readCommandResponse:
    replyLineQP: 150 Opening data channel for directory listing of “/PAX_Test_Xpance”

                  –readCommandResponse
    –controlChannelReply
    controlChannelReply:
    Reading final response..
    readCommandResponse:
    replyLineQP: 425 Can’t open data connection for transfer of “/PAX_Test_Xpance”

                  –readCommandResponse
    Final response indicates error.
    –controlChannelReply
    –acceptDataConnection
    Failed to accept data connection.
    –completeDataConnection
    Failed to complete the data connection.
    –fetchDirListing2
    –fetchDirListing
    Failed to get and cache directory listing…
    N: -1
    Failed.
    –GetDirCount

    If you need any help with this ‘data connection for ftp transfer’ question, please let us know.

    Best Regards,

    Limagito Team

    #ftp #managedfiletransfer #filetransfer #filemanagement

     

    By Limagito-Team FTP ,
1 2 3 4
SEARCH