• 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.

    Limagito File Mover Windows folder as Source

    • Open the ‘Function’ setup, important here is that ‘Exit Cyclus on Error’ is selected.

    Limagito File Mover Function Setup

    • 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.

    Limagito File Mover Destination setup

    • 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.

    Limagito File Mover mpcmdrun.exe command-line tool

    • 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.

    Limagito File Mover Rule Events

    • RunTime Log result:

    Limagito File Mover RunTime Log

    #FileTransfer

    If you need any help with this ‘Antivirus Command-Line tool’ request, please let us know.

    Best Regards,

    Limagito Team

  • 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:

    Limagito File Mover Directory Filter Setup

    My current ‘Dir Name’ Exclude filter:

    Limagito File Mover Directory 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”

    Limagito File Mover Directory Filter setup

    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/*

    Limagito File Mover Directory name exclude filter setup

    #FileTransfer

    If you need any help with this ‘Exclude some subfolders’ request, please let us know.

    Best Regards,

    Limagito Team

    By Limagito-Team Filters ,
  • 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’.

    Limagito File Mover filename inlcude filter

    2. We added XLS as Destination, XLS as Destination also handles CSV files. Just be sure that the source files have .csv as extention.

    Limagito File Mover XLS/CSV as Destination

    3. XLS.CSV as Destination setup. The Output File Format will be ‘Text, Delimiter separated values – with CRLF as End Of Line’.

    Limagito File Mover CSV Remove Quotation Marks

    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

    Limagito File Mover CSV Remove Quotation Marks

    To remove the quotation marks you need to enable ‘Import full csv file as text’ option (Common Tab).

    Limagito File Mover import full csv file as text

    #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 , , , ,
1 2
SEARCH