Galaxy S8, S9 and S10 random battery drain
If you note unusual/inconsistent battery drain in the Samsung Galaxy S8, S9 and perhaps S10 phones and there is no obvious apps draining the energy in the system power consumption tool here is the fix:
INFORMATION TECHNOLOGY
Information technology, softwares and articles.
Tulip Composer 2
Tulip Composer is a free software for creating road book tulip diagrams.
The software was updated to 2.0 in 2019, 14 years after the first release. Tulip Composer now works online.
Go to the Tulip Composer Online
To learn more about Tulips and the Tulip Composer, visit the official webpage.
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.
PHP - CSV Viewer for Web Browsers
Description
This PHP script opens and parses a CSV table file to an HTML view. It can be used together with the Internet of Things Web Logger Logger script.
PHP - Internet of Things Web Logger
Description
This is a PHP script that records data from Internet of Things (IoT) devices in a CSV spreadsheet that can be opened from Excel. If you also need a web view for the log, check the CSV Viewer for Web Browsers.
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.
Drupal - Clean database cache tables automatically
Drupal 8 has a known issue that allows database cache tables grow to the infinite (hundreds of MB or even GB) this can slow or stop automated backups and in the worst scenario, take all available storage and put the site offline.
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:
