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

ctrl-q

👋 Please meet Ctrl-Q!

…a new open source tool for Qlik Sense admins and developers ❓ Have you ever had to manually create dozens or even hundreds of master items in a Sense app? 😓 Only to later having to delete half of them? 🤯 ❓ Or needed a detailed list of all bookmarks in an app? ❓ Or

qliksense

A no-compromise Qlik Sense backup solution, part 2

The previous post focused on how to do a high level backup of all information in a client-managed Qlik Sense Enterprise on Windows (QSEoW) cluster. Let’s dig into details a bit and take a look at how we can do more granular backups of various parts of QSEoW. Specifically,

qliksense

A no-compromise Qlik Sense backup solution, part 1

Over the years there has been numerous discussion in the Qlik community about how to best back up a client-managed Qlik Sense Enterprise on Windows system (QSEoW). The backup and data security policies of different organisations of course differs, but if we focus on the Qlik Sense side of things

Can’t find that Qlik Sense log file from last week?

It can be difficult and time consuming to find old reload logs in Qlik Sense. Butler makes this easier by storing logs for all failed reloads in a central location, with separate directories for different dates.

butler-sheet-icons

How I learned to stop doing manual screen shots and love SenseOps automation

😖 Let’s be honest now. Does your 🧠 really enjoy the manual process of taking screenshots and processing 15 sheets each in 50 different apps? And then keeping those sheet icons updated as the sheets are modified…? Didn’t think so. No-one likes that and the result is usually outdated sheet

butler-sheet-icons

Butler Sheet Icons v2.1 is out

Happy unicorns! Free cake! 🦄 🍰 …and a new version of everyone’s favourite tool for creating #Qlik Sense sheet icons. Following up on last week’s release, version 2.1 is now out. Largely based on feedback from the v2.0, the new version adds: 1️⃣ Exclude some sheets from getting

senseops

CI/CD with Qlik Sense, GitHub Actions and self-hosted runners

In spite of Qlik Sense having great APIs, little has over the years been done around continuous integration/deployment (CI/CD) of Sense apps. It’s not that CI/CD is a bad idea – rather the opposite. These days it’s probably the closest thing to a standard way-of-working there

butler-sheet-icons

Qlik Sense sheet icons made easy

If you develop Qlik Sense applications you’ve been there: Manually creating screen shots and then manually uploading them to a content library, and finally manually assigning them as sheet icons. Fun? Not really. But it makes the lives of our end users easier, so we do it. I’ve

butler

Butler 5.0 is out - Extra mega super deluxe reload alerts for Qlik Sense

…and yes – Butler is still open source. The step from 4.x to 5.0 indicates this is a major release. Very much so in fact. The main focus of the new version is on reload alerts. Rich email alerts were introduced in Butler 4.2, but that was really

butler-auth

Butler Auth 1.0 now available - strong authentication for Qlik Sense!

After thinking about the concept for a few years and actively working on it for six months, it’s time for the first public release. The Butler family of open source DevOps tools for Qlik Sense Enterprise has a new member: Butler Auth Always open source Butler Auth is of