Applies To
	Product(s):	Bentley Automation Service
	Version(s):	10.00.00.55
	Environment:	N\A
	Area:	i-model Generation
	Subarea:	N\A
	Original Author:	Todd Combs, Bentley Technical Support Group

 

Bentley Automation Service CONNECT Edition delivers a new convenient log file conversion tool with Orchestration Framework. By default, Orchestration Framework logs (%AllUsersProfile%\Bentley\Logs\LoggingService.log) are recorded in text format. Log4NetToExcel.exe can be used to convert text logs into an easy to read Excel format.

 

Before conversion example:

 

After conversion example:

In an Excel format, severity levels are color coded and column filtering can be used to hide unwanted logging.

 

Usage:

C:\Program Files\Bentley\OrchestrationFramework\Tools\Logging\Log4NetToExcel.exe

 -f file to process - defaults to %AllUsersProfile%\Bentley\Logs\LoggingService.log

-d directories to process - gathers files in directory with the pattern *.log*

-o output folder - defaults to the same folder as the input log file

-e name of the excel file - defaults to name of the input log file with .xlsx appended i.e. LoggingService.log.xlsx

-m merges all the input log files into a single excel log

-l<loopIncrement> program goes into endless loop waiting the loopIncrement in seconds between loops. Default loop increment is 1 second

 

 

Examples:

Log4NetToExcel.exe -- takes all defaults - converts %AllUsersProfile%\Bentley\Logs\LoggingService.log to %AllUsersProfile%\Bentley\Logs\LoggingService.log.xlsx

Log4NetToExcel.exe -f"D:\Logs\LoggingService.log -- converts "D:\Logs\LoggingService.log to "D:\Logs\LoggingService.log.xlsx

Log4NetToExcel.exe -d"%AllUsersProfile%\Bentley\Logs" -f"D:\Logs\LoggingService.log" -- will sister excel log files next to the log files discovered in directory and the log file specified.

Log4NetToExcel.exe -m -f"D:\Logs\LogFromMachineA.log" -f"D:\Logs\LogFromMachineB.log" -f"%AllUsersProfile%\Bentley\Logs\LoggingService.log" -o"D:\Logs" -eMergedLog -- Will merge all specified logs into D:\Logs\MergedLog.xlsx

Log4NetToExcel.exe -l2-- goes into endless loop regenerating excel log waiting 2 seconds between report generations