Hello everyone,
I want to extract certain details from UiPath Execution log file
Please suggest on any ideas
And How to convert Execution log file to JSON or XML format?
Thanks
Neha
Hello everyone,
I want to extract certain details from UiPath Execution log file
Please suggest on any ideas
And How to convert Execution log file to JSON or XML format?
Thanks
Neha
Hello @Neha_Kumari1
Check if this thread helps: How to convert the excel output data into json file?
in addition to:
lets have a look on following:
I want to extract certain details from UiPath Execution log file
depending, on what you want to extract it can be done e.g. with Regex
or Deserialiting the {…} to JSON or both combined
lets assume format below for the execution log
13:06:03.1566 Info {“message”:“### execution started”,“level”:“Information”,“logType”:“Default”,…}
it already very close to JSON as parts of it are JSON {…}
So just let us know your details and extraction needs, so we can adress more indiviudally your case
Thanks a lot @Parth_Doshi , @Palaniyappan , @ppr for your inputs
I’ll try same at my end and would revert if get stuck
Hi @ppr ,
Thanks for responding.
My execution log format is in that only, what you stated. Attaching also the sample file for your reference.
And I tried going with Regex, not so comfortable with it for now. Could you please suggest how to go with deserializing in this? or any other possible way out there
From this log file, I need to extract data as such,
. Process Start Time
.Name Of Process
.Process Transaction Count
.Execution Duration (Process End Time- Process Start Time)
SampleExecution.txt (51.0 KB)
just find some introductions to the main building blocks.
Filtering / Preprocessing the log lines:
with regex we do find the JSON part
Let jo = … we do parse a string into a JObject
also did some demonstrations on retrieval, filterings, and orderings
there are some jobs that do not have an end log. So it is suggested to group the lines on the job id:
finally, we demonstrate on a prototype level on how a report data table can be populated including handling the missing endlines:
Result:
Kindly note: No of Transaction Info is not in the logs:
find starter help here:
ExecLogExtractor_Demo1.xaml (13.1 KB)
further info on LINQ and Regex
This CheatSheet introduces the basic use of regex functions. With further examples also special cases are presented. Introduction From the namespace System.Text.RegularExpressions following methods are offered: Regex.Match Regex.Matches Regex.isMatch Regex.Replace Regex.Split A simple usage for example would look like this: [grafik] Recommendation: add System.Text.RegularExpressions to the imports: [grafik] it allows to use the shortened statement, as the namespace part can be ommited…
This topic references the different Learning HowTos related to LINQ. It will be updated on new published HowTos as well LINQ Learning: Topic LINK First Start with LINQ [HowTo] - First Start with LINQ (VB.Net) Exploring the LINQ universe [HowTo] - Exploring the LINQ Universe (VB.Net) Operator [HowTo] Overview Topic LINK Where [HowTo] LINQ - First Start # Where Operator Select work in progress Any [HowTo] LINQ – First Start # Any Operator All [HowTo] LINQ – First Start…
Hi @ppr,
Thanks a lot for your efforts.
I was trying to add some extra columns to it. Some working well.
And could you please suggest on how to add an item that’s only available in, say, last log message, like if I wish to extract “totalExecutionTime” from the Execution log file.
Updated-Got it. Thanks…
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.