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

butler

Butler 4.2 for Qlik Sense is out!

Butler 4.2 brings alerting superpowers to Qlik Sense Enterprise on Windows. This version of Butler might actually bring you the most flexible and powerful alert emails ever for Qlik Sense. Layout and contents of the emails are configurable, script logs included in the email and more. Find all details

butler

Butler 4.0 for Qlik Sense is out!

Butler adds various features to Qlik Sense Enterprise (the Windows server version), making it easier to develop, maintain and operate Qlik Sense environments and apps. Butler is open source software. Full docs, getting started guide available at butler.ptarmiganlabs.com. The new version has a bunch of new features, including

qliksense

Post messages to Microsoft Teams from Qlik Sense

The Corona pandemic made lots of people start working from home and the importance of instant messaging apps has increased quite dramatically since. As a result more people are logged into Slack, Microsoft Teams and similar tools. This is good as it opens up for using these tools as a

traefik

Superpowers to Qlik Sense Enterprise, part 2: Free https certificates from Let's Encrypt

Security is important – period. Usability of web based systems is off course important, but so is security. In the previous (first) article in this series we looked at how the Traefik reverse proxy can be used set up end user friendly URLs for Qlik Sense Enterprise (QSE) environments, while at

senseops

Superpowers to Qlik Sense Enterprise: The Traefik reverse proxy, part 1

Edit: A GitHub repository has been created with the files mentioned in this article: https://github.com/mountaindude/qlik-sense-and-traefik What’s Traefik and how does it relate to Qlik Sense? Traefik is one of today’s most hyped reverse proxies. It’s available in both a commercial and a (very

butler

Black box monitoring of Butler tools - monitoring the monitor

This is part 3 in a series about how healthchecks.io can be used to solve various kinds of monitoring scenarios for Qlik Sense Enterprise on Windows (QSEoW) environments. Previous articles: Part 1: Oh data where art thou? Part 2: Black box monitoring of Windows servers Tl;dr Most of