CSV Archives - Page 2 of 3 - File transfer tool from Limagito

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
12 Nov
How to merge and add filenames to csv datafiles
How to merge and add filenames to csv datafiles
Q: I have a new daily job where I will receive 3 CSV files. I need to merge these together and also add a new field to the data that contains the original filename as I need to split them later on in the process and use the original filename to send back to the client. Also, I may not always get all 3 files so the rule needs to work for receiving 1,2, or all 3 files.
We will run the rule at 18:00 for example and process however many files have been uploaded, then run the rule every 1 hour after to pick up any files that the client has uploaded late. The ideal scenario would be for all 3 files to be uploaded by the client by the scan time, but they want us to be able to pick up any files they may upload late.
The data does not contain headers either. I’m sure I have asked this before but I can’t find the solution if I have, I have found similar and have tried to amend it to suit but failed miserably.
A: We asked and received the following example files:
BTW_Invites_20231023_1.csv
BTW_Reminders_20231023_1.csv
BTW_Results_20231023_1.csv
We used a Windows folder as Source:
We added the following ‘Include Filename’ Filter because we want to be sure to only process .csv files:
As Destination we add our ‘Pascal Script’ option:
Destination Pascal Script, do not forget to adjust the ctOutputPath const (Path must end with a \ ).
The script will add the filename of the source csv file to the end of each entry of the merged csv file. The Destination merged csv file is determined by stripping parts of the source filename. In our example it will be: ‘BTW_Merged_20231023_1.csv’.
This script is just an example and it can be adjusted so it fits your needs, just let us know.
You can download the script: here
RunTime Log Result:
#csv #filetransfer #filemanagement
If you need any help with this ‘merge and add filenames’ option, please let us know.
Best Regards,
Limagito Team
By Limagito-Team CSV Pascal Script add filenames, merge

26 May

Get a field value to rename a csv file

Q: Get a field value to rename a file. I received a file with a specific filename every week which goes through various processes, after I have finished I need to send the original data with some extra data columns generated by our process back to the client using the original filename. Unfortunately, I cannot keep hold of the filename throughout the process but I can have a column in the return file which contains the original filename. Is there a way I can use Filmover to have a look at a specific column of a data file get the contents of it and use it to rename the file to that value then deleted the column that I got the information from? Bit complex but I thought I’d ask before exploring other avenues. The column that contains the original filename to be used and then deleted is called IMPNAME.

A: Should be possible (we received an example file of the customer).

Please set filename filter to *.csv

limagito file mover filename filter

Add ‘Pascal Script’ as Destination:

limagito file mover pascal script as destination

Don’t forget to adjust the ctOutputPath Const (must end with a \ )

Var
  iEntry, iIndex, iList: Integer;
  tmpFilename, tmpInputFile, tmpOutputFile: String;
  tmpEntryList, tmpFileList: TStringList;
Const
  ctOutputPath = 'C:\Test\Out_Csv\';  // Must end with a \
  ctIMPNAME = 'IMPNAME';
Begin
  psExitCode := 0;
  iIndex := -1;
  tmpInputFile := psFilePath + psFilename;
  tmpOutputFile := '';
  // ... add your code here
  tmpEntryList := TStringList.Create;
  tmpEntryList.Delimiter := ',';
  tmpEntryList.StrictDelimiter := True;
  tmpEntryList.QuoteChar := '"';
  tmpFileList := TStringList.Create;
  Try
    Try
      tmpFileList.LoadFromFile(tmpInputFile);
      tmpEntryList.DelimitedText := tmpFileList.Strings[0];
      For iEntry := 0 to (tmpEntryList.Count - 1) Do
      Begin
        If SameText(ctIMPNAME, tmpEntryList.Strings[iEntry]) Then
        Begin
          iIndex := iEntry;
          psLogWrite(1, '', 'Found ' + ctIMPNAME + ' at Column with Index ' + IntToStr(iIndex));
          Break;
        End;
      End;
      // Did we find 'IMPNAME'
      If iIndex <> -1 Then
      Begin
        tmpFileList.Strings[0] := psStringReplace(tmpFileList.Strings[0], ',"' + ctIMPNAME + '"', '');
        For iList := 1 to (tmpFileList.Count - 1) Do
        Begin
          tmpEntryList.DelimitedText := tmpFileList.Strings[iList];
          If tmpEntryList.Count > iIndex Then
          Begin
            If tmpOutputFile = '' Then
            Begin
              tmpFilename := tmpEntryList.Strings[iIndex];
              If tmpFilename <> '' Then
                tmpOutputFile := ctOutputPath + tmpFilename + '.csv';
            End;  
            If tmpFilename <> '' Then
            Begin
              tmpFileList.Strings[iList] := psStringReplace(tmpFileList.Strings[iList], ',"' + tmpFileName + '"', '');           
              psLogWrite(1, '', 'Entry: ' + tmpOutputFile + ' : ' + tmpFileList.Strings[iList]);
            End;  
          End;
        End;
      End;
      // Save To File
      If tmpOutputFile <> '' Then
      Begin
        Try
          tmpFileList.saveToFile(tmpOutputFile);
          psExitCode := 1;
        Except
          psLogWrite(1, '', 'Error saving file: ' + tmpOutputFile);
        End;
      End;
    Except
      psLogWrite(1, '', 'Error loading file: ' + tmpInputFile);
    End;
  Finally
    tmpEntryList.Free;
    tmpFileList.Free;
  End;
End.

Get a field value

#filetransfer #mft #filemanagement #csv

If you need any info about this ‘get a field value to rename a file’, please let us know.

Best regards,

Limagito Team

By Limagito-Team CSV csv, field value

← 1 2 3 →

Contact Us Now

CSV

How to move files based on data from a csv file

How to merge and add filenames to csv datafiles

Get a field value to rename a csv file

SEARCH

CATEGORIES

ARCHIVES

TAGS

DISCOVER OUR SITE