Limagito File Mover Software Blog and Filemover News

12 Jul
Q&A 20: I’d love the option to go the other way, csv to xls
Q: It seems XLS as destination is meant to convert Xls as source file. I’d love the option to go the other way, csv to xls. Oh well, feature request.
A: You are correct the original idea was to convert XLS files but on your request we added this feature request in version v2020.7.12.0
We added some screenhosts to give you an idea about the setup. The Source is a Windows folder:
We added a file filter to only include *.txt and *.cvs files:
As Destination we added our ‘Add XLS’ option:
The Csv file that we are going to convert has a comma as delimiter. Our goal is to convert the Csv source file to a Xls file. We enabled ‘Change Extension’ and added .xls as ‘Extension’. File Format was set to ‘Xls, Excel 97-2000-XP-2003’.
Result:
If you need any help , please let us know.
Regards,
Limagito Team
By Limagito-Team Q&A XLS/CSV csv, xls
07 Jul
Q&A 19: Backup 2 Files but Only Copy 1 to Destination
Q: Backup 2 Files but Only Copy 1 to Destination.
I need to set up a job that
moves 2 files of different extensions off of a source
Backup both files
Only send 1 file to the destination.
The 2 files from the source will be like ‘Filename.rec’ and ‘Filename.snd’. I want both backed up, but only want ‘Filename.snd’ to be sent to the destination. Is that possible?
A: Yes that is possible using some Pascal Script.
First you need to add a filename include filter to only filter the files you want (*.snd and *.rec files):
Add two destinations. Really important:
First destination (ID1) must be your Backup destination
Second destination (ID2) must the output destination.
Add the following ‘On Destinations‘ Pascal Script:
Begin psExitCode:= 1; // ... add your code here If SameText(psDestinationID, 'ID2') then If Not SameText(ExtractFileExt(psFilename), '.snd') then psExitCode := -1; End.
If you need any help , please let us know.
Regards,
Limagito Team
By Limagito-Team Q&A pascal script
27 Jun
Second Vendor – Public Key Authentication optimization
Second Vendor – Public Key Authentication optimization in Version v2020.6.27.0
As mentioned in a previous blog post we’ve added a second SFTP vendor in LimagitoX File Mover
Vendor 2 is also able to logon using Public Key Authentication. To achieve this, the SFTP Client (our File Mover in this case) needs to add your Private Key (and Private Key Password).
Quite some types of private key files can be used. It is important to use the correct file extension.
We are also able to use private keys within certificate file types like:
.cer, .crt, .p7b, or .pem
.p12 or .pfx (PKCS #12)
Note: If the PFX contains multiple certificates, the 1st certificate in the PFX is loaded.
A private key file with .ppk as extention will be threaded as a PuTTy key.
Also the following private key file types are supported:
KCS1, PKCS8, PEM, JWK, PVK, etc.
If you need any help , please let us know.
Best Regards,
Limagito Team
By Limagito-Team SFTP Authentication, Public Key, PuTTy, SFTP