File Mover Blog

  • 07 Jul

    Sharepoint problem with filenames in Thai language

    Q: Sharepoint problem with filenames in Thai language not transfer host to destination. How to resolve?
    A: In version 2023.7.7.0 we added a new “Accept Charset” option under the “Common” Tab. Could you please set this to: utf-8

    limagito file mover sharepoint thai language

    #sharepoint #mft #filetransfer

    If you need any info about this “Thai language” issue, please let us know.

    Best regards,

    Limagito Team

     

  • 29 Jun

    How to increment the date in a filename by plus one day

    Q: Is it possible to rename a file containing a date string when copying it to increment the date in the filename by plus one day?

    where yyyymmddxx_I.p1.pdf the yyyymmdd will increase by +1

    Examples

    • Input: 2022010501_I.p1.pdf
      • Output: 2022010601_I.p1.pdf
    • Input: 2023123101_I.p1.pdf
      • Output: 2024010101_I.p1.pdf

    A: Yes this is possible. Please have a look at the following screenshots.

    • We used a Windows folder as Source (can be any other type of Source too):

    limagito file mover windows folder as source

    • Open our Pascal Script option:

    limagito file mover pascal script option

    • Enable and Add the following ‘On Destination’ Pascal Script:
    Var
     tmpFilename, tmpDateStr: String;
     tmpDate: TDateTime;
    Const
      ctDateFormatOld = 'YYYYMMDD'; ctDateSepOld = #0;
      ctDateFormatNew = 'YYYYMMDD';
    Begin
    (*
    Example:
    Input: 2022010501_I.p1.pdf
    Output: 2022010601_I.p1.pdf
    *)
      psExitCode:= 0;
      // ... add your code here
      tmpFilename := psFilename;
      If length(tmpFilename) >= 8 Then
      Begin
        Try
          tmpDateStr := Copy(tmpFilename, 1, Length(ctDateFormatOld));
          tmpDate := psStrToDate(tmpDateStr, ctDateFormatOld, ctDateSepOld);
          tmpDate := psIncDay(tmpDate, 1);
          psVSA := FormatDateTime(ctDateFormatNew, tmpDate);
          psExitCode:= 1;
        Except
          psLogWrite(1, '', 'Strip Date from File exception on ' + psFilePath + psFilename);
        End;
      End
      Else
      Begin
        psLogWrite(1, '', 'Strip Date length of File error on ' + psFilePath + psFilename);
      End;
    End.
    

    limagito file mover pascal script setup

    • Open our Destination setup

    limagito file mover destination setup

    • We used a Windows folder as Destination:

    limagito file mover windows folder as destination

    • Enable ‘Rename Files during Copy/Move’ and click the ‘Rename Filter Setup’ button:

    limagito file mover file rename option

    • Add the following ‘File Rename’ setup:
      • RegEx:  .{8}(.*)
      • Replacement:  %VSA\1

    limagito file mover file rename setup

    • RunTime Log result:

     

    limagito file mover runtime log result

    #mft #Filetransfer #rename

    If you need any info about this “increment the date in a filename” request, please let us know.

    Best regards,

    Limagito Team

  • 27 Jun

    Sending an email using Office 365 SMTP and OAuth2 authentication

    Q: Sending an email using Office 365 SMTP and OAuth2 authentication

    “AZURE setup”

    Azure App registrations

    • Register the app with Redirect URI = “http://localhost:3017”.

    Azure Register an application

    • Goto “API permissions” to add permissions. For this SMTP and OAuth2 authorization flow, we’ll add the following “Delegated permissions”:
      • offline_access
      • openid
      • SMTP.Send
      • IMAP.AccessAsUser.All is there because of a previous test (not needed for SMTP)

    limagito file mover azure add permissions

    • To add a Delegated permission, click ‘+ Add a permission’ and select ‘Microsoft Graph’

    limagito file mover azure add deligated permission

     

    • Select ‘Delegated permissions’

    limagito file mover azure add deligated permission

    • Search for the different permissions, select and click ‘Add Permissions’.

    limagito file mover azure add a deligated permission

    4) Go to “Certificates & secrets” and add a new client secret.

    • Important, the ‘Value’ field is the Client Secret which we need later during the setup in Limagito File Mover. This Value is only fully visible just after creation!
    • Do not use the Secret ID (common mistake).

    Azure Certificates & secrets

    5) In “App registrations”, go to “Endpoints” (located to the right of the “+ New registration” link. Note your endpoints for “OAuth 2.0 authorization endpoint (v2)” and “OAuth 2.0 token endpoint (v2).

    Azure Endpoints

    Azure endpoints

    “Microsoft 365 admin center setup”

    • Important, go to your Microsoft 365 admin center (this is NOT Azure).
      • Go to your Active users.
      • Click on a user to find the “Manage email apps” link under the Mail Tab. See Microsoft 365 Manage Email Apps.

    microsoft 365 admin center

    • Be sure ‘Authenticated SMTP’ is enabled

    limagito file mover microsoft admin center

    • When not enabled you’ll receive the following error message after trying to send an email using Limagito File Mover:

    Microsoft 365 admin center

    “Using a shared mailbox?”

    In case you want to send emails using a shared mailbox:

    • Open Microsoft 365 admin center setup
    • Select ‘Teams & “groups”
    • Click “+ Add a shared mailbox”

    Microsoft365 admin center shared mailbox

    • Add a shared mailbox

    Microsoft365 admin center shared mailbox

    • Click “Add members to your shared mailbox”

    Microsoft365 admin center shared mailbox

    • Search for members and add. The account you used previously during the ‘App registration’ in Azure must be added as member.

    Microsoft365 admin center shared mailbox

    • If the shared mailbox member is not correct, you’ll receive the following error:

    Microsoft365 admin center shared mailbox

    “Limagito File Mover setup”

    • We’ll be using the Office 365 SMTP to send emails from our ‘Rule Events’ option.

    limagito file mover rule events option

    • We enabled the ‘On Success ‘ event and enabled ‘Enable Mail’:

    limagito file mover rule events

    • Office 365 SMTP Server setup:

    office365 smtp setup

    • Adjust the Security setup:

    office365 smtp setup

    • Office 365 Auth2 setup:

    office 365 oauth2 setup

    1) Fill in the correct Authorization and Token Url from previous “Azure setup”

    2) Enter Application Client ID and Client Secret Value from previous “Azure setup”

    Azure App Client ID

    Azure Secret Value

    3) Adjust your scope to: openid profile offline_access https://outlook.office365.com/SMTP.Send

      • Provide a SPACE separated list of scopes.
      •  Important: The offline_access scope is needed to get a refresh token.

    4) Set Redirect URI to: http://localhost:3017/

    5) Set Redirect Port to 3017

      • This should be the port in the localhost callback URL for your app.
      • The callback URL would look like “http://localhost:3017/”, if the port number is 3017.
      • The redirect must go to http://localhost
        • It must be localhost and it cannot be “https”.

    Next, click on the <GET> button.

    Should ‘Windows Defender’ popup, please <Allow access>.

    Limagito File Mover IMAP4 Oauth2

    Your browser will open and ask you for ‘Confirmation’.

    Limagito File Mover IMAP4 OAuth2

    Follow the routine in your browser and accept the authorization request.

    Limagito File Mover IMAP4 OAuth2 Access is granted

    Now you can close the browser. The ‘Refresh’ and ‘Access’ Token in the OAuth2 Setup should contain values. Click <Save>.

    • Office 365 email setup

    office365 smtp email setup

    • Try your setup using the test button

    limagito file mover send email test button

    • Email result

    limagito file mover received email from office365

    Some extra information: ‘Explaining OAuth2 Authentication’.

    The OAuth2 Get Token button does a couple of things:

    1. It starts the OAuth2 Authentication process.
    2. Returns a URL that should be displayed in a browser.
    3. Starts a background thread to receive the redirect callback from the browser.

    The flow of control is like this:

    1. The browser (popped up and displayed by our file mover) automatically navigates to the URL provided by Start Authentication.
    2. The user interactively authorizes the access. In doing so, the response sent back to the browser is a redirect to http://localhost:<someport>/
    3. The browser receives the response, and redirects to the http://localhost:<someport>/
    4. The background thread (= temporary HTTP server using <someport>) is the thing that is listening at and receives the response, and then your OAuth2 is completed.

    The redirect must go to http://localhost:<someport>/. It must be localhost, and it cannot be “https”. If you defined your application’s redirect URL to a web address such as “https://yourdomain.com/something…”, then the background thread is just sitting there waiting for the callback, which never happens (because it went to your web server).

    #office365 #mft #Filetransfer #smtp

    If you need any info about this “Office 365 SMTP”, please let us know.

    Best regards,

    Limagito Team

1 31 32 33 34 35 36 37 145
SEARCH