Filters

  • 18 Feb

    How to copy files in a specific order to the correct location

    How to copy files in a specific order to the correct location

    Q:  Here is the challenge:

    1. Copy job files  (3 total)  in a specific order to the correct location.
    2. There are 3 file formats:
      • XML
      • USF
      • JPG
    3.    The XML must be copied first,  followed by the JPG and finally the USF.

    Is this something you can help with?

    A: Yes this would be possible with our tool. In version v2024.2.18.0 we added an option to achieve this.

    Our idea is to use 3 Rules (tasks):

    • Rule 1: Will copy the the files from the source into temporary subfolders with the name of the file without its extension.
    • Rule 2: Will check if all three files are available and copy them in a specific order to the destination.
    • Rule 3: Will do the cleanup of the temporary folders we used.

    limagito file mover rule listing

     

    Rule 1:

    • We used a Windows folder as source:

    limagito file mover windows folder as source

    • “Filename Include Filter” is to only include xml, usf and jpg files:

    limagito file mover filename filter setup

    • We enabled our file memory option so we’ll only handle the same source files once:

    limagito file mover file memory option

    • Function is set to “Copy” so the original files stay at their source:

    limagito file mover function setup

    • As destination we used a Windows folder:
      • This temporary Destination folder will be used in the ‘On Destination’ Pascal Script of Rule 2.

    limagito file mover windows folder as destination

    • We’ll copy the source files into subfolders with the name of the source file without its extension. This way a job consisting out of three files will reside with one subfolder.

    limagito file mover destination subfolder setup

    Rule 2:

    • The new option to achieve this request is available under our “Schedule Setup”. Switch to “Advanced” tab:
      • Select ‘Root filepath & extension descending (Z to A) – Reset Exit Output on filepath change’
      • Enable ‘Exit Output to Destination On Error’

    limagito file mover copy files in a specific order

    • As source we used a Windows folder but important, the folder itself is a parameter, %VSA
      • Don’t mind if it is marked red, this is because the parameter is empty during the setup.
      • This %VSA parameter will be used in our ‘On Rule Begin’ Pascal Script option.

    limagito file mover windows folder as source

    • Please open our ‘Pascal Script’ option:

    limagito file mover pascal script option

    • Enable and add the following ‘On Rule Begin’ Pascal Script:
      • Please add the following script: link
      • Don’t forget to adjust the ctScanPath Const. This path must be the same as the Destination folder of Rule 1.
      • The script will scan the temporary root folder for subfolders, these subfolders are added to our psVSA var (= %VSA parameter).

    limagito file mover on rule begin pascal script

    • Enable and add the following ‘On Destination’ Pascal Script:
      • Please add the following script: link
      • This script will check if all three files (xml, usf and jpg) of a job are available.

    limagito file mover on destination pascal script

    • We enabled our file memory option int the second Rule also because we want to handle copy errors:

    limagito file mover file memory setup

    • Function is set to ‘Copy’:

    limagito filemover function setup

    • As Destination we also used a Windows folder:

    limagito file mover destination setup

    • RunTime Log result:
      • There is a missing file for Job ‘TestFile2’, so we’ll retry this one during the next scan.
      • All three files are available for Job ‘TestFile’, so all three files are copied in the specific order as requested.

    limagito file mover runtime log result

    • Source folder of Rule 1:

    limagito filemover examples

    • Destination folder of Rule 1:

    limagito filemover examples

    • Destination subfolder of Rule 1:

    limagito filemover examples

    • Destination subfolder of Rule 1:

    limagito filemover examples

    • Destination folder of Rule 2:

    limagito filemover examples

     

    Rule 3:

    • Will handle the cleanup of the temporary folder we used: C:\Test\EDemo\Tmp

    If you need any help with this ‘copy files in a specific order’ request, please let us know.

    Best Regards,

    Limagito Team

    #managedfiletransfer #filetransfer #filemanagement

    By Limagito-Team Filters
  • 16 Feb

    How to move to different destination based on day of week

    How to move to different destination based on day of week

    Q: I was wondering if you have an easy way to determine the day of week based on the filename and move to different locations:

    example:
    ” file_20040218_1″  that is Sunday so it go to folder1
    ” file_20040221_1″  that is Wednesday so it go to folder2
    ” file_20040222_1″  that is thursday so it go to folder2 also
    • In our example we used a Windows folder as Source:

    limagito file mover windows folder as source

    • Next, please open our “Pascal Script” option:

    limagito file mover pascal script option

    • Enable and add the following ‘On Destinations’ Pascal Script: link
      • This script will strip the filename into parts using “_” as delimiter. The second part (= Index [1] of our list),  which is the datepart, will be converted to a TDateTime var. Next we’ll use the DayOfTheWeek function to determine the day mentioned in the filename. The result of the function will be used to set the correct destination folder to our psVSA variable (= %VSA as parameter). We added ctFolder1 and ctFolder2 as Const.

    limagito fil emover pascal script option

    • In our example files from Monday to Friday will go to folder 1 and files from Saturday and Sunday will go to folder 2. This can be easily adjusted.

    limagito file mover pascal script option

    • As Destination we are using [WIN] and the Directory is set to:  %VSA\
      • This %VSA is set by the previous “On Destinations” Pascal Script

    limagito file mover destination setup

    • RunTime Log Result:

    limagito file mover runtime log result

    This is is just an example of what is possible. If you need any help with this ‘destination based on day of week’, please let us know.

    Best Regards,

    Limagito Team

    #managedfiletransfer #filetransfer #filemanagement

  • 27 Jan

    How to keep the most recent files regardless of the creation date?

    Q: Is it possible to create a rule of type: keep the 100 most recent files (regardless of the creation date)?

    A: In version v2024.1.27.0 we added this option for WIN as Source

    • Important, this new option is only available when using our [WIN] as Source (= Windows Folder or Network Share) option:

    limagito file mover windows folder as source

    • Next , select ‘Schedule’ button > ‘Advanced’ Tab:

    The new Skip option is available when the ‘Sort Order’ <> ‘OS Sort Order’

    • Skip none (default) = handle all sorted files found during scan of source folder(s)
    • Skip first x entries in file list = handle all except first x sorted files found during scan of source folder(s)
    • Skip last x entries in file list= handle all except last x sorted files found during scan of source folder(s)

    In the following setup we’ll scan the source folder(s) for files and afterwards we’ll sort them using the last write date (= modified date) from Old to New. When this is done we’ll skip the last 100 entries of this list. The result is that we’ll keep the 100 most recent files in the Source and will not handle (= copy/move/delete) them.

    limagito file mover keep the most recent files

    #managedfiletransfer #filetransfer #filemanagement

    If you need any help with this ‘keep the most recent files’ question, please let us know.

    Best Regards,

    Limagito Team

    By Limagito-Team Filters WIN ,
1 2 3 4 5 6 7 10
SEARCH