Category Archives: How To Guides

Already in love with Snagit, just discovered the icing on top

I have been a very longtime user of Snagit, developed by TechSmith. Although it has taken some questionable directions on its UI since version 13, the core functions (and what was previously hidden but now more easily accessible, gems) is still fantastic. Well, I just found the feature that places the icing on top of the cake!

Recently I have been posting many new articles (like this one) that require many screenshots to support my guides. 90% of the screenshots are nothing special, just a snip of a specific region (or full screen) and insert. WordPress, unfortunately, does not support paste of images inline as well as ease of image manipulation (modify image border for example).

In comes Snagit.

Continue reading


IT Budget Blog Series: Integration of Currency Exchange Rates

As part of the continuing IT Budget Blog Series, we look at how to integrate currency exchange rates.  This is especially important for two points of consideration when creating an IT Budget for international companies:

  1. Acquired Software/Hardware may not all originate where the corporate headquarters reside. This means a collection of budget line items could have more than one currency. To define a solid budget, all budget items need to be standardized to a single currency.
  2. The budget may need to be reviewed/approved by individuals worldwide. To provide a familiar denomination, you need the ability to convert all figures to a preferred currency with accuracy and ease.

This article helps discuss how to insert data from an external source (the web) into your Excel file and how often the data should be refreshed (i.e. never). Steps in this article are in reference to Excel 2016 (Version 1711) on Windows.

Continue reading

Push Feedly articles to Microsoft Teams

Are you an informationholic? Do you wish you can share interesting stories with your teams to help extend their knowledge as well? Well now there is! After much trial and error, I figured out how to push articles from Feedly (my most favorite digital media aggregation tool) to Microsoft Teams (Microsoft’s answer to Slack with Office 365 subscriptions). For this solution we will use the following services:

  • Feedly Pro or Feedly Teams, sadly, cannot use Feedly Basic as it does not support the next requirement
  • IFTTT (If This, Then That), free, but to link to Feedly service, you need Feedly Pro or Feedly Teams.
  • Microsoft Teams
    • NOTE: you can use a similar configuration below but have output to Office 365 Groups or general email as well if you prefer or do not use Teams in your office. This article, however, focuses primarily on MS Teams.

The general concept is, when you see an article you are interested in, you can add notes and highlights to the article, then finally save the article to a personal board.  These features are actually new to Feedly and you can read more about them here (this is actually what finally got me to buy a subscription to Feedly Pro) –

Once the article is saved to a personal board, the IFTTT service will automatically pick it up, then POST a message immediately to the Microsoft Teams channel of your choosing.  An important note: In IFTTT we will be using Applets which are much easier to build compared to a full recipe which IFTTT provides support for as well. This means we will be limited to creating one applet per channel. If you want a single article to push to many channels, you will need to create separate applets or create a recipe without using the GUI (i.e. developer method, and beyond my current skill :-P)

Ok, let’s dive in and see what we have.

Continue reading

How to Kill (Hide) Status Bar in Firefox (without Add-Ons)

**UPDATE #2**

OK so I did some research and now updated my blog to work with FF 56 and 57, sorry for delay!


Sadly the below trick has stopped working with newer versions of Firefox. I’ll look into another method (without Add-Ons) and update when I find a solution 🙂  Thanks to my readers for letting me know!

**Support for 56 & 57**

First off, where are we with FF 57? Are we believers again? I was originally a heavy IE user which was due to my focus on SharePoint and it worked horribly in any other browser. Then I moved to Chorme (as many). Now with FF 57, I have found a huge improvement and moving back. Anyway, you are not here for that conversation, are you 🙂 I have now updated this blog to work for 56 and 57 only (sorry those who is holding out, time to upgrade I think…)


If you are taking screenshots for marketing collateral or grabbing the video for your next show and tell, there is nothing more annoying than the status bar that displays at the bottom of your Firefox window.  The status bar causes a loss of professionalism and must die! Ok that was a little overdramatic, but seriously folks, it looks better without right?

Remove Status Bar

status bar gone.png

