Softpedia >Windows >Internet >Servers >Database Utils >Log Parser Lizard >  Changelog

Log Parser Lizard Changelog

What's new in Log Parser Lizard 8.5.0

Oct 10, 2021
  • User interface tweaks, performance improvements and bug fixes with each new release.
  • New input formats: EvtxEcmd and Multiline record reader (v8.5).
  • New data grid features: highlight cell text, set quick find as filter, hide empty columns, show all columns (v8.5).
  • Improved input formats: delimited-field format now can combine columns from files with different structure (v8.5).
  • Improvements in SQLite RDBMS engine (new modules included out of the box). These modules are helpful for log analysis by using SQLite: csv, json1, xml, generate_series, zipfile, Portable Log Parser ParsingModule, etc. You can list all available modules and functions: "select * from pragma_module_list; select * from pragma_function_list" (v8.5).

New in Log Parser Lizard 8.0.1 (Mar 16, 2021)

  • Built-in Web Server – run queries in your browser or using JSON Web API. Useful for accessing LPL queries from the browser, for developers and for connecting LPL with external data analytics software that can read data from JSON Web API.
  • New input format: Media files – read metadata from media files (image, audio, video)
  • New input format: Delimiter-separated values – CSV/TSV plugin for reading text-based files with advanced features (including reading from compressed and online streams)
  • New input format: W3C Log Format Ex – read W3C logs from advanced file streams including compressed, encrypted or http/ftp/s3 stream. Also, additional fields like User Agent parsing and other fields.
  • New input format: Windows Event Log Ex – fixes some bugs from built-in MS Logparser IF and adds some extra fields. Also, can read any event log, not only System, Application or Security logs.
  • Support for direct reading from Amazon S3 in all LPL built-in plugins – for example, use it like this with delimited-field format: select top 100 * from ‘s3://{accesskey}:{secret}@s3.us-east-1.amazonaws.com/bucketname/logs/sampleTSV.log’
  • Many User Interface improvements.
  • Built-in source code editor for many text files including (C#, SQL, VB, JSON, XML, etc.) –very helpful for .NET developers to quickly open the source file logged in the exception.
  • Only one edition is available now. Till version 7.x there were standard and professional editions.
  • Many other user interface and performance Improvements and bug fixes
  • Search cell values on web search engines with one click (saves time when looking for an error message).
  • Easy to export data and share/send e-mail with one click. For example, this really saves time when running custom queries on some database then you need to send the report to someone else.
  • Right-click on existing file path in grid or editor will bring up windows file context menu with options to work with selected file.
  • Many other user interface tweaks, performance Improvements and bug fixes.
  • Only one edition is available now. Till version 7.x there were standard and professional edition, but now all features are collected in one edition named Professional edition.

New in Log Parser Lizard 6.6.0 (May 18, 2017)

  • New Sharing Wizard for easily sharing reports on various cloud drives.
  • New Input Type “Custom Visual Basic.Net plugin” allows you to create your own input format in Visual Basic .Net without compiling the code or advanced COM programming (two samples are included)
  • New Tree Map view. The new Tree Map data view allows you to visualize data using nested rectangles that are sized and ordered by a quantitative variable.
  • Save/Load Input and output format properties to/from file
  • New series types in Charts. Log Parser Lizard version 6.0 ships with the following new series types:
  • Nested Doughnut Chart,
  • Scatter Polar Line and Scatter Radar Line,
  • Stacked Step Area,
  • Full Stacked Step Area,
  • Radar Range Area,
  • Polar Range Area.
  • New Financial and Error Bar Indicators in charts. This release ships with the following new financial indicators:
  • Average True Range
  • Commodity Channel Index
  • Detrended Price Oscillator
  • Mass Index
  • Median Price
  • Moving Average Convergence Divergence
  • Rate Of Change (Momentum)
  • Relative Strength Index
  • Standard Deviation
  • Stochastic Indicator
  • Triple Exponential Moving Average (TEMA)
  • Triple Exponential Moving Average (TriX)
  • Typical Price
  • Volatility Chaikins
  • Weighted Close
  • Williams R
  • The following Chart Error Bar indicator types are now available in Chart Wizard:
  • Fixed - represents errors as a fixed value.
  • Standard Error - error is calculated as a standard error.
  • Standard Deviation - error is calculated as a standard deviation.
  • Data Source Based - error values are loaded from a data source.
  • In LPL 6.x you can obtain chart colors from a datasource. Also new Office Inspired Chart Palettes include: Blue Warm, Blue, Blue II, Blue Green, Green, Green Yellow, Yellow, Yellow Orange, Orange, Red, Red Orange, Red, Red Violet, Violet, Violet II, Median, Paper, Marquee, Slipstream.
  • New Chart Designer dialog box is created as replacement of Chart Wizard (Chart Wizard is still here but you can use Chart Designer if you find it better)
  • Microsoft Excel inspired dialog to edit Format Rules in data grid.
  • Microsoft Excel data Export enhancements.
  • News in Data Source Wizard for Dashboard and WYSISIG Report designers that simplifies the process of binding reports to external data source. Our new Visual Query Builder gives you a powerful and straightforward way to visualize the structure of SQL queries. The Query Builder displays tables, columns, keys and relationships and offers the user experience found in Microsoft Access and Visual Studio's Dataset Designer.
  • Data Source Wizard now supports Excel and Google Big Query data source. With this release, you can bind data in Dashboard and Report Designer to several new data sources including Microsoft Excel workbooks and CSV files (a worksheet, table or named region).
  • We extended the capabilities of our GUI with additional Office-inspired animations.
  • Filtering user experience has been improved.
  • New features in Dashboard Designer: in LPL 6.0, we have extended filtering capabilities with new filter elements: ComboBox, DropDown with multiselection, ListBox with multiselection, RadioGroup, TreeView. You can bind these elements to data source and customize their master filtering options.
  • Dashboard Item Group to arrange dashboard items to a separate group and enable group filtering.
  • Binding Data to Color Palette in dashboards to associate individual fields with a color palette to colorize dimension values and specific measures.
  • Conditionally Formatted Data Bars to add data bars to Pivot and Grid cells and compare measure values corresponding to different categories.
  • In LPL 6.0 you can bind the Dashboards to external data from MS SQL Server, Google BigQuery, Microsoft Excel workbooks and CSV files. The following Excel formats are supported: XLS, XLSX and XLSM. You can specify the source worksheet, table or named region from which to obtain data. You can also export dashboard item data to a file in PDF and MS Excel format.
  • The Grid dashboard item allows you now to add totals to columns. You can manage the visibility of Totals and Grand Totals for a Pivot dashboard item.
  • The Chart dashboard item allows you to use a logarithmic scale for its Y-axis. New Scatter Chart to visualize relationships between numerical variables in dashboards also provides a logarithmic scale for both axes.
  • Dashboard Parameters now support multi-selection allowing you to select multiple values at once. You can also pass a null value as a dashboard parameter.
  • New Local Data Storage Mode (Extract). With Dashboard's new Local Data Storage mode allows you to save the data snapshot on a client machine. Local Data Storage means that end-users can now create offline views and do not need a live connection to the database to interface with a Dashboard.
  • Various improvements in these Dashboards features: Conditional Formatting, Calculated Fields on Summary Level, Data Access
  • Text Box and Image Dashboard Items can be bound to a Dashboard's data source. This new feature can be used alongside Master Filtering in order to display specific information (for instance, a product's description or its image) for the selected value.
  • Support for bar, stacked bars and full-stacked bars.
  • Range Filter in Dashboard Designer – Redesign and Predefined Ranges support.
  • Various bug fixes, performance and memory usage optimization. With this release, we've improved the chart, data grid and dashboard performance and optimized memory usage when working with large volumes of data.

