INFORMATION TECHNOLOGY

Information technology, softwares and articles.

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.