Limagito File Mover Software Blog and Filemover News

17 Apr
Use referenced files during FTP and SFTP upload with shortcut files
Use referenced files during FTP and SFTP upload with shortcut files
Q: After hearing many positive testimonials regarding your product, I finally have the opportunity to work with it. I’ve been tinkering for a few weeks and I’m very impressed with the functionality and speed. I am attempting to architect a rather challenging solution. If possible I would like to present an overview of the requirements and the approach I have been building out and testing. Obviously, I am open to any suggestions regarding a better approach to accomplish these goals with your product.
I need to deliver approximately 9,000 files daily to each of (8) FTP destinations. That’s not an actual 72,000 files daily as each of those eight destinations utilize a text file filter. I know from experience with our current solution that this isn’t as easily achieved as one would think. At peak times we will have more that 2,400 files flowing in per hour. With that in mind I’m trying to design in as many efficiencies as possible.
These files average 4MB. In order to minimize storage and file duplication times, I wanted to create a shortcut alias to the original file. When that file is found in an input, I can use the reference to the original file. I can’t see where this approach would be possible in your product.
I did discover the create Shortcut function in the WIN as Destination and started pursuing that. When files flow into input, I move the original to a ‘processed’ dir and create an alias. Another process monitors the alias dir and copies/seeds all aliases into each of the (8) sub-folders using your ‘Output files to all subdirectories’ option.
Each of these (8) inputs for FTP destinations are using text file filters such as %FCA setup in Rule parameters. Some of these filters are 1,200 lines. I wasn’t sure how well this would work, but testing and speed far exceeded any expectations I had. I am also using a text file for calculating the destination dirs. This involves several pascal scripts as described in a solution I found in your blog. This is all working perfect.
The biggest issue I currently have and possible deal breaker is that the destination file is the shortcut alias. Obviously I was hoping to get the original in the destination.
Sorry for the verbose email. Any assistance or guidance is greatly appreciated.
A: We added a new option in version v2022.4.17.0 to achieve this.
Feedback customer:
This is incredible news! I never would have imagined we could get responsive support like this. I demonstrated my solution utilizing your product this past Friday. Everyone was impressed and couldn’t identify a single area that needed improvement.
Huge thanks to you and your team.

When this option is enabled and a shortcut (.lnk) file is found in the Source then the referenced file will be used during the FTP (or SFTP) upload.
RunTime Log: information about the referenced file is available in the log. The referenced file is used during the FTP upload.
#Filetransfer #SFTP
If you need any info about this ‘shortcut files’ option, please let us know.
Best regards,
Limagito Team
—————————————————————————————————-
FYI, in the ‘WIN as Destination’ setup you have an option to create Shortcut files.

By Limagito-Team FTP SFTP alias, reference, shortcut
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