How-to Archives - File transfer tool from Limagito

16 May
How to pick files from user’s Desktop/Export folder
Q: I am trying to create a rule where we need to pick files from user’s Desktop/Export folder, and the computer has several different users. The path goes like this \\<hostname>\C$\Users\<userid>\Desktop\Export\. I want the <userid> as a wild card where Limagito can monitor all the Desktop\Export path under all the users. I would really appreciate any suggestions on how to handle this. Thanks!
A: This is possible using our scripting option.
Start with the following Windows as Source option:
Set %VSA as Directory, %VSA = Variable String A
%VSA will be set by our Pascal Script option
Open our Pascal Script option:
Enable and add the following ‘On Rule Begin’ script:
You can download the script here
Do not forget to adjust the ‘ctUsersDir’ Const
This script will list all users and check if they have an ‘Export’ folder on their Desktop
You can add any file or directory filter if needed, that is up to you.
Select the Function and if you would choose ‘Copy’ then do not forget to enable our File Memory option otherwise you would copy the same files over and over again.
Destination Setup:
First Destination must be ‘Pascal Script’ (PScript).
Second Destination, we used a Windows folder but you can use other too.
First Destination: Pascal Script
You can download the script here
The script will strip the UserID from the FileDir and put it into %VSB (= Var String B)
Second Destination, Windows Folder:
Set the ‘Create Subdir’ to: %VSB\%SFS
%VSB will contain the UserID
If you need any help about this ‘pick files user’s Desktop’ request, please let us know.
Best Regards,
Limagito Team
#managedfiletransfer #filetransfer #filemanagement #limagito
By Limagito-Team How-to Pascal Script desktop, pick files

06 Apr

How to use day of the week folders based on the filename

Using day of the week folders

Q: I would like to sort my files based on the filename. The first 8 char contain the date that has to be used. The format is YYYYMMDD (Year = 4 char, Month = 2 char and Day 2 = char).

A: This is possible using our Pascal Script option. We’ve attached some screenshots to get you started.

We used a Windows folder as Source:

limagito file mover windows folder as source

File Filter Setup:

limagito file mover filename include filter

Open our Pascal Script option:

limagito file mover pascal script option

Enable and add the following ‘On Destination’ script:
- The script will strip the date part from the filename and will check the day of the week
  - Corresponding day of the week will go into the %VSA (Var String A) parameter which will be used in the Destination setup

Var
  tmpStr: String;
  tmpDate: TDateTime;
  tmpDays: array[1..7] of string;
Const
  ctDateFormat = 'YYYYMMDD';
  ctDateFormatLen = 8;
  ctDateSeparator = #0;
Begin
  tmpDays[1] := 'Monday';
  tmpDays[2] := 'Tuesday';
  tmpDays[3] := 'Wednesday';
  tmpDays[4] := 'Thursday';
  tmpDays[5] := 'Friday';
  tmpDays[6] := 'Saturday';
  tmpDays[7] := 'Sunday';
  // Default Result = Skip File
  psExitCode:= 0;
  psVSA := '';
  // ... add your code here
  tmpStr := Copy(psFileName, 1, ctDateFormatLen);
  If StrToIntDef(tmpStr, -1) <> -1 Then
  Begin
    Try
      tmpDate := psStrToDate(tmpStr, ctDateFormat, ctDateSeparator);
      psVSA := tmpDays[DayOfTheWeek(tmpDate)];
      // Successful Result
      psExitCode := 1;
      // Debug
      psLogWrite(1, '', psFileName + ' will go into subfolder: ' + psVSA);
    Except
      psLogWrite(1, '', psFileName + ' conversion exception of date part, file will be skipped');    
    End;
  End
  Else
  Begin
    psLogWrite(1, '', psFileName + ' does not start with a valid date, file will be skipped');
  End;
End.

limagito file mover day of the week folders

Destination Setup:

limagito file mover windows folder as destination

Important, adjust the default ‘Create Subdir option’, add %VSA (%VSA contains the day of the week):

limagito file mover day of the week folders

RunTime Log Result:

limagito file mover runtime log

If you need any help about this ‘day of the week folders’ option, please let us know.

Best Regards,

Limagito Team

#managedfiletransfer #filetransfer #filemanagement #limagito

By Limagito-Team How-to Pascal Script day, days of the week

01 Apr
How to use Limagito to do SQL Server Express backup
Q: Not sure if you can help or suggest with SQL Server Express Backup. We are looking to have Limagito to do SQL Express backup with more frequently. We have SQL Server Express and looking into option if Limagito has agent to directly Backup the database. Or what is your suggestion if we want to use Limagito?
A: We use it here with a script on SQL Express. Our tool triggers this script using our schedular.
Script attached.: link
Download and rename backupsqlexpress.txt > backupsqlexpress.bat
You’ll need to set up the following parameters:
REM Database Configuration
SET SERVER=.\SQLEXPRESS
SET DATABASE=YourDatabase
SET USERNAME=YourUserName
SET PASSWORD=YourPasswordREM Paths and Files
SET BACKUP_PATH=C:\Test\In_Script\Backup
SET LOG_PATH=C:\Test\In_Script\Log
– During our test the script was put under C:\Test\In_Script\BackupSQLExpress.bat
– The backup itself are placed under C:\Test\In_Script\Backup
– Logging of the Database backup was put under C:\Test\In_Script\Log
Add CMD as Source
Setup Schedule
We used every day at 5AM:
Function, not that it really matters because in this case we are using our CMD option as Source
Optional:
> You can add Rule Events “On Succes” or “On Error” to get notified about the daily backup
> You could add a simple “PScript” Destination like:
If you need any help about this ‘add a no file edited trigger’, please let us know.
Best Regards,
Limagito Team
#sql #managedfiletransfer #filetransfer #filemanagement
By Limagito-Team Database How-to

1 2 3 4 … 11 →

Contact Us Now

How-to

How to pick files from user’s Desktop/Export folder

How to use day of the week folders based on the filename

How to use Limagito to do SQL Server Express backup

SEARCH

CATEGORIES

ARCHIVES

TAGS

DISCOVER OUR SITE