October 2024 - File transfer tool from Limagito

12 Oct
Excel as destination losing some rows of data when converting from csv
Excel as destination losing some rows of data when converting from csv
Q: We are running LimagitoX File Mover v2024.1.20.0 and noticed an issue with the Excel destination. It appears to be losing some rows of data starting after line 45. You can replicate this issue by creating a simple rule that uses the attached test_file.txt file as the source and set the destination as Excel with the options in the images below. Note that the text input file has 101 rows, and the Excel output file only has 57. We are still seeing this issue with version 2024.8.26.0. Didn’t want it to fall off your radar.
A: We added the following Pascal Script which will convert your source Ansi csv file to Unicode.
Open our Pascal Script option:
Enable and Add the following ‘On Destination’ Pascal Script:
Begin psExitCode:= 1; // ... add your code here psChangeTxtEncoding(psFilePath + psFileName, psFilePath + psFileName, 2); End.
This will adjust the source txt file so if you don’t want this, add an extra Rule where you use a copy of the original file.
Feedback Customer: That fixed it. Thank you!
If you need any help with this ‘send an email when a file is successfully transferred’ request, please let us know.
Best Regards,
Limagito Team
#xls #managedfiletransfer #filetransfer #filemanagement
By Limagito-Team XLS/CSV excel, losing rows, xls
12 Oct
How to send an email when a file is successfully transferred
How to send an email when a file is successfully transferred
Q: Just to confirm… for an email to be sent when a file is successfully transferred I tick the On Success button ? I remember the tick box for 1 email per file or 1 email per session.
A: I’ve added some screenshots to get you started:
Open the Rule Events option:
Enable ‘On Success’ Event
Enable ‘Enable Mail’ with ‘On Success’ Event selected
Setup Email
Setup SMTP Server if not already done
I remember the tick box for 1 email per file or 1 email per session
If you want a single email after the scan, and not for each file, then please enable ‘Trigger mail event after scan’.
If you need any help with this ‘send an email when a file is successfully transferred’ request, please let us know.
Best Regards,
Limagito Team
#smtp #managedfiletransfer #filetransfer #filemanagement
By Limagito-Team Events email, successfully transferred
12 Oct
SFTP Fingerprint option added to Limagito file mover
Q: I have a question related to SFTP fingerprints. When I create a new rule and add new Source -> SFTP, where can I configure the fingerprints of the Source host’s fingerprint? I would like to be sure that the server is valid.
A: We allow the fingerprint of the sftp server you added as source automatically. At this moment there is no option to add fingerprints of the host manually.
Q: Thanks for the very quick answer. Hopefully it will be possible on the next version. There is a possibility for MiTM attack.
A: In version v2024.10.12.0 we added the Fingerprint option for SFTP as Source and Destination.
The goal of the fingerprint is to verify the authenticity and integrity of the SFTP server you’re connecting to. This is a short, unique representation (a hash) of the server’s public key. The purpose of this fingerprint is to help you confirm that you’re connecting to the correct server and not a malicious or imposter server. This is optional and by default we allow any fingerprint.
E.g.
The default Hash Algorithm is MD5
68:ff:d1:4e:6c:ff:d7:b0:d6:58:73:85:07:bc:2e:d5
Please add one if the following prefixes to adjust the default Hash Algorithm:
SHA256:
SHA384:
SHA512:
SHA1:
SHA3-224:
SHA3-256:
SHA3-384:
SHA3-512:
In case you receive an error message regarding the Fingerprint Compare, please increase the RunTime Log Level to ‘Debug’:
RunTime Log example:
If the the fingerprint in your SFTP setup is not correct, the following error message will appear
Increasing the log level of the RunTime log will show you the Fingerprint the SFTP server is sending
You can compare this to the one in your setup, in the example below we used the SHA256 hash algorithm
If you need any help with this request, please let us know.
Best Regards,
Limagito Team
#sftp #managedfiletransfer #filetransfer #filemanagement
By Limagito-Team SFTP fingerprint, SFTP