Q: Move a file and send email with filename and line count.
Can you help me with the following question.
I want to move a file and in an email state the file name (always a text file .csv, .txt) and a line count
Test.txt – 12 lines
Can this be done?
A: Yes this is possible. We have created a Pascal Script for you to achieve this.
1. It is important that you’ll only handle txt and csv files (text based files). We added a File Name Include File Filter, just to be sure:
2. Open our ‘Pascal Script’ option:
Add and enable the following ‘On Destination’ Pascal Script. This script will load the txt/csv file and will put the line count information into our %VSA parameter which can be use within our notification email.
Var tmpCount: Integer; tmpList: TStringList; Begin psExitCode:= 0; // ... add your code here tmpList := TStringList.Create; Try Try // Load Source File tmpList.LoadFromFile(psFilePath + psFileName); // Count Lines tmpCount := tmpList.Count; // Info to be used in email psVSA := psFileName + ' - ' + IntToStr(tmpCount) + ' lines'; psLogWrite(1, '', 'Information: ' + psVSA); // Set Result OK psExitCode := 1; Except psLogWrite(1, '', 'Error loading: ' + psFilePath + psFileName); End; Finally tmpList.Free; End; End.
3. Now you can use the %VSA as parameter within the email setup:
4. Email Result:
If you need any info about this option, please let us know.