Using SVG files in Microsoft Office

One of the consequences of moving to an integrated java based charting system in version 2.1 was that we lost the ability to generate Windows Metafiles (.wmf) from the chart program. The wmf format was a good vector based graphics format meaning that, for the graphics packages that could decode the files, the lines appeared sharp regardless of the scale it was plotted at. They were well supported by earlier versions of Windows and Microsoft Office, but more recent editions of Windows do not always render them very well. Unfortunately we have not been able to find a reliable code library that would created wmf files from our java code.

The alternatives are to create PDF files, which are vector based, or use the SVG format. The latter, which is short for Scaleable Vector Graphics, is an open graphics standard which is theoretically readable by a wide variety of software. We have found that although SVG files can be easily read by browsers like Internet Explorer, support was lacking in Microsoft Office. In Office, you needed to insert PDF files or bitmaps. These don’t always look optimal in Excel or Powerpoint.

Now, with the latest builds of Office, Microsoft have made good on their promise to be able to import SVG files. You will need a recent version – those who have an Office 365 subscription or similar will probably have received the update by now – specifically version 1705.

From the StrataBugs chart menus use the Export option and change the file type selector to show .SVG files. Create your file. Then in Office use the Insert Illustrations menu, select your file.

For large correlation charts which create large VGS files – particularly if you’re using logs and lithologies, the Office apps can get a bit sluggish, but otherwise it does reliably support the chart in pin sharp detail. Try it.

More information here: https://support.office.com/en-gb/article/Insert-SVG-images-and-icons-in-Office-2016-e2459f17-3996-4795-996e-b9a13486fa79

This file was 42Mb, and Powerpoint struggles, but it can read the file faithfully …

 

 

 

Filter by multiple categories

It has long been possible to use StrataBugs to create ‘closure’ diagrams, showing the relative abundance of different groups of species. I use the term ‘groups’ rather than ‘Groups’ intentionally, since the ‘groups’ may also be ‘categories’. A recent change has made this feature a little more flexible.

The new feature in brief

Let’s say a palynologist wants a quick overview of the relative abundance of marine vs terrestrial species. In practice this is achieved by comparing the abundance of dinocysts (category DC) with the abundance of pollen and spores (cateogry SP). Since all species belong to a category already, it’s simply a case of creating a panel which is grouped by category, and displayed as a relative stacked sawtooth plot. The only problem was that all the other palynology categories which happened to show up in the data would also be included in the plot (the left-hand panel in the image below). In the data below, the DA category represents the number of dinocysts in the first 100 specimens, so that’s what I want to compare to the SP count (N.B. your counting method might be different!).

We have now made it possible to ‘filter’ the panel by more than one category, which allows you to create the right-hand panel below comparing just DC and SP. Species not belonging to the filter categories are excluded from the data.

To make use of this setting, you need to select the ‘Outer’ panel properties tab, and choose ‘Restrict data to’. Here you can choose from a list of categories. To select more than one category, hold down CTRL while you select from the list.

A recap on groups and categories

All genera (and therefore species) must belong to one (and only one) category. This is a convenient way of, well, categorising taxa. Most StrataBugs users will not need to modify the standard list of categories – it would make exchanging data between databases more difficult.

Groups, on the other hand, are entirely under your control, and one species can belong to any number of groups. Groups can be attached to projects.

Both are useful for creating charts. You can find our more in the help.

More about closure diagrams

The inner panels above are created with the following options:

  • ‘Group data by’ is set to ‘categories’ – this means that counts of species from the same category will be aggregated. You could also use groups here, in which case either the outer or inner panel must be filtered to a group set (which defines the selection of groups).
  • ‘Plot type’ is set to ‘stacked curves’ – rather than showing the different categories in individual columns.
  • ‘Calculation style’ is set to ‘relative (inner)’ which means that instead of showing the absolute count for each category, we’re showing the count as a percentage of the total for the inner panel. In this case you could also select ‘relative (outer)’ (i.e. the count is relative to the outer panel), because the inner and outer panels are showing the same data (more in this previous post).

You can find out more about the biostratigraphy panel options here.

Tags : , , , ,

Backup your databases

In recognition of World Backup Day (no?, me neither), a quick run through the hows and whys of backing up your StrataBugs database.

Backing up your system seems a obvious no-brainer, but take a few minutes to consider what you’re backing up, why you’re doing it, and how you  might recover the database, should it be necessary.

