KilPen Technical Services - Knowledge Share

Sign in Subscribe

Migrate existing Mastodon from Masto.host to Linode

Migrate existing Mastodon from Masto.host to Linode

❤️This article was written to address a specific issue for a client. There is nothing inherently wrong with Masto.host for those organizations looking to have their own Mastodon instance without the headache involved in self-managed instances. Existing Setup For this tutorial, we'll be moving a production instance

Image with logos

Automating PGP Key Issuance and Distribution with GPG and 1Password

SKILL LEVEL: Advanced. In this article, we will be implementing one approach to centralize PGP key issuing and distribution for an organization. We'll use an existing Linux instance's GnuPG tool to issue and manage keys. To distribute keys to users, we'll use the 1Password

Google form to Gmail header image.

Google Apps Script

Google Form - Response Emailer

SKILL LEVEL: Beginner In this article, we will be using Google Apps Script (GAS) to process a Google Forms submission and send an email using Gmail. Let's dive in! Creating your form You can use your own form, or create one if you're starting from scratch.

Image with tool logos

Migrate existing docker Peertube instance to Linode, enable object storage.

‌This project will be migrating an existing Peertube instance from one cloud service provider's Virtual Private Server (VPS) to a Linode VPS. The existing Peertube instance, let's call that Peertube A, is an out-of-the-box install based on Peertube's Docker install instructions.

Automated Company-Wide Gmail Signature Blocks

Automated Company-Wide Gmail Signature Blocks

BUSINESS PROBLEM Our client valued consistency in branding within email. Concerned that employees creating their own signature blocks in email would result in branding conflicts, KilPen was consulted to develop a company-wide signature standard in Gmail. OUR MISSION Using Gmail and Google Cloud Console, KilPen needed to develop a technical

Image Conversion Using API

Image Conversion Using API

BUSINESS PROBLEM Our client needed to produce 1,000+ images using an image creation tool. The images exported from the tool in PNG format, but a TIFF format was needed. Doing this conversion by hand would take considerable resources. OUR MISSION Develop an automation tool that would integrate into the

Google Sheets Data Aggregation

Google Sheets Data Aggregation

BUSINESS PROBLEM Our client identified significant waste related to employees manually updating Google Sheets that fed business critical decision making information. The client operated in a projectized environment with one Google Sheet per project. With a portfolio size of 150+ simultaneously executing projects, executive leadership needed a way to aggregate

Gate Review Risk Management System

Gate Review Risk Management System

BUSINESS PROBLEM Our client expressed concerns about poor product quality exiting their product development workflows. Due to the nature of their business model, many contributors play a role in development and the quality of their contributions vary. OUR MISSION Using Google Workspace, develop a process and supporting tool to enable

Motor Pool Vehicle Maintenance System

Motor Pool Vehicle Maintenance System

BUSINESS PROBLEM Our client operates in a tight margin industry where budget wasn't available to purchase a commercial vehicle maintenance tracking tool. With growth in their business, tracking vehicle maintenance and licensing requirements became more and more difficult. A centralized tool was needed to help retrieve service and

Project And Vendor Management Tracking

Project And Vendor Management Tracking

BUSINESS PROBLEM Our client, a small business start-up company, utilized a business model where independent contractors provided services on a project basis. The contractors work on short term projects that build the company's product. The current commercial software products available on the market exceeded cost allowances. This business