• 31 Jul

    Second API Vendor for ZIP and UNZIP operations

    Second API Vendor for ZIP and UNZIP operations was added in version v2022.7.31.0

    The reason we added this second (UN)ZIP source code provider is that on some occasions we had exception issues when trying to add multiple source files to a single destination zip file. It seems this second API Vendor (third party code provider) handles this better.

    Limagito File Mover ZIP and UNZIP operations

    If you need any help with this second API Vendor, please let us know.

    Best Regards,

    Limagito Team

    #filetransfer #zip

    By Limagito ZIP ,
  • 21 Jul

    Microsoft identity platform and OAuth 2.0 authorization code flow

    Microsoft Sharepoint identity platform and OAuth 2.0 authorization code flow

    In version v2022.5.21.0 we added a new way to authenticate to SharePoint. It is in experimental phase and we would like to receive feedback from our users.

    Please select ‘OAuth 2.0 Authoziation Code Flow’ as Auth Type within your SharePoint setup.

    OAuth 2.0 authorization code flow

    In the OAuth2 setup you’ll need to add:

    • Authorization Endpoint URL:  https://login.microsoftonline.com/%realm/oauth2/v2.0/authorize
    • Token Endpoint URL:  https://login.microsoftonline.com/%realm/oauth2/v2.0/token
    • Client ID
    • Client Secret
    • Scope, provide the Scope(s) for your Sharepoint, depends on how you did the authentication setup for the Client ID:
      • offline_access web.manage
        • offline_access is a must otherwise we’ll not receive the Refresh Token
      • offline_access Sites.Manage.All
      • offline_access AllSites.Manage
      • offline_access ???
    •  Redirect URI:  https://localhost/
    • Redirect Port: 3017

    Click the <Get> button. This should fill the Realm field and after confirmation in your browser it should fill the Refresh and Access Token.

    Note: If you are not allowed to receive the Realm then you can enter this manually. In our case we’ll use the SharePoint Tenant ID as Realm parameter: link.

    OAuth 2.0 authorization code flow

    If you need any help with this ‘authorization code flow’, please let us know.

    Best Regards,

    Limagito Team

  • 21 Jul

    I am looking for a way to incorporate date logic

    Q: I am looking for a way to incorporate date logic within our Limagito installation. I believe the easiest way to do this would be to use a Pascal Script, however I have not been able to find a syntax guide to assist me.

    The date logic would be used in two places in a single rule that is run on a schedule. The first is in the file filter. Rule executes, I need to look for files that meet the pattern: NV_mmddyyyy.pdf where mmddyyyy is the date for the upcoming Friday.

    • If it ran today (July 20, 2022), I would be looking for the filename that matched NV_07222022.pdf

    The second place is in the path to the destination directory. The path looks like: c:\Jobs\mmdd_NV_WK\HotFolders\ where mmdd is the date for the upcoming Friday.

    • If it ran today (July 20, 2022, the path would look like: c:\Jobs\0722_NV_WK\HotFolders\

    Can you help us create a Pascal Script or provide us with a resource that has a syntax guide?

    A: Could you please try the following:

    First enable and add the following ‘On Destination’ Pascal Script

    Limagito File Mover Pascal Script

    Var
      tmpDay: TDateTime;
     
    Function GetNextFriday: TDateTime;
    Var
      iDay: Integer;
      tmpDate: TDateTime;
    Begin
      Result := 0;
      tmpDate := Now;
      For iDay := 0 to 6 Do
      begin
        tmpDate := tmpDate + iDay;
        // Check if Friday (= 5)
        If DayOfTheWeek(tmpDate) = 5 Then
        Begin
          Result := tmpDate;
          Break;
        End;
      End;
    End; 
     
    Begin
      psExitCode:= 1;
      // ... add your code here
      tmpDay := GetNextFriday;
      If tmpDay <> 0 Then
      Begin
        psVSA := FormatDateTime('MMDDYYYY', tmpDay);
        psVSB := FormatDateTime('MMDD', tmpDay);
      End
      Else
        psExitCode:= 0;  
    End.

    Limagito File Mover Pascal Script

    Next we need to adjust the File Filter Setup. The ‘Include Filename Filter’ will use the %VSA var (%VSA = Var String A) that was set in the previous Pascal Script.

    Limagito File Mover File Filter

    Important, do not forget to enable ‘Allow parameters in File Name filter (File Filter > Advanced Tab)

    Limagito File Mover File Filter

    Next, open Destination Setup and double click on your Destination:

    Limagito File Mover Destinations

    lect File & Directory Tab and adjust ‘Create SubDir, opt.’ to  %VSB_NV_WK\HotFolders\%SFS
    Again we will use a Pascal Script var (%VSB) that was set by the ‘On Destination’ Pascal Script.

    Limagito File Mover Destination Setup

    RunTime Log Result:

    Limagito File Mover RunTime Log

    #Filetransfer #Filemanagement

    If you need any info about this ‘incorporate date logic’ question, please let us know.

    Best regards,

    Limagito Team

1 2