JRevell.com

Johnathan Revell's Personal Website

Tag: Taskcentre

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

Posts navigation

1 2

Tags

.NET 3CX Aastra Azure Call-Task Competition Discount Code eBook email ETL ETL Tools Exchange FitBit FreeAgent Google Maps Gousto HipChat HTC One M8 Linux Microsoft MySQL Nagios Nav Notification Performance Raspberry Pi Redis Server 2012 Server 2016 ShellShock SIP spam SQL Taskcentre Tesco Orchard VBScript Visual Studio VPN Web Services Windows 10 Windows 10 Home Windows 10 IoT WordPress

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 79 other subscribers

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Donation

Hope these articles have been some help and saved you hours of time.

If they have helped, a little donation would be much appreciated.

£
Select Payment Method
Personal Info

Donation Total: £1.00

Proudly powered by WordPress | Theme: Doo by ThemeVS.