The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,861 other subscribers

Archive for June, 2019

“Nobody” Can Ping My Windows 10 Computer

Posted by jpluimers on 2019/06/10

A problem with ICMP can be that you if you allow File and Printer Sharing, that ICMPv4 and ICMPv6 for both Private and Public networks are only allowed for the Local subnet.

For Domain networks, however it is allowed for Any subnet.

You can see the difference in this picture:

The solution presented at [WayBack] Nobody Can Ping My Computer – Technet MSDN library is to add a less restrictive set of rules:

  1. In the Windows Firewall with Advanced Security snap-in, click Inbound Rules in the tree, and click New Rule in the Actions Pane.
  2. Click Custom and click Next.
  3. Click All programs and click Next.
  4. For Protocol type, select ICMPv4.
  5. Click Customize for Internet Control Message Protocol (ICMP) settings.
  6. Click Echo Request, click OK, and then click Next.
  7. Under Which local IP address does this rule match? and for Which remote IP address does this rule match click either Any IP address or These IP Addresses. If you click These IP addresses, specify the IP addresses and click Add, then click Next.
  8. Click Allow the connection, and then click Next.
  9. Under When does this rule apply?, click the active profile, any or all profiles (Domain, Private, Public) to which you want this rule to apply, and then click Next.
  10. For Name type a name for this rule and for Description an optional description. Click Finish.
  11. Repeat steps for ICMPv6, selecting ICMPv6 for Protocol Type instead of ICMPv4.

You can also add these rules using the netsh advfirewall command as shown at [WayBack] How to Allow Pings (ICMP Echo Requests) Through Your Windows Firewall

–jeroen

Posted in Power User, Windows, Windows 10 | Leave a Comment »

ms office – Keyboard shortcut to select all text in a cell in Excel – Ask Different

Posted by jpluimers on 2019/06/10

Via [WayBack] ms office – Keyboard shortcut to select all text in a cell in Excel – Ask Different a few keyboard tips.

Lets start with the shortest one:

  1. Put the focus on the cell (click, use arrow keys, etc)
  2. Press space
  3. Press CommandZ or ControlZ to undo the change

This probably is unintended, but works great: all text is now selected, so you can copy/cut with Command-C/CommandX.

Now the “official” way:

  1. Put the focus on the cell (click, use arrow keys, etc)
  2. Press ControlU or F2 to edit the cell (the cursor is now at the end)
  3. Press ShiftAltHome or ShiftControlHome (to select all text)
    note: Home can also be FnLeft.

Other selections you can make while the cell is in edit mode:

  • Press ShiftAltEnd or ShiftControlEnd (to select to the end of the cell)
    note: End can also be FnRight.
  • Press ShiftAltRight or ShiftControlRight (to select one word to the right)
  • Press ShiftAltLeft or ShiftControlLeft (to select one word to the left)
  • Press ShiftAltDown or ShiftControlDown (to select to the same position on the line below)
  • Press ShiftAltUp or ShiftControlUp (to select to the same position on the line up)

