My Brain BLOG – thoughts, ideas and knowledge

.htaccess to enforce https without www.

If not using WordPress you may need to create your own .htaccess file for this.
So how do you forward?

http://example.com/
http://www.example.com/
https://www.example.com/
to
https://example.com/

Create a new .htaccess file and enter the following content:

BIOS Settings

Reboot and keep hitting ESC, F2, F8, F10 or whatever the computer requires… But, there is another way, which I found out trying this for an old ASUS Transformer T100.
According to Asus: Press and hold the F2 button, then click the power button. DO NOT RELEASE the F2 button until the BIOS screen display.

Of course this does not work, why else would I write about it?

Thunderbird Unified Folders

Another issue …. suddenly the unified folders view was not showing the e-mails anymore from one of my e-mail accounts. Solution? Delete some files and force Thunderbird to recreate it’s unified folders cache.

Help EarthToday

Every square meter counts!

EarthToday was founded on a vision of a future society where we care for each other and the planet we live on. It is developed to sustainably facilitate a growing group of conscious people from all around the world who share the same dream. Everybody can join by protecting one or more m² of nature. From that moment on you can virtually visit your m² and curate inspiring content about nature conservation and a sustainable and holistic lifestyle.

We believe in equality, freedom, transparency and collaboration. We are organized as a for-purpose venture where 83% of all revenue is directed to the purpose. We are a community for change, and we invite you to join.

Have a nice day!

Word 2019 Save as PDF shows ‘title’, not ‘filename’

Using a new (to me) version of Word 2019 brings new challenges.
I create invoices in Microsoft Word and save them as a PDF file to send by e-mail. In Acrobat it started showing the Word document property for document title, and no longer the filename, like I was used to in Word 2013.

The answer is a simple option… you just have to know where to find it:

KiBiBytes en TeBiBytes

Learned something new today… Also see the wiki:

Een kilobyte, afgekort kB, is 1000 bytes. Vroeger werd er verschil gemaakt tussen een hoofd- en een kleine letter k:

k = kilo (10³)	1.000
K = kilo (2¹⁰)	1.024

In praktijk werkte dit verwarrend en bedoelde men met 1 kB vaak 1024 bytes.

De oude notatie wordt ontraden sinds er een nieuwe standaard is voor binaire voorvoegsels (zie: veelvouden van bytes). Deze standaard wordt echter nog niet veel toegepast.

Let op: het is nog steeds van belang voor de B een hoofdletter te gebruiken: een kleine letter b staat namelijk voor bit en niet voor byte.

1024 B heet nu een kibibyte, afgekort KiB. 1000 kB heet een megabyte, 1024 KiB heet een mebibyte.

In een tabel:

symbool	naam	waarde	symbool	naam	waarde
kB	kilobyte	1000¹ = 10³	KiB	kibibyte	1024¹ =2¹⁰	2,4%
MB	megabyte	1000² = 10⁶	MiB	mebibyte	1024² =2²⁰	4,9%
GB	gigabyte	1000³ = 10⁹	GiB	gibibyte	1024³ =2³⁰	7,4%
TB	terabyte	1000⁴ = 10¹²	TiB	tebibyte	1024⁴ =2⁴⁰	10,0%
PB	petabyte	1000⁵ = 10¹⁵	PiB	pebibyte	1024⁵ =2⁵⁰	12,6%
EB	exabyte	1000⁶ = 10¹⁸	EiB	exbibyte	1024⁶ =2⁶⁰	15,3%
ZB	zettabyte	1000⁷ = 10²¹	ZiB	zebibyte	1024⁷ =2⁷⁰	18,1%
YB	yottabyte	1000⁸ = 10²⁴	YiB	yobibyte	1024⁸ =2⁸⁰	20,9%

The more you know… 🙂

Reset the Excel Worksheet “Last” Cell

You can tell when the “used range” excel is using is too big and is going to add extra blank rows when you use the scroll bar to the right and it goes beyond the last row of actual data when you scroll to the bottom. Terrible when trying to print your data. I’ve found something, and corrected the procedure, so it consistently works to delete those blank rows.

Do this to get rid of them:

php ob_flush

How to show your script output as it is producing it. Normally everything is buffered and shown all at once, but sometimes you want to show the actual progress of the script.
This needs a few steps to get it working.

Excel CSV with comma’s

You want a CSV, a comma-separated file, to actually have comma’s as separators and NOT semi-colons as your field delimiter!
However, in countries where the comma is used as decimal separator, this is not by default for Excel. Various sources hint to the solution, but none are really complete. You need to do this:

1. Change the system – region settings – additional settings – to use a , as list separator.
2. Change Excel – options – advanced – to not “Use system separators”, but manually set a . as Decimal separator and , as Thousands separator.
3. Then with Excel, save your file as “CSV (Comma Delimited)”
4. Change your Excel setting back to what it was (Use system separators), so you can continue your work like you’re used to.

WooCommerce and Polylang

I ran into this issue: Any link in my code/theme/plugin to standard Woocommerce pages did not go to the correct translated page!
However the solution provided here will break whenever WooCommerce is updated. The correct way of solving this is adding some filters…

//20210216 - (c) My Brain - correction for function wc_get_page_id()
function woocommerce_translate_polylang_page_id($pageid) {
	if (!empty($pageid)) {
		if (PLL() instanceof PLL_Frontend) {
			$pllpageid = pll_get_post($pageid);
			if (!empty($pllpageid)) {
				$pageid = $pllpageid;
			}
		}
	}
	return $pageid;
}
//myaccount, edit_address, shop, cart, checkout, pay, view_order, terms
add_filter( 'woocommerce_get_myaccount_page_id', array( $this, 'woocommerce_translate_polylang_page_id' ), 10, 1 );
add_filter( 'woocommerce_get_edit_address_page_id', array( $this, 'woocommerce_translate_polylang_page_id' ), 10, 1 );
add_filter( 'woocommerce_get_shop_page_id', array( $this, 'woocommerce_translate_polylang_page_id' ), 10, 1 );
add_filter( 'woocommerce_get_cart_page_id', array( $this, 'woocommerce_translate_polylang_page_id' ), 10, 1 );
add_filter( 'woocommerce_get_checkout_page_id', array( $this, 'woocommerce_translate_polylang_page_id' ), 10, 1 );
add_filter( 'woocommerce_get_pay_page_id', array( $this, 'woocommerce_translate_polylang_page_id' ), 10, 1 );
add_filter( 'woocommerce_get_view_order_page_id', array( $this, 'woocommerce_translate_polylang_page_id' ), 10, 1 );
add_filter( 'woocommerce_get_terms_page_id', array( $this, 'woocommerce_translate_polylang_page_id' ), 10, 1 );

Have a nice day!