March 2022 - Page 3 of 4 - File transfer tool from Limagito

20 Mar
Q&A 48: Get an actual Rule Report for all Rules we currently have
Q: I have been asked the second time now if it is possible that I got out an actual Rule Report for all Rules we currently have in Limagito. It`s just all the reporting and documentation obligations our company has to follow. Of course it would be possible to print that on a per Rule-Basis. It would be great if there is an option to generate all Rule-Reports for all Rules at once
A: Yes this is possible using some Pascal Script. We added some screenshots to get you started.
1. Add the following Pascal Script as Source (do not forget to adjust the ctDestPath). Our Report output path will be C:\Test\Reports\.
Var tmpInfo: String; Const ctDestPath = 'C:\Test\Reports\'; Begin psExitCode:= 1; // ... add your code here tmpInfo := psSaveRuleReportsAsHTML(ctDestPath); psLogWrite(1, '', tmpInfo); End.
2. In this example we disabled the scan timers because we will trigger the rule manually:
3. No Destinations are needed:
4. We enabled the Rule and clicked the trigger button (small green arrow on he right of the enable/status button):
5. Result in the output folder, all the rule reports are saved as html:
#Filetransfer
If you need any info about this ‘Rule Report for all Rules’ option, please let us know.
Best regards,
Limagito Team
By Limagito-Team Pascal Script Q&A psSaveRuleReportsAsHTML, rule reports, save rule reports, SaveRuleReportsAsHTML
19 Mar
Notificate the windows application log if a certain error occurs?
Q: is it possible notificate in the windows application log if the following error occurs?
17.03.2022 14:29:35 Connect IMAP4, OAuth2 Authorization Failed, Error:
RefreshAccessToken:
..
    fullRequestGetResponse:
      Reading response header…
      responseStatusCode: 400
      Reading response body …
    –fullRequestGetResponse
    finalResponse: {“error”:”invalid_grant”,”error_description”:”AADSTS700082: The refresh token has expired due to inactivity. The token was issued on 2021-11-18T10:09:31.0508889Z and was inactive for 90.00:00:00.\..
–RefreshAccessToken
17.03.2022 14:29:35 Connect IMAP4, CK Login to outlook.office365.com Error:
Connect_Imap:
A: Yes this is possible using the following setup.
1. Open ‘Logging’ setup and enable the ‘Clear Log at Rule Begin’ option in the ‘RunTime Log’ tab. Since we are going to use the RunTime log as content to check, we want to keep it unique for each time the Rule is started.
2. Open ‘Rule Events’
3. Enable the ‘On .. Error’ event and enable the ‘Enable Event Log’ option. Add %VSE ( Var String E ) to the ‘Event Log’ setup. Be sure the ‘On Error’ event stays selected during the setup of the other options.
Important, in the ‘Options’ tab:
Enable ‘Include connect errors in on error event’
Enable ‘Use Pascal Script as Event Precondition’
4. Enable ‘Enable Pascal Script’ for the ‘On Error’ event. Add the following ‘Pascal Script’.
Const ctErrorToFind = 'AADSTS700082'; Begin // ... add your code here psExitCode := 0; If Pos(ctErrorToFind, psLRT) <> 0 Then Begin psLogWrite(1, '', 'Write Error To Event Log, ' + ctErrorToFind); psExitCode := 1; End Else psExitCode := 0; // Put LogRunTime information in psVSE var psVSE := psLRT; End.
Summary:
The RunTime Log is cleared each time the Rule is triggered/started.
If an error (connect or others) occurs then we’ll use the Pascal Script option of the Rule Events to check if the content of the RunTime Log includes a certain text ( ‘AADSTS700082’ ).
If this text is available then we’ll put the RunTime Log content into the Windows Application Log.
#Filetransfer
If you need any info about this ‘windows application log’ request, please let us know.
Best regards,
Limagito Team
By Limagito-Team Logging Pascal Script application log, event log, windows application log, windows log
19 Mar
SQL Source – RecordCount as variable?
Q: With the SQL Source is there a way to access the RecordCount as variable? Would be nice to include it in the subject line of an email Destination. Many thanks!
A: We added two new parameters in version v2022.3.18.0.
%QDC = Query Destination record Count, when using SQL as Destination
%QSC = Query Source record Count, when using SQL as Source
You can use %QDC and %QSC within your email or at other positions where parameters can be used. Some screenshots to get you started.
1. In our example we’ll be using SQL as Source. You can find more information about the setup of ‘SQL as Source’ in our Blog.
2. We’ll be using the new %QSC parameter in an email event:
3. We enabled the ‘On Success’ event and the ‘Enable Mail’ option:
4. In the email setup we used our new %QSC parameter so the RecordCount will be displayed.
4. Received Email:
#SQL #Filetransfer
If you need any info about this ‘RecordCount as variable’ option, please let us know.
Best regards,
Limagito Team
By Limagito-Team SQL record count, recordcount