WIN

  • 10 Oct

    File Copy with Destination path and name lookup

    File Copy with Destination path and name lookup

    Q: I have a source folder that has a ton of subfolders and files with a guid type filename. I have the translation from the source path\filename to the new desired path\filename. Is there a way to do this in Limagito?  I can put the list in any file format (delimited file, json, xml) or from a sql lookup. Is it possible to only copy files that it finds?

    A: Should be possible using a csv file with a | (pipe) between source and destination files. I’ve added some screenshots to get you started.

    – We used a Windows folder as Source:

    limagito file mover windows folder as source– Open our Pascal Script option:
    limagito file mover pascal script option

    • Enable and Add the following Pascal Script:
      • Do not forget to adjust the ctCSVFile Const value
      • We’ll use this file to determine the Destination Path and File. Content example file we used (csv.txt):
        limagito file mover name lookup
      • Be sure to use a | (pipe) as separator
    Var
      tmpName, tmpValue: String;
      iList: Integer;
      tmpList: TStringList;
    Const
      ctCSVFile = 'C:\Test\Csv\csv.txt';
    Begin
      psExitCode:= 0;
      psVSA := '';
      psVSB := '';
      // ... add your code here
      tmpList := TStringList.Create;
      Try
        tmpList.NameValueSeparator := '|';
        Try
          tmpList.LoadFromFile(ctCSVFile);
          // Iterate
          For iList := 0 to (tmpList.Count-1) Do
          Begin
            tmpName := tmpList.Names[iList];
            tmpValue := tmpList.ValueFromIndex[iList];
            If SameText(psFilePath+psFileName, tmpName) Then
            Begin
              psVSA := ExtractFilePath(tmpValue); // FilePath
              psCreatePath(psVSA);
              psVSB := ExtractFileName(tmpValue); // FileName
              // Set Result
              psExitCode := 1;
              // Break
              Break;
            End;
          End;
        Except
          psLogWrite(1, '', 'Error loading CSV: ' + ctCSVFile);
        End;
      Finally
        tmpList.Free;
      End;
    End.

    limagito file mover pascal script setup– Destination Setup:
    limagito file mover destination setup

    • We used a Windows folder as Destination:
      • Please use %VSA as Directory
      • The parameter %VSA will contain data from the previous Pascal Script

    limagito file mover windows folder as destination

    • File Renaming Setup:

    limagito file mover destination file renaming setup

    • RegEx:  (.*)
    • Replacement:  %VSB
      • Parameter %VSB will contain data from the previous Pascal Script

    limagito file mover file renaming setup– RunTime Log Result:
    limagito file mover runtime log result
    If you need any help with this ‘name lookup’ question, please let us know.

    Best Regards,

    Limagito Team

    #managedfiletransfer #filetransfer #filemanagement

    By Limagito-Team Filters WIN
  • 10 Oct

    How to solve File mover issue with UNC path

    How to solve File mover issue with UNC path

    Q: We’re testing another copy of FileMover in a new environment, but we’re having issues moving files from a UNC path. We want to move files from the UNC path of another server to a local drive on the same server as the File Mover application (so a UNC path to a local path). Should this work, and if it doesn’t, can you recommend what setting to check? I have tested moving from a local drive to a local drive and that works, but not if the source is a UNC path.

    A: Yes this should work. I guess you are using the Filemover as service. If the log on as user of the limagito service is not able to acces the network drive as source then you need to add an extra mapping with a different account in our network drive option under the Tools menu.

    limagito filemover installed as a windows service

    Double click on the ‘LimagitoX’ entry and adjust the ‘Log on as’ account:

    limagito filemover service logon as user

    If you need another account to access certain shares on the network, please use our ‘Network Drive’ option:

    limagito filemover network drive option

    If you need any help with this ‘UNC Path Issue’ question, please let us know.

    Best Regards,

    Limagito Team

    #managedfiletransfer #filetransfer #filemanagement

    By Limagito-Team WIN
  • 08 Sep

    How to delete empty folder, but there are hidden DS_Store files

    How to delete empty, but there are hidden DS_Store files

    Q: I tried to setup the flow to delete folders if it’s empty, but in each folder there’s a hidden file  (.DS_Store). I guess that’s why it couldn’t delete any of the empty folders. Do you have any solution for this?

    limagito file mover directory filter setup

    A: Should be possible using our Pascal Script option. Important is that we should move files from those folders first, otherwise the script will not work.

    • Please open our Pascal Script option:

    limagito file mover pascal script option

    limagito file mover delete hidden DS_Store files

    If you need any help with this ‘hidden DS_Store files’ question, please let us know.

    Best Regards,

    Limagito Team

    #managedfiletransfer #filetransfer #filemanagement

    By Limagito-Team Filters WIN
1 2 3 4 10
SEARCH