Lizard Labs
Lizard Labs is the home of award-winning software for Microsoft Windows operating systems. Log Parser Lizard is a GUI for Microsoft Logparser and uses a SQL-like query language to work with data in many formats. Ultimate Maps Downloader can download both satellite imagery and topographic maps from Google, Yahoo, Microsoft Bing, OpenStreet and ArcGIS.
Please help us improve our software to better meet your needs.
32 results found
-
How can I store changed column properties with my queries?
When I run a query against any type of logfile using the GUI, I can afterwards right-click on the column and change column properties. For instance, by default the value "0" (zero) is not shown, which is annoying, so I set the format string to "0.###", as opposed to the default #.### for numeric columns.
But when I run the query again, edited or not, these properties disappear and I have to go there again, which is very annoying and in the end makes it rather useless to use these properties.
I don't see any save-button in the properties window,…
3 votesThis is done in Log Parser Lizard version 5.1.2. Now you can save column properties in query by checking the ‘Save data grid layout’ check box in the Save Query dialog box.
-
problems with satellite images of google
I purchased the upgrade to the latest version of the software UMD but with regret I saw that the problem with the satellite images of Google has not been resolved. When will resolve the problem?
4 votesFixed in version 4.1
-
join between two data sources
I am currently evaluating log parser. is it possible to join data between two different data sources. i.e. IIS query that joins with sql data source. if so, can you point me in the right direction.
1 voteIn Log Parser Lizard version 5.0 new keywords are introduced 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 -
1 vote
Fixed in UMD 4
-
From the query editor's ToolBar Allow Execute Query
From the toolbar that has the undo/redo, copy,paste,delete add an execute button there. I find that I having to o back to the ribbon's query button and then sometimes the ribbon is on another tab so I have to switch this first is a real pain and slows me down.
3 votesFixed in Log Parser Lizard Version 5.0
-
Allow Automatic Refresh
Have some way to configure a time period where the data is pulled from the data source automatically at some interval (in seconds). For example, lets say I am querying a SQL table called eventLogs and there are multiple writers adding events into this table. I would like to see an updated view.
3 votesThis feature is implemented in Log Parser Version 5.0. Check the “Run Query with parameters”.
-
Allow to copy selected data in output grid via pressing ctrl+c
Allow to copy selected data in output grid via pressing ctrl+c
1 voteFixed in Log Parser Lizard Version 5.0
-
store the "copy command line to clipboard" automatically with the query
servers can access db and run commands from the central repository. If you'd like to take it a step further write the commands with variable overrides per host and schedules for a powerful automation tool.
1 voteWe think this is Fixed in Log Parser Lizard Version 5.0, but will have to check it first if Auto Run queries was what you were looking for.
-
Customize PDF title
When I export a report to PDF, I would like to be able to customize the report. For instance, include the SQL command, have the title include the value of one (or more) of the constants, etc. Currently, the exported reports do not have sufficient context, e.g., date(s) of data used to generate the report, how generated, etc. Otherwise, it's a GREAT product! Thank you.
1 voteFixed in Log Parser Lizard Version 5.0 (Professional Edition). Now you can use WYSIWYG Report editor to customize the look of your reports.
-
fix google satellite
What progress has been made on this issue? When do you expect to have this issue rectified.
1 vote -
setup a grid overlay
A quick fix for not being able to combine large areas would be if you could make it easy to overlay a grid on the map so I can see which areas I have combined and can move to the next area which is as big as I can get and still combine. I am combining the maps into larger ones in photoshop
3 votesYou can change the setting to display tiles grid in Settings dialog box.
-
Referencing a VB variable or constant
Using inline VB in a query, how can I declare a variable or constant at the top and reference it later?
<% Dim sMsg As String = "hello"%>
SELECT * FROM MYTABLE WHERE SOMECOLUMN='<% Return sMsg %>'
9 votesThis feature is implemented in Log Parser Lizard 4.0.3. You can find more info in comments.
-
The world files seem to be incorrect
I'm having troubles with the world files (.pgw) being generated by Ultimate Maps Downloader. I don't know what is wrong but the world file units seem to be about 5 orders of magnitude too small and the returned aspect ratio of the map is also wrong.
Anyone else having problems?3 votes -
make sofware download google imagery and also the imagery combination tool (with Bing imagery cause its all i can get) is tiling incorecctly
make sofware download google imagery and also the imagery combination tool (with Bing imagery cause its all i can get) is tiling incorecctly
1 vote -
Add an option to choose which tile is the origin of downloaded map
Many of the programs I use require that any downloaded tileset has its origin (Tile_0x0.png) in the southwest corner. UMD names tiles in a North to South arrangement before moving East for the next column.
I think it would be useful to have a dialogue that allows a user to choose which order the naming convention applies to the tiles that are downloaded. For instance today I had to rename 8134 files to align properly as X-Plane scenery, and even with a batch tool it took 4 hours due to the tool not catering for renaming a grid tileset so…
3 votesThis is implemented in UMD 4.0
-
The default skin reverts to snow.
Once a skin is selected it is not saved as the default
1 voteThis is not true. Selected skin will remain the same after the product restarts.
-
Option to auto-expand columns in grid results
When querying IIS W3C logs I would like all columns to be auto-expanded to their auto-fit width, instead of wrapping the text.
6 votesCompleted in version 5.0. Field properties can be changed.
-
Global X Y Variable
I would like to use the global X Y values to name my tile folders and files. Is there any way to do this?
1 voteYou can use global coordinates to name the tiles is you put {X} and {Y} in Path to Save text box. For instance, you can change Path to Save to something like this:
{Path}\{MapServer}_{Zoom}_{X}_{Y}
-
Obtain input from .zip files
It would be very convenient to specify a path to a .zip (or other) archive file or folder location in the FROM field and have a collection of compressed log files automatically extracted and used as input.
11 votesIn Log Parser Lizard version 5.0 compressed .gz archives can be read, but only for RegEx, Multiline RegEx and the new Regular Expression Enhanced Input formats.
-
Allow to type in multiple SQL querys into query editor
Allow you to put in multiple SQL / Log querys in a single query window.
Right now it's very limiting to only allow one SQL statement per query window.
I generally have a "scratch" pad which is just a text document that has common querys for a particular set of tasks all within one query document. THis is preferred to having 10 querys all in seperate files as the 10 querys build upon themselves for analysis, they are not mutually exclusive.
You should be able to highlight text in query window and press F5 to run the SELECTED query like…
5 votesIn Log Parser Lizard version 5.0 new keywords are introduced 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
- Don't see your idea?