File Mover Blog

  • 19 Nov

    How to rename a file to include day of the week

    How to rename a file to include day of the week

    Q: I found this in your blog but my filename pattern is different and I don’t know enough of the Pascal language to edit it.

    Here is an example of what I would like to rename.

    Original Filename: 2023-10-24_section_A2.pdf
    (2023-10-24 = October 24, 2023)
    Rename To:  Tues_2023-10-24_section_A2.pdf

    Any help you can provide would be greatly appreciated.

    A: Please have a look at the following example, I guess we need to fine-tune it. Let us know what you think.

    • We used a Windows folder as source:

    limagito file mover windows folder as source

    • Next, open our Pascal Script option:

    limagito file mover paascal script option

    • Enable and add the following ‘On Destination’ Pascal Script:

    You can download the script: here

    limagito file mover include day of the week pascal script

    • We used a Windows Folder as Destination:

    limagito file mover windows folder as destination

    •  Enable ‘Rename Files during Copy/Move’

    limagito file mover file renaming option

    • Renaming Setup:

    RegEx:   (.*)
    Replacement:   %VSA

    limagito file mover file renaming setup

    • RunTime Log Result:

    limagito file mover runtime log result

    #managedfiletransfer #filetransfer #filemanagement

    If you need any help with this ‘include day of the week’ request, please let us know.

    Best Regards,

    Limagito Team

  • 19 Nov

    How to move files based on data from a csv file

    How to move files based on data from a csv file

    Q: I have the Limagoto X software installed, and I would like to know if it’s possible to move files, based on some information from a csv file? I have an csv file with some order numbers, and the folders I want to move, are label with these order numbers.

    A line in the csv file would look like this:

    The file structure looks like this:

    limagito file mover folder structure example

    So I would have to extract “D” first letter of “Donald Duck” -> then look in folder “Donald Duck”\ordre and search for 9999999 and move that folder to a new location with the same folder structure.

    A: We asked and received a dummy csv file, data content lookes like:

    Art;Ordrenr.;Arkiveret;Arkivdato;Jobnavn;Kundenavn;Statuskode;Ordretype;S‘lger;Ordrestyrer
    Ordre;9876543;SAND;17-11-2023;Arkiveringstest;Limagito Complete;AABEN_ARKIV;ARK;TEAM-E;MHOE

    So in this example:

    • We would strip the first char of the ‘Kundenavn’ field:  L
    • Next it would be the full name of the same ‘Kundenavn’ field:  Limagito Complete
    • Add fixed text:  Ordre
    • And finally the value of data field ‘Ordre’:  9876543

    Result as Directory filter: *\L\Limagito Complete\Ordre\9876543\*

    • As source we used a Windows folder, root folder to start from is ‘Jobs’ :

    limagito file mover windows folder as source

    • Next we’ll need to add a ‘Pascal Script’ to strip data from the csv file and use it as directory filter:

    limagito file mover pascal script option

    • Enable and add the following ‘On Rule Begin’ Pascal Script:

    You can download the script: here

    Do not forget to adjust the ctDataPath const (must end with a \ ). In this path we’ll search for .csv data file(s) with a date structure in its filename like ‘YYYY-MM-DD’. This can, of course, be adjusted.

    limagito fil emover move files based on data from a csv file

    • Directory filter setup:

    limagito file mover directory filter setup

    The %VSA (= Var String A) configured by the previous script will be used as ‘Directory Name Include Filter’:

    limagito file mover directory filter

    This ‘Allow parameters in Directory Name Filter’ option should be enabled by default:

    limagito file mover directory filter

    • As Destination we used a Windows folder:

    limagito file mover windows folder as destination

    • RunTime log result:

    limagito file mover runtime log result

    #csv #managedfiletransfer #filetransfer #filemanagement

    If you need any help with this ‘move files based on data from a csv file’ request, please let us know.

    Best Regards,

    Limagito Team

  • 13 Nov

    How to move files and folders automatically at certain times

    How to move files and folders automatically at certain times

    Q:

    DE: Ich versuche es herauszufinden wie ich die Daten und Ordner zu bestimmte Zeit automatisch verschieben lasse.

    Bsp. Täglich um 11:00 Uhr. Hab es versucht doch leider kriege ich es nicht hin. Können Sie mir da Helfen.

    EN: I am trying to figure out how to move the files and folders automatically at certain times.

    For example, daily at 11:00 a.m. I have tried but unfortunately I can’t get it to work. Can you help me?

    A:

    This is possible using our Scheduler option. The ‘Schedule’ setup determines when a Rule (= Task) is automatically triggered. I’ve marked the ‘Schedule’ button in the following screenshot. We have a couple of ways to trigger (= start) a Rule.

    In the first example we used a timer. In this ‘How To’ we are going to use the ‘Scheduler’ option instead so I’ve disabled the ‘Timer’ option.

    limagito file mover scheduler setup

    Switch to ‘Scheduler’ tab and enable ‘Use Scheduler’. Next click <Add>:

    limagito file mover automatically at certain times

    Please have a look at the following schedule setup.

    • Give the newly added schedule a ‘valid’ name, this will help you later to understand the goal of this schedule.
    • Do not change ‘Begin Schedule’ if you don’t need it. Default is the DateTime when the schedule was added.
    • Do not change ‘End Schedule’ if you do not need it. Default is ‘Never’.
    • You can test your setup by using the <RUN> button. This will only show some information about when the Rule would be triggered when using the current setup. It helps you to check your setup. Click <Stop> to exit the test.
    • Click <Save> when the schedule setup is ready.

    limagito file mover automatically at certain times

    New schedule was added, click <Save> and please do not forget to enable the Rule afterwards. Icon should turn blue when it is enabled. A disabled Rule (grey) will not receive any trigger.

    limagito file mover scheduler option

    Important, when using a Single trigger like once a day, it is very important that the ‘Stabilized File Check’ is disabled. This option needs at least two scans because it will compare the size of the  files between 2 scans.

    limagito file mover stabilized file check

    #managedfiletransfer #filetransfer #filemanagement

    If you need any help with this ‘automatically at certain times’ option, please let us know.

    Best Regards,

    Limagito Team

1 18 19 20 21 22 23 24 145
SEARCH