File mover software: move, copy, delete your files with our filemover | Blog | ORDER NOW

Contact Us Now

[contact-form-7 id="1125" title="Contact form 1"]

File Mover Blog

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:
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’ :
Next we’ll need to add a ‘Pascal Script’ to strip data from the csv file and use it as directory filter:
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.
Directory filter setup:
The %VSA (= Var String A) configured by the previous script will be used as ‘Directory Name Include Filter’:
This ‘Allow parameters in Directory Name Filter’ option should be enabled by default:
As Destination we used a Windows folder:
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
By Limagito-Team CSV Filters Pascal Script based on data, csv file
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.
Switch to ‘Scheduler’ tab and enable ‘Use Scheduler’. Next click <Add>:
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.
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.
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.
#managedfiletransfer #filetransfer #filemanagement
If you need any help with this ‘automatically at certain times’ option, please let us know.
Best Regards,
Limagito Team
By Limagito-Team 1. First-time user How-to certain times, first-time, schedule, schedules
12 Nov
How to verify that the checksum of destination files remain unchanged
How to verify that the checksum of destination files remain unchanged
Q: Is it possible to verify that a file’s encryption (SHA) in the source folder remains unchanged when it is transferred to the destination folder? Additionally, send an email if anything has changed.
We want to know when a change is made to the file after it has been moved to the destination folder. Additionally, get an email notification if there is a change. Another software should pull the file, we ask to check that no changes were made to the file until it transferred from the destination folder .
A: We needed two Rules to achieve this.
Rule 1: Will search for the Source files to move. When a file is found, it will add some information (filename, checksum, date) about this file to a separate data text file.
Rule 2: Will check the Destination folder of the first Rule. It will search for moved files and if a file is found (not yet picked up), it will compare its checksum with the information found in the data text file. If there is a difference, Rule 2 will return an error which will trigger an email event.
1. First Rule: ‘OPC Move’
Source must be a Windows folder or share:
Function Setup, we enabled ‘Exit Cyclus on Error’ as Destination option:
Destination Setup, we added two Destinations:
Pascal Script as Destination
WIN (Windows Folder or Share) as Destination
First Destination: Pascal Script:
Do not forget to adjust the ctChecksumFile const. This is the data file where we keep checksum information about the files we moved.
Important:
The path of this file should already exist, we’ll create the file.
This path should be a local path on the system where Limagito File Mover is running.
It should NOT be the same as the Source or Destination Path, use a folder that is only used for this purpose.
You can download the script: here
Second Destination, is the actual Destination folder of the Source files. This is where the other software will pull the files from. Destination must be a Windows folder or share.
2. Second Rule: ‘OPC Checksum Check’
The Source of this second Rule is the Destination of the First ‘Move’ Rule, this is important. This Second Rule will search for moved files and if a file is found (not yet picked up), it will compare its checksum with the information found in the data text file. If there is a difference, Rule 2 will return an error which will trigger an email event.
As Schedule we used a timer and set it to every 5 seconds:
Function Setup: set ‘Rule Function’ to copy. We will not copy any files but this needed by the internal process.
As Destination, we added a ‘Pascal Script’. This script will compare the checksum of the files found with the information in the data text file. If there is a difference it will return an error which will trigger an email event.
Destination: Pascal Script:
Do not forget to adjust the ctChecksumFile const. This is the data file where checksum information about the moved files by the first ‘Move’ Rule is kept.
Important: Use exactly the same file as you did in the Pascal Script of the first ‘Move’ Rule.
You can download the script: here
Open our Rule events option:
With ‘On Error’ selected > Options Tab > Enable ‘File Error event memory’. This way you only get one email per filename.
Email Setup:
RunTime Log Result:
#managedfiletransfer #filetransfer #filemanagement
If you need any help with this ‘checksum of destination files’ request, please let us know.
Best Regards,
Limagito Team
By Limagito-Team How-to WIN

← 1 … 9 10 11 12 13 14 15 … 136 →

SEARCH

ARCHIVES

Limagito filemover is an automated file mover solution handling everything from moving, deleting to copying files.

Please don’t hesitate to contact us if you have any questions about our product and services.

DISCOVER OUR SITE

How to import data into a SQL table where a primary key as guid is needed

April 21, 2024 no responses

Generate Certificate Signing Request (CSR)

April 21, 2024 no responses

How to export all rules to CSV with column name, source and destination

April 20, 2024 no responses

© 2007-2024 IT services & software development by CPsoft // Webdesign & webhosting by Siteplan