New in Log Parser Lizard 5.5.0 (Jan 28, 2016)

  • Hyperlink in data grid.
  • Now you can use LPL in unattended mode (without UI from - Task Scheduler for instance).
  • New options when running queries with parameters.
  • Change Query Tab appearance.
  • External tools:
  • Quick Query,
  • DB Connection String Builder,
  • Report Designer and
  • Dashboard Viewer and Designer.

New in Log Parser Lizard 5.1.0 (Jan 28, 2016)

  • Create windows tasks from LPL Run properties.
  • Auto-create ZIP backup files on 10 days.
  • Various application settings and improvements.

New in Log Parser Lizard 5.0.3 (Jan 28, 2016)

  • Automatically Check for updates every 30 days.
  • Sample queries from users are added to the installation package.

New in Log Parser Lizard 5.0 (Jan 28, 2016)

  • Available in two editions: Standard Edition and Professional Edition (find more info on the site).
  • Dashboard designer with a number of new features and visualizations (Maps, Charts, Tables, Gauges, Pivot Tables, Cards, etc…). This feature is available only in Professional Edition (15 days FREE trial).
  • WYSISWG Report Designer also available only in Professional Edition.
  • New Input Formats:
  • Excel file reader,
  • HTML Table reader,
  • Microsoft Visual Basic .Net,
  • C# .Net,
  • Powershell,
  • Ultimate Dates Table and
  • Regular Expression Enhanced.
  • Automatically send emails with attachments to default email address.
  • Auto run queries.
  • Set custom shell command that will execute on double click on the tables cell or row.
  • New keyword “--LL PROPS: ” for setting query options in the query. Now you can use different input types in single command (in combination with data set operations GO, MERGE, etc…). You can also put the parameters from a button on a toolbar
  • New help documentation.
  • Context menu in “All Queries” window.
  • New Excel inspired styles in Data Grid (right click on a column for the options)
  • Customizable Data Grid, Pivot Grid and column properties
  • Improved Excel exporter (grouped rows will be grouped in the Excel too, not just list of all rows)
  • A number of other things: help documents, UI improvements, application settings, performance improvements and bug fixes.
  • New keywords to merge, join, group queries (these can be very useful since the merged datasets can be used in Dashboards and Reports):
  • GO - create tables in single dataset without relation (useful in dashboard and reports)
  • MERGE - merge tables in one
  • LPL_UNION - same as MERGE
  • LPL_INTERSECT - intersection of two tables
  • LPL_PRODUCT - product of two tables
  • RELATION_ON_FIRST_COLUMN - create tables in single dataset and try to create a relation on first column (must be of same data type)
  • RELATION_ON_SAME_COLUMNS - create tables in single dataset and try to create a relation on all columns with same name
  • JOIN_ON_FIRST_COLUMN - joins results of two tables in another one on the first column
  • JOIN_ON_SAME_COLUMNS - joins tables on the columns with the same name

