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 had this idea for years, but only got around to work on it recently.
Better late then never, the Butler family of open source tools for Qlik Sense has a new member:

Butler Sheet Icons

https://github.com/ptarmiganlabs/butler-sheet-icons

It’s an open source tool that will take screen shots of all sheets in a Qlik Sense Enterprise on Windows app, upload the images to a content library and finally set the sheet icons of each sheet. Automatically.

The tool is cross platform (Windows, MacOS, Linux, Docker).
A single command will update all sheets in an app. Add a few lines of PowerShell script and you can automatically update all sheets in all apps…
Or run it as a Docker container as part of your CI/CD workflow.
Or manually when you have made UI changes to your Sense app.

Feel free to try it out, feedback, report bugs or contribute with new features!

Butler SOS 5.0 is out – new features, new doc site

Butler SOS has matured quite a bit during past couple of years, with latest additions being fine-grained monitoring of what users are connected to what servers.
Opens up for various interesting use cases, including notification to users before server restarts etc.

A brand new doc site (butler-sos.ptarmiganlabs.com) also goes live today (built with Hugo and Docsy, vastly better than the previous one-pager at GitHub.

Starting today that site is the goto-place for everything Butler SOS related.
The site contains both installation and configuration instructions, as well as a (hopefully growing) set of examples on how Butler SOS can be used in various way.

Make sure to check out the blog section of that site too!

Butler Spyglass: Data lineage and metadata tool for Qlik Sense

Latest member of the Butler family

For years I have thought about ways to get data lineage info for all apps in a Qlik Sense Enterprise environment.

It would be super useful to know exactly what apps use a particular data source, as well as vice versa (what data sources are used by a specific app). I know there are commercial tools doing this and much more, but I wanted something easy to use, yet still effective and free.

Same thing for app load scripts: Extracting and storing them to disk in human readable format has more than once save days of work, when something has gone badly wrong in an app.
Dumping load scripts to disk was possible in my original Butler tool, but then only one app at a time. So not quite what was needed in an enterprise context.

Enter Butler Spyglass

Continue reading “Butler Spyglass: Data lineage and metadata tool for Qlik Sense”