April 2021 - Page 2 of 2 - File transfer tool from Limagito

16 Apr
Microsoft Defender Antivirus Command-Line tool before moving a file
Q: I would like to use an Antivirus Command-Line tool before moving a file to its Destination. Can you recommend an antivirus scanner that your software can call and scan the file before transmitting?
A: Since Microsoft Defender Antivirus is installed on latest OS versions we decided to use the command-line version ( mpcmdrun.exe ) of this AV.
We are using a 64bit Windows 10 and installed the 64bit version of our Limagito File Mover. In this case the 64bit version of our File Mover is a must because the AV Command-Line tool is also 64bit. It will not work otherwise.
In the following example the Source is a Windows folder (WIN). Our goal is to transmit some pdf files to an AWSS3 Destination. Before sending the files we want to scan them using the command-line version of Microsoft Defender Antivirus.
Open the ‘Function’ setup, important here is that ‘Exit Cyclus on Error’ is selected.
Now we are going to add our Destinations. The first Destination must be CMD (Command), the second Destination is where the source file will be moved to if it isn’t infected by a virus.
CMD (Command) Setup as First Destination:
CMD /C ” “%ProgramFiles%\Windows Defender\MpCmdRun.exe” -Scan -ScanType 3 -File “%SFP%SFN” “
When the AV scan is successful the ExitCode will be 0. All other values will be treaded as an error and will result in the source file not being moved to the second destination due to the ‘Exit Cyclus on Error’ selection in the Function setup.
The second destination is where the source file will be moved to if it isn’t infected by a virus. You can choose this yourself. In our case it is AWSS3.
In case the AV returns an error (CMD ExitCode <> 0) then the file will not be moved to its second destination. Now you can add an ‘On Error’ Rule event to warn you.
RunTime Log result:
#FileTransfer
If you need any help with this ‘Antivirus Command-Line tool’ request, please let us know.
Best Regards,
Limagito Team
By Limagito-Team Command Antivirus;Command-Line, defender
04 Apr
Exclude some subfolders and the subfolders of the excluded subfolder
Q: Exclude subfolders and the subfolders of the excluded subfolder. I’m connecting to a FTP site, looking through the folders for any files older than 28 days but I want to exclude some sub-folders and the sub-folders of the excluded folder.
My current ‘Directory Filter’ setup doesn’t seem to work:
My current ‘Dir Name’ Exclude filter:
I also changed the Directory Filter Setup – Advanced – Exclude Complete Invalid SubDirs hoping it would skip the sub folders of the GRAPHICS PURGE folder.
Limagito Team: “Reason, SubDir Search Mode (WIN) is for WIN as source only”
But in the log file we see the ‘GRAPHICS PURGE’ folder and its subfolder BUL are not being excluded.

Limagito Team:
It is possible to achieve this but you’ll need to add some extra ‘Dir Name Exclude’ Filters, leave the ones you already had.
GRAPHICS PURGE
*/GRAPHICS PURGE/*
Ads
*/Ads/*
PDF
*/PDF/*
#FileTransfer
If you need any help with this ‘Exclude some subfolders’ request, please let us know.
Best Regards,
Limagito Team
By Limagito-Team Filters exclude, subfolders
04 Apr
Q&A 42: Remove quotation marks around the data in a csv file
Q: Remove quotation marks around the data in a csv file. An Excel file is saved that has quotation marks around the data in the file. Which can be removed by opening Excel and re-saving as the CSV, but this is a manual step at this time. Would we be able to setup a Limagito rule to be able to do something similar for us?
A: Yes this is possible using our XLS as Destination option. XLS as Destination also handles CSV files. Just be sure that the source files have .csv as extention so we know we need to handle them differently.
Some screenshots to get you started:
1. Since we only want csv files, be sure the set the ‘Filename Include’ filter to *.csv in the ‘File Filter Setup’.
2. We added XLS as Destination, XLS as Destination also handles CSV files. Just be sure that the source files have .csv as extention.
3. XLS.CSV as Destination setup. The Output File Format will be ‘Text, Delimiter separated values – with CRLF as End Of Line’.
Also ‘Text, Delimiter separated values – with LF as End Of Line’ which was added in version v2021.4.4.0
This way you also can convert:
CSV with CRLF as Source to CSV with LF as end Of Line Destination
CSV with LF as Source to CSV with CRLF as end Of Line Destination
To remove the quotation marks you need to enable ‘Import full csv file as text’ option (Common Tab).
#FileTransfer
If you need any help with this ‘Remove quotation marks’ request, please let us know.
Happy Easter,
Limagito Team
By Limagito-Team Q&A XLS/CSV crlf, csv, linefeed, marks, quotation