InVision

InVision

Creating Workbook Plugins – Reading data using the Sql Script Web Service API

by

This is part 2 in the series about creating Workbook plugins for Profitbase InVision.

Part 1 : The Basics
Part 2 : Reading data using the Sql Script Web Service API (this one)
Part 3 : Writing data using the Sql Script Web Service API
Part 4 : Publishing events to the Workbook
Part 5 : Conditional execution of GenericAction

Download : Source code and sample database

In this post, we’ll walk through using the Web Service API of InVision to read from the database. As I mentioned in Part 1, InVision is built using AngularJS, so some experience with that framework is required.

Read more

Creating Workbook Plugins – The Basics

by

In this short series, we’ll walk through creating a simple Workbook plugin.

Part 1 : The Basics (this one)
Part 2 : Reading data using the Sql Script Web Service API
Part 3 : Writing data using the Sql Script Web Service API
Part 4 : Publishing events to the Workbook
Part 5 : Conditional execution of GenericAction

Download : Source code and sample database

Profitbase InVision is built using AngularJS (1.0 right now), so some experience with AngularJS is required for building plugins.

You can download the source code and sample database for this demo from the link above. I won’t talk about how I built the UI since there’s nothing InVision specific about it, it’s just standard HTML, CSS and AngularJS.

Read more

Debugging custom Data Flow Item Class Libaries

by

This is the fourth and final post in a series focused on Data Flow development.

Probably the most important tool used while developing software is the debugger. The debugger lets you step through your code and inspect the state of your program during runtime, so you can see what’s actually going on.

This post will focus on how to debug your custom class libraries while they are being executed by the Profitbase InVision Worker. For information on how to deploy your assembly (build and copy to target folders), you should read Part 1 of this series.

Read more

Upgrading InVision 1.0 to 2.0 and beyond

by

With InVision 2.0, we’ve also created a tool for upgrading the system model (model schema and solution metadata) from one version to the next.  The Model Version Tool (MVT for short), enables you to incrementally upgrade the system model from its current version to any version supported by the tool (no, you can’t downgrade after an upgrade).

Read more

InVision 2.0 Beta 3

by

With Beta 3, the primary focus has been on adding support for charting using Highcharts. There are still some work left to be done before this feature is 100% complete, but it’s pretty stable and you should be able to create great looking charts.

Read more

Passing arguments to Data Flows executed from Workbooks

by

This is the third post in a series focused on Data Flow development.

In this post, we’ll continue using your Data Flow from Part 2, but instead of executing it from the designer and hard coding the message we’re writing to the database, we’ll create a Workbook with a text input field for entering the message.

Read more

Executing Data Flow Item Tasks with parameters

by

This is the second post in a series focused on Data Flow development.

This post will show you how to create a parameterized Data Flow Item and execute it in a Data Flow. It’s a follow up to Creating and Deploying a custom Data Flow Item Class Library, so we’ll use the class library we created there. The way parameters are used, however, is exactly the same whether we use our own custom library or a built-in library.

Read more

Guidelines and tooling for the InVision Solution Development Cycle

by

You’ll probably need to make changes to, or continue developing InVision solutions after they have been published to production. Today, we’ll present a simple best practice pattern or guideline for continued development of InVision solutions, and the new InVision Data Migration Tool (InVision DMT for short) which helps you in this process.

Read more

Creating and deploying a custom Data Flow Item Class Library

by

This is the first post in a series focused on Data Flow development

Simply put, Class Libraries contains classes and methods that describe your business logic. Programs, such as Profitbase InVision, can execute class libraries after they have been compiled into assemblies (.dll) and linked to the program.

Read more

InVision 2.0 Beta 2

by

InVision 2.0 Beta 2 is ready for download! Because x-mas got in our way, it took more than the promised 2 weeks between Beta 1 and Beta 2, but now it’s here. Our primary focus for Beta 2 has been fixing the bugs in Beta 1, adding support for table reports and a few new features that will make Workbook … Read more