File mover software: move, copy, delete your files with our filemover | Blog | ORDER NOW

Contact Us Now

[contact-form-7 id="1125" title="Contact form 1"]

Home / 2023 / June

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):
Open our 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.
Open our Destination setup
We used a Windows folder as Destination:
Enable ‘Rename Files during Copy/Move’ and click the ‘Rename Filter Setup’ button:
Add the following ‘File Rename’ setup:
RegEx: .{8}(.*)
Replacement: %VSA\1
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
By Limagito-Team Pascal Script Rename increment date
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”
Login to Azure portal. In “App registrations” create a “+ New registration”.
Register the app with Redirect URI = “http://localhost:3017”.
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)
To add a Delegated permission, click ‘+ Add a permission’ and select ‘Microsoft Graph’

Select ‘Delegated permissions’
Search for the different permissions, select and click ‘Add Permissions’.
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).
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).
“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.
Be sure ‘Authenticated SMTP’ is enabled
When not enabled you’ll receive the following error message after trying to send an email using Limagito File Mover:
“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”
Add a shared mailbox
Click “Add members to your shared mailbox”
Search for members and add. The account you used previously during the ‘App registration’ in Azure must be added as member.
If the shared mailbox member is not correct, you’ll receive the following error:
“Limagito File Mover setup”
We’ll be using the Office 365 SMTP to send emails from our ‘Rule Events’ option.
We enabled the ‘On Success ‘ event and enabled ‘Enable Mail’:
Office 365 SMTP Server setup:
Adjust the Security setup:
Office 365 Auth2 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”
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>.
Your browser will open and ask you for ‘Confirmation’.
Follow the routine in your browser and accept the authorization request.
Now you can close the browser. The ‘Refresh’ and ‘Access’ Token in the OAuth2 Setup should contain values. Click <Save>.
Office 365 email setup
Try your setup using the test button
Email result
Some extra information: ‘Explaining OAuth2 Authentication’.
The OAuth2 Get Token button does a couple of things:
It starts the OAuth2 Authentication process.
Returns a URL that should be displayed in a browser.
Starts a background thread to receive the redirect callback from the browser.
The flow of control is like this:
The browser (popped up and displayed by our file mover) automatically navigates to the URL provided by Start Authentication.
The user interactively authorizes the access. In doing so, the response sent back to the browser is a redirect to http://localhost:<someport>/
The browser receives the response, and redirects to the http://localhost:<someport>/
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
By Limagito-Team 365 SMTP 365, OAuth2, Office 365 SMTP, shared mailbox, SMTP
25 Jun
How to transfer a single file even if multiple files match the file filter
Q: Is there a way to limit Limagito to only transfer a single file even if multiple files match the file filter? I am looking to rate limit our upload of specific files. Instead of uploading them all at once, I just want to upload one every 30 minutes.
A: This is possible. Please open the “Schedule” setup and set “Max. Files processed in One Scan” to 1. Use the “Timer” or “Scheduler” and set it to every 30 minutes.
#Filetransfer #mft
If you need any info about this request, please let us know.
Best regards,
Limagito Team
By Limagito-Team How-to transfer a single file

SEARCH

ARCHIVES

Limagito filemover is an automated file mover solution handling everything from moving, deleting to copying files.

Please don’t hesitate to contact us if you have any questions about our product and services.

DISCOVER OUR SITE

How to send just the logs from a most recent rule run

December 10, 2024 no responses

How to make Filemover available on a web page for users

December 10, 2024 no responses

How to email a list of deleted files

December 8, 2024 no responses

© 2007-2024 IT services & software development by CPsoft // Webdesign & webhosting by Siteplan