ctrl-q nr

Low-code find-replace in Qlik Sense app load scripts

Manually update app load scripts can be extremely time consuming. Ctrl-Q NR can assist in that use-case by both identifying apps that should be updated, doing a find-replace operation of all apps' load scripts, and finally reloading the apps.

ctrl-q nr

How to email all Qlik Sense Cloud users

Ctrl-Q NR and Node-RED can be used to get metadata for users in a Qlik Sense Cloud tenant. This can be combined with the email node in Node-RED to create a basic but quite flexible email service that can send emails to all users with email addresses in the tenant.

ctrl-q nr

Monitoring Qlik Sense Cloud app reloads using Node-RED

Ctrl-Q NR has a node that mirrors the reload state of all apps in a Qlik Sense Cloud tenant. Using this node it is possible to build logic that triggers when (for example) app reloads change from "Running" to "Failed".

ctrl-q nr

Qlik Sense license info, low-code style

Ctrl-Q NR includes license nodes for both client-managed and cloud versions of Qlik Sense. These nodes make it easy to create license monitoring solutions that will for example alert fixed number of days before licenses expire.

ctrl-q nr

Monitor Sense services using Ctrl-Q NR

Ctrl-Q NR can get info about all client-managed Qlik Sense services. Using Node-RED it's then easy to detect services that are not running and take necessary action (alert etc).

ctrl-q nr

Tagging rarely reloaded Qlik Sense apps

Using Ctrl-Q NR it is possible to first identify which apps in a client-managed Qlik Sense environment that have not reloaded for a long time, then tag those apps with a suitable tag. The apps can then be easily identified in the QMC.

ctrl-q nr

Ctrl-Q NR: Qlik Sense nodes for Node-RED

Ctrl-Q NR lets you interact with both Qlik Sense Cloud and client-managed Qlik Sense from within Node-RED. There are nodes for starting app reloads, updating app metadata, monitoring the status of all reloads and more.

ctrl-q

Ctrl-Q NR: Low-code tools for Qlik Sense

Ctrl-Q NR is a set of Node-RED nodes that make it easy to use both Qlik Sense Cloud and client-managed Qlik Sense from within the low-code Node-RED platform.

butler-sheet-icons

Butler Sheet Icons 3.1.0

Butler Sheet Icons 3.1.0 adds support for latest Qlik Sense versions, plus a new "browser" command that controls which browser is used to take screenshots of Qlik Sense sheets.

butler

🎉 Butler 9.0 - Monitoring Windows services

With Butler 9.0 it's easy to monitor Windows services, which combined with the already existing reload task monitoring makes Butler a comprehensive solution for high-availability Qlik Sense solutions.

qs-jwt

qs-jwt: JWT auth for Qlik Sense

JWTs - JSON Web Tokens is a well-established way to authenticate with APIs. The open source tool qs-jwt greatly simplifies the creation of JWTs for both Qlik Cloud and client-managed Qlik Sense.

qliksense

The lazy Qlik developer #4: How many users right now?

PowerShell script that will show how many - and what - users are connected to a client-managed Qlik Sense Enterprise server.

ctrl-q

Ctrl-Q 3.9 brings colors to Qlik Sense master items

In previous versions Ctrl-Q could import master dimensions and measures from definitions in an Excel file into client-managed Qlik Sense Enterprise. Ctrl-Q 3.9 adds full color support to those imports.

butler

Running Butler tools as Windows services

Several of the Butler family of open source tools for Qlik Sense Enterprise are intended to run 24/7. This article looks at how to achieve enterprise grade deployment of Butler & friends using standard Windows services.

butler-cw

Butler CW 4.2 released

Butler CW preloads apps into client-managed Qlik Sense servers, making the apps more responsive when users then access them. Latest version adds several security enhancements and the ability to run Butler CW as a Windows service.

ctrl-q

The lazy Qlik developer #3: Bulk export/import of both apps and reload tasks

Ctrl-Q now supports bulk export of both Qlik Sense apps and reload tasks, as well as storing associated metadata in a file on disk. Then import those apps/tasks into Sense again. Reload-tasks-as-code is now possible!

ctrl-q

Bulk import of Qlik Sense apps & tasks, take 2

Importing apps into Qlik Sense is a manual, tedious task. Creating reload tasks even more so. Ctrl-Q version 3.7 automates this fully, taking input from a single Excel file and then imports apps and creates tasks in a single go. Task chains supported too!

qliksense

Using ChatGPT to create Qlik Sense scripts

Can a language model like ChatGPT be used to create code for Qlik Sense? The answer is yes - and no. It's very impressive indeed but doesn't quite replace us humans yet.

butler-sos

The lazy Qlik developer #2: Setting up Butler SOS

Butler SOS provides real-time monitoring for client-managed Qlik Sense. Key metrics for both Sense and Windows are monitored together with errors and warnings from the Sense logs. In this article you find a complete recipe for how to set up Butler SOS.

ctrl-q

The lazy Qlik developer part 1: Ctrl-Q recipes

Ctrl-Q recipes for automating otherwise manual, repetitive, time consuming and error prone tasks when developing Qlik Sense applications.

ctrl-q

Bulk update of Qlik Sense task custom properties

Setting custom properties for dozens or hundreds of Qlik Sense reload tasks can easily take hours. Ctrl-Q has a command that automate this and also remove the risk for manual errors.

ctrl-q

🌴 Qlik Sense task trees using Ctrl-Q

Qlik Sense lacks a good built-in viewer for task dependencies. Ctrl-Q address this by offering a cross-platform tool for visualising Sense task trees, including latest execution result.

ctrl-q

Bulk export/import of reload tasks in client-managed Qlik Sense

The open source tool Ctrl-Q can be used to do bulk export/import of reload tasks in client-managed Qlik Sense Enterprise on Windows.

ctrl-q

An update of recent updates

It's been a while since the last newsletter, not because of lack of progress on the various Butler tools - rather the opposite. We have also moved ptarmiganlabs.com to a new, better hosting solution. Looong overdue but it finally happened. Among other things this means that you can yourselves

Time to move

Update 2023-Feb-1: All comments have now been migrated from the old site. A self-hosted Wordpress setup has served this site well as the hosting platform since it was launched many years ago. "Self-hosted" can however (too often..) be synonymous with "extra work", "maintenance" and "upgrades-that-fail". Time to move on. When