Archive for March, 2020
Posted by jpluimers on 2020/03/31
Since the Git output by default is not shown, here is how to enable it:
[WayBack] Version Control in Visual Studio Code: Git output window
You can always peek under the hood to see the Git commands we are using. This is helpful if something strange is happening or if you are just curious. :)
To open the Git output window, run View > Output and select Git from the dropdown.
Or shorter on MacOS:
- Press
Cmd–Shift–P
- Type
show git output
- Press enter
–jeroen
Posted in .NET, Development, DVCS - Distributed Version Control, git, Software Development, Source Code Management, Visual Studio and tools, vscode Visual Studio Code | Leave a Comment »
Posted by jpluimers on 2020/03/31
Veel doelgroepen hebben meer begrijpelijke taal nodig.
Deze sites helpen je verder:
–jeroen
Read the rest of this entry »
Posted in About, Personal | Leave a Comment »
Posted by jpluimers on 2020/03/31
As I need this one day:
To sum based on multiple criteria using OR logic, you can use the SUMIFS function with an array constant. In the example shown, the formula in H6 is:
=SUM(SUMIFS(E4:E11,D4:D11,{"complete","pending"}))
Source: [WayBack] Excel formula: SUMIFS with multiple criteria and OR logic | Exceljet

–jeroen
Posted in Development, Excel, Office, Office 2011 for Mac, Office 2013, Office 2016, Power User, Software Development | Leave a Comment »
Posted by jpluimers on 2020/03/31
Cool example, which requires dnspython and might need an update of the DNS record type list (maybe dnspython has that list built in?):
[WayBack] Printing all DNS records using DNSPython in Python 3 · GitHub
–jeroen
Read the rest of this entry »
Posted in Development, Python, Scripting, Software Development | Leave a Comment »
Posted by jpluimers on 2020/03/30
Improving your designs with tactics instead of talent: weight and colour. But be careful with the variation in meanings of colours for different cultures and mind about colour-blind people. Also ensure information workers can optimise your UI for information density.
Source: [WayBack] 7 Practical Tips for Cheating at Design – Refactoring UI – Medium
Via: [WayBack] 7 Practical Tips for Cheating at Design #webdev – ThisIsWhyICode – Google+
–jeroen
Posted in Usability, User Experience (ux) | Leave a Comment »
Posted by jpluimers on 2020/03/30
It seems Google Voice has gotten more restrictions over time that I was not aware of: [Archive.is] No forwarding phone number – Google Product Forums:
Bluescat said:
There is no bug involved here. And no, you haven’t stumbled on a way to game the system.
Two things have changed.
- With the introduction of Google Hangouts’ ability to place and receive calls via a Google Voice telephone number, the requirement to maintain a 10-digit forwarding phone number was removed. So yes, you can remove all forwarding phone numbers from your account if you wish. However, keep in mind that you have now made it more difficult to access your account from a telephone, to manage your voicemail greetings, listen to messages, set Do Not Disturb mode, etc. Without a forwarding phone number, you have no way to do that over the phone.
- In response to fraud and abuse of the service, Google now requires that users have a valid, working (paid-service) telephone number, which hasn’t been previously used to claim another Google Voice number, to be eligible to be issued a new Google Voice number. This is designed to deter people from collecting multiple Google Voice phone numbers to use for spam, robocalling, stalking, etc. Once that number has been used to claim a Google Voice number, it can’t be used to claim another Google Voice number. However, there’s no requirement that it be left on the account. Removing the forwarding phone from one Google Voice account will not enable that forwarding number to be used to claim a Google Voice number for another account.
So, all you did was use up your husband’s entitlement to a Google Voice number.
Finally, a disclaimer: Google Voice cannot be used for emergency 911 calling. Not having some alternative telephone service available for that purpose is a very bad idea.
–jeroen
Posted in Google, GoogleVoice, Power User | Leave a Comment »
Posted by jpluimers on 2020/03/27
- While 32-bit applications can run on 64-bit machines, they cannot use 64-bit ODBC drivers. A 64-bit application must use a 64-bit ODBC driver, and a 32-bit application must use a 32-bit ODBC driver.
- ODBC.INI registry paths for the various permutations:
- User DSNs for for 64-bit and 32-bit applications
HKEY_CURRENT_USER\Software\ODBC\ODBC.INI
- System DSNs for 64-bit applications on 64-bit Windows and 32-bit applications on 32-bit Windows
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI
- System DSNs for 32-bit applications on 64-bit Windows
HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBC.INI
Via: [WayBack] Windows registry on 32 and 64 bit windows, which also explains ODBCINST.INI to define drivers.
–jeroen
Posted in Database Development, Development, ODBC, Power User, Windows | Leave a Comment »
Posted by jpluimers on 2020/03/27
I got this on Windows 10, 8.1 and 7, MacOS and Linux:
C:\bin>nmap -sn 192.168.71.0/24
Starting Nmap 7.80 ( https://nmap.org ) at 2020-03-24 13:44 W. Europe Standard Time
Assertion failed: htn.toclock_running == true, file ..\Target.cc, line 503
Luckily [WayBack] Nmap 7.8 Assertion failed: htn.toclock_running == true · Issue #1764 · nmap/nmap · GitHub has a solution: add the --max-parallelism 100 parameter:
C:\bin>nmap -sn --max-parallelism 100 192.168.71.0/24
Starting Nmap 7.80 ( https://nmap.org ) at 2020-03-24 13:48 W. Europe Standard Time
Nmap scan report for 192.168.71.1
...
Host is up.
Nmap done: 256 IP addresses (50 hosts up) scanned in 54.07 seconds
The other workaround is to have at least one ARP request succeed.
Via [WayBack] “Assertion failed: htn.toclock_running == true, file ..\Target.cc, line 503” – Google Search
–jeroen
Posted in *nix, *nix-tools, nmap, Power User | Leave a Comment »
Posted by jpluimers on 2020/03/27
Af en toe (met name als de batterij bijna leeg geweest is) heeft mijn TomTom XXL een probleem dat deze niet meer reageert op de “Ga door” knop in het scherm met de gegevens van de eigenaar.
Dit lost het op en meestal ben ik dan niet eens de tijdzone kwijt:
Probeer het navigatie systeem te resetten (30 sec. de “aan/uit” knop induwen). Het enige aan gegevens die u kwijt bent, is de tijdszone instelling en de klok.
Source: [WayBack] Meest voorkomende problemen TomTom – TomTom Update
De TomTom XXL gebruik ik nog steeds af en toe: ooit gekocht in de USA had het “World Life-time Map-upgrades”. Dat bleek alleen voor de eerste kaart te zijn die ik had gedownload (USA dus) maar de updates komen nog steeds uit.
–jeroen
Posted in LifeHacker, Power User | Leave a Comment »