Limagito File Mover Software Blog and Filemover News

31 Mar
Csv to Xls conversion problems
Q: Csv to Xls conversion problems. I have a small problem with the conversion of .csv to .xls files. My original file is separated by ; saved as .txt.
I also tried with a comma separated .csv and I get the same result.
I also tried to import full csv as text
I also tried adding a header
I still get the same result
I have attached some screenshots, I have also attached the txt file to convert. My file contains data in French with accents, can this have an impact?
A: It looks like a problem with the encoding of the txt file. We converted it to UTF8 first using a Pascal Script and afterwards the conversion worked just fine.
1. Open the Pascal Script option:
2. Enable and add the following ‘On Destination’ Pascal Script. This will first change the Encoding of the Source txt file to UTF8. The conversion to XLS was ok afterwards.
Var tmpFile: String; Begin psExitCode:= 0; // ... add your code here tmpFile := psFilePath + psFileName; If psChangeTxtEncoding(tmpFile, tmpFile, 0) Then psExitCode := 1; End.
More information about the “psChangeTxtEncoding function”:
Use psChangeTxtEncoding to convert the encoding
> Encoding possibilities:
0: UTF8
1: UTF7
2: Unicode
3: Default
4: BigEndianUnicode
5: ASCII
6: ANSI
7: ASCII TRIM
8: ANSI TRIM
i.e. psChangeTxtEncoding(psFilePath + psFileName, psFilePath + psFileName, 0);
This script will change the encoding of the original source file before it is converted to .xls using XLS as Destination.
Some extra screenshots of the XLS as Destination setup:
#Filetransfer #csv #xls
If you need any info about this ‘conversion problems’ issue, please let us know.
Best regards,
Limagito Team
By Limagito-Team Pascal Script XLS/CSV conversion problems, Csv to Xls
29 Mar
Not able to upload to SFTP server, operation not supported
Q: I run into an issue with a project that is migrating to a new partner SFTP server. We created an upload process in Filemover that takes a TXT file, encrypts it via PGP and then uploads it via SFTP to the partner. That is done within one rule. I copied this existing rule and changed it to point to the new server (also new user and new keys for authentication). SFTP connect is possible but when I try to let the rule run it throws an error message: operation not supported. Please inform me if you need any additional information.
A: In version v2022.3.28.0 we added an extra option called ‘Upload ReadWrite Access Mode’. We did this in case for some strange reason the SFTP server does not like “writeOnly” (our default during file upload) and instead wants “readWrite”. Could you please enable this option and try once more. Log result would be appreciated.
Feedback from customer:
Awesome, that did the trick! Thank you very much for your quick and pragmatic support during the last days!

#Filetransfer #SFTP
If you need any info about this ‘Operation not supported’ error, please let us know.
Best regards,
Limagito Team
By Limagito-Team SFTP
25 Mar
Email When Transfer Size is not Above 90GBs
Q: Email When Transfer Size is not Above 90GBs. I have a job that runs everyday and 91GBs is transferred. On some days the job only transfers 60GBs because a file is locked. Is there a way to send an email when Limagito transfers anything under 90Gbs?
A: Yes this is possible since version v2022.3.25.0. In this option we added some Integer (Int64) Var: psVIA (= Pascal Script Var Integer A).
You’ll need to add some Pascal Script and Rule Event options to your existing transfer rule.
1. Open our ‘Pascal Script’ option:
2. Enable and add the following ‘On Rule Begin’ Pascal Script (this script will set the integer psVIA Var to zero):
Begin // ... add your code here psExitCode := 1; psVIA := 0; End.
3. Enable and add the following ‘On Rule End’ Pascal Script (this script will return an error internally when the total transfered size is not ok):
Const ctMaxSize = 97710505984; // 90 GByte Begin psExitCode := 1; // Debug psLogWrite(1, '', 'End Size: ' + '%VIA'); // Check If psVIA <= ctMaxSize Then Begin psLogWrite(1, '', 'End Size not above 90GBs'); psExitCode := 0; End; End.
4. In the Function setup set 'Destination Options' to 'Destination Memory & Exit Cyclus on Error':
5. Add a Pascal Script as Destination. If you have multiple Destinations then our Pascal Script must be the last one in the list.
6. Add the following Pascal Script as Destination (this will add the transfered filesize to the psVIA Integer Var):
Begin // ... add your code here psExitCode:= 1; psVIA := psVIA + psFileSize; // Debug psLogWrite(1, '', 'Sum of Bytes: ' + Int64ToStr(psVIA)); End.
7. Open our 'Rule Events' option:
8. Select and enable 'On Pascal Script Error' event. With this event selected enable 'Enable Mail' and setup the Email and SMTP Setup.
9. Received email in case 90GBs were not transfered:
10. RunTime log will also show yout when transfered size was not reached:

#Filetransfer
If you need any info about this ‘Email When Transfer Size’ request, please let us know.
Best regards,
Limagito Team
By Limagito-Team Pascal Script SMTP email, transfer size