Johnathan Revell's Personal Website
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]