INFORMATION TECHNOLOGY

Information technology, softwares and articles.

V-Car app for rear WiFi camera

This is just a mirror to download the app V-Car, used in Chinese WiFi rearview and front cameras. I tested it myself and it does not require abusive permissions: access to WiFi configurations, microphone (to record sounds) and storage (to save videos). It worked well on Android 8.0 in my Galaxy S8.

Since I am not the developer of this software I will not answer any technical support question regarding this application. Download and use it at your own risk.

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: