Q&A

  • 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 , , , ,
  • 21 Mar

    Q&A 41: Merge Multiple Input Files Into a Single Output File

    Q: Merge Multiple Input Files Into a Single Output File. We have a new requirement where we have multiple input files , but when this info is moved to the target server, then it should be combined into one single file – named for example… ‘ELEC_WHT_PRICESHEET.CSV’. Is there a way to combine all the input files into one output file?

    A: With WIN as Destination we have a File option: ‘Append if file exists’. The trick is to use the file rename option to rename the source files you want to append to the same destination filename.

    Limagito File Mover Merge Files

    Destination File Rename option:

    Limagito File Mover Merge Renaming

    If you need any help with this ‘Merge Multiple Input Files’ request, please let us know.

    Best Regards,

    Limagito Team

    By Limagito-Team Q&A WIN , ,
  • 09 Jan

    Q&A 40: Is it possible to create a file timestamp monitor job

    Q: Is it possible to create a file timestamp monitor job. I mean, is there a way to setup a job that states that if there has not been a file with a timestamp of less than say 2 hours to send an alarm?

    A: Yes this is possible. We added some screenshots to get you started.

    • Be sure the Function is set to ‘Copy Files’ (which is default).

    Limagito File Mover Function Setup

    • Please add the directory you want to monitor as WIN Source. In our example we’ll use ‘C:\Test\In\’.

    Limagito File Mover Source Selection

    • We are going to monitor .pdf files in this example so we added  *.pdf  as Filename Include Filter.

    Limagito File Mover Filename Filter Setup

    • Our goal is to check if there are files available younger than 2 hours:

    Limagito File Mover Filedate Filter Setup

    • As Destination we added a simple Pascal Script to give us some information:

    Limagito File Mover Destination Selection

    Begin
      psExitCode:= 1;
      // ... add your code here
      psLogWrite(1, '', 'File Found: ' + psFilePath + psFileName);
    End.

    Limagito File Mover Pascal Script

    • Next step is to setup the ‘On No File Found’ Rule Event:
      • Enable ‘On No File Found’ Rule Event
      • Enable Mail
      • Setup Mail Message
      • Setup Common SMTP (Server which will send the Mail Message)

    Limagito File Mover Rule Events

      • Mail Message Setup

    Limagito File Mover Email Setup

      • Setup Common SMTP (Server which will send the Mail Message). We are using the Google SMTP to send the Mail Message.

    Limagito File Mover SMTP Server Setup

    • We added a Pascal Script which will add information in the log when the event is triggered.
    Begin
      // ... add your code here
      psLogWrite(1, '', 'We did not find any file younger than 2 hours');
    End.

    Limagito File Mover Rule event Pascal Script

    • If you don’t want to send the email event ‘On No File Found’ with each scan then please enable ‘Error event Memory’ in the Options Tab. When this option is enable AND ‘No File Was Found’ then we’ll send the email only once. The ‘Error Event Memory’ will reset itself when a file was found again.

    • RunTime Log Result when no file younger than 2 hours was found:

    Limagito File Mover RunTime Log Result

    • Email Result when no file younger than 2 hours was found:

    Limagito File Mover Email Message

    If you need any help with this ‘file timestamp monitor’ request, please let us know.

    Best Regards,

    Limagito Team

    By Limagito-Team Q&A WIN ,
1 2 3 4 5 16
SEARCH