Second API Vendor for ZIP and UNZIP operations was added in version v2022.7.31.0
The reason we added this second (UN)ZIP source code provider is that on some occasions we had exception issues when trying to add multiple source files to a single destination zip file. It seems this second API Vendor (third party code provider) handles this better.
If you need any help with this second API Vendor, please let us know.
Best Regards,
Limagito Team
#filetransfer #zip
Q: I am looking for a way to incorporate date logic within our Limagito installation. I believe the easiest way to do this would be to use a Pascal Script, however I have not been able to find a syntax guide to assist me.
The date logic would be used in two places in a single rule that is run on a schedule. The first is in the file filter. Rule executes, I need to look for files that meet the pattern: NV_mmddyyyy.pdf where mmddyyyy is the date for the upcoming Friday.
The second place is in the path to the destination directory. The path looks like: c:\Jobs\mmdd_NV_WK\HotFolders\ where mmdd is the date for the upcoming Friday.
Can you help us create a Pascal Script or provide us with a resource that has a syntax guide?
A: Could you please try the following:
Var
tmpDay: TDateTime;
Function GetNextFriday: TDateTime;
Var
iDay: Integer;
tmpDate: TDateTime;
Begin
Result := 0;
tmpDate := Now;
For iDay := 0 to 6 Do
begin
tmpDate := tmpDate + iDay;
// Check if Friday (= 5)
If DayOfTheWeek(tmpDate) = 5 Then
Begin
Result := tmpDate;
Break;
End;
End;
End;
Begin
psExitCode:= 1;
// ... add your code here
tmpDay := GetNextFriday;
If tmpDay <> 0 Then
Begin
psVSA := FormatDateTime('MMDDYYYY', tmpDay);
psVSB := FormatDateTime('MMDD', tmpDay);
End
Else
psExitCode:= 0;
End.
Next we need to adjust the File Filter Setup. The ‘Include Filename Filter’ will use the %VSA var (%VSA = Var String A) that was set in the previous Pascal Script.
Important, do not forget to enable ‘Allow parameters in File Name filter (File Filter > Advanced Tab)
Next, open Destination Setup and double click on your Destination:
RunTime Log Result:
#Filetransfer #Filemanagement
If you need any info about this ‘incorporate date logic’ question, please let us know.
Best regards,
Limagito Team
Q: Convert character set of text file. I think I need some help here. We connect to a SFTP-server and download 3 files. One of these are a UTF-8 file named Vyymmdd.Thhmmss (i.e. V220627.TT110759). We need to download all 3 files, and convert the UTF-8 file to ISO-8859-1. I have found this article: https://limagito.com/text-character-encoding-conversion/
And edited like this : psChangeTxtEncodingExt(psFilePath + psFileName, ctOutputpath + psFileName, 65001, 28591, True)
Runtime Log says the file was successfully converted. But if I open the file in Notepad++ and click the “Encoding” option on the menu, it highlights UTF-8.
A: In version v2022.7.17.0 we added some extra functions to help you convert the character set of text files:
Function psChangeTxtEncodingCk(Source, Destination: String; SrcCharset, DstCharset: String; WriteBOM: Boolean; ErrorAction: Integer): Boolean;
Do not use this function when Source and Destination file are the same, use psChangeTxtEncodingCkExt instead.
Function psChangeTxtEncodingCkExt(Source, Destination: String; SrcCharset, DstCharset: String; WriteBOM, WriteFileIfModified: Boolean): String;
#Filetransfer #Filemanagement #Encoding
If you need any info about this ‘Convert character set’ question, please let us know.
Best regards,
Limagito Team
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.