XLS/CSV Archives - File transfer tool from Limagito

12 Oct
Excel as destination losing some rows of data when converting from csv
Excel as destination losing some rows of data when converting from csv
Q: We are running LimagitoX File Mover v2024.1.20.0 and noticed an issue with the Excel destination. It appears to be losing some rows of data starting after line 45. You can replicate this issue by creating a simple rule that uses the attached test_file.txt file as the source and set the destination as Excel with the options in the images below. Note that the text input file has 101 rows, and the Excel output file only has 57. We are still seeing this issue with version 2024.8.26.0. Didn’t want it to fall off your radar.
A: We added the following Pascal Script which will convert your source Ansi csv file to Unicode.
Open our Pascal Script option:
Enable and Add the following ‘On Destination’ Pascal Script:
Begin psExitCode:= 1; // ... add your code here psChangeTxtEncoding(psFilePath + psFileName, psFilePath + psFileName, 2); End.
This will adjust the source txt file so if you don’t want this, add an extra Rule where you use a copy of the original file.
Feedback Customer: That fixed it. Thank you!
If you need any help with this ‘send an email when a file is successfully transferred’ request, please let us know.
Best Regards,
Limagito Team
#xls #managedfiletransfer #filetransfer #filemanagement
By Limagito-Team XLS/CSV excel, losing rows, xls
19 Feb
How to copy a csv file when a specific row exists
How to copy a csv file when a specific row exists
Q: My client is looking for advanced file copy functionality and have set of requirements for this process. Appreciate if you can clarify below requirements applicability with Limagito. The file copying should not copy the currently modified csv files. Basically, the only difference in the files that are completed and in “modify” mode is a last row in the file – If this specific row not exists, file still in “modify” mode.
A: Yes this is possible. We added two examples (scripts) on how to achieve this.
1. Example 1: will read the csv file and check all rows for a certain keyword
2. Example 2: will read the csv file and will only check the last row for a certain keyword
We used a windows folder as source:
Open our ‘Pascal Script’ option:
Example Script 1 will read the csv file and check all rows for a certain keyword ( RT_Count )
Please enable and add the following ‘On Destination’ Pascal Script: link
You can adjust the Keyword but always in Uppercase
Example Script 2 will read the csv file and will only check the last row for a certain keyword ( RT_Count )
Please enable and add the following ‘On Destination’ Pascal Script: link
You can adjust the Keyword but always in Uppercase
As Destination we also used a windows folder:
RunTime Log Result:
If you need any help with this ‘copy files in a specific order’ request, please let us know.
Best Regards,
Limagito Team
#csv #managedfiletransfer #filetransfer #filemanagement
By Limagito-Team Pascal Script XLS/CSV row exists, specific row
08 Sep
How to use a wildcard in the excel sheet name
Q: How to use a wildcard in the excel sheet name. I am using the below to split and convert the tabs out of a spreadsheet but every now and again the client gets the sheet name slightly wrong.
Can you use a wildcard in the sheet name option?
Example:
2 Sticker*
A: Added on request and available in v2023.8.12.0
Example where we used: Page*
If you need any info about this ‘wildcard in the excel sheet name’ request, please let us know.
#excel #filetransfer #filemanagement
Best regards,
Limagito Team
By Limagito-Team XLS/CSV excel, sheet name, wildcard, xls