With the following simple steps, you can be a magician as well! I came across these steps from a variety of sources, and for your convenience, I merged them together. The secret sauce is the creation (or edit of) your userChrome.css file (

NOTE: Following steps are using Firefox 40 but are valid for older versions as well.

  1. Open Firefox.
  2. Click on the menu hamburger in top right menuhamburgerfirefox.png and then click on the ? mark icon questionfirefox
  3. Now select Troubleshooting Information 
  4. Locate Profile Folder under Application Basics and click Show Folder to display your local folder in your file system.

    NOTE: There is actually 2 types of Profile Folders, one that is in Local and one that is in Roaming, make sure you update  the Roaming folder!!! Looks someting like:


  5. In the folder shown, see if a folder called chrome exists, if not create the folder:
  6. Look inside chrome folder and create a userChrome.css file
    • To create a CSS extension, enable File name extensions under the View tab of your file explorerFilextensionsfirefox
    • File is case sensitive, so properly name it.
  7. Open the file in a text editor and add the following lines:
    @namespace url(""); /* only needed once */
    @namespace url(;
    statuspanel { display:none!important; }

    If the file already exists, search for statuspanel to see if that line exists. If not, add just that line, as the @namespace should already exist in the file.

    NOTE: yes there is two entries of the namespace. I saw conflicting details as to why two (one in quotes other not) but it works with both included, so (in poor programmer position) what’s the harm of having both?

Restart Firefox, and poof, the bar is now gone! If you want to add extra layer of magic, you can define which cases to display the bar and hide the bar by inserting the below lines instead:

/* only hide some messages */ 
#statusbar-display[label^="Looking"] { display:none !important; } 
#statusbar-display[label^="Connect"] { display:none !important; } 
#statusbar-display[label^="Waiting"] { display:none !important; } 
#statusbar-display[label^="Transfer"] { display:none !important; }

Live Edit Failure; “Name” cannot be null

See, told you I can’t promise to be active (sorry I’m bad at being sarcastic ^^’ ). Anyway, wanted to do a quick post about a recent obstacle I was tackling when playing with the B2C_acc_responsive recipe. When I opened WCMS Cockpit, hybris’s built in CMS tool, I tapped on Live Edit to see the control behavior with a responsive site, but was blocked by a mysterious error

"Name" cannot be null

So descriptive and helpful! ok ok, maybe not so much. I tried to dig around in logs, command window, etc, but was just more lost.  I then stumbled across the following article in the website.

Continue reading

Deploying hybris Sample Sites in version 5.6 and greater

Ahhh where have I been??? Sorry for the long run of silence. L I promised so much and all you have heard is empty air.  Well I’ll try (sorry, I’m done promising  :oops:) to get better and to start off on the right foot, I figured I’d start where I originally began, installing hybris locally.

Over the past couple months, I saw numerous comments with people hitting problems with 5.6 and 5.7 version of hybris deployment and trying to access the provided sample sites.  So I thought I would revisit one of my older posts, How to get started… Link to online references and a guide to setup your own environment, to see what is going on.

As mentioned many times before, is your holy grail to hybris, but even hybris themselves have admitted it is difficult to navigate.  As I began my research into hybris 5.7 installation and went straight to my previous trusted source, Quick Installation page. I noticed immediately a very important notification box:

  • Do notuse the quick installation procedure if you’ve already created a working commerce suite configuration. Recipes will not preserve it!
  • The Quick Installation procedure applies to releases 5.1 through 5.5 of the hybris Commerce Suite. As of the hybris Commerce Suite release 5.6, this procedure has been deprecated as sample configurations are no longer provided with the hybris Commerce Suite. To quickly install the hybris Commerce Suite for release 5.6 and later, see Sample Scenarios Installation.

The third bullet is most interesting as this means that my original guide I created for 5.4 is no longer valid, this is the likely reason so many people receive dead pages when trying to access the B2C or B2B accelerator pages. Starting with version 5.6, hybris implemented a new build mechanism called hybris Installer using an open source packaging solution called Gradle. Gradle allows a solution provider to build a template of sorts for their solutions, bundling the copy, move, configure and execution of commands all in a single call to remove chance of user error in more traditional deployments. After a solution provider like hybris has build their template package, vendors can create many “recipes” to deploy new functions or solutions.

To improve the deployment of hybris sample sites, hybris created over 30 recipes to support a variety of scenarios to introduce hybris capabilities.  For summary of the recipes, go here.  In this article, I will not go over them in detail, but I am investigating each one and report back later. In interest of time and the objective of this article, I will use the recipe B2C Accelerator.

Let’s begin:

Continue reading