New in Log Parser Lizard 4.0.0 (Jul 9, 2014)

  • We completely rewrote the user interface to make it easier to explore.
  • We completely rewrote the cod editor with much better support for syntax highlighting and auto complete (for MS Logparser and Google BigQuery code).
  • Pivot Chart is added in a Pivot Greed window for quick data visualization.
  • Numerous other user-interface and performance improvements and minor bug fixes.

New in Log Parser Lizard 3.5.0 (Jun 9, 2014)

  • Support for Google BigQuery queries. With Google's servers doing all the big data heavy lifting, LPL users will be able to fly through vast data sets with all the visualization options they're accustomed to in the software.
  • Bug fixes

New in Log Parser Lizard 3.0.0 (Jun 9, 2014)

  • Pivot Grid to analyze for advanced data mining and multi-dimensional analysis.
  • New and improved Grid View with a number of new features, including Find Panel, column chooser and advanced filtering dialog.
  • New and improved Chart View with advanced Chart Wizard for customizing data series and chart behavior and appearance.
  • Command line support.
  • Can show MS logparser command line with properties.
  • Batch files. Batch files can run from command line and save results to a number of different file formats.
  • All Queries form with multithreading support. Run multiple queries and save results to a file. You can also run custom command for each query (to send notifications for instance).
  • Storing queries in SQL server database is now available for single user license holders.
  • Advanced print preview for creating documents and send them by email from Log Parser Lizard.
  • Read Android logcat logs using regular expressions and standard console output. This can also be used by any other console application.
  • Support for Log Parser Custom Input Format plugins.
  • New TEXT FILE input format. Read all text file as a single record, then extract fields using regular expression.
  • Export data to PDF, RTF, XLS, XLSX, HTML, MHT, CSV, TSV, XML (MS .Net data table) and TXT files.
  • Import queries from Log Parser Studio.
  • Numerous other user-interface and performance improvements and minor bug fixes.

New in Log Parser Lizard 2.5.0 (Jan 16, 2013)

  • Conditional column format (color, font, size, image, etc). For instance, you can set the condition to change color of the errors in red, warnings in yellow or to highlight the field if it contains some string.
  • Store queries in SQL Server database for easily share among users and computers in organization (also for backups, auditing and everything that db storage allows). While using local file storage, when a user saves a query, another user has to recreate the same query if he/she wants to use it. With Log Parser Lizard you may save queries in SQL Server database to easily share queries between users. You can setup the database from Settings dialog box
  • New and improved Excel style row filtering
  • Ability to add columns with Excel style formulas (with most Excel functions)
  • Support for exporting in Excel 2007 format (more than 65365 rows).
  • Small user interface improvements and minor bug fixes.

New in Log Parser Lizard 2.1.0 (Jan 16, 2013)

  • Support for inline VB.Net code to create LogParser SQL queries. Write the code between marks, it will be executed and result string will be replaced in the query. We believe this feature will be very useful for the users of Log Parser Lizard. For instance, before parsing logs you can move-copy-rename files, download from FTP, shutdown IIS, etc. You can also use .Net data types like DateTime for arithmetic operations and/or System.Envirenment settings in query parameters. This is a sample query with inline VB.Net code: = '' -- last week
  • The resulting query from this sample would be
  • SELEC TOP 100 * FROM #IISW3C# WHERE time >= #2011-10-01# -- last week
  • New "Save Query As" command to easily copy existing queries
  • New option to display exact Logparser SQL query to help debugging queries who are using in-line VB.Net, constants and snippets
  • Charts use color palette (till now random colors were used do paint charts)
  • User-interface and performance improvements and minor bug fixes

New in Log Parser Lizard 2.0.0 (Jan 16, 2013)

  • Improved SQL code editor with enhanced source navigation and analysis capability, syntax-highlighting, automatic source code completion, method insight, undo/redo, bookmarks and more.
  • Support for Facebook Query Language (FQL)
  • Code snippets (code templates)
  • Log Parser Lizard "constants" binding to static/shared properties from Microsoft .Net
  • Now you can save MS Logparser output format properties for future use.
  • Numerous other user-interface and performance improvements and minor bug fixes.
  • Microsoft .Net 3.5 is required