Limagito File Mover Software Blog and Filemover News

29 Apr
Q&A List of Questions and Anwers of LimagitoX File Mover
Q&A Links:
Explain the difference between an orange, a blue and a grey button for each rule
Is it possible to rename a file that has a date in the filename to also include the day of the week?
Is there a way to retry to only the failed destination when using multiple destinations?
Is there audit trail on the rules?
I was wondering if it would be possible to monitor and send alert when file mover failed?
I want to use user accounts in LimagitoX File Mover
Can we test a rule before it actually runs in limagitox file mover?
Delete old files without deleting folders
Copy file into Azure storage container folder
Can we create a rule which will remove empty directories once a week, not every scan?
Can we remove info from the RunTime log
It would be nice if when we create a rule it is defaulted to “Disabled Timers”
Is it possible to retry a file delete if it fails
It looks like LimagitoX might not be sending emails
Can I exclude file and directory shortcut links
Can I rename files when moving to Windows Folder
Is it possible that move files and create a folder by partial files name
Is there a way to change the destination based on day of week
Backup 2 Files but Only Copy 1 to Destination
If you need help with these Q&A, please let us know.
Regards,
Limagito Team
By Limagito Q&A links, q&a
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 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 FTP & SFTP Information Authentication, Public Key, PuTTy, SFTP
25 Jun
SQLite ERROR: database disk image is malformed
2020-06-24 13:57:08.764 [WINGET] CheckQrySelect Exception: [FireDAC][Phys][SQLite] ERROR: database disk image is malformed
One of my moving rules is logging a SQLite error. Some files are processing, but the error was discovered because a select few files aren’t moving. I’m not sure that these failures are related to the error message. The files in question aren’t listed in the log. The rule seems to load OK, as does the file memory database. I’m not sure where else to look.
Q: Can you help me track down the database and resolve the error?
A: This is the first time we received feedback about this error message. It seems the File memory database file is damaged.
We googled a bit and decided to share this in a post.
1.- First we installed the latest (free) version of sqlitebrowser
2.- Check your settings directory. The File Memory file starts with LimagitoX.MemXY.sqlite where XY is the ID of the Rule.
In the example the Rule has ID120 so the File Memory Database file will be LimagitoX.Mem120.sqlite
3.- Copy the damaged File Memory database file first and open it with the installed SQLiteBrowser tool
4.- When opened select Tools > Integrity Check
5.- Click OK to start the Integrity Check
6.- We’re getting error messages so it seems the File Memory database file was damaged. Normally we should get an OK message only.
7.- Export the content of the damaged database to a temporary SQL File. You’ll be asked to name this SQL file (any name is ok).
8.- The File Memory database only contains one table, tblFileMemory
9.- Exporting ..
10.- Export completed
11.- Restart SQLite Browser Tool and select Import, Database from SQL File. Select the SQL file you exported in step 7.
12.- Now you’ll have to set the filename of this new database. It must be the same as the damaged database file. You’ll have to replace this file later.
13.- Import completed
14.- To be sure we did an integrity check on this new database file, result OK
15.- Finally you’ll have to replace the new File Memory database file with the damaged one. You’ll have to stop the LimagitoX Application or Service because the damaged File Memory database file will be locked as long as our File Mover Application or Service is running.
If you need any help with the ‘database disk image is malformed error’, please let us know.
Best Regards,
Limagito Team
By Limagito Error database, malformed