Articles

LibreOffice Calc Separate Cells Into Comma Separated Values

Use the =TEXTJOIN(",",1,A:A)

This will join all values in the A-column into a single cell separated by ",". You can of course change the value to whatever you like.

Drupal 8 Taxonomy Terms In Node URLs

Term hierarchies:

For content: [node:field_tags:0:entity:parents:join-path]/[node:field_tags:0:entity]/[node:title]

For taxononomy terms: [term:vocabulary]/[term:parents:join-path]/[term:name]

Essential Drupal 8 modules

Redirect - we need redirection if the title of an entity changes. Very good for search engine optimization and being able to contain links coming from outside.

Google Analytics - we need to track what is going on.

Pathauto - we need search engine friendly titles on our articles and pages populated automatically.

simple_sitemap - a nice xml sitemap generator.

Corrects urls automatically: pathologic

Core: responsive_image

Tar Notes

Compress:
tar -czvf name-of-archive.tar.gz /path/to/directory-or-file

The Drupal Shell - Drush

The Drupal Shell is an amazing tool if you maintain Drupal web sites and you have shell access to the server, where the Drupal site is hosted. This is also an unvaluable tool if you develop i in Drupal.

Drush 8

Updating drush: composer global update drush/drush

Manual install: http://docs.drush.org/en/8.x/install/

Check latest drush version: https://github.com/drush-ops/drush/releases/

Example procedure:

Squirrel SQL With MS SQL

Configuring SquirrelSQL and MS SQL

Remove 100 row limit: File -> New Sessions Properties -> Object Tree -> Contents -> limit rows.

Recently Installed Packages Ubuntu

Try this from the terminal: grep " install " /var/log/dpkg.log

Lenovo G580 Notes

The screen started flickering and the quick fix is to push down just above the keyboard in the middle and then the flickering stops. Looks like a loose connection of the cable connecting the screen with the motherboard.

Lenovo IdeaPad G580 Laptop Screen Replacement Procedure: https://www.youtube.com/watch?v=smGMmZzm9bc

Lenovo G580 Laptop Disassembly video, take a part, how to open: https://www.youtube.com/watch?v=84lV68WRKlQ

Recaptcha Above Send Message Button Webfrom Drupal 8

Go to Structure -> Webform -> Build -> Add element -> Capthca

Certbot notes

Remove ssl cert: sudo certbot-auto delete

Kubuntu 20.04 USB Audio Devices Not Found Fix

Here is what I needed to do to get my audio devices found by my Kubuntu 20.04 focal installation.

First install this patch, and see if things start working: https://launchpad.net/~kaihengfeng/+archive/ubuntu/fix-lp1869819

If not then follow the instructions:

sudo apt install alsa-tools-gui
Run hdajackretask
Parser hints > jack_detect = no
Apply now
Install boot override

Grub Notes

linux /boot/vmlinuz-5.4.0-31-generic root=UUID=24f1138b-2ab3-4617-a4aa-db3f37107cbc ro

Removed quiet splash $vt_handoff

VPS Options and Considerations

Flokinet

Iceland outside of EU - great data protection.
Expensive.

Hetzner

Great value for money.
Maybe not the best support in the world.

https://webdock.io/en

Looks like great value for money.

Transip

Great support.
OK prices.

Lenovo T450s Thinkpad Screen Connectivity Issues

Recently I am experiencing bad connectivity on my LCD-screen. It seems to happen randomly and periodically. The connection is disrupted and a gray darkish void appears on the screen. Sometimes this can be ammended by moving the screen up and down but the bulletproof solution is to suspend the laptop and wake it up again, then the screen works properly. Sometimes for hours sometimes only for minutes. Last time I managed to remove and reattach the left hand side LCD-connector from the motherboard. This releived the problem for a couple of days, but now it's back again.

Snedige Regneark!

Regneark (Excel blandt venner) bidrager normalt med forkerte, tidsrøvende, uoverskuelige, fejlbehæftede og fejlfokuserede løsninger. Alligevel ser man sommetider elegante og gennemtænkte regneark, der gør præcis dét, der var meningen med dem. Så det kan lade sige gøre.

Hvad er forskellen?

Læs mere og se video på logistikforum.grn.dk.

Du er sandsynligvis interesseret, hvis du:

Graphical Disk Usage Analytics

If you want to find the big files and clean up on your disk you might want to try this disk usage utility: qdirstat

R CVXR linear programming

Here is the example that works:

Original source not working: http://rtutorial.altervista.org/lp_solvers.html
Thanks to Mark Neal for debugging: https://stackoverflow.com/questions/60909930/r-cvxr-matrix-multiplicati…

Payment Gateways Denmark

Reepay - includes a subscription service.

Quickpay

Epay