Q&A

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

    LimagitoX File Mover Windows Source Folder

    We added a file filter to only include *.txt and *.cvs files:

    LimagitoX File Mover File Filter

    As Destination we added our ‘Add XLS’ option:

    LimagitoX File Mover XLS as destination

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

    LimagitoX File Mover Csv To Xls optionResult:

    Limagito File Mover Csv to Xls log result

    If you need any help , please let us know.
    Regards,
    Limagito Team
    By Limagito 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

    1. moves 2 files of different extensions off of a source
    2. Backup both files
    3. 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):

    LimagitoX File Mover Include Filename Filter

    Add two destinations. Really important:

    1. First destination (ID1) must be your Backup destination
    2. Second destination (ID2) must the output destination.

    LimagitoX File Mover Destinations

    Add the following ‘On Destinations‘ Pascal Script:
    LimagitoX File Mover Pascal Script Menu Item
    Begin
      psExitCode:= 1;
      // ... add your code here
      If SameText(psDestinationID, 'ID2') then
        If Not SameText(ExtractFileExt(psFilename), '.snd') then
          psExitCode := -1;
    End.
    LimagitoX File Mover On Destinations Pascal Script
    If you need any help , please let us know.
    Regards,
    Limagito Team
    By Limagito Q&A
  • 25 Jun

    Q&A 18: Is there a way to change the destination based on day of week

    Q: Is there a way to change the destination based on day of week? I have a rule that moves a backup to destination daily. Would like to use same rule to move Mondays backup to a Weekly backup folder.

    A: Yes this is possible using the Destination ‘Create Subdirectory’ option. Please check the File & Directory tab.

    First Example:

    LimagitoX File Mover Day of Week example 1

    Second Example

    LimagitoX File Mover Day of Week example 2

    You can use combinations of parameters or combinations of fixed text and parameters.

     

    If you need any help , please let us know.

    Best Regards,

    Limagito Team

     

     

    By Limagito Q&A
1 2 3 4 5 9