There are two main reasons to take a backup: the most obvious being a hard drive or system failure, a fire, or theft, that results in an unrecoverable data loss. The other reason, sometimes overlooked, is the need to go back to an earlier database state in the event of accidental data loss by deleting, mistaken editing, or even a programming error (I know, I know, highly unlikley, but let’s move on..).

For the first, you need a copy – any copy – on some kind of media that isn’t the computer that StrataBugs is installed on. Most sensibly this means an external drive or memory stick that isn’t stored (and fire damaged/stolen with) the computer itself, OR, files copied ino the cloud using Dropbox or similar services. The only real pitfall of this approach is that you need to ideally make multiple copies on different media and make sure you know which ones are most up to date. In the event of a system failure you want to be able to go straight back to the most recent copy without having to try to work out which of your myriad sources of backup contained the latest database.

For users of stand-alone databases, you only really need concern yourself with the database file(s) in the /Data folder ending in .db or .mdb, since this is the only file that we can’t restore for you. All the rest of the StrataBugs files can be downloaded afresh, or supplied by us.

For users of server-based databases like SQL Server and Oracle, this backup issue is out of your hands, and one would assume that server custodians would have a backup schedule fully in place. It’s worth asking however, how often the backups are performed.

Going back to an earlier state of data is more problematic if your backup schedule always involves overwriting the previous backup copy. You might be able to recover a database, but what if you discovered a previous problem that has only just come to light, or a loss of data that pre-dates your last backup? For this reason, you should keep snapshot copies stretching back say, every day for a week, then every month for a year, then each year.

Another way to create an effective backup, particularly for server based databases, it to export the data through Organiser, or through the process that creates project databases in the Wells & Outcrops module. In this way you can selectively restore data through the usual import mechanism.

To make this process as painless as possible, a recent addition to the Connection properties dialog for H2 databases allows you to Prompt for backup:

If you have this feature switched on, you will get the following dialog pop up whenever you exit from the system:

You can use this to quickly create a dated compressed backup file onto your chosen media. If you need to recover your database from the file, you need to unzip the database snapshot into the StrataBugs data folder, and provided your connection and database name are the same as the backup, you can be back up and running immediately.

Don’t let your backup be the one thing that you always meant to get around to doing … but never quite made it. If you haven’t done it recently – do it today!

 

Working with the Standard Chart

Amongst the many voices of approval from those that have got to grips with the templated charts in v2.1 there are always a few folks who are permanently wedded to the idea of “one well, one chart”, and don’t want to work in a templated view of the world. They also prefer a WYSIWIG panel property editor, so they can make individual panel changes as required for the well they’re working on. For them, getting to know the options available on the standard chart is where they need to start.

The Standard chart tab in the Samples & Interpretations module is always present, and contains a panel for all the data types that are present in the well. You can customise the standard chart by clicking in the chart properties icon in the toolbar: toolbar1and using the panel list to add/edit and delete panels. Right clicking on any panel in the chart will bring up the option to edit the panel’s properties.

In this way you can create the chart you want. When you’re done, you can then use the rightmost button to save the chart as a template.toolbar2

At this point you can name your template for use in the next well. Any panels that have different properties to the default will be saved in the new template.

In your second well, use the penultimate button on the toolbar to load the template you previously made into the standard chart…toolbar3

Now, make any changes you like to the panel properties. When you’re done, pres the last button again to save the template.templateupdateAt this stage you have a choice: if you update the existing template, then this will also apply to your first well and any others that happen to be using this template. This may or may not be what you want. To keep things simple, you can select New Template, and the template name will be suffixed by the well name, and thereafter opened in a new tab bearing the template name.

When you next open your wells, the template tabs will reopen in the same state they were saved in, while the standard chart will reset to the default layout. To make changes, see above (load your template into the standard chart ….)

Lots more information on the charts tab, as always, in the help here.

Claim your StrataBugs ID

Today we introduce an exciting new feature: an online register of StrataBugs users. It sounds simple – and for you, it is!

All analytical data in StrataBugs is linked to an analyst, who has a name and an ID (usually their initials); the idea being that you could identify who created particular sets of data, and possibly even interact with them in the real world. Anybody who imports data must deal with “matching” analysts – that is, linking their information in the file with some details in your database. This is relatively easy with the newer SBG files because they always contain the analyst’s name. However, there are lots of files out there in many different formats which don’t contain anything more than an ID. Even in the relatively small community of biostratigraphers, we don’t all know each other. This can make matching analysts an uncertain process. Add to this the problem that different people may have the same initials, and things get very tricky indeed.

Our new web services project tackles this situation by giving you the opportunity to “claim” your StrataBugs ID. Anybody else using StrataBugs will be able to link a file with your ID back to you. Plus, newbie biostratigraphers won’t be able to “steal” your ID!

When you next log in, you’ll get the opportunity to opt in or out of using our web services.

opt in or out
You can change your mind later on from the Control Panel > Config > StrataBugs web services menu.

If you accept, StrataBugs will check the online register to see whether your StrataBugs ID is registered. If not, you’ll get the opportunity to add it. If it is already registered, but not to your name, StrataBugs will suggest that you change your ID! If you or your system administrator changes your name or ID via the User dialog, your online record will also be updated.

Note that the only way to register your ID is for you to log in. No other user can do it for you.

Now when you are matching analysts from a file, you see a “lookup” button. This checks the register to see if there’s a match against the analyst ID.

wjsbugs-lookup

In this case, there is, and you’ve got the option to add him as an analyst in your database.

wjsbugs-PDB

In the interests of transparency, this is all the data we are collecting:

  • Your StrataBugs ID
  • Your full name
  • Your discipline
  • An optional link to a web page of your choice (personal website, LinkedIn profile etc)
  • The date on which you last logged in to StrataBugs (this is so that we can detect unused accounts and delete them if necessary)

So – download the update (from test) and get claiming your ID before somebody else does!

Tags :

Adding new zones from a chart

We try to make it as easy and ‘safe’ as possible for you to explore StrataBugs without inadvertantly corrupting your data. That’s why we always ask you to confirm before deleting something. Last week we were clicking about in this way (exploring), trying to think through an idea, when we stumbled upon a feature that we’d completely forgotten was there.

A helpful user had made a great suggestion. In their own words:

Being able to add interpretations (e.g. chronostrat) via the charts in the Samples & Interpretations module would be a very useful addition, rather than having to keep switching tabs back and forth.

The thought process on our side goes something like this: Well, yes, that would be good! How would that work? Double-click somewhere? There’s already some double-click action in the zones panel (*try double-clicking in a zones panel*) – you can edit existing zones by double-clicking on them. So, maybe double-click where there isn’t a zone? (*double-click where there’s no zone*) Hey, look, it brings up the interval dialog! So we already implemented this! (*try the same on another panel*) Oh dear, doesn’t seem to work in this panel, why’s that?

There are, literally, millions of lines of code in StrataBugs. It’s not surprising that we forget about some of them.
Go to the full post…

Tags : ,

Time moves on

Another year, and it comes to our attention that another new geological time scale is published in the form of GTS2016. This new work makes some 27 changes to stage boundaries compared to the previously published GTS2012. We have taken this opportunity to revisit our interpretation of the 2012 time scale and provide a 2016 version which shows the revised stage boundaries, and the resulting changes to the divisions further up the hierachy. We have also added more subdivisions where these didn’t exist before, e.g. the sub-epochs in the Cenozoic.

Because this new 2016 scheme has been created in StrataBugs v2.1, we have been able to add the boundary uncertainty indicator so you can see which are confident, probable or possible.

Users of Timescale Creator Pro may be able to import the new schemes directly from the data pack, but we have packaged the revised timescale so you can download your own copy and easily import this into StrataBugs. If you use the “Read…” button in the Schemes and Interpretations module, you can compare the new scheme on the Match Scheme dialog with the existing GTS2012. The match dialog shows you exactly which changes have been made:GTScomparison2

As usual, items in the workspace are on the left, and existing items from the database are on the right. Green rows indicate the new units. Red rows show where there is some kind of difference. Many of the differences are where we have added further precision to the boundary ages.

Once you’ve imported the new scheme, you will need to ensure that zone boundaries in your existing zonation schemes are in alignment with the updated time units. You can get StrataBugs to do the bulk of the work for you using the “Recalibrate…” button. This will create a copy of your scheme with zone boundaries adjusted in the same propoprtion as the change in the corresponding time unit from one scheme to another.

You can also relink existing well data intervals to a new scheme using the “Reassign…” button on the “show wells” dialog for the existing scheme. This procedure looks for units of the same name in the new scheme, and switches the well data to point to the new scheme. For a transition between GTS2012 and GTS2016 there should be a complete match of unit names. The implication of the reassignment is that the unit positions will change when plotting depth/age curves, so your depth/age curves might also need revisiting if you switch to the new time scale.

Unless you are actually using the time to calculate accumulation rates, or measuring time gaps in Wheeler diagrams, or exporting curves into another system, it doesn’t really matter which time scale you use; as long as all your schemes are consistent with it, there is no ambiguity as to which stratigraphic unit zones or events belong to. It is for this reason that in v2.1 you must specify which time scale a zonation scheme belongs to. You can also group the display of schemes according to the base chronostratigaphic scheme.

Event Confidence

Confidence levels for events are a new feature for v2.1. You will be more sure about the position of some events than of others. A strong flood of specimens makes a more definite marker than a single, poorly preserved top. Can you be sure you have located the relevant abundance peak? If you are going to base other interpretations on event picks (especially a depth/age curve), then you will want to give yourself some guidance as to the reliability of those picks. Here I will demonstrate the ways you can apply confidence to events in order to give yourself this support.

Events in wells

To change the confidence level for a well event, select from the drop-down in the Event dialog:

well-event-dialog

You can set the events panel to display less confident events in a lighter colour.

event-panel
Note that you must also select “use colours”.

Don’t forget that you can display events on your taxon distribution chart (for example, download the “Event Age” panel template from here). This is handy for deciding on the confidence level – you can easily spot the more dubious events and designate them accordingly. You can double-click on an event to edit it. In this panel, the colour changes where the event is picked. The colour change is more pronounced where the event is more confident.

well-event-panel
The left-hand track, showing the “possible” SA event, shows a less prominent colour change than the right-hand track which shows the “confident” C event.

Events in time (composite standard events)

Composite standard events are configured and displayed in much the same way. The stratigraphic range panel shows ‘probable’ events with a dashed line and ‘possible’ events as a dotted line.

cmp-std-range-panel

 Cross-plot of events (depth/age chart)

On a depth/age chart, confidence levels of both types of event help you when placing your curve. Events are shown with a lighter-weight line when their age is less confident, and a lighter colour when their depth is less confident.

depth-age
(1) Probable FAD / Probable LDO; (2) Possible LAD, Confident FDO; (3) Confident LAD, Possible LDO.

Note that the confidence is subjective: it’s not based on data from adjacent samples. The event depth range “tails” are based on the next analysis within the discipline under the assumption that, for instance, a top event could extend right up until the next sample, and vice versa for a base.

Tags : , , ,

Abundance Events in Stratigraphic Range Charts

In recent weeks we’ve been busy enhancing the stratigraphic range chart plot to display abundance events. Many thanks to Martin Pearce at Evolution Applied for working through this with us.

The stratigraphic range panel is designed as an alternative type of view on a composite standard (event scheme). It shows the ranges of events in time.

A note on terminology: the ‘range chart’ I will be referring to is different from a ‘species distribution chart’ showing abundance variations in a well section – which I do often hear referred to as a ‘range chart’. The range chart in question is concerned with time.

A simple range chart showing a few species might look like this:

rangechart_simple

Events relating to the same species are grouped together. In this case there are three events for Palynodinium grallator – a total species range, plus two abundance event ranges.

At the moment there is no formal way to link these abundance events (denoted by the [A] and [SA]) to an abundance scheme which defines them. A simple workaround is to create an abundance scheme with exactly the same name as the composite standard. The stratigraphic range panel will pick this up and use it to identify abundance events. Any term abbreviation from the abundance scheme which appears in the event name surrounded by brackets (you may use parentheses, square or angled brackets) will be interpreted as an abundance event. Go to the full post…

Tags : , ,

Overplotting Biozones

Over the past few weeks we’ve been polishing a new feature for “overplotting” biozone panels. This feature gives you more flexibility over which biozone schemes you can include in the same columns. It was something we allowed for in the v2.1 data model but hadn’t got around to implementing yet. And yes, I am aware that “overplot” isn’t officially part of the English language, but it does describe the concept quite succinctly!

Hopefully you are already aware that:

  • Biozone intervals are always linked to a scheme.
  • Biozone schemes are linked to a discipline.
  • There are four panel types for biozones: one for to each discipline.
  • A biozone panel in a block template has a scheme attribute. When you add a panel template to a block template, you can either:
    1. Choose one scheme belonging to the panel’s discipline, or
    2. choose no scheme (“<panel per scheme>”), in which case you will see all of the intervals linked to schemes with the panel’s discipline, either merged into one column or as separate, automatically generated panels.

In short, this means you could either select all the schemes for a discipline, or one scheme only.

Adding the overplot function makes things much more flexible, giving you complete control over which intervals will appear in which columns, and even allowing you to mix disciplines. It is a simple technique (on your side anyway!) which tells one panel to draw on top of the previous panel. Go to the full post…

Tags : ,