Keyboard symbols (more at [WayBackCommand, Option, & Shift Symbols in Unicode):

  • Shift
  • ^Control
  •  – Alt which is the same as Option
  •  – Command
  • Fn – Function

–jeroen

Posted in Apple, Excel, Mac, Mac OS X / OS X / MacOS, MacBook, MacBook Retina, MacBook-Air, MacBook-Pro, MacMini, macOS 10.12 Sierra, Office, Office 2011 for Mac, Power User | Leave a Comment »

Did Apple remove dashboard in MacOS Catalina? – Appleosophy

Posted by jpluimers on 2019/06/10

It was fun while it lasted: [WayBack] Did Apple remove dashboard in MacOS Catalina? – Appleosophy

I especially like the iStat Pro (though unsupported) widget, and that you can have a dashboard without the need to go on-line.

Related: [WayBack] Dashboard (macOS) – Wikipedia

Via: [WayBack] Apple verwijdert dashboard met widgets uit macOS Catalina – Computer – Nieuws – Tweakers

If might be that Übersicht can help me, but I am not sure yet if there is a good iStat Pro equivalent for it.

Future links to investigate:

–jeroen

Posted in Apple, Mac OS X / OS X / MacOS, Power User | Leave a Comment »

macos – User account no longer in ‘admin’, how to recover? – Ask Different

Posted by jpluimers on 2019/06/07

For my link archive:

–jeroen

Posted in Apple, iMac, Mac, Mac OS X / OS X / MacOS, MacBook, MacBook Retina, MacBook-Air, MacBook-Pro, MacMini, macOS 10.12 Sierra, macOS 10.13 High Sierra, OS X 10.11 El Capitan, Power User | Leave a Comment »

When %windir%Temp is filling up your disk: some notes

Posted by jpluimers on 2019/06/07

On my research list as I’m not sure if these are related:

–jeroen

Posted in Power User, Windows | Leave a Comment »

ls colour codes on OpenSuSE tumbleweed when accessed from Mac OS X ssh

Posted by jpluimers on 2019/06/07

`ls` colour codes

`ls` colour codes

I got confused as I thought red text would mean an error.

But they’re not: greenish yellow on a read background means error (a symbolic link to a place that’s no longer there).

It’s the output of https://github.com/gkotian/gautam_linux/blob/master/scripts/colours.sh as the one at

Actually the script is here https://raw.githubusercontent.com/gkotian/gautam_linux/master/scripts/colours.sh as the one at [WayBackcommand line – What do the different colors mean in the terminal? – Ask Ubuntu failed with errors like this one:

-bash: *.xbm: bad substitution

The full script output is below.

Since various terminals have a different mapping from colours in the ANSI escape code colour table, I used the standard HTML colours using (which slightly differs from the Terminal.app screenshot on the right):

References:

Note that the shell on Mac OS X uses a different way of configuring colours CLICOLOR as described in [WayBacksettings – CLICOLOR and LS_COLORS in bash – Unix & Linux Stack Exchange. I might cover that another day.

Script output:

Read the rest of this entry »

Posted in *nix, *nix-tools, ANSI escape code, bash, CSS, Development, Encoding, HTML, HTML5, Linux, openSuSE, Power User, Software Development, SuSE Linux, Tumbleweed, Web Development | Leave a Comment »

Re-read “I am looking for a good replacement for INI files for storing large/complex configuration”

Posted by jpluimers on 2019/06/06

Reminder to re-read [WayBackI am looking for a good replacement for INI files for storing large / complex configuration. So far I have used JvApplicatoinIniStorage + a custom INI f… – Thomas Mueller (dummzeuch) – Google+

INI files are textual and allow for comments. They are not good at large bits of information, and are hard to compare because the order is unimportant.

Alternatives like JSON or DFM have similar limitations.

XML is too chatty, and hard to get right by humans.

Related: [WayBack] JSON as configuration files: please don’t

–jeroen

Posted in Delphi, Development, Software Development | Leave a Comment »

What not to estimate: defects, spikes and (in during sprint planning): stories.

Posted by jpluimers on 2019/06/06

A few nice reads on that not to estimate and why:

Related:

Via:

–jeroen

Posted in Agile, Development, Scrum, Software Development | Leave a Comment »

Working with big data databases in Delphi – Cassandra, Couchbase and MongoDB (Part 3 of 3) – grijjy blog

Posted by jpluimers on 2019/06/06

Reminder to self to check out [WayBackWorking with big data databases in Delphi – Cassandra, Couchbase and MongoDB (Part 3 of 3) – grijjy blog and see if by now it supports authentication.

Repository: grijjy/DelphiMongoDB: A Delphi driver for MongoDB

Via: [WayBack] We finish our trilogy on big databases with a Delphi driver for MongoDB. – Erik van Bilsen – Google+

–jeroen

Posted in Delphi, Development, Software Development | 1 Comment »

windows – How to simulate drop-down form in Delphi? – Stack Overflow

Posted by jpluimers on 2019/06/05

Since I might need it one day: [WayBack] windows – How to simulate drop-down form in Delphi? – Stack Overflow

Via [WayBack] for whatever reason this SO question from 2015 showed up in my rss stream as “new or updated”. Interesting though. – Thomas Mueller (dummzeuch) – Google+

–jeroen

Posted in Delphi, Development, Software Development | Leave a Comment »