Consider this mouthful: you have a file on a network server, that you want to put into SQL server, that you want to put into Spotfire! I’ll show you this process below along with the common issues that enjoin it.

Read More

We had a quick question on how to wrap buttons in Spotfire. Usually buttons come out like this when you don’t specify the length of the button.

But! If you specify specific dimensions, you’ll find that your button label will trail off into the distance like the button below.

We can employ some simple tricks in Spotfire to get this label to wrap. You’ll need to have the ability to write CSS scripts using the <style> tag. Your Spotfire administrator can turn this on for you. To begin, you’ll need to do the following:

1. Create a text area.
2. Create your button with the size you want.
3. Open the text area into the HTML editor by right-clicking and selecting Edit HTML…

In the script below, you’ll want to add the <style> tag that I have listed below

The white-space property controls how text wraps inside the button. You’ll override this property to the “normal” way it works. The “!important” attribute overrides how Spotfire does this.

Presto! You’re all set.

Recently I needed to comb through the entire Exchange.ai library to see which templates had a certain set of Spotfire Extensions in them. This was a great application for Spotfire’ Application Profiler. Using the Application Profiler involves two IronPython scripts:

• One where you define the output
• One where you define the action you want to perform on each file.

Read More

For the DCA Wrangler, you’ll need to have your data organization into monthly values, which is tricky if you have daily production data that you’re working with. The conversion, however, is simple in Spotfire. Follow these steps to convert daily to monthly:

1. Select File > Add Data Tables…
2. Select Source and choose your existing Daily production data from the current analysis

Before you press OK, we need to add some transformations:

1. First, we need to Calculate new column, we need something to aggregate by and in this case it’s ProductionMonth. Use the expression: Date(Year([Date]),Month([Date]),1)
2. Now add the Pivot:
   1. for your Row identifiers choose your newly created ProductionMonth.
   2. for your Value columns and aggregation methods select Sum(BOPD)
   3. set your Column naming pattern to %V
   4. if you have metadata to pass through such as well name or API add it to your Transfer columns and aggregation methods
3. Review the data and press OK.

You’re all set! Repeat the process to include GAS or NGLs.

Best,
Lucas