Information technology, softwares and articles.
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.
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 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.
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.
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:
There are two types of duplicate results in multi-language website views:
Single file HTML 5 boilerplate for quick JavaScript applications development and testing. Comes with a built in console box and some input fields and buttons to speed up the development.
A working sample is available here.
Content available under the MIT license.
Simple HTML 5 boilerplate for quick JavaScript applications development and testing. Comes with a built in console box and some input fields and buttons to speed up the development.
All versions of this website since it's initial conception in the year 2000.
This spreadsheet calculates the importation taxes to Brasil based on the regulations from 2012 to 2016 (still valid)
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.
