Posts Tagged ‘Table’

Logbook Filter and more

Saturday, April 21st, 2012

Today you can download a new beta version with some great new features:

  • New filter function for all output windows
  • vCard import for buddy details
  • UDDF 3.x import support
  • HeinrichsWeikamp Frog download support
  • Several bug fixes and other minor improvements

With the new filter window, you can create filters for any output window (logbook, details data, table editor, dive site map, statistics, printing and exports). Filters allow you to view, export or print only a subset of your logbook data, based on any criteria you want. For example, you can now view the statistics just for one year or just for your rebreather dives. You can export or print only dives where you’ve dived with just one particular buddy. Or you can view in the map window only dive sites, which are deeper than 30 m and with a rating of 5 stars (just an example).

To create a filter, click the new filter icon you’ll find now in most toolbars:

Logbook Filter

Statistics Filter

Export Filter

Then you will see on the right side of the current window the new filter toolbox, where you can add with “AND/OR” any number of criteria for every database field. As soon as you add, edit or delete filters, you can see the results live in the output window.

Filter Toolbox

Edit Filter

To edit a filter row, just double click it or hit the edit button in the toolbar. That way you can easily refine your filter until you get the data you want. You can save your filter to a file and reload it later on. You can also exchange filters between identical database tables, e.g. between statistics, logbook and table window or between dive site details and dive site map.

vCard Import: In the Buddy details you can import now vCard files, which can be created by most contact and email applications and webmail apps:

vCard Import

Click here to download the update beta setup file. This is an update from the current version 5.0.6. If you have an older version than 5.0.6, please update first to 5.0.6 and then install the beta update. Please let me know how you like the new filter function, if it works for you or if you see any crashes or bugs. The filter function integrates deeply into many parts of the application, so I want to make sure I’ve not broken any existing functionality.

 

Diving Log 5.0 – Hierarchical Browser

Wednesday, April 29th, 2009

Before I talk about the new “Hierarchical Browser” in Diving Log 5.0, I want to show you another feature in the table editor I’ve wrote about in my last blog entry. Due to a recent user request who wanted sort (renumber) only a range of dives I’ve added to the table editor also a “renumber” function which makes it possible to select a range of dives and only renumber these dives with any start number. This gives you the possibility to create “gaps” in your logbook, e.g. if you want to log only dives 1 – 10, 50 – 150 and then starting from 300, for example. This is not easily possible in Diving Log 4.0 which could only renumber all dives at once.

Renumber Dives

Renumber Dives

The new “Hierarchical Browser” replaces (or better merge) the existing location, buddy and dive type statistics you see in Diving Log 4.0. These 3 windows are now included in one tree view window with a single list view on the right side. You can navigate through the several levels and drill down to the single dives which match the criteria (not possible in 4.0).

Hierarchical Browser

Hierarchical Browser

Dives as this dive site

Dives at this dive site

You can copy the list on the right side in an Excel compatible format and I’ve added also another tree which allows you to browse the dives chronological:

Chronological Tree

Chronological Tree

Diving Log 5.0 – Logbook Table

Tuesday, April 21st, 2009

Today I want to show you the logbook table window of Diving Log 5.0. This window got some significant improvements which will make especially those users happy, who hasn’t Microsoft Access installed. As you may know, Diving Log is using an Access database as logbook file which gives you the possibility to edit the raw data of your logbook directly in the database. The advantage is that this is a very easy and fast way to enter or modify a large number of dives or importing data from Excel, for example. But Access is only included in the expensive Office versions, so most users probably won’t have it.

The Diving Log 5.0 logbook table has now a view mode and an edit mode. In view mode the window looks almost the same as in version 4.0:

Logbook Table

Logbook Table

But now you can also enable a side pane which can display the dive profile, dive site map, buddy photo etc. and multi line comments:

Sidepane and context menu

Side pane and context menu

Sidepane with dive site map

Side pane with dive site map

Another great feature is the new find and replace window. You can see this window in Access or Excel, this one in Diving Log is almost identical and is a great help if you want to replace data from a large amount of records.

Find and Replace

Find and Replace

In edit mode you can use the replace function you see in the screenshot above. But you can also edit the raw data directly in the grid in the same way as you could do it in Access or Excel. As an additional feature you can select several cells and start typing. When you press enter, all selected cells will contain this data.

Editing several cells at once

Editing several cells at once

You can copy and paste single or multiple cells within the Diving Log table or between Excel and Diving Log. If you copy a single cell, then select a range of empty cells and paste the data, the data will be pasted into all selected cells at once.

Copy and Paste from Excel

Copy and Paste from Excel

As you can see, the logbook table window is now a really powerful feature and extremely useful if you don’t have Access installed. If you have some dives in Excel, this is also an easy way to get your data into Diving Log. Because you edit the raw data as it is stored in the database, the table editor supports only metric units when it is in edit mode. In view mode the table displays also imperial units. This editor supports the standard keyboard shortcuts like Ctrl-C (Copy), Ctrl-V (Paste) and Ctrl-F (Find).