Posted by jpluimers on 2019/11/19
I never thought you could do it, but you can: [Archive.is] Return empty cell from formula in Excel – Stack Overflow.
You have to crate:
Convoluted, but clever!
–jeroen
Posted in Development, Excel, Office, Office VBA, Power User, Software Development | Leave a Comment »
Posted by jpluimers on 2019/11/13
A few good links to a few alternatives for the built in Delphi REST client [WayBack] Hi looking for good and complete tutorial/course how to create RESTFul services with Delphi. Or if anyone use Delphi for creating RESTFul services feedb… – Gordan Paunovic – Google+
–jeroen
Posted in Communications Development, Delphi, Development, HTTP, Internet protocol suite, JSON, REST, Software Development, TCP | Leave a Comment »
Posted by jpluimers on 2019/11/12
On some systems, Get-HotFix has many entries with an empty InstalledOn column.
This at least shows there is a date-format difference, but now the Source column is empty.:
Get-HotFix | Select-Object Source,Description,HotfixID,InstalledBy,InstalledOn,@{Name="InstalledOnValue";Expression={$_.psbase.properties["InstalledOn"].Value}} | Out-GridView
I contemplated using Microsoft.Update.Session in the scripts below, but it requires WinRM, the server side implementation of WS-Management – Wikipedia:
[ERROR] [DevMachine] Connecting to remote server DevMachine failed with the following
[ERROR] error message : The client cannot connect to the destination specified in the
[ERROR] request. Verify that the service on the destination is running and is accepting
[ERROR] requests. Consult the logs and documentation for the WS-Management service run
[ERROR] ning on the destination, most commonly IIS or WinRM. If the destination is the
[ERROR] WinRM service, run the following command on the destination to analyze and conf
[ERROR] igure the WinRM service: "winrm quickconfig". For more information, see the abo
[ERROR] ut_Remote_Troubleshooting Help topic.
[ERROR] + CategoryInfo : OpenError: (DevMachine:String) [], PSRemotingTr
[ERROR] ansportException
[ERROR] + FullyQualifiedErrorId : CannotConnect,PSSessionStateBroken
This is a reminder to find and document a proper fix for this.
This at least works:
Get-HotFix | Select-Object Source,Description,HotfixID,InstalledBy,InstalledOn,@{Name="InstalledOnDateTime";Expression={[System.DateTime]::Parse($_.PSBase.Properties["InstalledOn"].Value,[System.Globalization.CultureInfo]::GetCultureInfo("en-US"))}} | Out-GridView
Some links that hopefully help with proper documenting it:
-Process:
PSBase:
–jeroen
Posted in CommandLine, Development, PowerShell, PowerShell, Scripting, Software Development | Leave a Comment »
Posted by jpluimers on 2019/10/30
[Archive.is] Dixin’s Blog – Use Fiddler with Node.js Fiddler is an useful HTTP proxy debugger on Windows. It would be nice if it can work with Node.js applications. To do this, just need to proxy Node.js requests through Fiddler… on port 8888.
There is a snippet for it at github/Dixin/CodeSnippets/…/fiddler.js (now moved to [WayBack] github.com/Dixin/Blog/…/Blog/Dixin.Nodejs/fiddler.js)
It complements a few posts I’ve written about Fiddler using port 8888 as a proxy before:
–jeroen
via: [WayBack] Use Fiddler with Node JS – CHUA Chee Wee – Google+
Posted in Cntlm, Development, JavaScript/ECMAScript, Node.js, NTLM, Power User, Scripting, Software Development, Windows, Windows-Http-Proxy | Leave a Comment »
Posted by jpluimers on 2019/09/26
TL;DR from [WayBack] Automating the world one-liner at a time… Boolean Values and Operators:
In PowerShell use the built-in constants $false and $true, as strings will be converted to booleans with results you don’t like
–jeroen
Posted in CommandLine, Development, PowerShell, PowerShell, Scripting, Software Development | Leave a Comment »
Posted by jpluimers on 2019/09/25
In production, somehow an application started to misbehave, so would spit out a lot of Windows EventLog entries for Applications you can see in the EventViewer. This small script helped counting it (it takes about 10 seconds on a log having a total of 77k entries):
$tenMinutes = New-TimeSpan -Minutes 10
$now = Get-Date
$tenMinutesAgo = $now - $tenMinutes
$eventLogEntries = Get-EventLog -After $tenMinutesAgo -LogName "Application"
$count = ($eventLogEntries | Measure-Object).Count
Write-Host $count
Related:
–jeroen
Posted in CommandLine, Development, PowerShell, PowerShell, Scripting, Software Development | 1 Comment »
Posted by jpluimers on 2019/09/18
Interesting talk:
Published on Oct 8, 2017
Via [WayBack] The Other Async (Threads + Async = ❤️) – screencast of David Beazley’s keynote at PyGotham 2017 – ThisIsWhyICode – Google+
–jeroen
Posted in Development, Python, Scripting, Software Development | Leave a Comment »
Posted by jpluimers on 2019/09/10
[WayBack] GitHub – slikts/js-equality-game: The Worst Minesweeper 💣 Ever:
It’s in response to claims like this one by the well-known author getify:
However, implicit coercion is a mechanism that can be learned, and moreover should be learned by anyone wishing to take JavaScript programming seriously. Not only is it not confusing once you learn the rules, it can actually make your programs better! The effort is well worth it.
You can play it on [WayBack] JavaScript Equality Table Game: Find out how well you know (or don’t know) the JavaScript == operator rules
It reminds me of the hilarious video on Wat – Destroy All Software Lightning Talk : Gary Bernhardt : Free Download, Borrow, and Streaming : Internet Archive
Based on:
Via:
–jeroen
Posted in Development, JavaScript/ECMAScript, Scripting, Software Development | Leave a Comment »
Posted by jpluimers on 2019/09/10
When starting to work with Python, a lot of examples contain the >>> characters on the first line often followed by ... characters on continuing lines.
They are about two things:
The answers in [WayBack] What do the three arrow (“>>>”) signs mean in python? give insight in the various Python versions and how they prompt.
References from them:
–jeroen
Posted in Development, Python, Scripting, Software Development | Leave a Comment »
Posted by jpluimers on 2019/09/05
I forgot how I originally bumped into the book series, but every time I try to program in JavaScript I’m reminded of them: You Don’ t Know JavaScript.
Originally a KickStarter project, they are now on GitHub and there is a Twitter account irregularly posting about them:
- Read online (free!): “Up & Going”, Published: Buy Now in print, but the ebook format is free!
- Read online (free!): “Scope & Closures”, Published: Buy Now
- Read online (free!): “this & Object Prototypes”, Published: Buy Now
- Read online (free!): “Types & Grammar”, Published: Buy Now
- Read online (free!): “Async & Performance”, Published: Buy Now
- Read online (free!): “ES6 & Beyond”, Published: Buy Now
–jeroen
Posted in Development, JavaScript/ECMAScript, Scripting, Software Development | Leave a Comment »
The Wiert Corner - irregular stream of stuff 