INFORMATION TECHNOLOGY

Information technology, softwares and articles.

Prevent Chrome from signing in Google services

When you sign in Google Chrome with you credentials it will automatically sign you in all Google services (Drive, GMail, Keep, Calendar, Search, etc...). This can be useful but can also expose your personal data since there is no default way to protect Chrome with a password.

Google says in the help page the only way to do this is by using the Incognito Mode. That's not true. There is a way to keep your Chrome Browser signed in and at the same time be signed out of other Google services. This takes less than 30 seconds and does not require the installation of any app or plugin.

Excel - Pivot tables with text values or numbers without calculations

Objectives

Create a Pivot table that displays text data or number values that are not summarized (count, sum, etc...). This solution does not require macros or long search/replace functions, just the Microsoft Power Query tool that comes with Excel 2016 or can be installed for free as an add-on in previous versions.

OpenCart orders and options Excel export tool

Introduction

This script should work in all OpenCart 2.x and OpenCart 3.x because it extracts the data directly from the OpenCart Database and does not rely on any OpenCart directory files. No VQMod, OCMod, theme or permissions required!

The script just dumps readable order data in an Excel file, you may later use Excel functions to auto-format the data according to your needs.

Drupal - Duplicate view results in multi language sites

This article explains how to eliminate the duplicate pages that appear in multi-language Drupal site views. The solution was tested on Drupal 8 but works well in previous versions.

Duplicate pages normally appear in:

  • Banners
  • Most Popular Lists
  • Related Content lists
  • Slideshows
  • Taxonomy terms
  • What's new pages
  • Lists or Tables
  • Views in general

Types of duplicate pages

There are two types of duplicate results in multi-language website views:

Fuel consumption spreadsheet

This spreadsheet calculates and keep track of the fuel consumption of vehicles. The result can be displayed in several ways including averages, statistics, graphics and multiple units. The main advantage of this spreadsheet compared to others is the ability to handle partial tank fills.

Last, the spreadsheet is not password protected so you can customize-it as you like.