Taskcentre – JRevell.com

Taskcentre – Recording Success / Failure using “Call Task” Tool

January 10, 2018January 10, 2018ComputersNo Comments

The “Call Task” tool in Taskcentre is a useful tool in calling other tasks. The task can run in two modes: Synchronous Queue Queue This adds the task to the queue, to be scheduled at a future point in time Synchronous This queues the task and awaits a response. Sometimes…

SQL Remove Trailing Decimal Places

July 29, 2016ComputersNo Comments

Within a recent project, I’ve been extracting data from Microsoft Dynamics NAV using Taskcentre. Within NAV, decimals are stored as decimal(38,20), complete will all 20 decimal places..! The following SQL query is very handy at removing the un-required decimal places (but keeping the accuracy of the data) The results of…

TaskCentre SQL Performance – One way to improve performance

February 24, 2016ComputersNo Comments

When using the “ODBC” or “OLEDB” tools in TaskCentre, it may appear that a single query is executed on the database. In actual fact from trial and error, I have identified multiple queries are being called. For example, if you run the following query (This query identifies all Item Ledger…

Selecting Text Between Characters in Taskcentre – Using VB Script

October 21, 2015ComputersNo Comments

In Taskcentre, the text parser tool can be used to extract text between set characters. A good example is if you have the following input data: <Result>This is a test</Result> And wish to extract the following text: This is a test This is a good tool, however doesn’t handle errors…

Automating E-Mail Support Requests using FOAAS and Taskcentre

May 31, 2015June 1, 2015Computers1 Comment

In this day and age, everyone is looking for prompt responses to e-mails and support requests. In this blog post I’m going to cover integrating FOAAS into e-mail using Taskcentre in order to provide prompt responses to support requests. By responding quickly to emails, it can greatly improve satisfaction levels,…

Taskcentre Alert Notifications – Update

May 11, 2015ComputersNo Comments

In a previous post, I mentioned about posting alerts to HipChat. Unfortunately passing the “notify” parameter resulted in error messages, regardless of the text passed. It appears that this was a bug with the web service api. I’ve just tried again and passing the following work as expected: true false

Stripping all Non Alphanumeric Characters From String in SQL

April 21, 2015ComputersNo Comments

With one of the projects I’m currently working on using Taskcentre, I required all non alphanumeric characters stripping from a string in a SQL query (in order to perform an inner join with another table). With a bit of research I found a brilliant solution here, by Even Mein (Why…

Plotting Customers on Map from Microsoft Dynamics Nav

March 1, 2015ComputersNo Comments

In this blog post, I am going to cover plotting UK customers in a map from Microsoft Dynamics Nav using Taskcentre. In this post I’m using Nav 2013R2, with the Extended Demo Database. (This has a lot more customers and data compared to the standard demo database). In order to…

eBook Price Tracking

February 8, 2015ComputersNo Comments

Having recently purchased my first eReader, the Kobo Aura, I’ve really started to enjoy reading books more. Instead of having to carry large books about, the small device can sit in my pocket and read books on the go. With the backlight I can even read in bed without the…

Using Taskcentre to Post HTML Tables to HipChat

January 3, 2015Computers2 Comments

I use Taskcentre from Orbis Software quite a lot to send HTML emails to recipients. These usually are bog standard HTML tables with content. For example, this is a sample report based on Microsoft Dynamics Nav database. This is not the standard out of the box Cronus database, but the…